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
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.
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.
