Workflow Templates

Description Save hours of manual reporting with this end-to-end automation. This workflow pulls campaign performance data (demo or live), generates a clear AI-powered executive summary, and compiles everything into a polished weekly report. The report is formatted in Markdown, automatically stored in Google Docs, and instantly shared with your team via Slack — no spreadsheets, no copy-paste, no delays. What it does ⏰ Runs on a schedule (e.g. every Monday morning) 📊 Collects performance metrics (Google Ads, Meta, TikTok, YouTube – demo data included) 🤖 Uses AI to summarize wins, issues, and recommendations 📝 Builds a structured Markdown report (totals, channel performance, top campaigns) 📄 Creates and updates a Google Doc with the report 💬 Notifies your team in Slack with topline numbers + direct report link 📧 Optionally email the report to stakeholders or clients Why it’s valuable Saves time** – no manual data aggregation Standardizes reporting** – same format and quality every week Adds insights** – AI highlights what matters most Improves transparency** – instant access via Docs, Slack, or Email Scales easily** – adapt to multiple clients or campaigns Professional delivery** – branded, polished reports on autopilot 💡 Extra recommendation: Connect to a Google Docs template to give your reports a professional, branded look.

This n8n workflow automates the process of generating and publishing LinkedIn posts that align with your personal brand tone and trending tech topics. It uses OpenAI to create engaging content and matching visuals, posts it directly to LinkedIn, and sends a confirmation via Telegram with post details. 🔑 Key Features 🏷️ Random Hashtag Selection Picks a trending tag from a custom list for post inspiration. ✍️ AI-Generated Content GPT-4o crafts a LinkedIn-optimized post in your personal writing style. 🖼️ Custom Image Generation Uses OpenAI to generate a relevant image for visual appeal. 📤 Direct LinkedIn Publishing Posts are made automatically to your profile with public visibility. 📩 Telegram Notification You get a real-time Telegram alert with the post URL, tag, and timestamp. 📚 Writing Style Alignment Past posts are injected as examples to maintain a consistent tone. Ideal Use Case: Automate your daily or weekly LinkedIn presence with minimal manual effort while maintaining high-quality, relevant, and visually engaging posts.

Automated daily swing‑trade ideas from end‑of‑day (EOD) data, scored by an LLM, logged to Google Sheets, and pushed to Telegram. What this workflow does Fetches EOD quotes* for a chosen stock universe (example: *NSE‑100** via RapidAPI). Cleans & filters** the universe using simple technical/quality gates (e.g., price/volume sanity, avoid illiquid names). Packages market context* and feeds it to *OpenAI* with a strict *JSON schema* to produce *top swing‑trade recommendations** (entry, target, stop, rationale). Splits structured output* into rows and *logs* them to a *Google Sheet** for tracking. Sends an alert* with the day’s trade ideas to *Telegram** (channel or DM). Ideal for Retail traders who want a daily, hands‑off idea generator. PMs/engineers prototyping LLM‑assisted quant sidekicks. Creators who publish daily trade notes to their audience. Tech stack n8n** (orchestration) RapidAPI** (EOD quotes; pluggable data source) OpenAI** (LLM for idea generation) Google Sheets** (logging & performance tracker) Telegram** (alerts) Prerequisites RapidAPI key with access to an EOD quotes endpoint for your exchange. OpenAI API key. Google account with a Sheet named Trade_Recommendations_Tracker (or update the node). Telegram bot token (via @BotFather) and destination chat ID. > You can replace any of the above vendors with equivalents (e.g., Alpha Vantage, Twelve Data, Polygon, etc.). Only the HTTP Request + Format nodes need tweaks. Environment variables | Key | Example | Used in | | -------------------- | -------------------------- | --------------------- | | RAPIDAPI_KEY | xxxxxxxxxxxxxxxxxxxxxxxx | HTTP Request (quotes) | | OPENAI_API_KEY | sk-… | OpenAI node | | TELEGRAM_BOT_TOKEN | 123456:ABC-DEF… | Telegram node | | TELEGRAM_CHAT_ID | 5357385827 | Telegram node | Google Sheet schema Create a Sheet (tab: EOD_Ideas) with the headers: Date, Symbol, Direction, Entry, Target, StopLoss, Confidence, Reason, SourceModel, UniverseTag Node map (name → purpose) Trigger – Daily Market Close → Fires daily after market close (e.g., 4:15 PM IST). Prepare Stock List (NSE 100) → Provides stock symbols to analyze (static list or from a Sheet/API). Fetch EOD Data (RapidAPI) → Gets EOD data for all symbols in one or batched calls. Format EOD Data → Normalizes API response to a clean array (symbol, close, high, low, volume, etc.). Filter Valid Stock Data → Drops illiquid/invalid rows (e.g., volume > 200k, close > 50). Build LLM Prompt Input → Creates compact market context & JSON instructions for the model. Generate Swing Trade Ideas (OpenAI) → Returns strict JSON with top ideas. Split JSON Output (Trade‑wise) → Explodes the JSON array into individual items. Log Trade to Google Sheet → Appends each idea as a row. Send Trade Alert to Telegram → Publishes a concise summary to Telegram.

