Best answer

Exporting Data to Airtable from Google sheets

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

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.

Did this topic help you find an answer to your question?

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

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor

+8

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

https://www.wemakefuture.com/

2 replies