This article covers Sheetgo Automations — the Google Sheets extension (Extensions > Sheetgo > Automations). Using the web app instead? See What is a Sheetgo destination?
The destination is the final step of your automation — it is where Sheetgo writes the data after collecting and processing it from the source. You choose the destination type, the target file or tab, and how to handle existing data.
Available destination options
Import data to the current sheet
Sends the data to a tab within the spreadsheet you currently have open. You can create a new tab or write to an existing one.
Select tab — choose an existing tab or create a new one
Tab name — set the name for the destination tab
Write mode — Replace or Append
Create a new file (recommended)
Sheetgo auto-creates a new file in your Google Drive and writes the data to it. The AI suggests a name based on your configuration — you can accept it, edit it, or use the rule-based fallback.
File type — Google Sheets, CSV, or Excel
File name — AI-suggested based on your configuration
Tab name — destination tab name (Google Sheets only)
Write mode — Replace or Append
Existing file
Sends the data to an existing Google Sheets file in your Drive. A file picker opens so you can browse and select the target file.
CSV export
Creates a CSV or an Excel file in a folder you specify in Google Drive.
Write modes
Write mode | What it does |
Replace | Overwrites everything in the destination tab on every run. |
Append | Adds new rows below the existing data, preserving previous records. |
In replace mode, the destination is permanently overwritten each time the automation runs. Use Append if you need to accumulate records over time.