Tracking Lead Custom Field changes via Zapier
Please read before continuing
The following guide will show you how to track and log changes to Lead Custom Fields via Zapier. If you're looking to track all changes, or a high volume of changes, we'd recommend using our Event Log API instead. If you're curious about a specific recent change, it's important to note that all changes to leads are tracked for 30 days by default.
Close automatically tracks all communications, activities and status changes directly on the lead, giving your team a historical record of what has occurred with any particular lead.
In some cases, teams also want to track or log changes to custom fields on leads. Here are a few examples:
- Changes to a sales rep lead assignment field
- Changes to a contract start or end date
In these instances, setting up a Zap to log the change is really easy.
What you'll need
- A Zapier account that supports multi-step zaps
- A Google Sheet (optional)
Setting up the Zap trigger
To get started, you'll want to select the New Event trigger from Zapier.
Use the New Event trigger for this Zap
For your required fields, we'll be looking for Lead objects that have been updated.
Make sure you're looking for leads that have been updated.
Under Changed Fields, you'll specify the field that you're looking to track changes on.
Choose which custom field to track via the Zap.
Be sure to specify a Changed Fields
If you do not specify any fields in the Changed Fields section, the zap will run on all custom field changes. This is not recommend via Zapier as the volume of updates is likely to exceed Zapier task limits.
Note: You may have to set up a test lead to trigger this Zap as you're creating these. If you're doing so, make sure the test lead contains any additional data points you'd like to log along with the changes. For example, you could track data in a separate field as well as the data in your changed field.
Choose how to log the custom field change
Once you have a sample that includes the data you'd like to log, you'll want to decide how to log it. Here are two options:
- Log the change to a Google Sheet - useful if the purpose of the logging is mainly to store changes for a longer period in case audits or reviews are needed at a later date.
Create a row in a spreadsheet to log your change.
Make sure you have a sheet set up with correct headers to match with the data you're looking to track.
Make sure you have a Google Sheet in place to log these changes
Map your data to the Sheet column headers
- Log the change as a note on the lead in Close - useful if the change would provide valuable context and information to someone viewing the lead at a later date.
Log the change as a note on the lead.
You'll want to use the Lead ID from the trigger to make sure we're creating a note on the lead where the change occurred. Here you'll also specify how you'd like the note to appear on the lead.
Mapping your triggered fields to create a note on the lead.
Once you're done, you'll have a note logged on the lead recording the date and time of the change, who made the change, as well as old and new values.
