Best answer

Exporting Data to Airtable from Google sheets

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

icon

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

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

Userlevel 6

+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 :)

Userlevel 7

+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.

Sign up