Yavin Songkham
← All workFacebook automation · local AI

Shop AI & Growth Office

A local AI for our shop's Facebook page: it collects every post, comment, chat and ad result, finds the best ad audiences, and drafts replies from the shop's own knowledge.

DeveloperOct 2026Running daily
Shop AI & Growth Office
3,700+Messenger messages analysed
98posts and 15 ads collected
6 amdaily automatic data pull
The problem

Small shops can't afford a marketing team. This is an AI "growth office" that does the analysis and drafting, while the owner approves anything that gets posted.

What it does & how it works

Inside Shop AI & Growth Office

What it does

  • Pulls posts, comments, Messenger chats, page insights and ads with age / gender / placement breakdowns into SQLite every morning.
  • Learns the shop's real prices and answers from past owner replies; drafts replies with retrieval (RAG).
  • Scores ad personas and suggests who to target next.
  • Content planning, AI images, reels and captions; a native macOS version with work orders, QA checks and exact owner approval before posting.
How it is built

Stack

PythonSQLiteFacebook Graph APIRAG (bge-m3)Qwen3 local LLMmacOS app: AppKit / WebKit
Next projectCatch the Word →