devs.kz workshop · Almaty · led by Askar Aituov

Free AI Dashboard for PMs

Stop manually stitching Google Sheets reports. Build a live dashboard — CJM funnel, CAC, unit economics, backlog — straight out of your project's scattered sheets and docs, using the free Gemini API. Then keep building in a team buildathon for a 30,000 ₸ prize.

DateSeptember 26, 2026
Time10:00 – 14:20
LocationAlmaty (venue confirmed on registration)
Price15,000 ₸
RequiresA laptop and a free Google account
Reserve a seat →
the problem

Your project's data lives in ten tabs, and none of them talk to each other.

Backlog in one file. CJM in a slide deck. Unit economics in a third owner's private sheet. Before every status update, someone manually copies numbers between them — and that someone is you. This is what we fix.

Source fileDataOwnerStatus
backlog_growth.xlsx12 tasks, own formatPM Ascattered
cjm_slides.pptx6-stage funnelPM Bmanual
Dashboard.xlsxCAC, LTV, CJM %, backlog split — liveGemini + Apps Scriptauto-synced
who it's for

You already run the project — this just stops it living in your head and ten tabs.

PM

Product managers

One dashboard for CJM, CAC, unit economics and backlog — pulled from files you already have.

PjM

Project & delivery leads

Stop rebuilding the same status slide from five different sheets every week.

FND

Founders wearing the PM hat

Investor-ready metrics without hiring an analyst yet.

DEV

Career switchers

A concrete, no-code-but-real way into AI-assisted workflows — and a portfolio piece.

what happens in the room

Run of show

10:00

The real cost

How many hours a week actually go into manually syncing project data before a status update.

10:15

Tools & honest limits

Getting a free Google AI Studio key, and exactly where the free-tier quota runs out.

10:30

Your first API call

Calling Gemini directly from Apps Script — no libraries, no installs.

11:00

Pulling from scattered files

IMPORTRANGE across sheets, and a Drive script that walks every file in your project folder.

11:45

Normalizing with Gemini

One prompt turns everyone's differently-formatted backlog and CJM into a single structure.

12:15

Building the dashboard

CJM funnel, CAC, LTV and a backlog breakdown — formulas and charts, live off your raw data.

12:45

Automation & risk

A daily trigger to keep it updated, and what never to send to a free API.

13:10

Buildathon

Teams of 2–3 extend their dashboard against a challenge revealed on the spot. 30,000 ₸ for the winning prototype.

14:00

Demo & vote

60-second demo per team, live audience + jury vote, prize awarded on the spot.

buildathon

Leave with a working prototype, not just a template.

The last stretch of the day turns everything you just built into a short, judged sprint. The prize is fixed and guaranteed — not a cut of ticket sales.

Format

Teams of 2–3. The challenge is revealed only at the start of the block, so nobody arrives with a head start. Extend your dashboard — a new metric, a new data source, or the competitor-scan bonus module — using what you learned that morning.

Judging & prize

30,000 ₸, guaranteed, for the best prototype. Scored on: does it actually run through Apps Script/Gemini on live data, is there at least one real visualization, and a clear 60-second demo. 50% audience vote via Google Form, 50% jury.

pricing

One straightforward price

Seat

15,000 ₸ / person
  • Full hands-on session, September 26, 10:00–14:20
  • Google Sheets dashboard template + prompt library
  • Buildathon entry, with a 30,000 ₸ prize on the table
  • Water, tea & coffee included

Seats are limited — it's a hands-on room, not a lecture hall.

Registration happens in a small Telegram group so we can confirm numbers, share the venue once it's locked, and make sure everyone shows up with a free Google AI Studio key already in hand.

Open registration chat →
This link is handled by our server and doesn't appear in the page source — it keeps the workshop chat from being scraped by spam bots.