Use Zapier & EasyCSV Together

How to use Zapier to send spreadsheet imports anywhere OR create CSV files from another app's data.

How to make import zaps with EasyCSV: Send each row to trigger Zap - 4 minutes

  1. Click here to start a Zap for EasyCSV then click "Connect with 2,000+ Apps to start a zap" - OR - choose a Zap template below.
    Try a popular Zap template:
  2. On the EasyCSV trigger action step, choose "New Spreadsheet Row Import".
  3. On the EasyCSV trigger testing step, click the "Get More Samples" button to get an example row for a spreadsheet import you have setup (fyi: click "Get More Samples" if you ever update the acceptable columns for a spreadsheet import). Zapier More Samples Example
  4. Choose sample data you are making this Zap for to make it easy to map fields from EasyCSV to the action in the next step. Then click "Continue".
  5. Choose the action app (examples below) you want spreadsheet row/record import data to go to.
  6. Go back to your import page on EasyCSV.io and click the button at the top "Send to Zapier". If you don't see a button click the "Sheet Details" link at the top of the page and click the checkbox labeled "Post to Zapier".
  7. It's that easy!

WARNING: Each row being imported will count towards your monthly plan task limit on Zapier IF your zap gets to an action step. If the Zap stops at a filter after the trigger step it will NOT count towards your limit as the Zap was not fully executed. You may want to limit the allowed number of rows per import to be a low number.

How to make import zaps with EasyCSV: Send an entire CSV File to trigger a Zap - 4 minutes

  1. Click here to start a Zap for EasyCSV then click "Connect with 2,000+ Apps to start a zap" - OR - choose a Zap template below.
  2. On the EasyCSV trigger action step, choose "New CSV File Generated via Import".
  3. On the EasyCSV trigger testing step, click to get example data.
  4. Then click "Continue".
  5. Choose the action app to be an app that can accept a URL to a CSV file and put the file where it needs to go. Examples: Gmail can use the CSV file URL as an attachment. Dropbox can use the URL to put into your Dropbox. Google Drive can use the URL to put into your Google Drive.
  6. Go back to your import page on EasyCSV.io and click the button at the top "Send to Zapier". If you don't see a button click the "Sheet Details" link at the top of the page and click the checkbox labeled "Post to Zapier".
  7. Then under the Post to Zapier option choose the option to "Create a new CSV file with all import data and trigger a Zap execution with the new file".
  8. You can also optionally specify the filename of the CSV file that is generated and sent to Zapier.
  9. It's that easy!

How to send a test row to Zapier

Step 1: Choose to send spreadsheet imports to Zapier

If you have not already specified to send your spreadsheet imports to Zapier then click edit on the sheet and choose Zapier.

Step 2: Click the 'Send Test Row' button.

If you are logged in as an admin, view the spreadsheet import form. You will notice a 'Send Test Row' button in the right side column. Simply click it!

How to make a CSV File in my Zap from data of another app - 4 minutes

  1. Start by creating a new Zap
  2. For the "When this happens..." (trigger) step choose any app you want that will trigger the zap to run.
  3. For the "Do this..." step (action) Search for "EasyCSV" and select the app.
  4. Follow the steps to select your EasyCSV account or create an account.
  5. If you have not created an EasyCSV CSV Generator before one will be auto-created right from Zapier. You can log in to EasyCSV and edit the generator settings to specify emails options, default filename, and SFTP details. You will also be able to see a log list of CSV generator executions and links to any files that were generated by your Zap.
  6. Specify your CSV file column headers and first row of data. (If you need to generate multiple rows of data in a CSV file you will want to use the "Webhooks by Zapier" action - How to Docs here).
  7. Test the action and you will see a File URL returned you can use later in your Zap. Depending on your Easy CSV Generator settings at www.easycsv.io the CSV generator may also email the people you have listed and/or upload the generated file via SFTP where you have specified.
  8. It's that easy!

Why should I use EasyCSV with Zapier?

EasyCSV enables two great functions with Zapier. EasyCSV enables you to send spreadsheet data to any app Zapier supports. EasyCSV is also the only app that enables you to create CSV files you can use in your Zap, email the file as an attachment, or upload it via SFTP.

See example Zaps to get an idea of what is possible: EasyCSV Zap Examples

How can I have multiple EasyCSV import pages or email addresses sending data to multiple zaps?

  1. Create all your EasyCSV import pages and have them all set to send data to Zapier when importing.
  2. In Zapier, you will create one or more Zaps per import page.
  3. When you create a zap, choose EasyCSV as the first step of you zap.
  4. When you get an example row, you need to check the field "spreadsheet name" to match the import page name. If you get a row for a different import page, just click the button to get another example row in Zapier. You may have to try a couple time.
  5. Once you get the right example row data then finish editing the first step, trigger of the Zap.
  6. Click the little circle with a plus symbol in-between the Trigger and the destination of the zap to add another step to you zap in the middle.
  7. Choose to add a filter. We will use a filter step to only let new row data from a specific EasyCSV import page through to the later steps of your Zap. Your task count will only be affected if your full zap runs. That is why filters are so nice!
  8. In the filter, choose "spreadsheet name" - "exactly matches" and then type the name of your import page exactly.
  9. Finish your zap by setting the data destination app and mapping the EasyCSV fields to the final app or api fields you want to send your data to.
  10. Turn your Zap live.
  11. Try an import on your import page the zap(s) has been set up for.
  12. Repeat all these steps for as many import pages as you need. You can have multiple zaps fire for any import page.

