Get started with Google Sheets

Etlworks can read and write data in Google Sheets.

What can you do with Google Sheets in Etlworks

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 Etlworks, 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

Kyero case study Integrate PostgreSQL, HubSpot, Snowflake, Google Sheets, SFTP, Amazon S3, and more.

Kyero, a leading property portal for international buyers, initially adopted Etlworks for a single integration use case. Surprised by its power, flexibility, and ease of use, Kyero quickly expanded its use of Etlworks to cover a wide range of data integration needs. With seamless integration across platforms such as Postgres, HubSpot, Snowflake (ETL and reverse ETL), SFTP file sources, Google Sheets, Amazon S3, and more, Etlworks has become an integral part of Kyero’s operations, enabling them to unlock new use cases every day.

 

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.