Apr 16, 2020 05:11 PM
I would like to reference up-to-date data from an Airtable base in Google Sheets. For example, I’d like to execute a formula in Google Sheets based on live Airtable data, or populate a Google Sheets dropdown menu (via data validation) based on the data in an Airtable field (i.e. column).
I know that it’s possible to export data from Airtable, but those data are static (i.e. they won’t update when the data in Airtable changes).
Thanks a bunch.
G
Apr 17, 2020 01:17 AM
I recommend looking at Zapier or Integromat - Both are great solutions, and will do what you need.
Jan 04, 2023 06:58 AM - edited Jan 09, 2023 11:15 PM
Hi there!
If you are looking for an automated Airtable to Google Sheets data export, I would recommend using a Coupler.io data integration tool. It is a no-code data extraction tool that allows its users to pull out the data from Airtable and other 30+ essential business apps on a desired schedule to one of the following destinations: Excel, GoogleSheets or BigQuery.
Please use Airtable Source link to learn more about this integration. Also you can take a look at step-by-step guide of how to extract the data from Airtable to Google Sheets with the help of Coupler.io. 🙂