(429): Too Many Requests when connecting to google sheet

[jtaelman]

I am working on a project where I need to use the data from a google sheet.

I am not able to import the data because of the 429 error: too many requests.

Via another reporting tool, I am able connected to that specific sheet.

(429): Too Many Requests
Details:
DataSourceKind=GoogleSheets
....

ranges=Overview%20pagina!A1:AH73170&fields=sheets/data/rowData/values/effectiveFormat/numberFormat,sheets/data/rowData/values/effectiveValue

[Anonymous]

Hi  @jtaelman 

The HTTP 429 Too Many Requests response status code indicates the user has sent too many requests in a given amount of time. Please try to combine some google sheet files into one .

Best Regards,
Community Support Team _ Ailsa Tao

[jtaelman]

@Anonymous 

There is only one sheet.

I have some conditional selection boxes in that sheet (referring to selection options in a second sheet) to limit the user's input, but also for user friendliness.

There is no other sheet involved.

A far less advanced reporting tool only takes the selected values in a column, which is how I assume it should work.