Skip to main content
Answer

What ID to use when using the action Update Activity in Redtail CRM?

  • November 4, 2021
  • 4 replies
  • 242 views

What am I supposed to use within the required ID field when creating a zap so that activities changed in Acuity are fed to RedTail using Zapier’s “Update Activity in RedTail CRM” as the zap action? I’ve testing using every form of “ID” I could frond from the dropdowns but still get an error message. (See screenshot below)

 

Best answer by SamB

Hey @BeckFC, welcome to the Community! :)

As Troy mentioned, there isn’t currently Find Activity search action which would be able to give you the ID for the activity to use in that ID field. That said, we do have a feature request open for a Find Activity action to be added to the Redtail integration, so I’ve added your vote for that. I don’t have an ETA for when that will be added but we’ll contact you by email as soon as it is.

In the meantime, do you have a Zap that creates the activities in Redtail initially? If so, I’m thinking that you could potentially add another step to that Zap to make a record of the activity’s details, including the ID (this info should be output by the Create Activity step), in an app like Google Sheets.

Then in the Zap that’s looking to update the activity, you would add a Lookup Spreadsheet Row Google Sheets search action. This would allow you to search the Google Sheet for the activity and obtain it’s ID. Then in the Update Activity step, you’d select the ID that was found by the Lookup Spreadsheet Row step. 

Do you think that approach could work?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • November 4, 2021

Hi @BeckFC 

The field expects a number as indicated by the icon next to the field name.

In this case, the field expects the internal ID of the Activity in Redtail.

Unfortunately the Redtail Zap app integration doesn’t have a Find Activity action available, that could be used to find the Activity to get the Activity ID to use in the Update Activity action step.

 


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • Answer
  • November 5, 2021

Hey @BeckFC, welcome to the Community! :)

As Troy mentioned, there isn’t currently Find Activity search action which would be able to give you the ID for the activity to use in that ID field. That said, we do have a feature request open for a Find Activity action to be added to the Redtail integration, so I’ve added your vote for that. I don’t have an ETA for when that will be added but we’ll contact you by email as soon as it is.

In the meantime, do you have a Zap that creates the activities in Redtail initially? If so, I’m thinking that you could potentially add another step to that Zap to make a record of the activity’s details, including the ID (this info should be output by the Create Activity step), in an app like Google Sheets.

Then in the Zap that’s looking to update the activity, you would add a Lookup Spreadsheet Row Google Sheets search action. This would allow you to search the Google Sheet for the activity and obtain it’s ID. Then in the Update Activity step, you’d select the ID that was found by the Lookup Spreadsheet Row step. 

Do you think that approach could work?


  • Author
  • Beginner
  • November 9, 2021

Sam, thanks for the temporary “hack” tip!  Sounds like that’ll work so I’ll give it a try and just use that until the Find Activity feature requests gets implemented. I appreciate the prompt feedback from both of you :)


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • November 10, 2021

You’re most welcome @BeckFC. Hopefully that will work well in the meantime! :)