Hi Everyone,
I am testing an API which sends data to Google Sheets. I am struggling to send data to sheets which is the first sheet. Would someone be able to help?
Solution:Jump to solution
Hi @GGB The Add Row node is working fine, the is that the sheet name you are using in the Get Sheets node is wrong, and it won't fetch the data. Seems you have mistakenly added the range in the sheet name. - Retirement Spending!B2:B24, on the Get Sheets, you can remove the range and confirm the sheet's name.
Also, if you execute a full workflow test and check the logs you should be able to see the inputs of the Add Row in the logs it is updating/adding rows to the correct sheet.
And the data format should be in this form
[...
3 Replies
AI Support Bot Information
<@1000454415293087764> you can react on the relevant answer (message) with a ✅ in this thread when you think it has been solved, by the bot or by a human!
Anyone can react on this message with a ❌ if the GPT bot is unhelpful or hallucinating answers.
Please note: Team members will review and answer the questions on best efforts basis.
I'm trying to send data to other sheets
Solution
Hi @GGB The Add Row node is working fine, the is that the sheet name you are using in the Get Sheets node is wrong, and it won't fetch the data. Seems you have mistakenly added the range in the sheet name. - Retirement Spending!B2:B24, on the Get Sheets, you can remove the range and confirm the sheet's name.
Also, if you execute a full workflow test and check the logs you should be able to see the inputs of the Add Row in the logs it is updating/adding rows to the correct sheet.
And the data format should be in this form
[
["Cell1", "Cell2"],
["Cell3", "Cell4"]
]
Sent you an email reply on your support request.