DEV Community


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

calvinpak profile image
CP Author

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

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?

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 !