I have trying to setup my DevOps integration to import Features as new rows in Smartsheet. I then need another Zap to send any updates over to Smartsheet. I don’t want the updates to go over as new rows but to make updates to existing rows. Any ideas or help anyone can provide would be awesome!
Best answer by Danvers
You would have the Dev Ops feature in the first column and the Row ID from Smartsheet in the second column. Then add a Google Sheets Lookup Spreadsheet Row step into the Zap, using the Dev Ops feature as the search term.
When the step finds the relevant row, it will give you the Smartsheets Row ID which you can use in the Smartsheet step of the Zap.