Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Send Update Request via API to Contact List User

Tim Meeks
Tim Meeks ✭✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

Has anybody deveoped a solution using the API's to send Update Request from a sheet?


Meeting with my developer to see if we can send an update request when  the PAYMENT field changes to PAID status and the DATE PAYMENT RECEIVED is blank. Then send an Update Request to the User in the Agency Contact field which will be setup as a Contact List.


Another idea would be to get the email from a separate table that has the associated email address.


Anybody have any lessons learned from similar solutions?





  • dAVE Inden
    dAVE Inden Employee

    Hi Tim,


    This sounds like it could be accomplished via the Smartsheet API. You could montior a sheet for changes and after finding the value you are looking for in the sheet send the Update Request to the appropriate email.

    To monitor the sheet for data changes the best practice would be to implement one of our Webhooks. Once alerted of a change you could run a GET Sheet request. Looking through the response you could find the value you are looking for and the email address to send them along to a request to send an Update Request.


    If you have questions while building this process feel free to reach out to us at api@smartsheet.com.

This discussion has been closed.