Airtable to Google Sheets script

[thomasg]

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]

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]

---

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

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

[Connor_hutch]

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.