Automate io & Deleting Data from Smartsheet

Automate io & Deleting Data from Smartsheet

I just recently started using automate io and just recently ran into some major issues. Automate io allows you to create a bot with the trigger of 'New Row' so anytime a new row is created on a sheet, it will trigger the bot. Soon after setting it up, my bot stopped triggering, every time I created a new row (using a smartsheet form) the bot wouldn't trigger. Automate io looked into it and got back to me.

Basically what they told me, is that I should not be deleting data from my sheet. They told me that every time a row is created it is given a 'created at' stamp in the API. When I delete a row from my sheet, the row disappears but it never loses it's 'create at' stamp in the API. Therefore if I make a new row, and the new row was one that was previously deleted, the API gets sent to Automate io with it's existing 'created at' stamp and therefore the bot sees it not as a new row but as an updated row.

This was pretty frustrating to learn, for not being able to delete a row from my smartsheet is an impossible ask; especially when my smartsheet caps at 5000 rows.



  1. Can you confirm that what they are telling me regarding the API and the created at stamp are correct?
  2. Do you have any better suggestions on how to remove data from a sheet and by doing so also deleting the created by stamp?


I look forward to your reply.

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Alex Lubow

    The limit for the number of rows has been raised recently to 20 000.

    Would that help for your process?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hey Andrée,

    The number of rows now being 20,000 helps the problem, but is certainly does not solve it. I physically cannot delete a row from my sheet until this issue is solved with Smartsheet's API. Again if I delete a row from my sheet, the API does not remove the created at date of the row in the API so then if I add a new row, it's technically not seen as a new row because the created at date still exists.

    This is screwing up all of the bots that I have set up in automate io to trigger when a 'new row' is created. Again, unless smartsheet can change this in their API, I cannot use this trigger in automate io if I plan to delete rows on my sheet (which I definitely need to do!)

    Does this make sense? I am already in communication with Automate IO and they are willing to discuss fixing this integration with someone at smartsheet, I just need to see if this is something Smartsheet would be willing to troubleshoot with us.


    Until this issue is fixed, Smartsheet does not work seamlessly with automate io.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Alex Lubow

    Yes, that makes sense.

    If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team.

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • @Andrée Starå - Yes I did reach out to Smartsheet Support, they are just very slow at getting back to me.

Sign In or Register to comment.