Import data from BigQuery to Google Sheets
Integrate BigQuery with Google Sheets to run SQL queries and streamline reporting workflows across your organization.
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 "Google Project ID" field.
Enter the unique ID of your Google project.
Where to get Google Project ID
- Go to the Google Could Platform console.
- Select your project from the drop-down list at the top of the web page.
- You will find the Project ID in the "Project info" section on the activity dashboard.
2.2. Fill out the "SQL query" field.
Enter the query statement that scans one or more tables or expressions and returns the computed result rows. Read more about Standard SQL Query Syntax.
2.3. Fill out the "Key File" field.
- Enter the key to your service account in JSON format.
How to get a Key File
1. Go to the Service account in the Google Cloud Platform console.
2. Choose your project from the drop-down selector at the top.
3. Click Create service account at the top to add a new service account.
4. Enter Service account name and press Create.
5. Add roles BigQuery Data Viewer and BigQuery Job User.
6. Find your service account and open it.
7. Press Add key, choose Create new key.
8. Pick JSON type and press Create.
9. You will be asked to save a file to your computer. Save it.
10. Open the file (raw data), copy its content, and paste it into the Google Service Credentials field.
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.
Name the Google 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.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.
- Specify the import Frequency.
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 the Last Update parameter on.
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