Blockify® Technical Manual Data Optimization Workflow Blockify Optimizes Data for Technical Manual RAG and Agents - Giving Structure to Unstructured Data for ~78X Accuracy, when pairing Blockify Ingest and Blockify Distill Learn more at https://iternal.ai/blockify Get Free Demo API Access here: https://console.blockify.ai/signup Read the Technical Whitepaper here: https://iternal.ai/blockify-results See example Accuracy Comparison here: https://iternal.ai/case-studies/medical-accuracy/ Blockify is a data optimization tool that takes messy, unstructured text, like hundreds of sales‑meeting transcripts or long proposals, and intelligently optimizes the data into small, easy‑to‑understand "IdeaBlocks." Each IdeaBlock is just a couple of sentences in length that capture one clear idea, plus a built‑in contextualized question and answer. With this approach, Blockify improves accuracy of LLMs (Large Language Models) by an average aggregate 78X, while shrinking the original mountain of text to about 2.5% of its size while keeping (and even improving) the important information. When Blockify's IdeaBlocks are compared with the usual method of breaking text into equal‑sized chunks, the results are dramatic. Answers pulled from the distilled IdeaBlocks are roughly 40X more accurate, and user searches return the right information about 52% more accurate. In short, Blockify lets you store less data, spend less on computing, and still get better answers- turning huge documents into a concise, high‑quality knowledge base that anyone can search quickly. Blockify works by processing chunks of text to create structured data from an unstructured data source. Blockify® replaces the traditional "dump‑and‑chunk" approach with an end‑to‑end pipeline that cleans and organizes content before it ever hits a vector store. Admins first define who should see what, then the system ingests any file type—Word, PDF, slides, images—inside public cloud, private cloud, or on‑prem. A ​context‑aware splitter finds natural breaks, and a series of specially developed Blockify LLM model turns each segment into a draft IdeaBlock. GenAI systems fed with this curated data return sharper answers, hallucinate far less, and comply with security policies out of the box. The result: higher trust, lower operating cost, and a clear path to enterprise‑scale RAG without the cleanup headaches that stall most AI rollouts.

