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
- Fill out the Title field
- Set up your data source
- Set up your data destination
- 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.
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.
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.
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.
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.
This will skip 10 rows from top.
3. Set up your data destination
3.1. Connect a Google Account you want to import data to.
- Pick an account you want to connect to.
- Sign in to the chosen account.
- Review the contents of access rights which you are granting to Coupler.io and press Allow.
- Confirm your choices.
- Read the "Close this window" message and close the pop-up.
3.2. Fill out the "Sheet name" field
Click Show advanced to set up optional parameters for your data destination.
3.3. 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 & Import 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 email@example.com