CSV data source
Learn how to set up a CSV data source and then move this data to one of the supported by Coupler.io data destinations.
Video tutorial:
The 2 steps to complete the setup
1. Set up your data source
1.1. Select an application: CSV
1.2. Fill out the "CSV URL" field
Paste the CSV URL to export data from. This field supports macro. Learn more.
If you're importing data from a CSV file on Google Drive, enter the shareable link ("Anyone with the link can view") of your CSV file here.
If you want to import from a CSV file on Google Drive securely (without file sharing with the public) you can use our Google Drive importer.
1.3. Select an HTTP Method
Select a method to indicate the desired action to be performed for a given data source. Learn more
1.4. Fill out the "Request headers" field
Specify the header parameters if you use a protected/private API or define the response rules for the returned content. Learn more
1.5. Fill out the "URL query parameters" field
Specify the query parameters to narrow your results. Learn more.
This field supports macro. Learn more.
1.6. Fill out the "Request body" field
Specify the Request body, which is part of an HTTP request and contains data sent to API. It is only supported by these HTTP methods: POST, PUT, PATCH, and DELETE.
This field supports macro. Learn more. Example:
customer_id: 1 customer_email: email@example.com<br>
This field supports macro. Learn more.
1.7. Fill out the "Columns" field
Specify a comma-separated list of fields and their order to be imported to Google Sheets. By default, Coupler.io will select all fields (e.g. Title, Status).
1.8. Fill out the "Skip rows" field
If your CSV file has multiple headers, specify the number of rows to skip from the top of the document. By default, Coupler.io will select all rows.
2. Set up your data destination
Continue setting up the integration depending on the system to which you want to import data. See the full list of supported data destinations and follow the setup guide for the chosen one.