When setting up an automation, first you need to specify which data should be fetched from the source.
If you select a spreadsheet, there are three options to choose from:
Selecting a single tab
Selecting multiple tabs
Selecting a range from a tab
Selecting a single tab
By default the first tab from your source spreadsheet is selected. To change this, just open the dropdown menu and pick another tabs.
Selecting multiple tabs
You can select multiple tabs from your source file:
Make sure Select multiple tabs is on.
Select all the tabs you want.
Click Done.
To deselect all tabs but one, hover over it and click Only.
Selecting a range from a tab
You can also select a specific data range from one of the tabs:
Select Data range.
Choose the tab.
Specify a Range using spreadsheet coordinates.
