search

enuchi / React-Google-Apps-Script

This is your boilerplate project for developing React apps inside Google Sheets, Docs, Forms and Slides projects. It's perfect for personal projects and for publishing complex add-ons in the Google Workspace Marketplace.
MIT License
1.33k stars 178 forks source link

Menu Not Appearing #201

Open ktjh123 opened 1 year ago

ktjh123 commented 1 year ago

Hi, just did a fresh clone and ran the steps up till deploying to production but when I open the spreadsheet, it dosent show the custom menu

image

enuchi commented 1 year ago

Can you open the script editor through sheets and confirm the code is there?

Also try refreshing the spreadsheet page and waiting a few seconds. It can take a bit before the menu shows up.

ktjh123 commented 1 year ago

Sorry, when using npm it seems to work but when i switched to yarn it dosent

ktjh123 commented 1 year ago

yarn inside a yarn workspace

enuchi commented 1 year ago

Using the exact packages is important so please try with npm, since the package-lock.json file has the right packages.

manojbajaj95 commented 1 year ago

Such a weird issue. Wasn't working with pnpm either.

MarkAtOmniux commented 11 months ago

Come across this issue too it seems. The scripts have loaded, I am currently in dev mode. Taking a look at the app execution it says the onOpen() function has failed with the following error;

Error ReferenceError: React is not defined at 363(main:1:21768) at t(main:1:21878) at unknown function at unknown function at unknown function

dhruv9499 commented 7 months ago

I had the same issue. Steps how I solved the problem Step 1- Delete package-lock.json and node_modules Step 2- Import or copy the original package-lock.json as in repo Step 3- Run npm run deploy Step 4- Go the sheet -> Script Editor and run the function any function such that the permission dialog opens up.

DONE !