How Can I update a Row in SS with Matching Key from Zapier?
I don't see an obvious way to do this? Short video explains...
Thanks! 😀
Answers
-
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!
