One of the most pressing challenges facing businesses today is deciding…
Update BigQuery data in Sheets with App Scripts and Macros
What’s new:
Gần đây, Google đã cho ra mắt tính năng BigQuery data connector (Kết nối dữ liệu với BigQuery. Giờ đây, bạn có thể sử dụng những công cụ như App Script và trình quay Macro (Macro recorder) trong Sheets để lên lịch tự động cập nhật dữ liệu của BigQuery.
Who’s impacted
End users
Why you’d use it
Stay up to date with the latest and greatest in your business by automatically refreshing BigQuery data in Sheets.
For example, you can set up the sales data to be updated automatically, so that every time you open the data sheet, you can always observe and analyze the latest data every day. You can also let the data automatically update to prepare you for important meetings/presentations that happen weekly or monthly. Or you can set a schedule to update the data automatically every time you open the spreadsheet.
Instructions for using the feature
- With Admin: No need to do anything
- End users: Go here to learn how to schedule updates for data fetched from BigQuery.
- Shoot Macros to Refresh Your Data
- Trên máy tính của bạn, hãy mở một spreadsheet chứa dữ liệu được kết nối với BigQuery trong Google Sheets
- Record a macro from another tab, then from the tab you want to refresh
- After starting macro recording, switch to the tab you want to refresh
- At the bottom of the screen, click Refresh
- Click Save.
- Set a schedule for macros
- In the upper part of the screen, select Tools > Script Editor
- In the upper part of the screen, choose Edit > Current project's trigger.
- In the lower right, click Add trigger and choose the options you need.
- Click Save.
Additional details
Để tìm hiểu về những quyền truy cập chính đối với phần kết nối dữ liệu BigQuery
As always, you can use access management to control who can see, edit, or share your data.
Useful links
Updated: Gimasys