This is documentation for Semarchy xDI 5.3 or earlier, which is no longer supported.

For more information, see our Global Support and Maintenance Policy.

Google Sheets Component

Overview

Semarchy xDI allows to work with Google Sheets to produce fully customized Data Flows.

Install the Google Sheets Component

The Google Sheets Component is installed from Semarchy xDI Designer using the component installation feature.

Supported Features

Feature	Description
Reverse-Engineering	Reverse-engineered Google Sheets as Metadata.
Read	Extract Google Sheets data and load it into any target technology.
Write	Load data to Google Sheets from any source technology.
View Data	View Google Sheets data from Designer.

Feature

Description

Reverse-Engineering

Reverse-engineered Google Sheets as Metadata.

Read

Extract Google Sheets data and load it into any target technology.

Write

Load data to Google Sheets from any source technology.

View Data

View Google Sheets data from Designer.

The Google Sheet component had been upgraded to the Google v4 API. This API change prevents listing all user sheets. As a consequence reverse-engineering must be performed one sheet at a time.