Describe the issue/error/question
I’m trying to create an automation that lists all Active Campaign tags and throws them into Google Sheets, keeping the tag name and how many people it has.
I would like to update this data every minute, however, Google Sheets cannot process the amount of Tag.
I currently have 360 tags in my Active Campaign, this value increases with every big event we do, and I would like to pass them all over to Sheets to create automated tracking sheets.
The problem is that when Google Sheets starts receiving the information, it hangs between line 60 to 70 and does not continue, displaying an error saying that our quota has been exceeded.
I already tried adding a Wait before the Google Sheets node, however, Wait keeps sending 360 rows at once and Google Sheets is failing to process this.
How can I solve this problem?
What is the error message (if any)?
The service is receiving too many requests from you! Perhaps take a break?
OR
ERROR: The service is receiving too many requests from you! Perhaps take a break?
Quota exceeded for quota metric ‘Read requests’ and limit ‘Read requests per minute per user’ of service ‘sheets.googleapis.com’ for consumer ‘project_number:30947376690’.
Please share the workflow
Share the output returned by the last node
Information on your n8n setup
- n8n version: 0.196.0
- Database you’re using (default: SQLite): SQLite
- Running n8n with the execution process [own(default), main]:
- Running n8n via Docker