Get started with Google Sheets

The Etlworks Integrator can read and write data in Google Sheets.

What can you do with Google Sheets in Etlworks Integrator

Extract data from Google Sheets You can extract data from Google Sheets through four easy steps. Read more	Load data in Google Sheets You can load data in Google Sheets through only four steps. Read more
Create a new Google Spreadsheet You can configure the Google Sheets connection to create a new spreadsheet if it does not exist. Read more

 

Videos

How to extract data from business application or well-known API and load into database Create a source Connection. Create a destination Connection. Create a new Well-known API to database Flow. Add a new transformation. Click MAPPING and configure the Source SQL if needed. Test the transformation. Read the full article

 

Related resources

Read from and write into different worksheets using the same Google Sheets connection In the Etlworks Integrator, the name or index of the Google Sheets worksheet is configured in the Google Sheets Connection. Read more

Google Sheets connector To work with Google Sheets, you will need to create a Connection. In the Connections window, type in google sheets in the search field.  Read more

 

Related case study

Fitness club Share data with Tableau using Google Sheets. Read the case study

"Since the Tableau can access the Google worksheet, it was decided to create a Flow that extracts the data from Sage300 API and loads it into the shared Google worksheet."

 

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

Here are the steps to 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

Here are the steps to 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.  

Create a new Google spreadsheet

You can configure the Google Sheets connection to create a new spreadsheet if it does not exist.

Process

When creating a new connection for Google Sheets enter the title of the spreadsheet in the Spreadhseet ID or Title field and enable Find Spreadsheet ID by Title.

How it works

When the Title is entered instead of spreadsheet ID and the Find Spreadsheet ID by Title is enabled the flow which reads from or writes into the Google Sheet will attempt to locate the spreadsheet ID by the title and if it does not exist will create a new spreadsheet with the specified title and automatically generated the spreadsheet ID.