Update an Airtable field when a Google Sheets cell is updated

[jcouser]

Hi,

I'm trying to figure out if there is a script or formula to allow for when cells are updated in a column of a Google Sheet to update a corresponding column in Airtable. Here's the scenario I have:

I have a Google Sheet that is organized by client project and it tracks the number of project hours used. I'd love for when the corresponding client project's client hours are updated in that Google Sheet that it is updated in the corresponding client record field in Airtable. 

I see a lot of stuff for updating a Sheet based upon an Airtable trigger, but not the other way. And I know that there is a Google Sheets API to add a row, but that's not what I need either as no new rows are created, it's just a field being updated.

Hopefully this makes sense. Would really love any guidance on this that someone may have.

Thank you!

Julie

[ScottWorld · Accepted solution]

That is only possible with 3rd-party automation apps, such as Zapier or Make.

It's a little easier to setup with Zapier, because Make requires the Chrome browser and a Chrome extension to do this, but in general Make is the better platform than Zapier.

That's because Make is INFINITELY more powerful & customizable than Zapier, yet it is SIGNIFICANTLY CHEAPER than Zapier. I wrote an entire Make vs. Zapier comparison at this link.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

[Tristan-ARG]

Hi  Julie, 

in this video is explained exactly how to do it 

https://www.youtube.com/watch?v=t0ODCFZGSlA&pp=ygUcZ29vZ2xlIHNoZWV0IHVwZGF0ZSBhaXJ0YWJsZQ%3D%3D

Hope it helps!

[TheTimeSavingCo]

On the off chance you've got a JavaScript developer on staff you can also accomplish this via Google Apps Script without needing to use/pay for another service too

[matthew_b]

Hi Julie!

Might be able to help here. Whalesync has a two-way sync between Airtable and Google Sheets:

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

This makes it so that any updates in an Airtable record sync to rows in Google Sheets and vice-versa without having to build convoluted step-by-step automations.

Let me know if you have any questions!

[jcouser]

I want to thank everyone who gave me some guidance here. In the end, Zapier proved to be the easiest and most successful route to accomplishing what I needed. Highly recommend it!

[ScottWorld]

Great job! Congratulations!

Just as a side note, to reiterate what I mentioned above:

99% of the time, Make is the superior option to Zapier... EXCEPT when working with Google Sheets. Then Zapier is the vastly superior one.

- ScottWorld, Expert Airtable Consultant