React-Google-Apps-Script Menu Not Appearing

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

Aug 22 '23 13:08 ktjh123

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.

Aug 22 '23 14:08 enuchi

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

Aug 22 '23 16:08 ktjh123

yarn inside a yarn workspace

Aug 22 '23 16:08 ktjh123

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

Aug 22 '23 16:08 enuchi

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

Oct 20 '23 11:10 manojbajaj95

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

Nov 30 '23 14:11 MarkAtOmniux

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 !

Mar 22 '24 11:03 dhruv9499