Although I have connected my Google Sheet, the node isnt getting executed. Can you help me with where i am going wrong?
Can you please share more information. What authentication method are you using? Do you get any errors when you execute the node?
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.
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?
Thanks Harshil, it worked after i changed the credentials