automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion.
I have looked at Zapier. It looks like I can have it email me the data in excel but the free version does not have a trigger based on a cell value or number of rows. I have some ideas as to how to set up a trigger though. However Zapier does not allow me to delete data in the SmartSheet once exported. So it only accomplished part of the task.
I image other companies have this workflow too. I have searched the community and found a lot of great suggestions for each part but no solution for the whole workflow.
Any suggestions to automate the workflow? Apps out there? Or will I need to program something using the API?
Thanks for any suggestions and guidance.
Dianne
Comments
-
Hi Dianne,
With Zapier you could maybe move the rows to another sheet and then delete them on that temporary sheet?
Would that work
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
If you're willing to do the programming, it sounds like the API is the correct tool for this job. It may be possible to put together a combination of Zaps and alerts to get you part way there. But I am not aware of any way to automatically delete data except the API. And once you're having the API do the deletions, you might as well have it do the export too.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives