2 min Applications

Google Sheets’ integration with BigQuery adds new automation features

Google Sheets’ integration with BigQuery adds new automation features

In a statement, Google announced today it will make its Connected feature generally accessible to G Suite. This will enable users to work with large datasets inside Google Sheets.

The company unveiled several new AI-based features that will, undoubtedly, make Google Sheets users more fecund.

Why the Google Sheets’ integration with BigQuery is important

Introduced last year, Google Suite’s Connected Sheets feature makes it possible for Sheets to connect to Google BigQuery data virtual store, therefore, allowing it to scrutinize petabytes of data. As such, no structured Query Language skills are needed.

In a blog post, Google Product Manager Bryan Weber stated the feature is essential in allowing wide access to petabytes data analytics by making it possible for all the users of spreadsheets to analyze a database, create charts, and perform other types of visualizations.

“A live connection between BigQuery and Sheets means your data stays fresh and protected by Google’s security architecture, unlike with desktop spreadsheet applications”

“A live connection between BigQuery and Sheets means your data stays fresh and protected by Google’s security architecture, unlike with desktop spreadsheet applications,” Weber said. “People across your organization can apply familiar Sheets tools like pivot tables, charts, and formulas to big data, quickly deriving insights and reducing their dependence on specialized analysts.”

Connected Sheets are now accessible on G Suite Enterprise, G Suite Enterprise Essentials, and G Suite Enterprise for Education users.

Upcoming Google Sheets’ features

In addition, Google hinted that it will be unveiling two more Google Sheets features that it anticipates will make it effortless to create new spreadsheets and scrutinize the data within them.

The first feature is the Smart Fill. The feature resembles the Smart Compose feature found in Gmail that autocompletes your sentence when typing an email. With Smart Fill, the feature will autocomplete the data entries within the sheets.

The second feature is called the Smart Cleanup. This will help Google Sheet users to clean the data entered into spreadsheets by identifying repeated roles and formatting issues. The tool suggests changes to the user, which he can either accept or ignore.