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
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 checkbox 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 checkbox 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.
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 that the Use new runtime checkbox is selected on the tab bar if you want to use Google Sheets in your package.
Synchronization is not supported.
Google Sheets Connections
To create a Google Sheets connection, perform the following steps:
- Click +NEW in the top menu.
- Open the Select Connector page by clicking Connection in the menu on the left.
- In the opened pane, find and select Google Sheets.
- In the Connection Editor page, in the Untitled field, specify a connection name that will be used to identify the connection.
Click Sign In with Google.
- In the opened window, enter your Google credentials and click Sign in.
- Click Allow to grant access to your Google Account.
- The authentication token is generated.
Select the corresponding spreadsheet from the Spreadsheet drop-down list. You can use only one speadsheet in one connection.
- 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.
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.
Supported Actions and Actions Specifics
Google Sheets connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.
- Update in Target Data Flow components.
- Delete in Target Data Flow components.