Getting started with Google Sheets

Etlworks Integrator can read and write data in Google Sheets.

Connecting to Google Sheets

Read how to create a connection for Google Sheets.

Extract and load data in Google Sheets

Extracting data from Google Sheets

Step 1. Create a Google Sheets connection.

Step 2. Create a destination connection.

Step 3. Create extract and load flow (start by typing in "well-known API to") where the source is a Google Sheets connection created in step 1 and destination is connection created in step 2. Look for the flows which extract data from the well known APIs.

Loading data in Google Sheets

Step 1. Create a source connection.

Step 2. Create a Google Sheets connection.

Step 3. Create an extract and load (start by typing in "to well-known api") flow where the source is a connection created in step 1 and a destination is a Google Sheets connection created in step 2. Look for the flows which load or push data into the well known APIs.