Create a table in MySQL and insert data
Companion workflow for MySQL node docs
By amudhanAutomated birthday emails with Google Sheets, OpenRouter GPT-4o & Gmail
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Send Automated Personalized Birthday Emails Using Google Sheets, OpenRouter AI, and Gmail 🧠 What This Workflow Does This workflow sends personalized birthday greetings via email every morning using data from Google Sheets and messages generated with AI. It’s great for communities, schools, small businesses, or anyone who wants to automate meaningful connections. ⚙️ Features 🗓 Daily Birthday Check — Runs every day at 9 AM 📋 Google Sheets Integration — Reads user data: Name, Email, DOB 🔍 Smart Date Matching — Extracts day & month from DOB to match today’s date 🤖 OpenRouter AI Integration — Generates a custom subject + email message 🛠 Function Node Cleanup — Separates AI response into subject & body 📬 Gmail Node — Sends personalized birthday wishes instantly 🔧 Tech Stack Google Sheets OpenRouter (or OpenAI-compatible model) Gmail 💡 Use Cases Educators sending birthday emails to students Team leads acknowledging team members’ birthdays Freelancers staying in touch with clients 1Coaches or mentors maintaining personal rapport 📝 Requirements Google Sheet with columns: Name, DOB (DD/MM/YYYY), and Email Gmail account with OAuth2 connected OpenRouter (or OpenAI) API key Basic understanding of n8n nodes
By Parth PansuriyaExtract transactions from images using unli.dev Vision API & Telegram
unli.dev + n8n + Telegram Image Analyzer turns images sent to your Telegram bot into clean, Markdown-formatted transaction text using unli.dev Vision API. Instead of typing numbers and dates manually, the workflow downloads the photo, converts it to base64, analyzes it via API, and replies in-chat with extracted details, saving time and reducing errors. 💡 Why Use Image Analyzer? Save time: Process images in seconds, cutting manual entry by up to 90%. Solve pain points: No more blurry screenshot frustration; get clean Markdown transactions. Faster outcomes: Per-image turnaround under 15s. Competitive edge: Give staff/customers structured feedback instantly ⚡ Perfect For Small business owners: Capture receipts/payments quickly. Accountants/bookkeepers: Intake client receipts with fewer typos. Ops/support teams: Turn messy screenshots into actionable records. 🔧 How It Works Trigger: Telegram bot receives photo. Process: Convert to base64 & prepare request. Smart Logic: Call unli.dev Vision API for text extraction. Output: Send Markdown result back to Telegram. Optional: Save structured data to Google Sheets, Airtable, or DB. 🛠 Quick Setup Import workflow JSON to your n8n instance. Add credentials: Telegram bot + unli.dev API key. Customize the system prompt (default: extract the transaction in Markdown). Test by sending a real photo to your bot. 🧩 You’ll Need n8n instance Telegram bot token unli.dev Vision API key Optional: Google Sheets / Airtable for storage Made by: Khaisa Studio Category: Image Analysis Contact: Get in touch
By Khairul Muhtadin