Airtable Integrations With Google Sheets and Forms

One of the most popular Airtable integrations is with Google sheets and Google Forms. In this video, we discuss how to integrate them so that new rows in a Google Sheet or Form can be created as a record in Airtable, and conversely how newly created records in Airtable can be synced to Google Sheets as a new row.

[@puseletsomaraba1313]

thank you so much.needed this integrate with my apps

[@johnquesterloyola1229]

u can't update it but is it possible you could do is scd type 2?
wherein everytime a row is created/updated, it would insert it to the other tool, then just filter the latest 'datemodifiedon' column or 'datecreatedon' column

[@RockCityTumblers]

i just used the new extension Dokin and it's syncing🙌🏼🙌🏼

[@user-vu4qr8pg9u]

Aren't there any way to sync google sheets and airtalbe by updating and deleteting rows ?

[@charmaineruiz6220]

Thanks! Followed your instructions and the tests are valid, but it doesn't reflect to my table. Is there any additional step for that?

[@noochy12]

Hi, I just tried the first part to get data from GS to Airtable. It's working but When I go to Airtable to see what was sent, it's only sending the first cell I enter data. Almost like the first cell is the created record and all the rest are updated records

[@amypareezer7946]

I also had the same issue, only 1 row carries over. How to have all the rows transfer from GS to Airtable? @danleeman?

[@gunrajsingh563]

Aren't there any way to sync google sheets and Airtable by updating and deleteting rows ?

[@jasonvangotten1229]

If our company utilizes Excel, not Google Sheets would we have to convert our Excel files to GS?

[@danleeman]

Hey Jason,
There are easy ways to import/export data to Excel. If you need continuous integration (like the example here) you'd need to be on Office 365 (cloud) and use a tool like Make to assist with the movement of data

[@katiaberrios6081]

I can't find my google sheets into my Google sheets account 😢

[@danleeman]

Just checking, do you maybe have 2 different Google accounts (work, home?) and you've authenticated with the other account?

[@katiaberrios6081]

@@danleeman Hi 👋 I figured I had an excel file ( and not google sheets) , I finally made it :D . Thanks !