Just looked at the current Smartsheet app and it doesn't seem to provide any search steps. The Smartsheet API does support searching through sheets though. https://smartsheet-platform.github.io/api-docs/?javascript#search-sheet

So, it looks like you need to develop a custom Zapier app that provides search capability then you will be able to retrieve the row ID from the search results.

Yes its possible with a custom Zapier App, but you might be able to do it with a simple webhook: https://smartsheet-platform.github.io/api-docs/?javascript#authentication-and-access-tokens suggests that you don't need the full oauth 2.0 workflow for the authentication, thus a simple webhook could get the information you need.

Hi @Vera! Thanks for the great question

We do have a feature request open for this addition to the SmartSheets Zapier integration and we're in the process of working with SmartSheets to see if it will be possible to add this. I've added you to the feature request, which means that we'll drop you an email if it does become a reality.

In the meantime, it looks like you have some great workarounds above!

@Danvers Awesome and thanks for adding me into the future request.

@Danvers If we'd like to follow along on this feature request, is there a way for us to view it or follow for any updates?

@EJones Hello, and yes. You my submit your feature request by sending us an email to contact@zapier.com with details about the feature request you are looking to receive updates about. We will add your request to our wish list and inform you when there's new updates.

Thanks!

Hey folks,

Just wanted to share that it’s now possible to search for an existing row using a query with the Smartsheet app on Zapier! 

 

Please do give that new “Find sheet Row” search action a try and let us know if you run into any issues with it. In the meantime, happy Zapping!