Etlworks enables two-way integration with Google Sheets. You can extract data from any worksheet and load data into one or more worksheets—making it a 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.