Skip to main content
Skip table of contents

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.

  1. Open Google Sheets, navigate to Data  Data Connectors  BigQuery

    Click here to expand...

  2. Select pmg-datawarehouse as the billing project and then hit Write Query:

    Click here to expand...

  3. Write your query and hit Insert Results

    Click here to expand...

    Your data will now appear in your google sheets.

Create a macro to refresh your data

  1. On your computer, open a spreadsheet that contains data connected to BigQuery in Google Sheets.
  2. Record a macro from a different tab than the one you want to refresh.
  3. After you start recording, switch to the tab you want to refresh.
  4. At the bottom left, click Refresh.
  5. Click Save.

Step 2: Schedule your macro

  1. At the top, click Tools Script editor.
  2. At the top, click Edit Current project's triggers. 
  3. At the bottom right, click Add trigger and select your options.
  4. Click Save

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.