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
Setting up Integration from DevOps to Smartsheet
- Beginner
- 2 replies
Best answer by DanversBest answer by Danvers
Hi
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.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+8- Zapier Staff
- 1366 replies
Hi
Thanks for reaching out!
To make sure I’m understanding your workflow you are looking to 1) Import features as new rows in Smartsheet 2) Send feature updates from DevOps to the same Smartsheet rows. Is that correct?
This integration article on DevOps + Smartsheet is also a handy guide to what triggers/actions are available for each of these apps!
Look forward to hearing back from you!
- Beginner
- 2 replies
You are correct. I have features in DevOps that I want to send to Smartsheet. The developers are updating those features within DevOps and I want to be able to send those updates to Smartsheet. I don’t want to end up with a row in Smartsheet for each update.
So if there are 10 Features in DevOps, I only want 10 rows in Smartsheet. If there are 20 updates to those 10 Features, I want to still only have 10 rows in Smartsheet. I hope that makes sense.
Sarah
+12- Zapier Staff
- 3731 replies
Hi
It is possible to update rows in SmartSheet using Zapier, the tricky part is that it requires the Row ID and there isn’t a way to search for Rows using the SmartSheet integration. The good news is that if you only have 10 issues, then we can workaround that!
You’ll need to add a step in your Zap that tells it ‘when this is the DevOps Feature, use this Row ID’. To do that, you’ll need to add a Formatter by Zapier step in the middle of the Zap. Choose the ‘Utilities’ option and the transform ‘Lookup table’. Here’s a help guide on how to create a look up table: https://zapier.com/help/create/format/create-lookup-tables-in-zaps
You can then use the Row ID that’s found in the Lookup table step in a SmartSheet New Row Update action to update the details of the relevant row.
- Beginner
- 2 replies
Well, unfortunately I now have probably 50 issues in DevOps to send to Smartsheet. Will this workaround still work or is it limited to a smaller # of issues?
+12- Zapier Staff
- 3731 replies
- Answer
Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.