Bug in Google Sheet API request

Questions
1

Hi, I am using n8n cloud version 1.41.1. Every setting is default.
I was making a request to append rows to Google Sheet with Sheet API.
The process is to create a report by creating a new spreadsheet and append data to the newly created spreadsheet.

image
image371×178 7.78 KB

I use a variable to store the 2D array for the json request body as below:

image
image358×118 2.05 KB

However, when I used the variable in the request body in the sheet api node, the array showed up incorrectly, missing the closing square bracket.

chrome_NnuItCCMU6
chrome_NnuItCCMU6607×416 7.19 KB

Could anyone tell me where the mistake is?
Best regards,

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
5

Hi @emhaii

Thanks for posting here and welcome to the community! :partying_face:

I am trying, but I cannot re-create this output that you are getting. Could you share your workflow and ideally pin the mock data? You can share your workflow here by pasting them as JSON in between two block quotes (```).

Also, just out of curiosity, why are you using the HTTP request node instead of the Google Sheet Node ?