Updating a row in Smartsheet from Zapier

Hello,

I have an integration set up in Zapier which connects Aha! to Smartsheet.

The webhook from Aha! is providing information about new, updated, or deleted records. I am trying to use this information to add, update, or remove a copy of the record I currently store in Smartsheet.

Adding a new record is simple, but I am having difficulty when trying to "update/remove" existing records because I need to provide the "RowID" as a reference.

The only way I can access the RowID seems to be via navigating to the row properties.

I have unique identifiers within the record, but I am stuck with the provided RowID.

Has anyone else had this same issue or knows of any workarounds?

Find more posts tagged with

Accepted answers

ThomasHalpin

I found a workaround via a community post on the Zapier page.

There is a custom action which is hidden within the Zapier API tools, you have to search for "Find" within the Smartsheet action.

This will then find the row for any unique value you pass into the query field, and it will provide back the RowID.

All comments

ThomasHalpin

I found a workaround via a community post on the Zapier page.

There is a custom action which is hidden within the Zapier API tools, you have to search for "Find" within the Smartsheet action.

This will then find the row for any unique value you pass into the query field, and it will provide back the RowID.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.