Guide

AI agent + your CRM or spreadsheet

Plenty of small businesses run on a spreadsheet or a light CRM. An AI agent is useful there when it does three things: reads the rows, writes back a small amount (a note, a status, a next date), and tells you who needs a follow-up. It's risky when it can overwrite or delete rows nobody checks. This is a setup for a Google Sheet or a CRM, with the columns to add and the order to switch things on. For the follow-up messages themselves, see AI lead follow-up. Time figures here are estimates, not measurements.

What to hand to an agent first

  • Add three columns first

    Give the agent its own lane: 'Last contact', 'Next step' and 'Agent notes'. It may write only to those. Your original columns stay human-edited.

  • Connect read-only, then one write

    Start with read access so it can answer 'who haven't I spoken to in 14 days?'. Then allow writes to the agent columns only. In Google Sheets, protected ranges let you stop edits to chosen cells (Google Docs Editors Help, Protect, hide and edit sheets). Many CRMs have field-level permissions; check yours.

  • Daily follow-up list

    Each morning it lists the rows where 'Next step' is due or overdue, with one line of context and a draft message for each. You send.

  • Log after every contact

    After you reply or call, tell the agent in one line; it updates 'Last contact', 'Next step' and 'Agent notes'. Estimate: this can save roughly 15–30 minutes a day of copy-paste for a list of a few hundred contacts, depending on how you work today.

  • Weekly clean-up report

    Once a week it lists duplicates, missing emails and stale deals, and suggests fixes for you to approve. It never merges or deletes on its own.

  • Keep a backup

    Turn on version history (Google Sheets has it built in) or export a copy weekly before giving any write access.

Not sure which jobs fit your business?

Build my free AI plan →

Get the free AI Team Starter Kit

4 copy-paste agent prompts, a business brief template and a 7-day plan, as a PDF. Plus this guide's templates.

Ready-made use cases

  1. 01Never miss a lead follow-up
    The agent checks your CRM or inbox for leads that went quiet and drafts the next follow-up.
    ~4h/week · estimate
  2. 02Metrics digest without opening dashboards
    The agent pulls your key numbers from Stripe, analytics and your store into one daily message.
    ~2h/week · estimate
  3. 03Invoice chaser that gets you paid
    The agent tracks unpaid invoices and sends polite, escalating reminders.
    ~2h/week · estimate
  4. 04Weekly client status updates
    The agent writes each client a clear progress update from your tasks and messages.
    ~3h/week · estimate
  5. 05Weekly CEO review & plan
    Every Friday the agent compiles wins, numbers, stuck items and proposes next week's priorities.
    ~2h/week · estimate

Example: Grok Bot setup

Grok Bot routine: Never miss a lead follow-up
Schedule: Daily 11:00

Every day, find leads that haven't heard from me in 3+ days (CRM or email). For each, draft a short follow-up that references our last conversation and offers one clear next step. List them for approval, oldest first.

Rules: draft first, never send or post anything external without my approval. Keep summaries short.

Grok Bot, ChatGPT, Claude and n8n versions: all templates

Setup steps

  1. Add 'Last contact', 'Next step' and 'Agent notes' columns.
  2. Protect your original columns so only you can edit them.
  3. Connect read-only and ask it who needs a follow-up.
  4. Allow writes to the agent columns only.
  5. Get a daily due list with draft messages; you send.
  6. Add a weekly clean-up report you approve; keep a backup.

Keep these human

  • Write access only to the agent's own columns or fields. No delete permission.
  • Don't put card numbers, ID numbers or health details in rows the agent reads.
  • Follow-up messages are drafts; you send, especially to new contacts.
  • Check your CRM's or Sheet's sharing settings before connecting a third-party tool.
  • Start in draft mode: the agent prepares, you approve, then you loosen the leash routine by routine.

Get the free AI Team Starter Kit

4 copy-paste agent prompts, a business brief template and a 7-day plan, as a PDF. Plus this guide's templates.

FAQ

What should an AI agent do first for AI agent + your CRM or spreadsheet?

Add three columns first: Give the agent its own lane: 'Last contact', 'Next step' and 'Agent notes'. It may write only to those. Your original columns stay human-edited. Connect read-only, then one write: Start with read access so it can answer 'who haven't I spoken to in 14 days?'. Then allow writes to the agent columns only. In Google Sheets, protected ranges let you stop edits to chosen cells (Google Docs Editors Help, Protect, hide and edit sheets). Many CRMs have field-level permissions; check yours. Daily follow-up list: Each morning it lists the rows where 'Next step' is due or overdue, with one line of context and a draft message for each. You send.

What should stay human?

Write access only to the agent's own columns or fields. No delete permission. Don't put card numbers, ID numbers or health details in rows the agent reads. Follow-up messages are drafts; you send, especially to new contacts. Check your CRM's or Sheet's sharing settings before connecting a third-party tool. Start in draft mode: the agent prepares, you approve, then you loosen the leash routine by routine.

Is there a ready-made template?

Yes. Start with "Never miss a lead follow-up": copy-ready Grok Bot, ChatGPT, Claude and n8n templates are at https://whatshouldmybotdo.com/use-cases/lead-follow-up-sequences#templates.

Get a plan for your exact business

Build your free AI team. No signup.

Build my free AI plan →

Related guides