Google Drive Input - Sheets With Multiple Tabs

Question

Hi All,

I have a Google Sheet workbook with multiple tabs that I integrate into a single workflow. I was using the Google Sheets Input Connector, but it recently ceased working. I'm trying to update my workflow with the Google Drive Input Connector by using a new connector for each tab, but I'm getting an error indicating a rate limit ("Error code 429:  Reached rate limit for requests")

The solutions I'm considering, but don't fully know how to execute, are the following:

* Request a rate limit increase -- I'm having difficulty identifying the service in my Google Cloud account that I'd have to select in order to request a rate increase
* Use a single Drive tool, then connect to filter tools for each tab, then connect that to a Dynamic Input tool -- I don't know how to configure the Dynamic Input for a Google Sheet file
* Use Control Containers -- I've seen this suggested, but I don't know how to configure a control container in order to accomplish what I'm trying to do.
* Create a macro -- I'm sure there's a macro that could do what I need for this task, but I don't know how to configure one for this task.

I think option 2 would be the easiest solution if I could understand how to execute it. I'll take any and all solutions you can suggest. Thank you in advance for your help!

apathetichell · Answer

Hey --- so without knowing how this is setup on your GCP side ---> I can't answer this. If you are using a dedicated GCP client for your oauth ---> it would be tied into a GCP project --- and whoever at your company is also using that GCP project for integrations ---> alteryx doesn't matter here.

So most likely ---> something is off with Alteryx's gsheets implementation because you should not be hitting this issue for that amount of data/sheets. Potentially - this could be a you/your company issue. Easiest fix ---> have your company create a gcp project/client specifically for Alteryx and use it for your integration. If you still hit these issues it's 100% on the Alteryx side.

Note ---> if your company is on google workspace and does not use GCP for anything --- you have bigger issues.

kebinger · Answer

There are 12 sheets, with the largest being less than 300 rows, and each having around 2 to 6 columns. It's not really a ton of data.

>keep in mind that quotas are per PROJECT. not per user. if you are not using a company specific gcp app for your workspace integration --> I'd recommend it. These are basically 0 costs --- so if you need multiple clients (like one per department) you can have multiple projects under a single umbrella.

Unfortunately I don't understand what this means, but if it makes any difference, there are only 2 people in my company that have Alteryx licenses, and the other doesn't use Google integrations.

Do you have any suggestions for further troubleshooting steps or workarounds?

apathetichell · Answer

hey --- this is the standard rate issue for google workspace which tends to be like 500 reads per 100 seconds/60 writes per 100 seconds. So I guess my first question would be 1) how many sheets do you have 2) how many cells are you bringing it (ie how many cells per sheet) ---> alteryx should be doing some kind of batched getLastColumn/getLastRow for each sheet --- so I'm a bit surprised you are hitting the 429 issue on this.

keep in mind that quotas are per PROJECT. not per user. if you are not using a company specific gcp app for your workspace integration --> I'd recommend it. These are basically 0 costs --- so if you need multiple clients (like one per department) you can have multiple projects under a single umbrella.