Use the Folder destination to write your automation's data to every supported file in a folder in a single run. You don't need a data processor: you can send data directly from a source to this destination.
If you need to send different parts of your data to different files, use the Split processor instead. The Folder destination sends the same data to every file.
Set up the Folder destination
In the automation builder, choose Folder from the FOLDER group of destinations. It's separate from SPREADSHEETS and APPS & SERVICES.
Under DESTINATION FOLDER, choose the folder you want to write to. The Folder name field shows your chosen folder. To select a different folder, select Change file.
Under DESTINATION TAB, enter the destination tab's name in Tab name, or keep the default,
Sheetgo_Sheet1. This setting applies to spreadsheets.If you want to keep a history, turn on APPEND DATA. Sheetgo will add data under previous entries to track historical changes.
Run your automation to write the same data to every supported file in the folder.
What happens to the destination files
By default, Sheetgo replaces data rather than appending it:
In spreadsheets, Sheetgo writes to the named destination tab. It creates the tab if it doesn't exist and replaces it if it already exists.
In CSV files, Sheetgo replaces the file's contents.
Sheetgo skips files of other types.
Sheetgo creates the destination tab in each file and leaves the file's other tabs untouched.
Check Tab name before running the automation, especially if your destination files already have a tab with that name.
Supported files and later additions
The Folder destination supports:
Google Sheets files
Excel files (
.xls,.xlsx, and.xlsm)CSV files
Sheetgo automatically includes files you add to the folder later. If it can't write to one file, it continues with the remaining files.