I have not experienced this problem with any of my clients.
You may want to try reconnecting your Google Sheets account to resolve it. (If that doesn’t work, then there might be 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, and see what error you get from Google Sheets.
Also, as a side benefit, Make's automations & integrations offers tons more functionality for Google Sheets & Airtable automations than what Airtable natively offers.
If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
For those looking for a slick solution to this problem, I'd encourage you to check out CSV Getter’s guide on exporting Airtable to Google Sheets. Can be done in a few clicks.
Export Airtable to Google Sheets
Hey @GavinA that is interesting, thanks for sharing.
Also, in additional to Make.com I would highly encourage you to check out n8n.io. You can check the differences here.
Mike, Consultant @ Automatic Nation