How do I use different Google Sheets accounts on n8n?

Questions
1

Good evening, how do I use different Google Sheets accounts on n8n?

When I log in to a specific flow, consequently all other flows also change the Google account

I want a specific flow to use a different account than the others, because I’m using it to read spreadsheets and send emails, so I end up having many requests in a short space of time, which sometimes causes the other flows to fail. google sheets node, due to excessive requests, so I would use a specific account for this email flow, and another account for all other flows

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


n8nn8n Team

1m

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

  • n8n version: Version 1.33.1
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker compose
4

image

I use Oauth2

5

That’s not how it works - each node allows you to select the Google credentials, so you can definitely use multiple accounts. Perhaps you copy/pasted nodes so they all use the same account?

And in order to avoid rate limiting you can use a Loop over Items node in combination with a wait node to reduce the frequency of the requests.

1 Like
6

image
image1613×633 49.8 KB

Ah yes, true, I was using an old version of node, I created a new flow with the latest sheets node and made a new credential

But I’m facing a problem

EXIT
Maximum call stack size exceeded
Error details

Other information
n8n version

1.33.1 (Self Hosted)

Stack trace

RangeError: Maximum call stack size exceeded
at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Google/Sheet/v2/actions/sheet/read.operation.js:182:20)
at processTicksAndRejections (node:internal/process/task_queues:95:5)
at Object.router (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Google/Sheet/v2/actions/router.js:67:23)
at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Google/Sheet/v2/GoogleSheetsV2.node.js:21:16)
at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:724:19)
at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:660:53
at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1062:20

My spreadsheet has around 278 thousand rows, could this be it? In the flow where I use the old node, it works perfectly, however when adding the new sheets node this error appears when giving a “get rows”

7

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