OwenLee
A graduate student who is learning n8n. contact me: owenlzyxg@gmail.com
Templates by OwenLee
Multi-modal expense tracking with Telegram, Gemini AI & Google Sheets
🤯 Problem of Traditional Bookkeeping 🔀 Context switch kills the habit: Because bookkeeping lives outside the apps you use every day, you postpone it → forget to log. 🧱 High input friction: You’re forced to fill rigid fields (amount/category/date/notes…), which is slow and discouraging for quick capture. 🎙️💸 Weak or pricey natural-language options: A few tools support voice/chat, but they’re often expensive, and the experience is hit-or-miss. 🔒📦 Limited data ownership: Records live on third-party servers, so privacy and control are diluted. 📲 How This Workflow Fixes It 💬 Put the capture back where you already are: Log expenses directly inside Telegram (or other channels) in a familiar chat—no new app to learn. ⚡ Ultra-low-friction, unstructured input: Send text, a voice note, or a receipt photo—the flow extracts amount · item · date, supports multiple languages and relative dates, and can split multiple expenses from one message. 🗂️📝 Your data, your sheet: Final records are written to your own Google Sheet (columnar fields or a JSON column). You keep full control. 🔗 Demo Google Sheet: click me --- 👥 Who Is This For 😤 Anyone fed up with traditional bookkeeping but curious about an AI-assisted, chat-based way to log expenses. 🤖 People who tried AI bookkeeping apps but found them pricey, inflexible, or clunky. 💵 Bookkeeping beginners who want frictionless capture first, simple review and categorize later. --- 🧩 How It Works 💬 Captures expenses from Telegram (text, voice note, or receipt photo). 🔎 Normalizes inputs into raw text (uses Gemini to transcribe voice and extract text from images). 🧠 Parses amount · item · date with an LLM expense parser. 📊 Appends tidy rows to Google Sheets. 🔔 Sends a Telegram confirmation summarizing exactly what was recorded. --- 🛠️ How to Set Up 1) 🔑 Connect credentials (once) TELEGRAMBOTTOKEN LLMAPIKEY GOOGLESHEETSOAUTH 2) 🚀 Quick Start Setup: Create a Google Sheet to store Log Expense data and configure it in n8n. Telegram: Fill in and verify the Telegram chatId. Remember enable the workflow! --- 🧰 How to Customize the Workflow 📝 Other user interaction channels: Add Gmail, Slack, or a website Webhook to accept email/command/form submissions that map into the same parser. 🌍 Currency: Extract and store currency in its own column (e.g., MYR, USD); keep amount numeric only (no symbols). 🔎 Higher-accuracy OCR / STT to reduce errors --- 📩 Help Contact: owenlzyxg@gmail.com
By OwenLeeBulk YouTube channel content analysis with Apify & DeepSeek AI to Google Sheets
🎓📺 Watching top YouTubers is now a mainstream way to learn, but watching dozens—or even hundreds—of videos isn’t realistic. This workflow gives learners a fast way to grasp an entire creator’s catalog at a glance. 📄🔗 Demo Google Sheet: click me --- 🧠🔍 YouTube Channel Research & Summarization Workflow 👥 Who’s it for 📚 Learners and educators who want a fast overview of a creator’s entire catalog. 🧩 Research, SEO, and content ops teams building an intelligence layer on top of YouTube channels. ⚙️ How it works 📝 Collects parameters via a Form Trigger. 🕷️ Launches an Apify YouTube Scraper, polls for completion, and fetches the final dataset. 💾 Saves the raw JSON to Google Drive, reloads it, and processes records in batches. 🗣️ Auto-selects English subtitles when available, extracts core metadata, and feeds transcript + metadata to an AI Summarization Agent. 📧 Sends a Gmail completion notification when done. 🛠️ How to set up 🔑 Connect credentials (once) 🗂️ Google Drive 📊 Google Sheets (OAuth enabled) ✉️ Gmail 🧠 DeepSeek API (or alternative LLM); Apify API (YouTube scraper actor) 📝 Configure the form 🔗 YoutuberMainPageURL (e.g., https://www.youtube.com/@n8n-io) 🔢 Totalnumbervideo (tip: use the channel’s current total to crawl all) 🏷️ Storing_Name (used for the Drive filename & the Sheet tab) 🔑 Apify_API (Apify provides $5 free credit per month, which can crawl ~1,000 YouTube videos → https://console.apify.com/) 📧 Email 📁 Point Sheets & Drive 🔗 Create a Google Sheet and link it to all Google Sheets–related nodes. 💽 Select a Drive folder to save raw CSV backups (optional). 🎛️ How to customize the workflow 🈯 Subtitle logic: Extend the language selector SelectSubtitleLanguage to choose English, Mandarin, or another language. 🔔 Notifications: Customize the Gmail subject/body, or add Slack/Teams alerts on success/failure with basic run stats. 📬 Need help? Contact me <owenlzyxg@gmail.com>
By OwenLee