VERY URGENT: Google Sheets Update Issue in Workflow

Questions
, ,
1

Hey guys,

this is very very urgent!
uploaded a video to state my problem:
[https://youtu.be/aqMKNmmoEws](https://Youtube video)

The core idea of my workflow is to watch for new leads inf a folder (where @Ingo and @Robm helped me with the csv to spreadsheet)- and then create a custom presentation from a template for each lead. And the final update of the lead list (adding the presentation ID) does not seem to work.

2nd problem is that this copy file module seems to very quickly match the API limits. It creates these presentations all within that one module “copy file” - which means if the lead list is a bit longer it processes to many files in too short of a time: The problem occurred with the DRIVE copy file module 403 error permissions: check quota. I think the quota is""300 write requests per minute per user.10 write requests per second per user. “” - problem is I don’t know how to add a delay if that all happens within the Google Drive Copy file module.

I am not sure if these are all problems with this workflow but I think so.

Anyways, thank you so much for anyone who can help with this.

  • n8n version: 1.69.2
  • Database (default: SQLite): QLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own, main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): self-hosted in google cloud
  • Operating system: Windows10
2

Short on time right now but given that you say this is urgent, maybe this will help.

Use the loop in batches node to throttle the calls to the api. You can figure out the batch size with trial and error and fild the biggest batch size that will stay below the limit. I am sure there is some maths you could use.

In your final sheet node you are using email to match on but you are not putting the email variable into the “values to update” field.

Thats needed so n8n knows which row ( or which email address) a particular presentation ID belongs to.

1 Like
3

Thanks a lot @Robm ! You are a true gem. The most important part works now but as far as split in batches goes I am unsure where and HOW to place it since it only allows me to adjust one field.

4

Hi @Robm . Thanks again. Could you please tell me where you meant to use the “loop in batches node” - I really don’t get it since the way I see it these custom presentations are generated within one node (Drive copy file)

5

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