Etlworks enables seamless two-way integration with Google Sheets. You can extract data from any worksheet and load data into one or more worksheets—making it a powerful option for reporting, data sharing, and collaboration use cases.
This article shows how to authenticate, create a connection, and build flows that move data between Google Sheets and other systems like databases, files, and APIs.
What You Can Do with Google Sheets in Etlworks
-
Extract data from one or more worksheets and load it into:
-
Relational databases (e.g., Postgres, Snowflake, MySQL)
-
Files (CSV, JSON, XML)
-
SaaS platforms and APIs
-
-
Load data into a new or existing spreadsheet from virtually any source.
-
Use worksheet-specific routing within the same spreadsheet connection.
-
Automatically create new spreadsheets if they don’t exist.
Authentication
Etlworks supports both OAuth2 and Google Service Account authentication methods.
-
Use OAuth2 for quick, interactive setup.
-
Use a Service Account for production-grade server-to-server integration.
Learn how to connect to Google Services for detailed instructions on authentication options.
Step-by-Step: Extract Data from Google Sheets
1. Create a Google Sheets Connection.
Go to Connections, click +, and search for Google Sheets.
2. Create a destination Connection (e.g., a database or file).
3. Go to Flows, click +, and select the Well-known API to database or similar flow type.
4. Add a transformation:
-
-
FROM: your Google Sheets connection.
-
TO: your destination.
-
Optional: add |worksheetname to the FROM field to select a specific worksheet.
-
5. Optionally:
-
-
Add SQL filters or parameters.
-
Use Mappings to rename or convert fields.
-
Step-by-Step: Load Data into Google Sheets
1. Create a source Connection (e.g., a database or file).
2. Create a Google Sheets Connection.
3. In Flows, choose a flow type like Database to well-known API or File to well-known API.
4. Add a transformation:
-
-
FROM: your source.
-
TO: the Google Sheets connection.
-
Optional: add |worksheetname to the TO field to write into a specific worksheet.
-
5. Optionally:
-
-
Add SQL filters or parameters.
-
Use Mappings to rename or convert fields.
-
Automatically Create New Spreadsheets
When configuring a Google Sheets connection, you can auto-create a new spreadsheet if it doesn’t exist:
-
In the connection settings, enter a Spreadsheet Title in the Spreadsheet ID or Title field.
-
Enable Find Spreadsheet ID by Title.
If the spreadsheet doesn’t exist, Etlworks will create it automatically using the specified title and use its generated ID moving forward.
Videos
ETL with Google Services
Case Study
Kyero, a global property portal, uses Etlworks to sync data across Postgres, Snowflake, HubSpot, Google Sheets, and SFTP. With its flexible Google Sheets connector, Kyero unlocks new workflows daily while simplifying collaboration across teams.
Read the full Kyero case study
Comments
0 comments
Please sign in to leave a comment.