Skip to main content

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

Hi @Christopher_Ryan



You might be able to use an integration app, such as Integromat or Zapier, to do this process.



Mary Kay


Hi @Christopher_Ryan - have a look at this post here:







TL;DR - not possible to do a full sync in Zapier.



But…might be possible in Integromat:







JB


Hi @Christopher_Ryan - have a look at this post here:







TL;DR - not possible to do a full sync in Zapier.



But…might be possible in Integromat:







JB


Hi



You’d almost certainly get further with Integromat compared to Zapier - but complete synchronisation isn’t really feasible for a whole host of reasons:







  1. There is not trigger based on deleted records from Airtable - so no way to delete from Sheets automatically







  2. There now seems to only be a new record trigger from Airtable - now way to trap an update as far as I can see at the moment. In V1, this was done with the New Record in view Trigger (as it is in Zapier) but this seems to be missing from V2. You cannot create a new scenario using V1.







  3. what happens if both AT and Sheets are updated at about the same time, Integromat or Zapier runs - which update should win?







There are many other issues with this type of synchronisation - in practice it’s often best to consider one of the systems as the ‘master’ and then do a periodic update of one from the other - Integromat has the advantage here as you can go through multiple records easily.



Julian


Hi



You’d almost certainly get further with Integromat compared to Zapier - but complete synchronisation isn’t really feasible for a whole host of reasons:







  1. There is not trigger based on deleted records from Airtable - so no way to delete from Sheets automatically







  2. There now seems to only be a new record trigger from Airtable - now way to trap an update as far as I can see at the moment. In V1, this was done with the New Record in view Trigger (as it is in Zapier) but this seems to be missing from V2. You cannot create a new scenario using V1.







  3. what happens if both AT and Sheets are updated at about the same time, Integromat or Zapier runs - which update should win?







There are many other issues with this type of synchronisation - in practice it’s often best to consider one of the systems as the ‘master’ and then do a periodic update of one from the other - Integromat has the advantage here as you can go through multiple records easily.



Julian




@Elias_Gomez_Sainz mentioned in another thread that the New Record in View behavior has been rolled into the New Record trigger somehow.






@Elias_Gomez_Sainz mentioned in another thread that the New Record in View behavior has been rolled into the New Record trigger somehow.




Hi @Elias_Gomez_Sainz - that is what the description says - but the watch records trigger has nowhere to select a view - it is only triggered by new records in a table.



You can achieve much the same though using a timed Integromat Scenario which uses the Search Records option (which can filter using a View in AT or a formula). The only proviso is that you would need to update the records you process so that they don’t get selected the next time the Scenario runs. Actually this is much more flexible than the watch records process (and Zapier equivalent).



Still doesn’t help with @Christopher_Ryan’s question though because there is no simple way to see that a record has changed in AT and for this to then update Sheets. One thing that could help would be if AT records had a Last Updated field (as standard) - I think there are threads already requesting this.



Julian


Ouch! I thought that the descriptions were right, cause there are very precise. V1:





V2:




Thanks all – and I’m glad my question sparked such a robust conversation. My two takeaways are:





  1. What I ask isn’t full feasible and I should walk away.


  2. I get the sense that Integromat is more robust that Zapier. Am I correct? Should I embrace one over the other?




-Peter


Hi



You’d almost certainly get further with Integromat compared to Zapier - but complete synchronisation isn’t really feasible for a whole host of reasons:







  1. There is not trigger based on deleted records from Airtable - so no way to delete from Sheets automatically







  2. There now seems to only be a new record trigger from Airtable - now way to trap an update as far as I can see at the moment. In V1, this was done with the New Record in view Trigger (as it is in Zapier) but this seems to be missing from V2. You cannot create a new scenario using V1.







  3. what happens if both AT and Sheets are updated at about the same time, Integromat or Zapier runs - which update should win?







There are many other issues with this type of synchronisation - in practice it’s often best to consider one of the systems as the ‘master’ and then do a periodic update of one from the other - Integromat has the advantage here as you can go through multiple records easily.



Julian


Thanks everyone. It looks like there’s no obvious solution to my problem at the moment then. Although what Julian mentions at the bottom of his post may actually be of help to me.



in practice it’s often best to consider one of the systems as the ‘master’ and then do a periodic update of one from the other - Integromat 1 has the advantage here as you can go through multiple records easily.



My airtable is in effect the master source, are you saying there’s a way for Integromat to take a snapshot from AT periodically and then export that snapshot to Google sheets? If so, how exactly can I do that? In integromat I can only see a trigger for when a new record is created in AT.


Thanks everyone. It looks like there’s no obvious solution to my problem at the moment then. Although what Julian mentions at the bottom of his post may actually be of help to me.



in practice it’s often best to consider one of the systems as the ‘master’ and then do a periodic update of one from the other - Integromat 1 has the advantage here as you can go through multiple records easily.



My airtable is in effect the master source, are you saying there’s a way for Integromat to take a snapshot from AT periodically and then export that snapshot to Google sheets? If so, how exactly can I do that? In integromat I can only see a trigger for when a new record is created in AT.


Hi @Christopher_Ryan



Integromat is different to Zapier in that the first step doesn’t need to be a ‘trigger’ as such. You could use the Search records option and have it return all records (how feasible this is would depend on your volume). You could then either update rows in Sheets - or new ones.



You would then set the Scenario in Integromat to run periodically (say daily).



Julian


Thanks all – and I’m glad my question sparked such a robust conversation. My two takeaways are:





  1. What I ask isn’t full feasible and I should walk away.


  2. I get the sense that Integromat is more robust that Zapier. Am I correct? Should I embrace one over the other?




-Peter


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


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!


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.


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.




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


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 🙂


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 🙂


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


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.


zzBots was pretty easy. I second that.


What about this:

https://youtu.be/U9v0il6nE2A ?


Thanks all – and I’m glad my question sparked such a robust conversation. My two takeaways are:





  1. What I ask isn’t full feasible and I should walk away.


  2. I get the sense that Integromat is more robust that Zapier. Am I correct? Should I embrace one over the other?




-Peter


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!


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.

 


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!


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.


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


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

 


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

 


is it easy?

1 or 2 way sync?


Reply