To automatically delete rows in an "archive/trash bin" sheet I do this. I use a standard "move" automation template to move the rows into a newly created "trash bin" sheet. Using Data Shuttle I do this:
- Create an Upload workflow.
- The source file will be a blank .xls or .csv with the identical structure as your regular data import file - but blanked out, no data.
- Configure the workflow for complete replace of the target sheet (the "delete bin" sheet).
- Schedule the new delete bin workflow frequency greater than the frequency of your data import. For example, if you upload your data every hour, then empty the trash bin every 15 or 30 minutes. I do this to reduce the chance that I could "overflow" the trash bin and halt the automation.