Syncing with Google Sheets

[Jonny_Longden]

I use Airtable for something related to website data. I have a table which is a list of pages/URLs from a website, which was extracted from Google Analytics. The key is the URL/page but it also contains data such as the volume of page views and other statistics about the page.

In an ideal world I want this table to update automatically, so e.g. the data is always about the most recent month.

I know there is a zapier integration but I can’t get my head around it, mainly because what happens if someone creates a new page in the source data i.e I am not just updating records based on changes to the data in Sheets, I need to also populate new records. Is this multiple Zapier integrations??

[Andy_Cloke]

The Data Fetcher extension now has a Google Sheets Airtable integration which is easy to set up and can be scheduled to run up to every 5 minutes.

For your question about new items: new rows in Sheets create new records in Airtable

datafetcher.com

Import Google Sheets Data to Airtable (Integration)

Easily and quickly import Google Sheets Data to Airtable using the free Data Fetcher Google Sheets Airtable integration.

[cmatej]

Hello, i have similar situation, i want to sync changes from my google sheets to my Airtable almost instantly or in minutes, can coupler.io do that? If answer is yes, how?

Flow:

Added new row in Google sheet -> Adds new row in Airtable?

[Daniel_Halenko]

do any of these work 2 ways? coupler is V expensive IMO

[MichaelTomar]

Take a look at Skyvia - it allows you to connect Airtable with Google Sheets. ​​​​​​​This is a no-code cloud service

[cshenoy86]

Hi,

Sorry to barge into the conversation like this. However I am looking for Google Sheet to Airtable sync. Is there a similar guide for that too?

[salah_osman]

@cshenoy86 there are a few existing solutions, why haven't those worked for you? Are you looking for something custom?

[cshenoy86]

Hi Salah,

I had asked this question way back in November 2023 when I was still new to airtable and trying to figure out sync based on search from airtable. I have found out a way to do so using Make now. Thanks for this 🙂

[GavinA]

A video to show off a cool way of doing it:

https://youtu.be/mU2my6U3vZU

[matthew_b]

a bit late to the party but wanted to share the update for anyone new here -> 

Whalesync now has a 2-way sync between Airtable and Google Sheets 🎉

here's a quick demo if you want to see it in action: https://www.youtube.com/watch?v=BDH5f7OUHlQ