A hands-on starter workflow that teaches beginners how to: Pull rows from a Google Sheet Append a new record that mimics a form submission Generate AI-powered text with GPT-4o based on a “Topic” column Write the AI output back into the correct row using an update operation Along the way you’ll learn the three essential Google Sheets operations in n8n (read → append → update), see how to pass sheet data into an OpenAI node, and document each step with sticky-note instructions—perfect for anyone taking their first steps in no-code automation. 0️⃣ Prerequisites Google Sheets** Open Google Cloud Console → create / select a project. Enable Google Sheets API under APIs & Services. Create an OAuth Desktop credential and connect it in n8n. Share the spreadsheet with the Google account linked to the credential. OpenAI** Create a secret key at <https://platform.openai.com/account/api-keys>. In n8n → Credentials → New → choose OpenAI API and paste the key. Sample sheet to copy** (make your own copy and use its link) <https://docs.google.com/spreadsheets/d/15i9WIYpqc5lNd5T4VyM0RRptFPdi9doCbEEDn8QglN4/edit?usp=sharing> 1️⃣ Trigger Manual Trigger – lets you run on demand while learning. (Swap for a Schedule or Webhook once you automate.) 2️⃣ Read existing rows Node:** Get Rows from Google Sheets Reads every row from Sheet1 of your copied file. 3️⃣ Generate a demo row Node:** Generate 1 Row of Data (Set node) Pretends a form was submitted: Name, Email, Topic, Submitted = "Yes" 4️⃣ Append the new row Node:** Append Data to Google Operation append → writes to the first empty line. 5️⃣ Create a description with GPT-4o OpenAI Chat Model – uses your OpenAI credential. Write description (AI Agent) – prompt = the Topic. Structured Output Parser – forces JSON like: { "description": "…" }. 6️⃣ Update that same row Node:** Update Sheets data Operation update. Matches on column Email to update the correct line. Writes the new Description cell returned by GPT-4o. 7️⃣ Why this matters Demonstrates the three core Google Sheets operations: read → append → update. Shows how to enrich sheet data with an AI step and push the result right back. Sticky Notes provide inline docs so anyone opening the workflow understands the flow instantly. 👤 Need help? Robert Breen – Automation Consultant ✉️ robert.j.breen@gmail.com 🔗 <https://www.linkedin.com/in/robert-breen-29429625/>

Who's it for This template is perfect for any SaaS business or subscription service using Stripe. Product managers, customer success teams, and founders can use this to automatically collect cancellation feedback without manual follow-up. Ideal for companies looking to reduce churn by understanding why customers leave. What it does When a customer cancels their Stripe subscription, this workflow instantly: Detects the cancellation via Stripe webhook Fetches customer details from Stripe API Sends a personalized feedback survey email with embedded customer information Logs all cancellations to Google Sheets for tracking Receives survey responses via webhook Automatically routes feedback to different Google Sheets based on reason (pricing concerns, feature requests, or other feedback) This organized approach helps you identify patterns in cancellations and prioritize improvements that matter most. How it works Stripe triggers the workflow when a subscription is canceled Customer data is fetched from the Stripe API (email, name, plan details) Personalized email is sent with a survey link containing customer data as URL parameters Cancellation is logged to a Google Sheets "Cancellations" tab When the customer submits the survey, a webhook receives the response Feedback is routed to dedicated sheets based on cancellation reason: Price Concerns → for pricing-related issues Feature Requests → for missing functionality Other Feedback → for everything else Set up steps Setup time: ~20 minutes Prerequisites Stripe account (test mode recommended for initial setup) Google account with Google Sheets Email service (Gmail, Outlook, or SMTP) Survey tool with webhook support (Tally or Typeform recommended) Configuration Stripe webhook: Copy the webhook URL from the "Stripe Subscription Canceled" node and add it to your Stripe Dashboard → Webhooks. Select the customer.subscription.deleted event. Email credentials: Configure Gmail, Outlook, or SMTP credentials in the "Send Feedback Survey Email" node. Update the fromEmail parameter. Survey form: Create a survey form with these fields: Hidden fields (auto-populated from URL): email, customer_id, name, plan Visible fields: reason dropdown ("Too Expensive", "Missing Features", "Other"), comments textarea Configure webhook to POST responses to the "Survey Response Webhook" URL Google Sheets: Create a spreadsheet with 4 sheets: "Cancellations", "Price Concerns", "Feature Requests", and "Other Feedback". Connect your Google account in the Google Sheets nodes. Survey URL: Replace [SURVEY_URL] in the email template with your actual survey form URL. Test: Use Stripe test mode to trigger a test cancellation and verify the workflow executes correctly. Requirements Stripe account with API access Google Sheets (free) Email service: Gmail, Outlook, or SMTP server Survey tool: Tally (free), Typeform (paid), or custom form with webhook capability n8n instance: Cloud or self-hosted How to customize Different surveys by plan: Add an IF node after getting customer details to send different survey links based on subscription tier Slack notifications: Add a Slack node after "Route by Feedback Type" to alert your team about price concerns in real-time Delayed email: Insert a Wait node before sending the email to give customers a 24-hour cooldown period CRM integration: Add nodes to sync cancellation data with your CRM (HubSpot, Salesforce, etc.) Follow-up workflow: Create a separate workflow that triggers when feedback is received to send personalized follow-up offers Custom routing logic: Modify the Switch node conditions to match your specific survey options or add more categories Tips for success Use Stripe test mode initially to avoid sending emails to real customers during setup Customize the email tone to match your brand voice Keep the survey short (2-3 questions max) for higher response rates Review feedback weekly to identify patterns and prioritize improvements Consider offering a discount or incentive for completing the survey

