DEV Community

loading...

Discussion on: How-to Read & Write Google Sheets with React

Collapse
jotarenan profile image
João Pedro Renan

Nice post. A question: do I have to Publish the spreadheet on the Web in order for google-spreadsheet to be able to access it?

Collapse
calvinpak profile image
CP Author

You only need to share the spreadsheet with your google app. ^_^

Collapse
jotarenan profile image
João Pedro Renan

:(
I'm having the same problem this user describes on StackOverflow. Apparently he was able to fix it, but his solution didn't work for me. Would you have any clue of what may be going on? stackoverflow.com/questions/644108...

Thread Thread
saifrehman99 profile image
Saif ur Rehman

Hi Joao,

Try this,
process.env.PRIVATE_KEY.replace(/\n/g, '\n')

Also enable the google sheets api in google console.
Hope it works for you !