Exceeding "Read Request" limit for Google Sheets

#1

Hey,

I keep exceeding “Read Request” limit for Google Sheets - I’m using the Direct connector for Google Sheets.

image
image1419×281 14.4 KB

The thing is, the tables of data that I’m pulling at any one time are no where near the 100K records, with it probably amounting to less than 3k, however I’d anticipate the data across all tabs of the spreadsheet to be in excess of 1-2m.

Is the problem with the sheets or does it all need migrating to using Jet Tables (although I seemingly hit a rate limit with JET tables also…)

Thanks!

#2

Hu Alex, thanks for your question! You shouldn’t hit the limit with Jet tables so it’s already odd. Sheet’s API allows 300 calls/minute which should be enough.

Can you please share the project URL here or through DM? - we’ll take a deeper look.

#3

It seems to have been resolved by reducing the amount of direct connections - I think it could be that the mix of direct and JT meant that if the direct calls were pushing near the limit, the JT connection had the chance of “tripping the limit”.

Have had no issues with the API rate limit since, and the the writing of JT → JT Tables → Google sheets seems to be pretty instantaneous which is pretty neat.

#4

I’m having the same issue. I’m using the direct Google Sheets connection.

Is there any way to increase the maximum amount of API calls?

#5

Hi! The limit is set by Google, we can’t change that from our side. We are working on improving our sync algorithms to reduce the amount of requests we are making. ETA is about 1 week.
If you want us to take a closer look at your case, please message us through via instant chat in the bottom right corner while in the builder.

#6

Hey everyone! We’ve improved our data-pulling algorithms for Google Sheets so that 429 errors should happen less frequently.