Build a Customer Support AI Voice Agent with GPT-5 and ElevenLabs 👥 Who is this for? This template is ideal for: Businesses that want to provide 24/7 automated voice-based customer support Service providers needing to schedule appointments via voice interaction Teams looking to handle multilingual customer queries automatically Entrepreneurs aiming to boost customer engagement without hiring large support teams 💡 What problem is this workflow solving? Traditional customer support requires: Human agents to answer repeated questions Manual handling of bookings and confirmations Limited availability outside office hours This workflow solves those issues by combining GPT-5 intelligence with ElevenLabs voice synthesis, enabling your website visitors to: Ask questions and receive spoken answers in multiple languages Request appointment availability Confirm bookings and receive automatic email confirmations All of this happens automatically, reducing costs and ensuring consistent customer experience. ⚙️ What this workflow does Receive customer voice input via webhook from your website Transcribe and understand intent using GPT-5 and LangChain reasoning Fetch information from your knowledge base (Google Sheets) for FAQs, services, or policies Check availability in Google Calendar in real-time Create confirmed appointments only after explicit user confirmation Send confirmation emails with booking details via Gmail Respond back to the user with a multilingual spoken reply using ElevenLabs 🧰 Setup Before launching this workflow, make sure you: Have an OpenAI API key for GPT-5 Set up an ElevenLabs account and API key for voice input/output Enable Google Sheets API and prepare a sheet with your FAQ/knowledgebase Enable Google Calendar API and connect your calendar for scheduling Connect your Gmail account for booking confirmation emails Configure the Webhook URL on your website for sending voice requests Follow the sticky note instructions inside the workflow for final setup 🛠️ How to customize this workflow Knowledgebase:** Add or update information in your Google Sheets to cover new FAQs Voice settings:** Configure ElevenLabs voice style, tone, or supported languages Appointment rules:** Adjust event duration or add reschedule/cancellation options Notifications:** Add Slack or Telegram alerts for each new confirmed booking Email templates:** Customize the confirmation email with your brand style With this workflow, your website becomes an AI-powered voice assistant — capable of handling customer inquiries, providing multilingual support, and managing bookings seamlessly. 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube

