• HomeHome
  • Vibe Code
  • Neural Dreams
  • What I do
  • Contacts
ruen
AllAppsWebsitesBotsAutomationAI agents
Business process automation

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
SapGeo CRM — the agency's system1 folder · 2026
CRM sections4 shots
DetailsCRM · Python + SQLite

Tap a folder — the work's sections are inside

Inside this work

  • CRM sections 4
  • Details 6
  • How it works
  • Price

How it works

The client journey without manual routine

  1. 01

    Request from the site

    A person leaves a request and it lands in the agency's Telegram bot right away

  2. 02

    Client in the CRM

    One button turns the request into a client card with a stage and history

  3. 03

    Questionnaire via link

    The client fills in a questionnaire via a personal link with no login: 7 steps in about 15 minutes

  4. 04

    AI review and edits

    The listing is scored on 10 criteria, AI suggests edits, a manager approves them

  5. 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

  1. 01Website requests arrive from the Telegram bot — one button turns a request into a client.
  2. 02Clients by stage: onboarding → support → listing improvement; access, questionnaire progress, calls and trend at a glance.
  3. 03Client card: questionnaire, listing score on 10 criteria, AI edits through draft → approved → applied, stats and CSV import.
  4. 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.
  5. 05Approvals: work packages come in for review, the owner answers “Approve” or “Changes” — with Telegram notifications.
  6. 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

Discuss a project Telegram