To bulk import data into your Zaps, you can do so by using a spreadsheet app. You only need to get your data into a spreadsheet format, like a CSV file.
This tutorial will show you how to achieve this with Tables or Google Sheets.
Tip
TipYou can also transfer existing data using a Zap.
1. Export data into a spreadsheet file
- Import data into Zapier Tables. You can do this with a CSV file, or import rows from Airtable or Google Sheets.
- Once your data has been imported, click the + button to add a new column.
- In the name field, enter “Send to Zapier”.
- Import your data into Google Sheets.
- Add a column called “Send to Zapier” in your new spreadsheet.
2. Setup the import data Zap
In your Table:
- Click the column Send to Zapier.
- A new menu will be displayed. Click + Create Zap.
- You’ll see your trigger prefilled in the Zap editor. This means your Zap will only trigger when the Send to Zapier column is updated.
- Click Continue.
- Next, set up the action. This will be the app you want to send the data to.
- Once you’ve finished setting up your action step, click Publish to turn the Zap on.
In your Zapier account:
- Go to the Zaps.
- Click + Create.
- Click 1. Trigger
- In the dialog box, search and select Google Sheets.
- In the Event dropdown menu, select New or Updated Spreadsheet Row.
- Click Continue.
- Next, you will need to connect to your Google Sheets account:
- Click Sign In and follow the on-screen instructions to connect to your Google Sheets account.
- Click Choose and select your Google Sheets account.
- Click Continue.
- In the dropdown fields, select the spreadsheet and worksheet from step 1.
- For the Trigger Column dropdown field, select Send to Zapier. This means that anytime this column is updated in a row, it will trigger the Zap.
- Click Continue.
- Next, set up the action. This will be the app you want to send the data to.
- Once you’ve finished setting up your action step, click Publish to turn the Zap on.
3. Send data to your desired app
Once your Zap is published, you can import your data into your desired app. You can do this by:
- In your spreadsheet from step 1, in the column “Send to Zap” add text to trigger the Zap. Zapier recommends updating 100 rows every 20 minutes.
- Repeat this process until all rows have been updated.
NoteIf you try to update more than 100 rows within a 20-minute period, you may get throttling errors when trying to update all rows simultaneously.