📝 Description This n8n workflow automates the candidate shortlisting process by integrating Google Sheets, Gmail, ClickUp, and Calendly. It fetches candidate records, filters high-scoring profiles, sends personalized advancement emails, and creates screening tasks for your HR team—all with a single manual trigger. 🚀 What It Does Fetch All Candidate Records Retrieves complete candidate data (names, scores, contact info, summaries) from the ‘Resume store’ Google Sheet (Sheet2). Efficiently loads all rows for batch analysis. Filter High-Score Candidates Applies a threshold filter (default: score > 70) to identify strong-fit candidates. Only qualified profiles advance; threshold is customizable per role. Send Congratulations Email Sends personalized emails to qualified candidates using Gmail. Includes a dynamic Calendly scheduling link for interview booking. Maintains a positive candidate experience with professional messaging. Create Screening Task in ClickUp Automatically generates screening tasks for each qualified candidate in ClickUp. Assigns tasks to a designated team member and organizes them in specified project folders. Ensures accountability and seamless follow-up. 📈 Key Benefits Speed: Instantly advances qualified candidates—no manual sorting. Consistency: Standardized criteria and communications for every role. Organization: Auto-creates ClickUp tasks so nothing slips through. Experience: Timely, professional communication enhances candidate journey. Efficiency: Reduces HR workload and error risk. ⚙️ Customization & Integration Score Threshold: Set to 70 by default; adjust for different roles or seniority. Email Template: Editable subject, body, and CTA (Calendly link). ClickUp Integration: Uses configurable Team, Space, Folder, List, and Assignee IDs. Systems Supported: Google Sheets (data), Gmail (email), ClickUp (tasks), Calendly (scheduling). 🔧 Setup Requirements n8n instance (self-hosted or cloud). Google Sheets access for ‘Resume store’ (Sheet2). Gmail credentials for candidate notifications. ClickUp API token and IDs for task creation. Calendly link for interview scheduling. 👥 Target Audience HR teams, recruiters, staffing agencies. Operations managing high-volume candidate pipelines. Startups/SMBs seeking standardized hiring automation. 🛠️ Maintenance Tips Update email templates seasonally. Review scoring thresholds monthly. Monitor ClickUp task completion rates. Ensure Calendly links remain active. 📋 Step-by-Step Usage Connect Google Sheets, Gmail, and ClickUp credentials in n8n. Import the workflow; configure threshold, email, and ClickUp settings. Edit the email node with your Calendly link and branding. Trigger “Execute workflow” after new candidate scores are added. Review logs and results for successful candidate progression.

This n8n workflow automatically detects canceled meetings from Calendly, uses GPT to write a friendly follow-up message, and sends it via Gmail, complete with a personalized Loom video link. It also creates an Asana task to remind your team to follow up manually if needed. Ideal for B2B consultants, agencies, and sales teams who want to salvage missed opportunities and stay top-of-mind with prospects after no-shows. ⸻ Who it’s for Sales teams, consultants, and agencies who rely on scheduled calls to close business and want to re-engage leads who cancel or no-show using automated, human-sounding follow-ups. ⸻ How it works / What it does A Calendly Webhook triggers the flow when a meeting is canceled. Edit Fields extracts the meeting details (who canceled, when, and why). A GPT-4 node writes a personalized follow-up email based on the meeting context. You manually paste in your Loom video link. A Merge node combines the AI-written message, user info, and video link. Gmail sends the follow-up message automatically to the contact. An Asana task is created for your team to track the missed call and optionally follow up manually. ⸻ How to set up Create a webhook in Calendly and connect it to the Calendly Trigger node. Add your OpenAI key in the Message a Model node. Connect your Gmail and Asana accounts via n8n credentials. Manually paste in the Loom video link in the Loom Link node. Set your preferred Asana project and teammate in the Create a Task node. ⸻ Requirements A Calendly account OpenAI API key Gmail account with OAuth connected in n8n Asana account with access to a project and user ID ⸻ How to customize the workflow Update the GPT prompt to change the tone or add context based on your business. Replace Loom with a Vidyard, Tella, or custom-hosted video link. Add a Slack notification node to alert your sales team when a call is missed. Link with a CRM or Google Sheets to track follow-up activity across your pipeline. This modular workflow helps you turn no-shows into new opportunities, while keeping your team organized and your leads engaged.

