Automate and expand Connected Sheets updates with new APIs, connections, and capabilities

We recently launched Connected Sheets, which connects Google Sheets and BigQuery to help you analyze large datasets using familiar spreadsheet tools. We’re now adding support for macros and APIs to help you automate tasks, as well as providing mobile access. Specifically, you can now use Connected Sheets with:

Developers and end users

You can use the macro recorder to record when to create, edit, delete, and refresh Connected Sheets objects. This generates macros which you can then directly run in Sheets to refresh the data. This can automate common tasks, saving time and reducing errors.

You can use these APIs to write scripts and applications that automate tasks. For example, you can automate CRUD functions for Connected Sheets objects, including sheets, formulas, pivot tables, and extracts. Additionally, you can use the APIs to refresh these objects, as well as to refresh charts.

You can now view Connected Sheets on mobile devices. You can also copy and paste data from Connected Sheets using the mobile apps. At this stage, you can’t create, edit, or refresh data in Connected Sheets on mobile.