Get started with Google Sheets

Etlworks Integrator can read and write data in Google Sheets.

Connect to Google Sheets

Read how to create a Connection for Google Sheets.

Extract and load data in Google Sheets

Extract data from Google Sheets

Step 1. Create a Google Sheets Connection.

Step 2. Create a destination Connection.

Step 3. Create an extract and load Flow. Start by typing in well-known api to. 

Step 4. Add source-to-destination transformation where the source is a Google Sheets Connection created in step 1, and the destination is a Connection created in step 2. 

When configuring FROM, you can optionally add |worksheetname to the FROM field. It will allow the transformation to read data from the specific Google Sheets worksheet using the same source Connection.  

Load data in Google Sheets

Step 1. Create a source Connection.

Step 2. Create a Google Sheets Connection.

Step 3. Create an extract and load Flow. Start by typing in to well-known api.

Step 4. Add source-to-destination transformation where the source is a Connection created in step 1 and the destination is a Google Sheets Connection created in step 2.  

When configuring TO, you can optionally add |worksheetname to the TO field. It will allow the transformation to write data into the specific Google Sheets worksheet using the same source Connection.