A regular question we get in Zapier is: Can Zapier import/export my data from App A to App B?
Unfortunately, Zapier is not designed to mass import/export your data between two apps. We can only trigger from new data added to App A and send it over to App B only after creating and turning on a Zap.
While Zapier can't natively import/export existing data from one app to another, we do have methods one can employ to get around this limitation.
If you are able to get your data into a spreadsheet format like an excel or CSV file, you can use Google Sheets as an intermediary app in creating a Zap that mimics an import/export function of data from one app to another.
If you have data previously existing in one app that you'd like to move elsewhere, Zapier can help you move those provided you can export the apps data into a spreadsheet formatted file.
Here's an example of what your spreadsheet of data might look like. This example is a list of email addresses imported from an email marketing app in CSV format:
Suppose we want to transfer these 5 contacts from the email marketing app to a CRM app. What we can do here is setup a Google sheets Zap to send over the data to another app.
Below are the steps on how to set this up
Here's what you'll need:
Afterwards, set up the action for the app you want the data sent to. In this example, we are transferring over the information to a CRM app.
When setting up the action template, you should see all the columns from the spreadsheet as available fields which you can use to map out the action template.
Warning: If you have hundreds or thousands of rows in your spreadsheet, you may get throttling errors if you try to copy them all at once. We recommend copying them in at a rate no greater than 100 rows every 20 minutes
If you have multiple types of objects you'd like to create such as contacts, leads, opportunities, etc you'll need a different Zap for each of those, as they'll each require a different Action from the Zap.
Whilst it's not possible to export historical data from another app using Zapier, if you have been collecting continuing data to a Google spreadsheet, you can use the collected data for export to another app.
Below are examples of Zaps you can use in conjunction with other apps to collect data:
Lots of apps can take and import spreadsheet data via a CSV formatted file, you'll need to check the particular documentation for your app to make sure your column headers are correct first.