nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Error Message

Accepted answers

cpet13

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 Overflow

All comments

cpet13

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703