Enhance your hiring pipeline by automating interview management post-screening. This workflow runs every 5 minutes to scan upcoming Google Calendar events, filter relevant interviews, send timely email reminders to candidates and internal teams, and handle result submissions via webhook — updating statuses in Google Sheets and notifying via Gmail based on pass/fail outcomes. Ensure no interviews slip through the cracks with proactive reminders and instant feedback loops. What This Template Does Step 1: Triggers every 5 minutes to proactively check for upcoming interviews. Step 2: Fetches all Google Calendar Events and identifies interview-related ones. Step 3: Filters Upcoming Interviews based on event details (e.g., candidate name, role). Step 4: Sends Reminder Emails to candidates and interviewers via Gmail for preparation. Step 5: Receives Webhook Submission of interview results (pass/fail) post-event. Step 6: Updates Google Sheet with result data, including feedback and updated status. Step 7: Branches on result:   → Passed: Sends congratulatory Email to Candidate and advances status.   → Failed: Sends polite Failure Notification and closes the loop. Key Benefits ✅ Reduces no-shows with automated reminders ✅ Centralizes interview tracking in Google Sheets ✅ Instant Gmail notifications for pass/fail decisions ✅ Minimizes manual status updates ✅ Improves candidate experience with timely communication ✅ Ensures audit-ready logs of all interactions Features Cron-triggered checks every 5 minutes Google Calendar integration for event fetching Smart filtering for interview-specific events Gmail-powered reminder and notification emails Webhook for secure result submissions Conditional branching on pass/fail Real-time Google Sheets append/update Comprehensive sheet structure for tracking Requirements GOOGLE_SHEET_ID**: Your Google Sheet ID (structured as below) Credentials Needed:** Google Calendar OAuth2 Gmail API Key Customize:** • Event filter criteria (e.g., keywords like "Interview") • Reminder timing (e.g., 24 hours before) • Email templates for reminders and results • Webhook endpoint for result submission Google Sheet Structure: Create a sheet with columns: Candidate Email Interview Link Status Result Meet Link Feedback Updated At Target Audience Recruiters juggling multiple interview schedules 🗓️ HR teams focused on candidate engagement 💬 Hiring managers needing quick result turnarounds ⚡ Growing companies scaling interview volumes 📈 Remote teams relying on calendar and email sync 🌐 Step-by-Step Setup Instructions Set up Google Sheet  → Create sheet with the specified columns: Candidate Email, Interview Link, Status, Result, Meet Link, Feedback, and Updated At.  → Replace YOUR_SHEET_ID in the workflow with your actual Sheet ID. Configure Calendar Integration  → Connect Google Calendar OAuth2 and select the relevant calendar (e.g., hiring@company.com). Define Event Filters  → In the "Filter Upcoming Interviews" node, set keywords (e.g., "Candidate Interview") to match event titles/descriptions. Customize Reminders  → Edit the "Send Reminder to Candidate" template (e.g., include interview link and prep tips).  → Set reminder offset (e.g., 1 day before event). Set Up Webhook for Results  → Generate and expose the webhook URL for your interview form/tool to submit pass/fail data. Connect Gmail  → Enable Gmail OAuth2.  → Define sender email and customize pass/fail templates. Test the Flow  → Create a test calendar event for an upcoming interview.  → Wait 5 minutes or trigger manually → Verify reminder email.  → Submit test webhook result → Check sheet update and notification email. Go Live  → Enable the 5-minute cron trigger.  → Monitor sheet for real entries on Thursday, October 23, 2025, or your next interview day.

Client Onboarding Email Automation with Google Sheets + Gemini + Gmail When a new client fills out your onboarding form, this workflow automatically creates a personalized welcome email and sends it — using the details they submitted. Benefits Triggers automatically on every new Google Sheets form response Uses Google Gemini to generate a friendly, structured welcome email Includes a checklist of next steps for the client Sends email directly via Gmail Handles errors safely so the workflow never stops How It Works Google Sheets trigger fires when a new row is added Workflow extracts client name, email, company, and service needs Loads a standard onboarding checklist Gemini model writes a custom email using client info + checklist Gmail node sends the email with a welcome subject line Marks workflow as completed or logs failure if there is an error Who Is This For Agencies onboarding new clients Coaches and consultants welcoming new members SaaS or service businesses sending structured welcome steps Setup Connect Google Sheets (use the onboarding form sheet) Add Gemini (Google AI) API key Add Gmail OAuth2 credentials Customize the checklist items if needed Test with a sample form submission before going live ROI & Monetization Save 1–2 hours per new client on manual welcome emails Give clients a smooth and consistent onboarding experience Turn onboarding into a branded, automated touchpoint Strategy Insights In the full walkthrough, I show how to: Build a clean onboarding checklist step by step Use Gemini prompts to keep emails short and professional Add error handling and logging for reliability Extend workflow to create tasks or Slack notifications for your team Check Out My Channel For more AI automation systems that save time and improve client experience, check out my YouTube channel where I share the exact strategies I use to automate onboarding, scale client systems, and grow to $20k+ monthly revenue.

