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!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives