Best answer

Exporting Data to Airtable from Google sheets

  • 27 August 2020
  • 2 replies

Userlevel 1

Hi community


So I created a zap to create a new record in airtable from google sheets which is working fine.

Problem- How do I transfer the existing data from my google sheets to Airtable. When I select the zap and click export it is just downloading it 



Best answer by Troy Tessalone 27 August 2020, 03:29

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Zaps only work when turned ON for new data going forward.
You’ll have to manually export your existing data from GSheets and import in to Airtable.

Or, depending on your Zap trigger, you may be able to update the row to trigger the Zap.

Userlevel 6
Badge +7

You can either directly import it via airtable API and execute a one time code or do it manually. 


If you then need a trigger on existing values, add a timed zap (Schedule by Zapier) and process the fields. Feel free to get in touch with us :)