Google Sheets destination setup
Review this guide to learn how you can set up Google Sheets destination for a number of supported by Coupler.io data sources.
The 4 steps to complete the setup
- Connect Google Account
- Select a spreadsheet and sheet to import data to
- Review optional parameters
- Set up an automatic data refresh
1. Google Account you want to import data to
- From the Destinations tab click "Connect new" and select Google Sheets
- 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.
2. Select a Spreadsheet & Sheet where to import data
Select one of the existing sheets to import data. By typing in a new name that doesn’t exist yet, Coupler.io will create a new sheet and then import data.
3. Review optional parameters
3.1 Complete the Cell address field
Specify the first cell where to import your data range. If your destination sheet has formulas, keep them on the left side of your imported data set.
3.2. Pick the right Import mode
- Replace - fully replaces all previously imported data with the latest information available in your data source.
- Append - places your newly imported data under previously imported entries; is suitable for tracking historical data changes.
3.3. Enable Last updated column
Switch on this parameter if you want to add a column specifying the date and time of the last data refresh.
3.4. Enable Update data each run
To learn more about this function, you can check out our article about it.
4. Set up an automatic data refresh
Learn more about Automatic data refresh.
5. Open the newly imported data
To see your imported data, just click 'View results' in the top right corner.
To find troubleshooting tips, check this article.