Data integrations with third party tools play a crucial role at Refiner. With our Google BigQuery integration, you can push survey response data from your Refiner account to a Google BigQuery table in real time.<\/p>\n\n\n\n
Create a Google BigQuery integration<\/h2>\n\n\n\n
Refiner allows you to create multiple Google BigQuery integrations, each with their own trigger configurations and target tables.<\/p>\n\n\n\n
Start by navigating to the \u201cIntegrations > Google BigQuery > Manage Connections\u201d within your Refiner dashboard and click on \u201cCreate integration\u201d.<\/p>\n\n\n
\n<\/figure><\/div>\n\n\n
When prompted, choose a name for the Google BigQuery integration that describes it accurately (e.g. \u201cNew NPS survey responses\u201d).<\/p>\n\n\n
\n<\/figure><\/div>\n\n\n
Choose trigger event <\/h2>\n\n\n\n
You can choose between different trigger events. for your Google BigQuery integration:<\/p>\n\n\n\n
\n
Completed Survey<\/li>\n\n\n\n
Segment Match<\/li>\n\n\n\n
Tag Added<\/li>\n<\/ul>\n\n\n\n<\/figure>\n\n\n\n
Choose data to sync<\/h2>\n\n\n\n
You can choose which data fields you want to sync to your Google Sheets file. You can choose to include user identifiers (Id, Email, Display Name), meta data (Survey Name, Response Date, Response Tags), actual survey response data, as well as other user traits.<\/p>\n\n\n
\n<\/figure><\/div>\n\n\n
Create an authorization key<\/h2>\n\n\n\n
Next, you\u2019ll need to create an authorization key in your Google Cloud Console. This key is used to grant Refiner access to your Google BigQuery tables.<\/p>\n\n\n\n
Go to IAM & Admin > Service Accounts<\/em> in your Google Cloud Console click on “Create Service Account”.<\/p>\n\n\n
\n<\/figure><\/div>\n\n\n
Enter a name for your new service account and choose a user role that has access to BigQuery resources. You can either choose an already existing user role or create a new one.<\/p>\n\n\n\n
Once you created the service account, navigate to the “Keys” tab of the account. Click on “Create new key” as shown in the screenshot below.<\/p>\n\n\n
\n<\/figure><\/div>\n\n\n
Choose “JSON” as the key format and download your new key. <\/p>\n\n\n\n
Open the file in a text editor and copy the JSON object in the Refiner BigQuery integration as shown below.<\/p>\n\n\n
\n<\/figure><\/div>\n\n\n
Create BigQuery table<\/h2>\n\n\n\n
It’s now time to create the table in which you want to store your survey response data. Head over to your Google BigQuery account, select a dataset and create a new table.<\/p>\n\n\n
\n<\/figure><\/div>\n\n\n
Once you created the table, copy & paste the project ID, the dataset name and the table name to your Refiner account.<\/p>\n\n\n\n<\/figure>\n\n\n\n
Create BigQuery table schema<\/h2>\n\n\n\n
As a final step, you’ll need to create a schema for your BigQuery table which corresponds to the data fields that you want to sync. Go to your newly created table and click on “Edit Schema”.<\/p>\n\n\n\n<\/figure>\n\n\n\n
Depending on the data fields you’ve selected in your Refiner account, we’ll show you a list with the fields to add to your schema.<\/p>\n\n\n\n<\/figure>\n\n\n\n
Test integration<\/h2>\n\n\n\n
Once you created all columns in your BigQuery table with the right data type, it’s time to send a test request. In your Refiner integration, click on “Send Test” and check if any errors are returned. <\/p>\n\n\n
\n<\/figure><\/div>\n\n\n
If a confirmation message is shown after sending a test, go to your BigQuery account and check if all data was received correctly. Click on “Preview” to see the data you received. You might need to wait a minute or two before the synced data shows up in your BigQuery table.<\/p>\n\n\n
Introduction Data integrations with third party tools play a crucial role at Refiner. With our Google BigQuery integration, you can push survey response data from your Refiner account to a Google BigQuery table in real time. Create a Google BigQuery integration Refiner allows you to create multiple Google BigQuery integrations, each with their own trigger […]<\/p>\n
![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-22-at-00.47.50-1024x560.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-22-at-00.47.50-1-1024x560.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-03-at-10.36.52-1024x179.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-22-at-00.50.45-1024x486.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-21-at-23.45.25-1024x481.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-21-at-23.50.56-1024x584.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-22-at-00.31.25-1024x489.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-22-at-00.35.53-1024x604.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-22-at-00.37.33-1024x171.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-22-at-00.41.18-1024x500.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-22-at-00.40.19-1024x658.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-22-at-00.44.51-1024x200.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/refiner.io\/docs\/wp-content\/uploads\/2025\/02\/Screenshot-2025-02-22-at-00.54.29-1024x470.png\")
<\/figure><\/div>","protected":false},"excerpt":{"rendered":"