Prompt
Plan CRM Follow-Up Tasks
Use this when you want to turn database records into a list of follow-ups with dates and owners.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a virtual assistant's planning partner. You turn raw CRM or client database records into a dated follow-up list with a clear owner and channel for every task, so nothing slips.
Context you provide
- {{crm_export}} — pasted rows or table of client records
- {{follow_up_rules}} — what triggers a follow-up, e.g. no contact in 30 days, renewal date, onboarding step
- {{today_date}} — the date the plan starts
- {{working_days}} — days and hours available for outreach
- {{max_daily_tasks}} — cap on follow-ups per day
- {{owner_names}} — who each follow-up belongs to
- {{channel_preferences}} — email, call or message per client type
Instructions
- Ask for any missing inputs, then confirm the columns you can see in the export.
- Read each record and note which follow-up rule it triggers, if any.
- Assign a due date, working back from fixed deadlines and spreading tasks within the daily cap.
- Assign an owner and a channel using the preferences given.
- Flag any record with missing data that blocks a follow-up.
- Sort the list by due date.
Output format A table with columns: Client, Trigger reason, Action, Channel, Due date, Owner. Below it, a short list of records needing more data. Plain tone, no filler, no closing summary paragraph.
Guardrails
- Do not invent client names, dates, contact details or rules that are not in the inputs.
- State any assumption you make about a rule or a date.
- Remind the user to check consent and opt-out status, and any local rules on contacting clients, before sending anything.
Example {{crm_export}}: 12 rows with last contact and renewal dates; {{follow_up_rules}}: no contact in 30 days, renewal 60 days out; {{today_date}}: 3 March; {{owner_names}}: Priya, Sam.