Help

Re: How to connect airtable to google sheets?

Solved
Jump to Solution
8831 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Christopher_Rya
4 - Data Explorer
4 - Data Explorer

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

26 Replies 26

Peter - I wouldn’t say Integromat is ‘more robust’ - but I would say it’s more capable (you can build more comprehensive logic with it). See my comparison here:

http://software.kirknessassociates.com/blog_files/4c01f44b92b9730eedd8c04a88c5df9a-31.html

Ricky_Charpenti
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi @Christopher_Ryan, my name is Ricky and I created a site, Quickflow, that integrates web apps together. Airtable and Google Sheets are two of them. I’m already working on a specific integration to keep an Airtable table and a Google Sheet in full sync. If you’re interested on knowing when it’s done, drop me your email at https://www.getquickflow.com/pioneer and I’ll be more than happy to keep you posted!

Orin_Hutchings
6 - Interface Innovator
6 - Interface Innovator

You can use zzBots to one way sync from Airtable to Google Sheets.

You can create this sync at: www.zzbots.com

Below is a video that will walk you through how to create a one way sync from Google Sheets to Airtable in zzBots:

You could easily customize this bot to work the opposite way, and sync from Airtable to Google Sheets.

drassi
6 - Interface Innovator
6 - Interface Innovator

Hi everyone, I am surprised this hasn’t been mentioned yet, but an amazing solution for one-way Airtable to Google Sheets sync that has been reliably working for our business for years is:

Airtable Importer by Railsware

https://gsuite.google.com/marketplace/app/airtable_importer_by_railsware/817906878275

I can’t recommend it enough. I have no affiliation whatsoever with this company, we are just very happy customers. I think it costs $40/year for the fast auto-syncing version (1/hr I believe) but it’s completely worth it for us. No complex configuration or anything else, you just pop open the Google Sheets app tab, configure it with an Airtable Grid View link once, and then never have to worry about it again.

Luca_Fixy
4 - Data Explorer
4 - Data Explorer

Check this solution made by Optimi here : Google Data Studio connector for Airtable

Olga_Rusnak
6 - Interface Innovator
6 - Interface Innovator

Hi @Christopher_Ryan

You can also check out Coupler.io Google Sheets add-on that does exactly what you need: syncs Airtable with Google Sheets completely.

At this moment it is free of charge.

And if you are already aware of Airtable Importer, Coupler.io is its younger, but a more powerful brother :slightly_smiling_face:

Brian_Don
4 - Data Explorer
4 - Data Explorer

Hey Christopher,

Here’s a solution for you. Go to this page: https://automate.io/integration/airtable/google-sheets

Follow these steps:

  1. Connect your Airtable and Google Sheets accounts to Automate.io.
  2. Select the trigger and action you want.
  3. Map the necessary data.
  4. Test the integration and make it live.

Hope this helps :slightly_smiling_face:

Orin_Hutchings
6 - Interface Innovator
6 - Interface Innovator

Here is a solution.

I previously commented on this thread with a video showing how to set this sync up in zzBots.

This is now even simpler using the Bot Store to install this sync from Google Sheets to Airtable.
Install it here: https://www.zzbots.com/store/PZcihgaRgi5hsJzsr

Disclaimer: I am affiliated with zzBots

zzBots was pretty easy. I second that.

What about this:

https://youtu.be/U9v0il6nE2A ?

Tutorial on how to create simple two-way sync between Google Sheets and Airtable via Integromat. Integromat: https://rebrand.ly/tryintegromat Airtable: https://rebrand.ly/getairtable The first part of this video can be found here: https://youtu.be/t0ODCFZGSlA Business Automated is an independent ...