Personal CRM with Automatic Contact Discovery
Automatic maintenance of a personal CRM discovering contacts from email and calendar, generating morning meeting briefings, and answering queries against the database.
On a daily schedule, the system scans events and emails, updates contact records with relationship context, and delivers briefings on external meeting attendees. The database supports natural language queries about contact details, last conversation dates, and follow-ups.
Requirements
gogCLI for Gmail and Google Calendar access.- Custom CRM database (SQLite or similar) or the crm-query skill if available.
- Telegram topic for CRM queries.
How to use
- Create a CRM database:
CREATE TABLE contacts (
id INTEGER PRIMARY KEY,
name TEXT,
email TEXT,
first_seen TEXT,
last_contact TEXT,
interaction_count INTEGER,
notes TEXT
);
- Set up a Telegram topic called "personal-crm" for queries.
- Prompt OpenClaw:
Run a daily cron job at 6 AM to:
1. Scan my Gmail and Calendar for the past 24 hours
2. Extract new contacts and update existing ones
3. Log interactions (meetings, emails) with timestamps and context
Also, every morning at 7 AM:
1. Check my calendar for today's meetings
2. For each external attendee, search my CRM and email history
3. Deliver a briefing to Telegram with: who they are, when we last spoke, what we discussed, and any follow-up items
When I ask about a contact in the personal-crm topic, search the database and give me everything you know.
Source: hesamsheikh/awesome-openclaw-usecases and its contributors. License: MIT.
Copyright (c) 2026
Translation and editorial adaptation by ClawCases.
>Resources
>Related Use Cases
1-3-1 Communication Rule Decision Brief
Writes 1-3-1 decision briefs for tasks with multiple viable approaches, producing a one-sentence problem framing, three options with pros and cons, and a single recommendation with definition of done and implementation plan.
AI-Powered Earnings Tracker
Stay on top of earnings season across dozens of tech companies without manually checking multiple sources and remembering report dates for every AI/tech earnings report.
Delegate Coding to OpenHands CLI
Delegate coding tasks to the OpenHands CLI via the terminal tool; OpenHands is model-agnostic and works with any LiteLLM-supported provider such as OpenAI, Anthropic, OpenRouter, DeepSeek, Ollama, or vLLM.