Skip to main content
Solved

Sync data with Google Sheets

J

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??

Best answer by Olga_Rusnak

Just wanted to let you know that we’ve recently updated our Airtable to Google Sheets guide! It is not possible to set up custom schedule for data refreshes! So, feel free to review it and give it a try!

View original
Did this topic help you find an answer to your question?

M
Forum|alt.badge.img+20
  • M_k
  • Inspiring
  • August 13, 2019

Hi @Jonny_Longden

It sounds like it might be easier to use Integromat.

I have set up personal scenarios, for myself, similar to what you want to achieve and it probably can be done. You would have to further investigate this, to be sure. Integromat has a support forum on Facebook.

You may find it a bit cheaper to use Integromat, but you would have to do some research on the cost of the plan and operations.

Hope this points you in the right direction.

Mary

B
H
Justin_Barrett
3 people like this
  • B
    Bill_French
  • H
    HJun_Chen
  • Justin_Barrett
    Justin_Barrett
B
Forum|alt.badge.img+19

@M_k is right - Integro is a bit easier to understand than Zapier, although both do require some concerted effort to master. Using wither of these services do allow you to update and add new records based on the new records in your Google spreadsheet.

O
Forum|alt.badge.img+3

Hi @Jonny_Longden

I see that you did not find the right solution for your question. I hope that mine will help you sort it out.

It is possible to synchronize your data between Airtable and Google Sheets, keeping it in near to real-time sync.

How you can do it:

  1. Establish connection between Airtable and Google Sheets
  2. Set up automatic data refresh for 1 hour (so, every hour)
  3. Pull data to a destination sheet which you can call raw data.
  4. Create graphs and formulas in other sheets, referencing them to your raw data sheet.

You can do it by using Coupler.io Google Sheets add-on.

C
Y
A
5 people like this
  • C
    Canh_Phan
  • Y
    Yu_Guo
  • A
    Atreya_Chowdhur
  • C
    Caitlin_States
  • C
    cmatej
C
Forum|alt.badge.img+3
  • Canh_Phan
  • New Participant
  • April 28, 2020
Olga_Rusnak wrote:

Hi @Jonny_Longden

I see that you did not find the right solution for your question. I hope that mine will help you sort it out.

It is possible to synchronize your data between Airtable and Google Sheets, keeping it in near to real-time sync.

How you can do it:

  1. Establish connection between Airtable and Google Sheets
  2. Set up automatic data refresh for 1 hour (so, every hour)
  3. Pull data to a destination sheet which you can call raw data.
  4. Create graphs and formulas in other sheets, referencing them to your raw data sheet.

You can do it by using Coupler.io Google Sheets add-on.


This is an awesome feature!

O
1 person likes this
  • O
    Olga_Rusnak
O
Forum|alt.badge.img+6

Hi @Jonny_Longden,
If I understand correctly, you have a Google Sheet with data from Google Analytics, which includes new and updated rows?

If this is the case, you can install a full 1-Sync from Google Sheets to Airtable using zzBots. This will add new rows from Google Sheets into Airtable as new records, and update those records with any updates made in Google Sheets. The update will happen automatically.

You can install this sync here: https://www.zzbots.com/store/PZcihgaRgi5hsJzsr

The video below will explain how it works, and walk you through the install. There will also be a video to help you finish setting it all up after you install it. I hope this is helpful, and provides the solution to your problem.

Disclaimer: I am affiliated with zzBots

A
1 person likes this
O
Forum|alt.badge.img+3

Just wanted to let you know that we’ve recently updated our Airtable to Google Sheets guide! It is not possible to set up custom schedule for data refreshes! So, feel free to review it and give it a try!

C
1 person likes this
  • C
    catchel
J
Forum|alt.badge.img+2

Hi there! I’m from Unito, we offer an automated 2-way integration between Airtable and Google Sheets that’s pretty quick and easy to set up. The whole thing is no-code/self-serve, so you don’t need a specialist to help you get started. Here’s a case study put together by one of our engineers. Feel free to reach out if you have any questions!

R
Forum|alt.badge.img
Olga_Rusnak wrote:

Hi @Jonny_Longden

I see that you did not find the right solution for your question. I hope that mine will help you sort it out.

It is possible to synchronize your data between Airtable and Google Sheets, keeping it in near to real-time sync.

How you can do it:

  1. Establish connection between Airtable and Google Sheets
  2. Set up automatic data refresh for 1 hour (so, every hour)
  3. Pull data to a destination sheet which you can call raw data.
  4. Create graphs and formulas in other sheets, referencing them to your raw data sheet.

You can do it by using Coupler.io Google Sheets add-on.


Coupler.io is definitely the easiest but super expensive until they have competitive pricing models for light usage like this.

Ricardo11
T
2 people like this
  • Ricardo11
    Ricardo11
  • T
    TractionHQ
R
Forum|alt.badge.img
Orin_Hutchings wrote:

Hi @Jonny_Longden,
If I understand correctly, you have a Google Sheet with data from Google Analytics, which includes new and updated rows?

If this is the case, you can install a full 1-Sync from Google Sheets to Airtable using zzBots. This will add new rows from Google Sheets into Airtable as new records, and update those records with any updates made in Google Sheets. The update will happen automatically.

You can install this sync here: https://www.zzbots.com/store/PZcihgaRgi5hsJzsr

The video below will explain how it works, and walk you through the install. There will also be a video to help you finish setting it all up after you install it. I hope this is helpful, and provides the solution to your problem.

Disclaimer: I am affiliated with zzBots


Nice! Pricing seems fair too.

A
Forum|alt.badge.img+15
  • Andy_Cloke
  • Known Participant
  • October 26, 2022

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

C
Forum|alt.badge.img+1
  • cmatej
  • New Participant
  • December 9, 2022
Olga_Rusnak wrote:

Hi @Jonny_Longden

I see that you did not find the right solution for your question. I hope that mine will help you sort it out.

It is possible to synchronize your data between Airtable and Google Sheets, keeping it in near to real-time sync.

How you can do it:

  1. Establish connection between Airtable and Google Sheets
  2. Set up automatic data refresh for 1 hour (so, every hour)
  3. Pull data to a destination sheet which you can call raw data.
  4. Create graphs and formulas in other sheets, referencing them to your raw data sheet.

You can do it by using Coupler.io Google Sheets add-on.


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?

D
Forum|alt.badge.img+1

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

MichaelTomar
Forum|alt.badge.img+3

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

C
Forum|alt.badge.img+12
  • cshenoy86
  • Inspiring
  • November 7, 2023
Olga_Rusnak wrote:

Just wanted to let you know that we’ve recently updated our Airtable to Google Sheets guide! It is not possible to set up custom schedule for data refreshes! So, feel free to review it and give it a try!


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?

 

cshenoy
S
Forum|alt.badge.img+3
cshenoy86 wrote:

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?

 


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

C
Forum|alt.badge.img+12
  • cshenoy86
  • Inspiring
  • January 18, 2024
salah_osman wrote:

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


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 🙂

cshenoy
GavinA
Forum|alt.badge.img+13
  • GavinA
  • Inspiring
  • December 9, 2024

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

https://youtu.be/mU2my6U3vZU

matthew_b
Forum|alt.badge.img+15
  • matthew_b
  • Known Participant
  • January 11, 2025

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

Reply


Most helpful members this week

Terms & Conditions