Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.