Google Sheets Append row Error

Questions
1

Hi all, I am new here in this community. I already try to use the Google sheets and append row node to insert data into a sheet. The workflow runs without errors, but no new row shows up in the sheet. I already check is the authentication is set up correctly, the spreadsheets id and sheet name are correct, and the data I’m passing has the right fields.

Still nothing appears in the sheet after execution. Anybody have the same issue or something I’m missing. Please help me, I really appreciate it

2

Hello Jones_smith, welcome the n8n community. I’ll try my best to help!

I think this usually happens when the range or sheet tab name isnt exactly what Google expects. A couple things to try:

  1. Check the sheet tab name again and make sure its correct cus its case sensitive
  2. Clear Named Ranges, if the sheet has a defined range, sometimes the append node wont expand correctly. Remove named ranges or specify the sheet without them.
  3. Test with simple data, you can try to appending just one column to confirm it works, then expand.

If that still fails, the workaround is to use Google Sheets API via HTTP node where you have more control. but 90% of the time, its just a mismatch with sheet/tab naming.

I hope this will help you to create it, hope will works yaa! :blush::raising_hands:

1 Like
3

Thank you for the greetings. I double checked the sheet name and tried raw mode, but still wont append anything. Is there any clue I can try? I am so confused :confused:

4

Oh yeah, if its doesnt work. How about the drive permissions? Make sure the service account (or the Google account you connected in n8n) actually has edit rights on that sheet, not just view.

2 Likes
5

OOO yeah, aaa my bad. That is my mistake, thank you so much for the responds.

6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.