How to append multiple rows to Google Sheet in Single Node Execution

Questions
1

Hey folks!

I am attempting to copy bank transactions from my finances app (monarch) to Google Sheets. I have many transactions and thus would like to append all transactions (rows) to my Google spreadsheet in a single API call. Appending each transaction in a loop quickly exceeds the Google API transactions per minute limit.

Is it possible to append multiple rows to a Google Sheet in one node execution?

Thanks so much.

System information:

  • n8n version:1.24.1
  • Database: SQLite
  • n8n EXECUTIONS_PROCESS: own, main
  • runtime: docker
  • Operating system: archlinux
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:
3

@nmercaldo , you do not need to utilize any loop. Keep your transactions in a single list and feed that list into Google Sheet node.

1 Like
4

Hello @ihortom !

That is fantastic! Unfortunately, I have been unsuccessful in inducing multirow append when passing a list of rows into the Google Sheets node.

Could you perhaps provide me with a basic example of this functionality?

Thanks so much.

EDIT: Nevermind! Figured it out! Thanks once again!

5

If the data is from different formats you need to use a set node to ensure consistency. Next use the append to merge the data and write it to the sheets

6

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