This article covers Sheetgo Automations — the Google Sheets extension (Extensions > Sheetgo > Automations). Using the web app instead? See What is a Sheetgo source?
In Sheetgo Automations, the source is the first step of any automation. It tells Sheetgo where to read the data from. You can use one source or combine multiple sources in the same automation.
Available source options
Export data from current sheet (recommended)
Uses the spreadsheet you currently have open in Google Sheets as the source. This is the fastest way to get started — no file picker needed.
Select from Google Drive
Opens a file picker so you can choose a file stored in your Google Drive.
Supported file types:
Google Sheets — same or different spreadsheets
Excel files — .xlsx and .xls
CSV files
Note: Excel and CSV files must be stored in Google Drive. Each file can be up to 1 MB on the free plan.
Source settings
Once a file is selected, configure two additional settings:
Sheet / tab
Choose which tab inside the file contains the data you want to transfer.
Data range
Option | Description |
Import entire sheet | Transfers all data from the selected tab. |
Named range | Uses a named range already defined in the spreadsheet. |
Custom range | Lets you specify an exact cell range (e.g. A1:D100). |
Using multiple sources
To combine data from more than one file or tab, click + Add another source and repeat the process. Each source has its own sheet/tab and data range settings.
You can reorder sources using drag-and-drop — the order determines how rows are stacked when using the Merge processor.
Note: When multiple sources are configured, the Merge processor becomes available in the next step. Merge must be added before any filter processors can be applied. Filter processors are only available after Merge when using multiple sources.
Related articles