Best answer

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

  • 4 November 2021
  • 4 replies

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 5 November 2021, 11:33

View original

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

Userlevel 7
Badge +14

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.


Userlevel 7
Badge +11

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?

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 :)

Userlevel 7
Badge +11

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