Error refreshing Google Sheets in dataflow

[euow9302]

I have a dataflow that contains tables from sharepoint and google sheets. There are 3 tables sourced from 3 different google sheets and the following error message will pop up from time to time. The table sizes are small within 1++ rows only.

DataSource.Error: Web.Contents failed to get contents from 'https://sheets.googleapis.com/v4/spreadsheets/...?fields=sheets/properties,namedRanges ' (429): Too Many RequestsDetailsReason = DataSource.Error
ErrorCode = 10117
DataSourceKind = GoogleSheets
DataSourcePath = https://docs.google.com/spreadsheets/d/ ....
Url = https://sheets.googleapis.com/v4/spreadsheets/....?fields=sheets/properties,namedRanges 

Here is one of my power query:

let
  Source = GoogleSheets.Contents("https://docs.google.com/spreadsheets/d/.../export?format=xlsx"),
  #"Navigation 1" = Source{[name = "Scheduled Customers", ItemKind = "Table"]}[Data],
  #"Promoted headers" = Table.PromoteHeaders(#"Navigation 1", [PromoteAllScalars = true]),
  #"Changed column type" = Table.TransformColumnTypes(#"Promoted headers", {{"Timestamp", type text} ....}, "en-AU"),
  #"Renamed columns" = Table.RenameColumns(#"Changed column type", {{"", "_"}})
in
  #"Renamed columns"

Is there a way to make it more stable?

[lbendlin · Accepted solution]

You are running too many requests in too short succession. Space your requests out more, for example via Function.InvokeAfter