We have a deal stage in the sales pipeline called āāmeeting scheduledāā - however some of our sales reps forget to register the meeting activity in HubSpot, so to address this I want to be able to create workflow or a validation rule that when a deal is move to the āāmeeting scheduledāā stage there should be an existing meeting activity associated to the contact or the deal.
Now since I have a lot of cases where the deals are being place in āāmeeting scheduledāā and no meeting activities are registered I want to able to create them via workflow.
Hi @CDeMares,
Going forward, you might want to evaluate deal approvals so that you can check whether a meeting is logged before a deal can proceed: Require approvals for deals
Alternatively, on an Enterprise subscription, there is also a solution where a deal can only pass to a next stage when a meeting is logged. The approach would be as follows:
- Create custom deal property āMeeting loggedā (single checkbox)
- Set property permissions for this property to view only for all non-super-admins (this is an Enterprise feature)
- Create a workflow that enrolls deals when theyāre associated to a meeting, then use the āSet property valueā workflow action to check the property from step 1
- Make the property from step 1 a required property for the next deal stage
Regarding your question of retroactively creating meetings automatically, this is unfortunately not possible via workflow, at least not without custom code. If you want to retro-actively create meetings for deals that are missing one, hereās what I would do:
- Create a list of deals that are associated to a meeting
- Create a list of deals that are not in the list from step 1 but have the deal stage āMeeting scheduledā or later
- Export those deals
- In the export file, add new columns with the meeting information for each deal
- Re-import the file as multiple objects (deals, meetings)
For meetings, youāll have to include the following columns:
Meeting description,
Meeting start time, and
Meeting end time.
When importing new meetings, itās also recommended to include Activity date.
The start time, end time, and activity date values should be formatted as date-time properties.
See here: Format import files
This is the fastest and easiest way to create meetings historically in bulk.
Best regards!