Airtable API Connection to Google Sheets

thomasg · ‎Sep 29, 2023

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?

ScottWorld · ‎Sep 29, 2023

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 · ‎Oct 02, 2023

@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.

thomasg · ‎Oct 03, 2023

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

Connor_hutch · ‎Jun 04, 2024

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.