Gigasheet
Append filtered data from new Gigasheet sheets to an existing sheet
When a new sheet is added to Gigasheet, select only columns with specific names (delete the others), then filter that sheet to set criteria. Finally append the resulting rows to an existing primary sheet. This is useful for automatically updating running reports on a periodic basis. For example, each month upload a report, clean it, and add the clean rows to a running log.
When a new sheet is added to Gigasheet, select only columns with specific names (delete the others), then filter that sheet to set criteria. Finally append the resulting rows to an existing primary sheet. This is useful for automatically updating running reports on a periodic basis. For example, each month upload a report, clean it, and add the clean rows to a running log.
- When this happens...New Sheet
Trigger when a new sheet is added.
- automatically do this...Select Columns by Name
Makes the sheet have only the provided columns, in the specified order. Deletes all other columns. Always keeps the row number column.
- then do this...Get Filtered Rows
Get Filtered Rows from a Sheet
- then do this!Append From Sheet
Append rows from a source sheet to a target sheet.
- Free forever for core features
- 14 day trial for premium features & apps
Handle of sheetRequired
Try ItNew Sheet
Trigger when a new sheet is added.
Try ItHandle of the source sheetRequired
Handle of the target sheetRequired
Add unmatched columnsRequired
Case insensitiveRequired
Trim column namesRequired
Handle of file to exportRequired
CompressionRequired
Row limit
New Folder
Trigger when a new folder is added.
Try ItHandle of the file to append toRequired
Columns Note
Source sheetRequired
Source columnRequired
Lookup sheetRequired
Lookup columnRequired
Near match
New Column(s) ContentRequired
Handle of sheetRequired
Columns Note