How Can I update a Row in SS with Matching Key from Zapier?

Alan Davis

I don't see an obvious way to do this? Short video explains...

https://www.loom.com/share/8991473c308d4d4890aaf7b8434fbb20

Thanks! 😀

Chris Mondeau

Hi @Alan Davis,

I haven't any out of the box "lookups" in Zapier for Smartsheet specifically, but you may be able to write a some code with either Zapier's code based actions or look into Smartsheet's API.

I'm not a super good programmer, so I like using what's available with Smartsheet or Zapier, so something like this might help: https://drive.google.com/file/d/1ORKFfKQ9kN_ceulJvtvChKeEghEVlhLX/view

How I get the row ID dynamically from Smartsheet is to set up a row action as the trigger zap (whenever a row is updated/added). That will allow me to use that row's id in any future steps of the zap, like adding to an email, or updating the same row to use. Hopefully that gets some juices flowing, I'd love to hear what other users have tried with success as well. Thanks!