Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Airtable API Connection to Google Sheets

2023 1
cancel
Showing results for 
Search instead for 
Did you mean: 
thomasg
4 - Data Explorer
4 - Data Explorer

I currently use the Airtable API connection to pull data into Google Sheets. I've gotten an automated message that the API key will no longer work in 2024. Is there a new solution that I can use? 

4 Replies 4

You have to use a Personal Access Token (or oAuth) to communicate with Airtable.

Also, for Google Sheets integrations, I would recommend using Make's Google Sheets integrations, which is what I use with all of my Airtable consulting clients. If you need help with any of this, feel free to reach out to me on my website.

Menark4419
4 - Data Explorer
4 - Data Explorer

@thomasg wrote: myenvoy

I currently use the Airtable API connection to pull data into Google Sheets. I've gotten an automated message that the API key will no longer work in 2024. Is there a new solution that I can use? 


If you've received a notification that your API key will no longer work in 2024, it's essential to follow up with Airtable's official documentation or customer support for the most up-to-date information.

How do I follow up? The only customer support I can find is a chat bot that doesn't help whatsoever. 

Hi Scott. I am trying to do exactly this thing. Airtable > Make.com > Google Sheet.  Every time I try to make the Airtable connection on make.com, I get a 403 error.  I know the PAT is correct.  Apparently 403 means I don't have the correct permission for the resource... but isn't the purpose of the PAT to give me that permission? I would very much appreciate your advice. Thank you.

Screen Shot 2024-06-04 at 5.56.57 PM.png