Skyvia Query Google Sheets Add-on Overview

Skyvia Query Google Sheets add-on allows you to easily build Google Sheets reports based on your data from a wide variety of databases and cloud applications. It enables you to easily get these data directly to Google Sheets and works within the Google Sheets interface.

You may share these reports with your colleagues and refresh data in them with a single click whenever needed.

The data can be retrieved as they stored in the data source or undergo filtering, aggregations, performing calculations, joins, etc. Thus, the add-on allows you to immediately get live cloud or database data in the form you need for your reports.

query-add-on

ExpandedToggleIcon        How It Works

Skyvia Query Google Sheets Add-on works with the data sources via Skyvia. The add-on uses Skyvia Query - our online SQL client and query builder tool for querying and managing cloud and database data.

You create connections to the data sources you want to query data from on Skyvia, and then Skyvia stores your connections. Queries are executed by the Skyvia service, and then it sends the returned data to Google Sheets. The queries you save in Query Gallery are available both from the Query Add-on and on Skyvia, and you can open, run, edit, or delete them both in the add-on and in Skyvia Query.

This means that you need a Skyvia account for using the add-on. You can register at https://app.skyvia.com/register. Note that registration at Skyvia is free and there is a free plan available. You can also view Skyvia pricing on our pricing page.

Before using our Google Sheets Add-on you will need to log in to Skyvia from Google Sheets.

 

ExpandedToggleIcon        Connections

For querying data, first you need to create a connection to the corresponding data source. Connections are created and stored on the Skyvia service, not in Google Sheets.

Note that Skyvia supports creating OAuth connections for all the supported data sources that allow connecting via OAuth, like Salesforce, and thus, you don't need to store your credentials on Skyvia for such data sources. Connections are stored in an encrypted form.

Skyvia Query Google Sheets Add-on supports getting data from various cloud applications, databases, and cloud data warehouses. Please see the Cloud Sources and Databases topics for the complete list. You can find more information on creating the corresponding connections in the Connections section of our documentation.

salesforce-connection-oauth

 

ExpandedToggleIcon        Queries

In Skyvia Query add-on, you get data from a data source to Google Sheets using queries. A query determines what data you want to get, and in which form.

While Skyvia Query add-on queries data using SQL SELECT statements, you are not required to know SQL. You can configure a query visually in Query Builder. Of course, if you are familiar with SQL, you may simply enter an SQL statement.

After you retrieve data, the query is linked to the Google Sheets workbook. You can later modify it or reexecute it and refresh data on your workbook with the actual data from the data source in a single click. You can use different queries on different worksheets of a Google Sheets workbook, and thus, have data from different sources in one workbook.

Queries can be also saved in Query Gallery for reuse in other Google Sheets workbooks. Query gallery offers convenient interface allowing you to quickly find the necessary query. It also contains a number of predefined queries to various data sources for common use cases that you can use as is or study in order to understand better how to compose your own queries.

 

ExpandedToggleIcon        Query Editor

Skyvia offers a powerful query editor with visual Query Builder. It allows both creating a query visually or entering SQL statements. For this, it has two tabs - Builder and SQL.

First, you select a connection you have created on Skyvia (or you can open Skyvia page and start creating a new connection from the query editor directly). Then you can select an object (table) to query data from, select its fields to get data from, and configure data processing and filtering.

query-add-on-builder

While Query Builder provides a wide specter of features, you can configure your query in much more details using SQL. At any time you can switch from visual creating of a query to editing SQL code, and you can see the generated SQL code for your query that you created visually. However, if you modify the SQL code, you won't be able to edit this query visually anymore, because not every SQL feature can be interpreted in a visual editor.

For databases, Skyvia Query uses their native SQL Syntax. For cloud applications, you use SQLite SQL syntax.

query-add-on-sql

After you finish your query, either in Query Builder or as SQL code, you can immediately run it and get the returned data into your Google Sheets workbook. Please note that query execution can take some time, especially for cloud applications, if the query contains complex processing, queries objects with a lot of data in them, etc.

To find out how to query data in more details, see the How to Query Data to Google Sheets topic.

 

ExpandedToggleIcon        Query Parameters

When you need to use a query with some variables, for example, create a report on orders for a specified period, and then make the same report over different time periods you can create a query that uses parameters. A parameter is a variable that you can set without modifying the query itself.

Parameters can be used in Query Builder, in filters, or directly in SQL code. You can find more information about using parameters in the Query Parameters in Google Sheets Add-on topic.

When you need to use the same query with different parameter values in different reports, save the query to Query Gallery. Whenever you need to use this query in the current or another workbook with different parameter values, simply specify the necessary parameter values directly in the Query Gallery and run the query without opening it for editing.

 

ExpandedToggleIcon        Query Gallery

Useful queries that you plan to reuse in other workbooks can be saved in Query Gallery. Then you may quickly open the saved query in just a few clicks. A query can be saved together with a connection reference.

Query Gallery has four tabs that display queries grouped by different criteria: by data sources, by connections, by user-defined folders, and all the queries ungrouped. Thus, you can always find the necessary query by any of the mentioned criteria, or simply enter a part of its name in the Search box.

query-add-on-gallery-queries

To use a query from the gallery, simply click it. Then you can select a connection for the query, specify parameters (which are described below) and click Run in order to run it immediately, without opening the query in the editor. You can also open it for editing, delete it from the gallery, or open it on the Skyvia service.

query-add-on-gallery-query

In addition to queries, saved by you, Query Gallery contains a number of predefined public queries for different data sources and use cases. If you don't want to see them in the gallery, you can use the toggle in the Query Gallery header to hide them.

For more information about query gallery, see the Query Gallery in Google Sheets Add-on topic.