Automated 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 email tasks with Gmail, ChatGPT-4o and Supabase
📩 Gmail → GPT → Supabase | Task Extractor This n8n workflow automates the extraction of actionable tasks from unread Gmail messages using OpenAI's GPT API, stores the resulting task metadata in Supabase, and avoids re-processing previously handled emails. --- ✅ What It Does Triggers on a schedule to check for unread emails in your Gmail inbox. Loops through each email individually using SplitInBatches. Checks Supabase to see if the email has already been processed. If it's a new email: Formats the email content into a structured GPT prompt Calls ChatGPT-4o to extract structured task data Inserts the result into your emails table in Supabase --- 🧰 Prerequisites Before using this workflow, you must have: An active n8n Cloud or self-hosted instance A connected Gmail account with OAuth credentials in n8n A Supabase project with an emails table and: sql ALTER TABLE emails ADD CONSTRAINT uniqueemailid UNIQUE (email_id); An OpenAI API key with access to GPT-4o or GPT-3.5-turbo --- 🔐 Required Credentials | Name | Type | Description | |-----------------|------------|-----------------------------------| | Gmail OAuth | Gmail | To pull unread messages | | OpenAI API Key | OpenAI | To generate task summaries | | Supabase API | HTTP | For inserting rows via REST API | --- 🔁 Environment Variables or Replacements SupabaseTaskManagementURI → e.g., https://your-project.supabase.co SupabaseTaskManagementANON_KEY → Your Supabase anon key These are used in the HTTP request to Supabase. --- ⏰ Scheduling / Trigger Triggered using a Schedule node Default: every X minutes (adjust to your preference) Uses a Gmail API filter: unread emails with label = INBOX --- 🧠 Intended Use Case > Designed for productivity-minded professionals who want to extract, summarize, and store actionable tasks from incoming email — without processing the same email twice or wasting GPT API credits. This is part of a larger system integrating GPT, calendar scheduling, and optional task platforms (like ClickUp). --- 📦 Output (Stored in Supabase) Each processed email includes: email_id subject sender received_at body (email snippet) gpt_summary (structured task) requiresdeepwork (from GPT logic) deleted (initially false)
By Paul TaylorAutomate Google Classroom with Gemini AI: Topics, assignments & student tracking
Automate Google Classroom: Topics, Assignments & Student Tracking Automate Google Classroom via the Google Classroom API to efficiently manage courses, topics, teachers, students, announcements, and coursework. Use Cases Educational Institution Management Sync rosters, post weekly announcements, and generate submission reports automatically. Remote Learning Coordination Batch-create assignments, track engagement, and auto-notify teachers on new submissions. Training Program Automation Automate training modules, manage enrollments, and generate completion/compliance reports. Prerequisites n8n (cloud or self-hosted) Google Cloud Console access for OAuth setup Google Classroom API enabled Google Gemini API key (free) for the agent brain — or swap in any other LLM if preferred Setup Instructions Step 1: Google Cloud Project Create a new project in Google Cloud Console. Enable Google Classroom API. Create OAuth 2.0 Client ID credentials. Add your n8n OAuth callback URL as a redirect URI. Note down the Client ID and Client Secret. Step 2: OAuth Setup in n8n In n8n, open HTTP Request Node → Authentication → Predefined Credential Type. Select Google OAuth2 API. Enter your Client ID and Client Secret. Click Connect my account to complete authorization. Test the connection. Step 3: Import & Configure Workflow Import this workflow template into n8n. Link all Google Classroom nodes to your OAuth credential. Configure the webhook if using external triggers. Test each agent for API connectivity. Step 4: Customization You can customize each agent’s prompt to your liking for optimal results, or copy and modify node code to expand functionality. All operations use HTTP Request nodes, so you can integrate more tools via the Google Classroom API documentation. This workflow provides a strong starting point for deeper automation and integration. Features Course Topics List, create, update, or delete topics within a course. Teacher & Student Management List, retrieve, and manage teachers and students programmatically. Course Posts List posts, retrieve details and attachments, and access submission data. Announcements List, create, update, or delete announcements across courses. Courses List all courses, get detailed information, and view grading periods. Coursework List, retrieve, or analyze coursework within any course. Notes Once OAuth and the LLM connection are configured, this workflow automates all Google Classroom operations. Its modular structure lets you activate only what you need—saving API quota and improving performance.
By Mantaka MahirExtract 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