Need help with a workflow

Saandhy_Ganeriwala · September 1, 2021, 10:52am

https://saandhyg.app.n8n.cloud/workflow/1003

Although I have connected my Google Sheet, the node isnt getting executed. Can you help me with where i am going wrong?

harshil1712 · September 1, 2021, 11:21am

Can you please share more information. What authentication method are you using? Do you get any errors when you execute the node?

Saandhy_Ganeriwala · September 1, 2021, 11:41am

this is the error i got (attached) & i used OAuth

harshil1712 · September 1, 2021, 11:48am

Can you check the Sheet ID that you’re using? Make sure that you don’t have any extra characters.
I get the same error when the Sheet ID is incorrect.

Saandhy_Ganeriwala · September 1, 2021, 11:52am

Have given screenshot of the sheet and also what I am entering in the Sheet ID

harshil1712 · September 1, 2021, 2:22pm

Hey @Saandhy_Ganeriwala,

I tested it out and it works for me as expected. From the screenshot that you shared, it seems that the ID is correct. I am not sure if there’s any whitespace that might cause the issue. Can you create new credentials, connect to your account and try again?

Saandhy_Ganeriwala · September 2, 2021, 9:30am

Thanks Harshil, it worked after i changed the credentials