I am using Zapier to send CSV import data to my webhook. How does Zapier send data to my webhook?

In your EasyCSV import page sheet details, if you have chosen the option "Each row being imported should trigger a Zap execution", Zapier will be triggered for every row/record of a spreadsheets that is being imorted. Therefore, your webhook will be hit for every row/record of a spreadsheet. (Make sure your webhook can handle a high-volume of requests in case a user imports a large spreadsheet consisting of many rows)

In your EasyCSV import page sheet details, if you have chosen the option "Create a new CSV file with all import data and trigger a Zap execution with the new file", Zapier will be triggered once for each import with a url to a CSV file.

How do I re-connect EasyCSV to Zapier?

Have your admin log into Zapier and go here to reconnect Zapier to EasyCSV: Zapier Authorizations List.

Why is Zapier limited to 1500 rows per import when I want each row to trigger a Zap execution? How can I post more to rows/data?

Why the limit?

If EasyCSV enabled you to upload more than 1500 records per import you would encounter the Zapier rate limiting system – you can read more about it on Zapier's page. Even at 1500 records per import you may encounter rate limiting if you attempt to do many 1500 record imports.

IMPORTANT Zapier's default Flood Protection limit for a Zap is ONLY 100 records in a short period of time. Zapier now let's you customize your Flood Protection limit on a per Zap Basic. Allowing up to 1500 records to be submitted without hitting the limit: Customize your Flood Protection Limit. If your files will have more than 1500 records per file, then use the Webhooks by Zapier option detailed below.

Let's say EasyCSV enabled uploading of more than 1500 records per import, trying to process more than 1500 records at a time means Zapier would hold the 1501+ tasks and email the Zapier account owner asking for their approval to process them. Once granted, Zapier will process the tasks at the rate of 1 per second. This is known as Zapier's Flood Protection.

At the speed of 1 second of processing per row, then uploading such a large number of items might not be a great fit – this is because processing 9,000 records would take about 2 hours to run.

How can I submit all the rows from my CSV to Zapier?

There are 4 good options to process more records per CSV imported:

Recommended Solution Walkthrough - Import up to 10,000 rows into Zapier:

  1. Most Popular & Recommended: Instead of using EasyCSV as the first trigger step of your Zap, use "Webhooks by Zapier" > "Catch Hook".
    1. You will then get a Custom Webhook URL in Zapier. Copy that URL.
    2. Go back to your EasyCSV import page and change the destination to be "Post imports to an API / Webhook" instead of sending to "Zapier".
    3. Paste the URL you get from Zapier in the text field for the API Webhook URL in EasyCSV.
    4. Click the checkbox on EasyCSV labeled "Post multiple records at once in bulk chunks" and bump it up to a number you like - maybe go with 1,000 to start. Zapier can accept up to 10,000 POST calls every 5 minutes.
    5. Save the EasyCSV form.
    6. Back in Zapier, click continue to get to the "Test Trigger" step. Zapier now wants you to send some example data.
    7. Now go back to your EasyCSV import page and select the file you wish to import and click to send it to Zapier.
    8. Back in Zapier click the "Test Trigger" button and you should see an example row of data you can use in the rest of your Zap.
  2. Email Zapier support and ask for a higher limit. Many customers, especially if you are on the pay-as-you-go Zapier plan, get the Zapier support team up the limit. If you get it successfully put to the limit you need just chat EasyCSV from your import page or email support@easycsv.io and EasyCSV can also up your limit.
  3. Post your imports to Google Sheets first (EasyCSV docs to post data to Google Sheets), then set up a Zapier Zap to be triggered when new rows are added to the Google Sheet. Zapier will process every new row that was added from EasyCSV over time. Zapier has built that process to get around their flood protection.
  4. Look for any API docs for the application that your Zap is sending the data to. You can try following the docs and use the option in EasyCSV to post data to a Webhook. If you need help going directly to an app, instead of through Zapier, please contact EasyCSV support and we can help you connect it.

Troubleshooting Zapier Issues

Visit this page Zapier connections. Find EasyCSV and click the "Test" button. If you do not see a "Success" message, then click the "Reconnect" button and test again.

If reconnecting did not work then click the "Disconnect" button. Then start a new Zap for EasyCSV by going here: Click here to start a Zap for EasyCSV.