Skip to main content

OK someone please help! About 2 months ago the automation I had set up from Airtable to Google sheets simply stopped working. I have reconnected everything but get the follwing error message.

Error message "This automation is no longer authorized to use the configured Google Sheets account. Please select a new Google Sheets account for this step. Please select a new Google Sheets account for this step."

I have a similar automation working fine. Why not this one?

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
 

 


Reply