Google Sheets Component
Overview
Semarchy xDM Data Integration 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. |
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. |