🧾 Attendance Extraction & Notification Pipeline (Google Drive + VLM Run + Google Sheets + Gmail) ⚙️ What This Workflow Does This workflow automates daily attendance tracking by analyzing uploaded attendance images, extracting participant names via VLM Run’s Execute Agent, appending the structured data into Google Sheets, and emailing a formatted attendance summary through Gmail. 🧩 Requirements A Google Drive account with a designated folder for attendance image uploads. A VLM Run API account and your Execute Agent URL or API credentials. A Gmail account connected to n8n for sending notification emails. An n8n instance with the following credentials configured: Google Drive, Google Sheets, Gmail, VLM Run (HTTP API Credential) ⚡Quick Setup Install the verified VLM Run node by searching for VLM Run in the node list, then click Install. Once installed, you can start using it in your workflows. Add VLM Run API credentials for image parsing. Link your Google Drive, Google Sheets and Gmail accounts in the credentials section. In the “Google Drive Trigger” node, select the folder where attendance images will be uploaded. In the “Append Row” node, connect your Google Sheet and map columns manually (e.g., Date, Total, Names…). Add VLM Run execute agent endpoint. Upload an image (whiteboard attendance photo or scanned sheet) to your Drive folder. Wait for the automation to process and check your Google Sheet for results. After each extraction and logging step, the Gmail Node sends an automated summary email. Email includes: 📅 Date of attendance 👥 Total participants detected 🧍 List of extracted names ⚙️ How It Works Monitor List Uploads – Watches a Google Drive folder for new attendance images (e.g., whiteboard snapshots, scanned sheets). Download List – Downloads each new image automatically for AI processing. VLM Run for Extraction sends the image to VLM Run Execute Agent, which uses an AI model to detect and extract attendee names from the image. Receive Attendance Data – The Webhook node (check-attendance) receives structured JSON data from VLM Run in the format: { "majorDimension": "ROWS", "values": [ ["2025-10-03", "6", "Camila Torres Rivera", "Mellissa Richmond", "Captioner Javier", "Siobhan", "Catherine Soler", "Anisah Anif"] ] } The Google Sheets Node appends the structured attendance data to the selected sheet, maintaining a daily log for future reference. The Gmail Node sends an automatic email summarizing attendance. 💡Why Use This Workflow 🔄 Fully Automated: No manual data entry required. 🧠 AI-Powered Extraction: Uses VLM Run to read and parse images with handwritten or typed text. 📊 Centralized Logging: Attendance data neatly organized in Google Sheets for future analysis. 📬 Instant Notification: Keeps stakeholders informed automatically after each session. ⚡ Scalable: Works with multiple folders, daily batches, or parallel sessions. 🛠️ How to Customize You can tailor this workflow to match your organization’s needs: | Area | Customization Options | | ------------------------ | ---------------------------------------------------------------------------------------------------------- | | Drive Folder | Point to a different upload folder for each department or class. | | Google Sheet Mapping | Add more columns (e.g., “Class Name,” “Supervisor”) and map them in the Append Row node. | | Email Template | Modify the Gmail node’s subject and body to include custom formatting or logos. | | Trigger Schedule | Replace Google Drive Trigger with a Cron Node if you prefer scheduled checks instead of live watching. | | Data Validation | Add a Function Node to filter duplicates or incorrect entries before appending to Sheets. | | Notification Options | Send alerts via Slack, Telegram, or Microsoft Teams instead of Gmail if desired. | ⚠️ Community Node Disclaimer This workflow uses community nodes (VLM Run) that may need additional permissions and custom setup.