TelegramRU

SMM studio

Lilya Grechka

A funnel site with a blog, cases and an admin panel, a Telegram lead-magnet bot and a mini-CRM in a Google spreadsheet.

TypeServices, personal brand

Pages7

Task

Build a “site → lead or Telegram bot → customer” funnel and let the owner publish articles and cases herself.

What was hard

  • The owner is not a developer: content has to change without a programmer.
  • Leads from the site and from the bot must be collected in one place so none get lost.
  • Russian requirements: consent to data processing, careful mentions of banned social networks.

Solution

What was done

  1. 1

    A funnel site

    A landing page with blocks: pains, how we work, cases, reviews, a lead magnet, prices, FAQ and a form. Separate pages for cases, “About me”, a blog and mentoring.

  2. 2

    An admin panel for the blog and cases

    Login with a one-time code from Telegram. Drafts are kept in a separate branch, publishing is done with a commit.

  3. 3

    A lead-magnet Telegram bot

    Subscription, file delivery, notifications to the owner about new people. Two bots: a public one for customers and a private one for alerts.

  4. 4

    A mini-CRM

    Leads go to Telegram and to a Google spreadsheet with statuses, written in Apps Script.

  5. 5

    Analytics and legal

    Yandex Metrika with UTM, a privacy policy and consent to data processing, a separate terms page.

Result

The owner publishes articles and cases herself, and leads from the site and the bot are collected in one spreadsheet and don't get lost.

Scope of work

  • A funnel home page
  • Cases and case pages
  • About me
  • Blog
  • Mentoring
  • Policy, consent, terms
  • Admin panel

Technologies

  • Next.js
  • TypeScript
  • Telegram Bot API
  • Google Sheets + Apps Script
  • GitHub API
  • Yandex Metrika

Need the same?

Leave a contact and we'll record a video review of your site. Free.

Other work: unigate

Free video review

Leave a contact and we'll book your review

How to reach you