About Openflow Connector for Google Sheets¶

Note

The connector is subject to the Connector Terms.

This topic describes the basic concepts of Openflow Connector for Google Sheets, its workflow, and limitations.

The Openflow Connector for Google Sheets enables the ingestion of Google Sheets data into Snowflake. It uses the Google Sheets API to fetch data and persist that data in a table dedicated to a given range from a sheet. The connector creates the destination table in the database and the schema provided in the configuration.

Workflow¶

  1. A Google Cloud administrator creates a service account and a key as described in Service account credentials.

  2. A Google Sheets user creates a Google Sheets spreadsheet and shares it with the service account. The first row of data represents the column names in the destination table that the connector will create. It cannot contain actual data. If a column contains multiple data types, the connector selects the least restrictive type.

  3. A Snowflake account administrator configures the connector as follows:

    1. Imports the connector definition file into the Snowflake Openflow canvas.

    2. Creates Snowflake warehouse, destination database, destination schema, and key.

    3. Specifies the required parameters for the connector, such as Snowflake Warehouse, Destination Database, Snowflake Key, and Spreadsheet ID.

    4. Runs the connector flow. The connector performs the following tasks when run in Openflow:

      1. Retrieves the data from a specified spreadsheet.

      2. Creates and updates the destination table to reflect the schema of data from Google Sheets. If the destination table is not created, then it is truncated.

      3. Inserts the data into the destination table.

Limitations¶

  • The connector saves numeric values from a sheet only as INT or DOUBLE types. Because of this, small rounding errors may occur in the least significant digits if sheets contain floating point numbers. The connector currently doesn’t support higher precision.

  • Incremental load is not supported. The connector uses the truncate and load ingestion strategy.

Next steps¶

Set up the Openflow Connector for Google Sheets

Language: English