Business process automation · 2026
SapGeo CRM — the agency's system
The agency's private CRM: the whole client journey from a website request to managing their Yandex Maps listing — questionnaire, listing score, edits, stats and onboarding in one place.
- CRM
- Python + SQLite
- Telegram
- Automation
How it works
The client journey without manual routine
- 01
Request from the site
A person leaves a request and it lands in the agency's Telegram bot right away
- 02
Client in the CRM
One button turns the request into a client card with a stage and history
- 03
Questionnaire via link
The client fills in a questionnaire via a personal link with no login: 7 steps in about 15 minutes
- 04
AI review and edits
The listing is scored on 10 criteria, AI suggests edits, a manager approves them
- 05
Statistics
Calls, clicks and weekly trends in one place, the report is ready without spreadsheets
Work packages come to the owner for approval: “Approve” or “Revise”, with a Telegram notification
Onboarding runs on a 4-column kanban, so you see which client is at which step
Folder 01 · 4
CRM sections
Screenshots use demo data — no real client contacts.
Details
How it's made
- 01Website requests arrive from the Telegram bot — one button turns a request into a client.
- 02Clients by stage: onboarding → support → listing improvement; access, questionnaire progress, calls and trend at a glance.
- 03Client card: questionnaire, listing score on 10 criteria, AI edits through draft → approved → applied, stats and CSV import.
- 04The client questionnaire opens from a personal link with no login, 7 steps in about 15 minutes; the agency can prefill it, and the client just confirms.
- 05Approvals: work packages come in for review, the owner answers “Approve” or “Changes” — with Telegram notifications.
- 06Under the hood: plain Python, SQLite, systemd services behind nginx.
Price
from 10,000 ₽
This is not a final price: it depends on the scope and type of the task and is discussed individually