Projects using Google Sheets in LagosProjects using Google Sheets in Lagos
Projects
People
Cover image for AI Sales Analysis for Loyverse
AI Sales Analysis for Loyverse Receipts — OpenAI & Gmail Raw receipt data tells you what sold. This tells you what it means. Built a Make.com (http://Make.com) automation that runs daily at 11:59 PM, pulls receipt data from Google Sheets, fetches the corresponding Loyverse records, iterates through each entry, aggregates the data across two parallel processing paths, retrieves and cross-references additional Google Sheets data, runs the compiled sales data through OpenAI to generate a structured analysis, and delivers the finished report via Gmail — ready in your inbox every morning without touching a thing. Day ends. Data collected. AI analyses. Report delivered. Stack: Make.com (http://Make.com) · Google Sheets · Loyverse · OpenAI · Gmail · Iterator · Array Aggregator · Router
1
110
Cover image for I automated Facebook group lead
I automated Facebook group lead generation using n8n and DeepSeek AI. Here is the exact architecture to position yourself as the first responder to hot leads. Answering questions in online communities is the best way to build B2B authority. The problem? Monitoring groups manually is a massive time sink—90% of posts are self-promotional spam, and manually scanning them means you often reply too late. This n8n workflow solves this by running the entire pipeline on autopilot: Schedule Trigger: Runs every morning at 9:00 AM. Fetch Targets: Reads target group URLs from Google Sheets. Scrape Posts: Calls Facebook scraper API to get recent posts. Fast Regex Filter: Runs local JS regex to weed out short posts and identify question patterns. DeepSeek Classification: Uses deepseek-chat to strictly verify if it's a genuine question, avoiding false positives. AI Reply Draft: DeepSeek writes a helpful, tailored reply under 120 words. Auto-Post & Log: Attempts to comment on the post automatically and logs the status to Google Sheets. Telegram Alert: Notifies you instantly with direct links to take over if needed. The Business Impact: Zero hours wasted scrolling groups. Instant expert responses to hot questions. Built-in review queue in Google Sheets. If you are looking to scale organic B2B lead gen in niche communities, this is the blueprint. #n8n #Automation #LeadGeneration #DeepSeek #GrowthHacking #SocialSelling
0
24
Cover image for A content analytics dashboard built
A content analytics dashboard built in Looker Studio, connected to Google Sheets, tracking views, engagement, and content-pillar performance at a glance for a short-form video brand. The problem: raw platform analytics (TikTok, etc.) don't show performance broken down by content category — making it hard to see which content pillars are actually working without manually cross-referencing every post. The build: at-a-glance scorecards for total views, total followers gained, and total engagement (likes + comments + shares), plus a breakdown of views by individual video and by content pillar (Rare Animals / Family Trees / Ancient History) — surfacing which content categories perform best. Note: built using sample/demo data for demonstration purposes, not live account data. The dashboard structure, connections, and logic are fully functional and could be connected to real data at any time. Result: a working, reusable reporting template — the kind of dashboard a content or marketing team would use to make decisions on what to produce more of.
0
0