Import data from a CSV file to Google Sheets

Connect CSV to Google Sheets to instantly import your data from a published online CSV file to a spreadsheet.

The 4 steps to complete the setup

  1. Fill out the Title field
  2. Set up your data source
  3. Set up your data destination
  4. Configure importer's settings

1. Fill out the "Title" field

Name your importer. We recommend you pick a name that will enable easy in-app navigation for you and your team.

2. Set up your data source

2.1. Fill out the "CSV URL" field

Enter the CSV URL to export data from.

If you're importing data from a CSV file on Google Drive, enter the shareable link of your CSV file here. (The folder containing the CSV file on GDrive must also be shared with "Anyone with the link")
Click Show advanced to set up optional parameters for your data source.

2.2. Select an HTTP Method

Pick one of the HTTP methods from the drop-down list: Get, Post, Put, Patch, or Delete. Read more about HTTP methods.

2.3. Fill out the "Request headers" field

Specify an HTTP header that can be used in an HTTP request. HTTP headers do not relate to the content of the message. Read more about HTTP headers.

For example:

You may need to access the CSV URL, which uses Basic authentication. In this case, you'll need to add the " authorization:" header followed with the proper BASE64 encoded value:

Authorization: Basic SmlyYTpTZXJ2ZXI=

2.4. Fill out the "URL query string" field

Enter a query string (a part of the CSV URL), which assigns values to specified parameters.

Example:

limit: 100 
offset: 20

This parameter is not supported if you're importing data from a CSV file on Google Drive.

2.5. Fill out the "Request body"field

If your HTTP method POST, PUT, PATCH, or DELETE, you can specify the Request body - a part of an HTTP request that contains data sent to API.

Example:

dateRangeStart: '2020-01-01T00:00:00.000Z'
dateRangeEnd: '2020-01-07T23:59:59.999Z'
sortOrder: ASCENDING
description: ''
rounding: false
withoutDescription: false
userLocale: en_US
customFields: 
weeklyFilter:
  group: PROJECT
  subgroup: TIME
exportType: CSV

2.6. Fill out the "Fields" field

Specify the names of the columns in the CSV file to import to your spreadsheet, as well as their order. Separate column names by commas. The default behavior: select all columns.

Example:

Title, Status

2.7. Fill out the "Skip rows" field

Specify the number of rows to skip from the top of the CSV document. The default behavior: select all rows.

3. Set up your data destination

3.1. Fill out the "Sheet name" field

Name the sheet, which will be receiving data. If the sheet with this name does not exist, Coupler.io will generate a new one for you.
Click Show advanced to set up optional parameters for your data destination.

3.2. Fill out the "Cell address" field

Type in the address of the first cell where the data range will be imported. The default value is A1.

4. Configure importer's settings

4.1. Enable the Automatic data refresh

  • Select Interval
  • Select Days of week
  • Specify Time range

Check out more about Automatic data refresh.

Click Show advanced to set up optional settings for your importer.

4.2. Pick the Import Mode

Follow this link to read more about choosing a data import mode.

4.3. Add the "Last Update" column

If you want to add a column specifying the date of the last data refresh, toggle on the Last Update parameter.

4.4. Save the changes

Click Save to save the parameters or Save & Run to save the parameters and run the initial import right away.

Book a free onboarding call!
For any questions, feel free to email our team at coupler@railsware.com