Error code 429: Reached rate limit for requests.

[RoliveIndeed]

I am using the Google Drive Input connection to connect to a Google Sheet with multiple tabs.  The setup of each tab is different so I have 6 separate connections for the Google Drive Input tool.  When running the process I am getting the following error "Error code 429: Reached rate limit for requests."  I assume it is because I am referencing the same file for each tab.  Do I need to create 6 separate Google Sheets to reference instead?  Or is there another way around this?

[cpet13 · Accepted solution]

Hi @RoliveIndeed. I found this article about a similar issue on Stack Overflow. You could have each input tool in a control container, connect the control containers, then have one run, add a delay of a minute or two, then run the next, etc. How to handle Quota exceeded error 429 in google sheets when inserting data through python? - Stack ...

[apathetichell]

429 for gsheets is 350 in a single minute. you clearly hit that. you can a) ask google to raise this rate limit for you (which they usually do) - b) try to add a block tool somewhere. c) use a batch macro or something. or d) try to rewrite the gsheet tool in Python because Alteryx didn't do a great job.

[RoliveIndeed]

Control Containers was the way to go!  Worked perfectly and didn't even need a timer in-between!