Connecting Alli Data to Google Sheets
In the same way, Excel can connect to Redshift, Google sheets can automatically sync with PMG's BigQuery instance.
Open Google Sheets, navigate to
Data→Data Connectors→BigQuery
Select
pmg-datawarehouseas the billing project and then hitWrite Query:
Write your query and hit
Insert Results
Your data will now appear in your google sheets.
Create a macro to refresh your data
- On your computer, open a spreadsheet that contains data connected to BigQuery in Google Sheets.
- Record a macro from a different tab than the one you want to refresh.
- After you start recording, switch to the tab you want to refresh.
- At the bottom left, click Refresh.
- Click Save.
Step 2: Schedule your macro
- At the top, click Tools > Script editor.
- At the top, click Edit > Current project's triggers.
- At the bottom right, click Add trigger and select your options.
- Click Save.