Wake the dead: turn stalled opportunities into won deals

Author
Authors
Jacob Tuwiner
&
Date
Feb 8, 2024

ā€Most follow-up emails donā€™t wake the deadā€¦(the dead = prospects that never made it through your pipeline)

ā€

This play uses Clay to send automated emails (personalized w/ ChatGPT + CRM notes) to restart conversations with closed-lost prospects.

100% automated emails SO GOOD ā€” they get results like:

notion image
notion image

All of these sequences were 100% automated using Clay + ChatGPT + CRM notes.

Hereā€™s exactly how I did it:

TL;DR

  1. Create list of closed-lost opportunities from past few years (export from Salesforce/HubSpot)
  1. Pull key deal info into Clay table (prospect name/email, when the deal was lost, deal notes, etc)
  1. Use ChatGPT to personalize email based on CRM info (see below):
notion image

How to Run the ā€œWake The Deadā€ Play

1. Export closed-lost deals from your CRM

Find all of the deals that were were lost in the past 1-2 years and export them as a CSV.

(If you need more help ā€” just ask ChatGPT)

Make sure to include the following info in the export:

  1. Prospect/Contact Info
  1. Full Name
  2. Work Email
  3. Company Name
  1. Opportunity Owner (the AE who owned the deal)
  1. Deal Closed Date (when the deal was lost)
  1. Call Notes (the initial reason the prospect was interested)
  1. Deal Lost Reason (the noted reason for losing the deal)

2. Import key info about the lost deals into Clay

Create a new table in Clay, click ā€œImport People From CSVā€, and upload the CSV from step 1:

notion image

3. Personalize variables w/ ChatGPT + CRM info

General steps to create the personalized outputs used in the email:

  1. Check if the email is valid
  1. Check if theyā€™re still at the company (if not they go into other sequence)
  1. Use ChatGPT + CRM notes to create following outputs:
  • Months Ago (created from the date when the deal was closed + normalized)
  • Context Output (created from the CRM call notes)

(CLICK IMAGE TO EXPAND)
(CLICK IMAGE TO EXPAND)

4. Export personalized variables for email template

After creating all of the personalized outputs ā€” I add them to a ā€œfinal outputā€ view in Clay and export the view as a CSV.

notion image

See how the CSV outputs are used in the email template below?

ā€œbecause becauseā€ was a mistake - but small mistakes make it feel more human šŸ˜‰
ā€œbecause becauseā€ was a mistake - but small mistakes make it feel more human šŸ˜‰

5. Upload into Instantly and schedule sequence

(CLICK IMAGE TO EXPAND)
(CLICK IMAGE TO EXPAND)

After a few days if they donā€™t respond ā€” I ask them if another contact in their company (found using the find contact integration) is a better point of contact.

(CLICK IMAGE TO EXPAND)
(CLICK IMAGE TO EXPAND)

If it wasnā€™t able to find another contact (who fits specific requirements) it uses ā€œsomeone elseā€ as a fallback. Youā€™d be surprised by how effective this last little email is haha. Especially since I say ā€œWine or cookies are stills yours :)ā€ Ā 

ā€¦and thatā€™s how I was able to get these kind of results with 100% automated emails:

notion image
notion image

Pretty neat, yea?

Appreciate you reading all of this!

If you got any value from it do me a quick favor and share it with someone. The exposure helps my business. Cheers!

notion image

[Bonus] Email Template

-> Swipe the play email copy here.

Table template coming soon!

ā€

ā€Most follow-up emails donā€™t wake the deadā€¦(the dead = prospects that never made it through your pipeline)

ā€

This play uses Clay to send automated emails (personalized w/ ChatGPT + CRM notes) to restart conversations with closed-lost prospects.

100% automated emails SO GOOD ā€” they get results like:

notion image
notion image

All of these sequences were 100% automated using Clay + ChatGPT + CRM notes.

Hereā€™s exactly how I did it:

TL;DR

  1. Create list of closed-lost opportunities from past few years (export from Salesforce/HubSpot)
  1. Pull key deal info into Clay table (prospect name/email, when the deal was lost, deal notes, etc)
  1. Use ChatGPT to personalize email based on CRM info (see below):
notion image

How to Run the ā€œWake The Deadā€ Play

1. Export closed-lost deals from your CRM

Find all of the deals that were were lost in the past 1-2 years and export them as a CSV.

(If you need more help ā€” just ask ChatGPT)

Make sure to include the following info in the export:

  1. Prospect/Contact Info
  1. Full Name
  2. Work Email
  3. Company Name
  1. Opportunity Owner (the AE who owned the deal)
  1. Deal Closed Date (when the deal was lost)
  1. Call Notes (the initial reason the prospect was interested)
  1. Deal Lost Reason (the noted reason for losing the deal)

2. Import key info about the lost deals into Clay

Create a new table in Clay, click ā€œImport People From CSVā€, and upload the CSV from step 1:

notion image

3. Personalize variables w/ ChatGPT + CRM info

General steps to create the personalized outputs used in the email:

  1. Check if the email is valid
  1. Check if theyā€™re still at the company (if not they go into other sequence)
  1. Use ChatGPT + CRM notes to create following outputs:
  • Months Ago (created from the date when the deal was closed + normalized)
  • Context Output (created from the CRM call notes)

(CLICK IMAGE TO EXPAND)
(CLICK IMAGE TO EXPAND)

4. Export personalized variables for email template

After creating all of the personalized outputs ā€” I add them to a ā€œfinal outputā€ view in Clay and export the view as a CSV.

notion image

See how the CSV outputs are used in the email template below?

ā€œbecause becauseā€ was a mistake - but small mistakes make it feel more human šŸ˜‰
ā€œbecause becauseā€ was a mistake - but small mistakes make it feel more human šŸ˜‰

5. Upload into Instantly and schedule sequence

(CLICK IMAGE TO EXPAND)
(CLICK IMAGE TO EXPAND)

After a few days if they donā€™t respond ā€” I ask them if another contact in their company (found using the find contact integration) is a better point of contact.

(CLICK IMAGE TO EXPAND)
(CLICK IMAGE TO EXPAND)

If it wasnā€™t able to find another contact (who fits specific requirements) it uses ā€œsomeone elseā€ as a fallback. Youā€™d be surprised by how effective this last little email is haha. Especially since I say ā€œWine or cookies are stills yours :)ā€ Ā 

ā€¦and thatā€™s how I was able to get these kind of results with 100% automated emails:

notion image
notion image

Pretty neat, yea?

Appreciate you reading all of this!

If you got any value from it do me a quick favor and share it with someone. The exposure helps my business. Cheers!

notion image

[Bonus] Email Template

-> Swipe the play email copy here.

Table template coming soon!

ā€

Share Article

More Articles

Clay brand asset shaped as a 3D group of abstract objects made out of purple and pink clayClay brand asset shaped as a 3D group of abstract objects made out of purple and pink clay

Scale your outbound motion inĀ seconds, not months

14 day free Pro trial - No credit card required

Try Clay free
Skip to main content