Skip to main content

Airtable API Connection to Google Sheets


Forum|alt.badge.img+2

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

ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8805 replies
  • September 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.


Forum|alt.badge.img+1
  • New Participant
  • 3 replies
  • October 3, 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.


Forum|alt.badge.img+2
  • Author
  • New Participant
  • 1 reply
  • October 3, 2023
Menark4419 wrote:

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


Forum|alt.badge.img+2
  • New Participant
  • 3 replies
  • June 5, 2024
ScottWorld wrote:

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.


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.


Reply