Advanced ETL Processor can write data into Google Sheets by using the Google Spreadsheet Writer. This tutorial shows how to configure the target spreadsheet, choose where the rows should be written, and decide whether existing sheet data should be kept or cleared before loading.
What You Will Learn
- Select Google Spreadsheet as the Writer target.
- Configure the spreadsheet destination and write location.
- Choose whether to add rows from a specific cell, from the top, or at the end.
- Clear the full sheet or a selected area before loading when the job requires it.
Before You Start
Use a test spreadsheet first, especially if the Writer is set to clear a sheet or range before loading. Shared spreadsheets have a gift for making small mistakes visible to everyone.
Google Spreadsheet Writer Docs
The Google Spreadsheet Writer documentation explains how Advanced ETL Processor writes transformation output into Google Sheets.
Review Writer properties before running the job. The target can add data from a specific cell, write from the top, or append rows to the end.
The same properties also control whether Advanced ETL Processor clears the entire sheet or only a selected area before loading the new data.
If the Google connection is not already configured, use Connecting to Google Spreadsheet before building the transformation.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.