Forum Discussion
Google Sheet Connector
I am having trouble connecting to data on Google Sheets. Here is the error: Web.Contents failed to get contents from 'https://sheets.googleapis.com/v4/spreadsheets/CTrTkX99999999999?fields=sheets...
Can you share the full M code for the Power Query query that you're using? It looks like Google Sheets is raising this error because your code is making too many requests in too short a time period. Wrapping the call to get data from Google Sheets with Table.Buffer or adding delays between calls using Function.InvokeAfter (see https://blog.crossjoin.co.uk/2015/04/30/using-function-invokeafter-in-power-query/ for example) might help avoid this error.