Auto refresh/ connect to google sheets doesn't work, always getting Error: (429): Too Many Requests

[Oleh_Karavskyi]

Hi.
Could you pls help, want to connect to google sheets and at least one time per day update my bi dasbords app/ workspase

Always when I try update manyally or set schedule update always getting such error:

Processing errorWeb.Contents failed to get contents from 'https://sheets.googleapis.com/v4/spreadsheets/*******?fields=sheets/properties,namedRanges' (429): Too Many Requests

I don't need to update data every minute, just want that bi managed to take updated data from google sheets one/two times per day

[Ailsa-msft]

Hi @Oleh_Karavskyi 

The HTTP 429 Too Many Requests response status code indicates the user has sent too many requests in a given amount of time. How did you connect to Google and get data? Web connector or REST API ?

Best Regard

Community Support Team _ Ailsa Tao

[Oleh_Karavskyi]

HI!@Ailsa-msft,

Thank you a lot for your soonest response!
I'm connecting to google sheets using = GoogleSheets.Contents(
with Organisational privacy level