How to connect airtable to google sheets?

[Christopher_Rya]

Hi,

Is there a way to connect airtable to google sheets such that it syncs completely? So every time any change is made to my airtable the corresponding google sheets file will also be updated?

Thanks,
Chris

[mikikizuna]

I have another question related to this thread. 

Without using Integromat, Zapier, or any other source, can AT update when a Google Sheet is updated?

If I upload a new Google Sheet/Excel sheet, will my data/records will be updated, duplicated, overrided?

Thanks!

[atusr]

Hi Chris,

Try cdata.com/kb/tech/airtable-cloud-google-sheets.rst

Pricing is 199$ (USD) per year, the most efficient solution that i tested up to date, 30 days free trial.

[atusr]

They will be UpDated.

If the id fields that you choose do not match, then you can use an extension called DeDupe to merge duplicate records.

[MichaelTomar]

You can use the Skyvia cloud platform to connect Airtable and Google Sheets. It is a freemium app with no code.

[changchen]

You can try Bardeen, it has ready to use Airtable to Google Sheets connectors

[atusr]

is it easy?

1 or 2 way sync?

[ScottWorld]

I typically use Make's Google Sheets integrations to do this.

There is a small learning curve with Make, which is why I created this basic navigation video to help. In that thread, I also provide the links to a few other Make training resources there as well.

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld

[GavinA]

Pretty cool way of doing it: 

https://youtu.be/mU2my6U3vZU

[matthew_b]

Hi Christopher - figure you've found a solution by now (😅), but since things have progressed a ton since 2019, wanted to share for others.

Whalesync now has a true two-way sync with airtable<>gsheets so that every time a change is made in airtable it updates the corresponding google sheet (and vice-versa):

https://www.whalesync.com/connect/airtable-google-sheets

https://www.youtube.com/watch?v=BDH5f7OUHlQ