Dormant Zoho CRM Lead Re-Engagement Drafts in Gmail

Build me an agent workflow that re-engages dormant leads in Zoho CRM by staging personalized Gmail drafts for the lead owner to review and send.

Trigger: cron, every weekday (Mon–Fri) at 9am in the user's local timezone.

Step 1 — Pull dormant leads from Zoho CRM. Use Zoho CRM Get Records on the Leads module. Page through results and keep leads where Last_Activity_Time is between 21 and 60 days ago. Exclude leads whose Lead_Status is Lost or Converted (or any equivalent closed-out status the user has in their pipeline). Skip any lead with Email_Opt_Out set, or any custom Do Not Contact flag. Skip leads with no email address. For each kept lead, capture Owner (id + email), Email, First_Name / Last_Name, Company, Industry, Title, Lead_Status, Last_Activity_Time, and any custom fields the user flags as personalization signals.

Step 2 — Ground the message. For each kept lead, call Zoho CRM Get Notes for that lead record and grab the most recent 3 notes (Note_Title + Note_Content + Created_Time). These are the agent's anchor for what was actually being discussed last. If a lead has zero notes, fall back to lead industry / title / company only and write a lighter-touch check-in.

Step 3 — Draft the email. For each lead, write a short, plain-language follow-up (around 90–140 words). It must: reference the last topic discussed using the notes; personalize off industry, role, and any custom signals; offer exactly ONE specific next step (a relevant resource, a 15-minute slot, or a single open question); avoid filler like 'just circling back'; and never invent product features, pricing, discounts, or commitments. Sender voice should sound like the lead's owner, not a marketing blast. Subject line should be specific, lowercase-friendly, and under 60 characters.

Step 4 — Stage the draft in Gmail. Use Gmail Create a Draft inside the lead owner's Gmail account, with From = owner, To = lead's email, a clear Subject, and the drafted body as plain text. Do NOT send. The rep reviews and sends manually.

Guardrails: cap at 10 drafts per owner per run, so reps aren't swamped. If more than 10 dormant leads belong to one owner, pick the 10 with the most recent activity inside the dormant window and leave the rest for tomorrow's run. Never create a draft for a lead marked Do Not Contact or missing an email. Never duplicate a draft for a lead the agent already drafted within the last 7 days.

Output: at the end of each run, log a one-line summary per owner (e.g. 'Drafted 7 re-engagement emails for jamie@acme.com'). Surface any leads that were skipped because the owner had no connected Gmail account so the user can fix the connection.

Additional information

What does this prompt do?

Every weekday at 9am, pulls leads from Zoho CRM whose last activity was between 21 and 60 days ago and whose status is still active, skipping anyone marked Do Not Contact.
Reads the last few notes on each lead so the email references the real last topic discussed, not a generic template.
Writes a short, plain-language follow-up email from the lead owner to the lead, with a clear subject and one specific next step like a relevant resource, a 15 minute slot, or a single question.
Saves each email as a Gmail draft in the owner's account so the rep just reviews and hits send, and caps the run at 10 drafts per owner per day so no inbox gets swamped.

What do I need to use this?

A Zoho CRM login with permission to read the Leads module and the notes on those leads.
A Gmail account for each lead owner who should receive drafts, connected so the agent can create drafts in their drafts folder.
An agreement inside your team on what counts as dormant. The default is 21 to 60 days since last activity, with Lost and Converted leads excluded.

How can I customize it?

Change the dormant window. Tighten it to 14 to 30 days for high-velocity pipelines or widen it to 30 to 90 days for longer sales cycles.
Adjust the per-owner cap. The default is 10 drafts per owner per day so reps are not buried, but you can lift or lower it.
Tune the voice and the next step. Tell the agent what your one specific ask should look like, for example a calendar link, a case study, or an open ended question.
Change the schedule. Run it Monday and Thursday only, or shift the time to fit when your reps actually plan their day.

Frequently asked questions

Does this actually send the emails?

No. Every message is saved as a Gmail draft in the lead owner's account. The rep reviews the message, edits anything they want, and decides whether to send. Nothing goes out without a human.

How does it decide which leads count as dormant?

It looks at the last activity time on each lead and picks the ones that have gone quiet for 21 to 60 days. Leads with a Lost or Converted status are skipped, and so is anyone marked Do Not Contact. You can change the window any time.

Will the emails sound generic?

No. Before drafting, the agent reads the last few notes on each lead so the email opens with what was actually being discussed. It also uses the lead's industry, role, and any custom signals you tell it to consider, and it only offers things you can actually deliver.

What if a rep already has a hundred dormant leads?

The workflow caps drafts at 10 per owner per day so no one is buried. The leftover leads roll naturally into the next day's run, sorted so the highest priority ones surface first.

Can the agent invent product features or commitments?

No. The instructions tell it to stay grounded in the notes, lead fields, and inputs you provide. It will not promise discounts, features, or timelines you have not given it.