Refresh BigQuery data in Sheets using Apps Script and Macros

By Anonymous -
Recently the BigQuery data connector was released to enable clients to effectively import information from bigger datasets into Sheets. Presently, you can utilize devices like Apps Script and the large macro recorder to plan automatic updates inside Sheets to the associated BigQuery data.
Reasons to use it
Remain over the best in class information crucial to your business via automatically refreshing the BigQuery information in your sheet.
For instance, you can set sales data to automatically refresh with the goal that it's prepared for analysis toward the start of every day. You can likewise auto-refresh information in preparation of key meetings or introductions that happen on a weekly or monthly basis. Or on the other hand you could set a trigger to auto-refresh your information each time you open the spreadsheet.
This feature will be ON by default.

When you compare data in Sheets and BigQuery, the following procedure should be adopted.

To compare data, you might need to change the data type. For example, if a column is string data in BigQuery, then it must be plain text in Sheets to be compared correctly.If the data type in the spreadsheet and BigQuery are different, you can:

  • Change how the data is formatted in Sheets. For example, data formatted as number could be changed to plain text.
  • Cast the value in a query. For example: WHERE zip_code = CAST(@ZIP AS string) 

Please note

  • When you run a query, your spreadsheet permissions are used, not the spreadsheet owner’s.
  • You can pull up to 10,000 rows per query from BigQuery.
  • You can scan up to 1 TB of data in a single query in Sheets.
  • Data that you pull from BigQuery is read-only.
  • Only standard SQL is supported by BigQuery. 
Record a macro to refresh your data
  • On your computer, open a spreadsheet that contains data connected to BigQuery in Google Sheet.
  • Record a macro from a different tab then 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

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.

Comments

  1. AnonymousAugust 28, 2026 at 9:18 AM

    Refreshing BigQuery data automatically in Google Sheets can make it easier to keep business information current for analysis and reporting. By using Apps Script, macros, and scheduled triggers, users can arrange for connected data to refresh at useful intervals, such as before daily analysis, recurring meetings, or presentations. Paying attention to data types is also important when comparing information between Sheets and BigQuery.

    Working with large datasets and automated data refreshes provides a practical context for exploring Big Data Projects, particularly when applications need to retrieve and work with substantial amounts of information. Understanding how data is collected, refreshed, and prepared can support more effective data workflows.

    ReplyDelete
  2. AnonymousAugust 28, 2026 at 9:18 AM

    Once refreshed, the data can be prepared and presented for easier interpretation and decision-making. A Data Visualization Training can help learners understand how data can be organized into meaningful visual representations, while Data Analysis Training can complement this by developing skills for examining, comparing, and interpreting datasets.

    ReplyDelete

Post a Comment

Popular posts from this blog

Features of AppSheet - The easy app developer

By Anonymous -
Image
  AppSheet is a platform that provides ease in developing apps to bridge the gap between physical and digital worlds. Here are some of the features of AppSheet; Provides multi-platform support Without even needing to write a line of code, the AppSheet framework allows anybody to create an app for iOS, Android, and the web. Apps run smoothly through every standard form of device. As a perk, never again think about updating the app with the latest updates to iOS and Android. The AppSheet team makes it a point to monitor fresh program fixes and debug them. Data Integration AppSheet incorporates a range of various sources of information. The platform works seamlessly whether anyone is using G-Suite, Office, SQL, or other leading data providers as their primary data source.  To optimize the data entry, management, and reporting processes, link a single app to many data sources. Or use slices of data and private tables to monitor how people appear to the data. Data Visualization I...
Read more

Google Partner in Bangladesh

By Anonymous -
Image
We are honored to join Google Partners in Bangladesh In order to guarantee that your team makes the most of this robust collection of corporate collaboration tools , Finetech is a licensed Google Workspace, Google G Suite Enterprise for Education partner/reseller in Bangladesh. We provide comprehensive implementation, installation, training, and ongoing support. To set up, move, or receive help with Google Workspace, contact us . With the single objective of advancing your company, we have the potential to work together with you. We are one of the most trusted Google Workspace resellers in Bangladesh, with years of expertise helping businesses of all sizes and types with Google Workspace support. By treating your business prospects with Google Workspace for business, we assist you in achieving your goals. As a reputable Google Cloud partner for Google Workspace Business in Bangladesh, we have the expertise to harness Google Workspace's power and offer all of its benefits to your ...
Read more

Top 10 apps made using AppSheet

By Anonymous -
Image
AppSheet being a no code platform has been able to provide innovative and creative applications for many organizations, and these applications have turned out to be very successful. Today we bring to you 10 most innovative and useful applications created using AppSheet ranging from non-profit organizations to global powerhouses. 10. Rotary International Rotary International is a service organization that brings together pioneers in professional and business industries in aid of upholding world peace. In 2017 when hurricane Maria hit the Caribbean Islands, Rotary International dived into action to support the affected. They provided food, water, clothing, medicine and shelter to those affected in many areas. Managing the resources during this crisis was extremely difficult, therefore Rotary decided to develop an application using AppSheet to keep in contact with members in any area and keep track of supplies. With the use of this app Rotary was able to immediately distribute needed supp...
Read more