Google Sheets Component


The Google Sheets Component is used in Semarchy xDI to integrate with this technology and produce integration flows.

Install the Google Sheets Component

If it is not available yet in your Semarchy xDI Designer, install the Google Sheets Component from Designer using the component installation process.

Supported Features

Feature Description


Reverse-engineered Google Sheets as Metadata.


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


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.

Sub-Metadata support

The Google Sheets component lets you create Sub-Metadata on schema and query folder Metadata nodes.

To learn more about Sub-Metadata, see Work with Sub-Metadata.