Connecting to Google Sheets

Google Sheets is a cloud-based solution, which allows users to edit, organize, and analyze different types of information online. It allows collaborations with multiple users. Users can edit and format files in real-time, and any changes made to the spreadsheet can be tracked by a revision history.

Data integration: Skyvia supports importing data to and from Google Sheets, exporting Google Sheets data to CSV files and replicating Google Sheets data to relational databases.

Backup: Skyvia Backup does not support Google Sheets.

Query: Skyvia Query supports Google Sheets.

Google Sheets-Specific Features and Limitations

Data Structure

Each Google Sheets connection represents data from a single spreadsheet. You must select a spreadsheet in the connection settings. Its sheets are represented as tables.

The names of the fields can be either determined from the first row (if the corresponding check box is selected in the connection settings). In this case, Skyvia displays all the columns up to the last one with a non-empty cell in the first row. If a column has an empty value in the first row, but there are columns with non-empty first row values further, the column is available and has the name as it has in Google Sheets — from A to Z, then from AA and so on.

If the Use Header To Detect Colum Names check box is not selected, all the sheet columns are available in Skyvia with names as in Google Sheets.

Besides, Skyvia adds the RowNo column, containing row numbers.

Limitations

Skyvia has the following limitations for Google Sheets:

  • In the Data Integration product, Google Sheets connections are supported only for packages, which use a new data integration runtime.

    Make sure you select the Use new runtime check box on the tab bar if you want to use Google Sheets in your package. You need to select this check box each time you create a new data integration package.

  • Synchronization is not supported.

Google Sheets Connections

To create a Google Sheets connection, perform the following steps:

  1. Click +NEW in the top menu.
  2. Open the Select Connector page by clicking Connection in the menu on the left.
  3. In the opened pane, find and select Google Sheets.
  4. In the Connection Editor page, in the Untitled field, specify a connection name that will be used to identify the connection.
  5. Click Sign In with Google.

    Connection Editor window

  6. In the opened window, enter your Google credentials and click Sign in.
  7. Click Allow to grant access to your Google Account.
  8. The authentication token is generated.
  9. Select the corresponding spreadsheet from the Spreadsheet drop-down list. You can use only one speadsheet in one connection.

    Connection Editor window

  10. Click Create Connection.

Please note that Spreadsheet is a required parameter. You need to select the spreadsheet you want to work with. You can select only one speadsheet in one connection window and read sheets from this certain spreadsheet. The sheets will be created as tables in the connector.

Additional Parameters

If necessary, you may click Advanced Settings and set additional connection parameters:

Use Header To Detect Colum Names — this parameter specifies whether to use the columns from the first row of the table in Google Sheets. If there are no column names in the Google Sheets, then standard Excel column names will be displayed.

Cell Max Length — this parameter defines the maximum text length in a cell.

Advanced Settings

Supported Actions and Actions Specifics

Google Sheets connector supports the following actions: