I haven’t seen this problem, and I have many of my Airtable consulting clients connecting with Google Sheets.
Did you try reconnecting your Google Sheets account to resolve it?
If that doesn’t work, then there is something misconfigured with your Google Sheets account.
To receive more specific error messages about what went wrong, try setting it up with Make’s Google Sheets automations for Airtable, and see what error you get from Google Sheets.
Also, as a side benefit, Make offers tons more functionality for Google Sheets & Airtable automations than what Airtable natively offers.