Push Airtable to Google Sheets

How To
,
1

I found a related topic that mentions creating a button to create a manual push from Airtable to Google Sheets. However, it was more focused on the pull from google sheets vs the push to google sheets.

Forgive my lack of knowledge, but my goal is for ANY Airtable updates in one particular view to update a Google sheet. The purpose it retain our Source of Truth, BUT share data in spreadsheet format to someone on our team and they prefer Google sheets.

We would not want them to update any fields in this Google sheet, but they should be able to view it and have it as up-to-date as possible.

Any ideas?

2

Hi :blob_wave:,

Unfortunately, Airtable does not have a webhook module that could execute your scenario with every change done in Airtable.

Unless you would want to stick to the standard “Watch Records” scheduled to sync your table and sheet multiple times a day, you might try to create a similar “button” in the Airtable yourself.
Simply with a link to Make webhook.

The “Custom Webhook” module would then execute a scenario that would search the whole Airtable Table and updated appropriate rows in Google Sheets. Similarly as in the below picture.

image
image1812Ă—500 70.2 KB

I hope it makes sense.

Cheerio :cat_roomba:

2 Likes