Apps Script and Macros Update in Sheets with Bigquery Data

Google has Launched a new way to make your Work easy.  Bigquery Data Connector allows users to Import data from Bigquery to Google Sheets. Now users can able to use the tools like Macro Recorder & Apps Script for scheduling auto update within sheets. Now larger data can be import to Google Sheets.

Why This is Useful And to Whom this is useful:

A business has to deal with a numerous number of data every day. Bigquery automatically updates data to sheets means, no need to fetch from the database every time. We can set data to automatically refresh at the beginning of the day to analyze. You can auto update data for the presentation purpose which occurs weekly basis as well as can trigger to auto-update each and every time you open the spreadsheets.

This is obviously useful for the end users.

How to use This:

For Admins: No Action is Required

For End Users:  

How To record a Macro to Refresh Your Data:

Step1: Open a Spreadsheet that contains that data which is connected to Bigquery in Google Sheets.

Step 2: Start recording  the Macro to that tab which one you want to refresh

Step 3: Once you start recording switch to tab you want to refresh

Step 4: At the bottom left side there is an option to refresh.; Click on that option

Step 5:  Click Save

How to Schedule your Macro:

Step 1:  At the top, there are an option Tools > Script Write

Step 2:  Click on Edit option > Current Project Trigger  

Step 3: Click on Add Trigger  and select your options

Step 4:  Click on Save