DEV Community

DEV Community is a community of 582,093 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

Create new account Log in
loading...

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

View post Full discussion

Replies for: 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 !