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]

That is only possibly with 3rd-party apps, like Zapier or Make.

Hope this helps!

- ScottWorld, Expert Airtable Consultant 

[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!