Workflow Templates

Title: 🤖 AI-Powered BDR Engine: Apollo to Instantly.ai (Airtable + n8n) Overview: This is a full-stack, end-to-end AI-powered BDR workflow that automates your entire outbound process. Go from sourcing raw leads in Apollo to launching a hyper-personalized, multi-sequence campaign in Instantly.ai, all orchestrated by n8n and managed from a user-friendly Airtable interface. This template is a game-changer for founders, agencies, and sales teams. It replaces 80% of the manual work of a BDR team at a fraction of the cost, with a smarter, more efficient workflow designed to save you money on every lead. How This Workflow Works (The Upgraded Process): Lead Generation 🎯: Automatically sources targeted leads from Apollo.io and pushes the data to your Airtable base. Deep Lead Enrichment 📚: Enriches each lead with crucial context by scraping information from various sources: Company business summary and key details. The lead's most recent LinkedIn post. Recent company news releases from across the web. Intelligent Lead Qualification ✅: (NEW!) A dedicated node qualifies each lead based on your custom criteria (set in Airtable). This ensures a perfect ICP match and prevents unnecessary spending. Optimized Email Verification 📧: Emails are now verified for deliverability only after a lead has been qualified. This saves significant credits and protects your email account's sender reputation. AI-Powered Personalization ✍️: AI models craft a sequence of three highly personalized emails (subject and body) using the enriched data. An integrated "remake" option allows you to manually adjust messages as needed. Instantly.ai Campaign Push 🚀: The fully enriched, qualified, and personalized lead list is seamlessly pushed to Instantly.ai, where it automatically creates and launches a new campaign. Why This Template is Unique: End-to-End Automation: A single workflow handles the entire BDR process, eliminating the need to stitch together multiple automations. Cost Efficiency: The new pre-verification qualification step dramatically reduces API costs for email verification, making your campaigns roughly 30% cheaper than many market tools. Unmatched Personalization: Leverages multiple enrichment APIs and AI models to create truly unique and relevant email sequences. Scalable & User-Friendly: The Airtable-based UI makes it easy for non-technical users to manage campaigns, while n8n provides a robust, scalable backend. Requirements: An n8n instance (Cloud or self-hosted) Airtable account API access for: Apollo, Apify, Instantly.ai, Emailable, Jina AI, Perplexity, OpenAI/Anthropic Demo Video: Youtube: Presentation Video

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Capture More Traffic: AI-Mapped Topics & Keywords Stay ahead of competitors by uncovering their content strategies automatically. This workflow crawls competitor websites, extracts structured topic hierarchies, entities, and depth scores, and delivers actionable insights directly into Google Sheets. No more manual browsing, just clean, analyzable data you can act on. Benefits Competitor mapping at scale** Automatically map sites into hierarchical topics and entities. Data-driven content strategy** Identify gaps, weak spots, and opportunities to stand out. Seamless integration** Results flow straight into Google Sheets for filtering, charting, or export. Time & resource savings** Eliminate copy-paste research and focus on strategy. Target audience SEO specialists and digital marketers Content strategists and copywriters Agencies running content audits SaaS startups monitoring competition E-commerce teams benchmarking rivals Required APIs Google Sheets credentials (trigger & save) Apify API token (crawler) Gemini (Google Generative AI) key (content parsing) Easy customization Competitor domains:** Update in the Google Sheets config. Crawl depth & limits:** Adjust max_pages_num and crawl_depth_num. Output format:** Modify the Code node to add or remove Google Sheets columns. Delivery channels:** Add Slack or Email nodes for instant audit reports.

How it works This workflow automatically identifies users who started but did not complete the signup process. It runs on a fixed schedule, checks your database for inactive and incomplete users, and validates the results before proceeding. Each user is then processed individually to send a personalized recovery email and enroll them in a follow-up sequence. Finally, the workflow updates the database to avoid duplicate outreach and notifies the sales team in Slack. Step-by-step Step 1: Run scheduled check and identify abandoned users** Schedule Trigger – Executes the workflow automatically every 24 hours. Find Abandoned Users – Queries Postgres for users marked as incomplete and inactive for over 24 hours. If – Confirms that valid user records exist before continuing. Step 2: Process users and send recovery emails** Loop Over Items – Processes users one at a time to avoid rate limits and execution errors. PrepareEmail email – Generates a personalized recovery email using a predefined template. Send a message – Sends the recovery email through Gmail. Get a message – Retrieves the sent email details for tracking and thread reference. StartSequence email – Adds the email to a follow-up sequence for engagement tracking. Step 3: Update records and notify the team** Update rows in a table – Marks the user as contacted to prevent duplicate recovery emails. Alert Sales Team – Sends a Slack notification with user details and recovery status. Why use this? Recover users who abandon onboarding without manual follow-ups Ensure each user receives only one recovery email Keep your Postgres user data accurate and up to date Provide sales teams with real-time visibility via Slack alerts Improve signup completion and activation rates automatically

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

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.

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.

Stripe Invoice Reminder Workflow Who’s this for Businesses using Stripe subscriptions or one-time payments who want to automatically follow up with customers after a failed payment. What this workflow does Detects expired or failed charges in Stripe Drafts AI-generated payment reminders for customers Creates a new Stripe invoice for the failed payment Optionally sends reminders via Email or Slack How it works Stripe trigger listens for expired charges Set node normalizes customer and payment information OpenAI node drafts a friendly payment reminder Stripe node creates a new invoice Optional Email/Slack node sends the reminder How to set up Connect Stripe account and enable 'charge.expired' events Connect OpenAI API credentials Configure Email or Slack notifications if desired Optional: Customize AI prompt for company tone Requirements n8n account with Stripe integration OpenAI API key Optional Email/Slack integration How to customize Change AI prompt to fit brand voice Include dynamic invoice details or subscription links Add internal alerts for accounting teams Modify email templates or Slack messages

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.

AI Email Dispatcher: Classify, Process, and Route Emails with Multiple Agents This n8n template automatically classifies incoming emails (Sales, Support, Internal, Finance, Promotions) and routes them to a dedicated OpenAI LLM Agent for processing. Depending on the category, the agent will then: Internal/Customer Support:** Draft a reply and send it. Sales/Finance/Promotions:** Generate a summary, notification, or draft reply for a human to review. This is the ultimate workflow for managing a high volume of emails, ensuring every message gets a fast, appropriate, and structured AI-powered response or initial analysis. How it works The Gmail Trigger node monitors your inbox for unread emails. The Text Classifier node uses AI to read the email body and subject to categorize it as Internal, Customer Support, Sales, Promotions, or Admin/Finance. The workflow then uses a Split In Batches node and multiple If nodes to send the email data to a specific, specialized OpenAI Agent (LLM node) based on the classification. Each AI Agent has a custom system prompt (e.g., "Customer Support Agent," "Promotions Analyst") to ensure it processes the email with the right rules, tone, and output format. Finally, the workflow either automatically replies via Gmail (for Internal and Support) or creates a draft/summary and sends a notification (for Sales, Finance, and Promotions) for human review. Set up steps Setting up the accounts and nodes should take about 10–15 minutes. Gmail Account: You'll need to set up two Gmail credentials for the workflow: One for the Gmail Trigger to watch for new unread emails. A second one for the Gmail action nodes to label, draft, and reply to messages. OpenAI Account: Connect your OpenAI API Key to the five different LLM Agent nodes. Telegram/Slack: Set up your Telegram or Slack credentials to receive the 'New Sales Opportunity' and 'New Finance' notifications. Labels in Gmail: Before activating the workflow, make sure you have created the necessary labels in your Gmail account for the classifier (Internal, Customer Support, Promotions, Admin/Finance, Sales Opportunity). Review Agent Prompts: The instructions and logic for each AI Agent are in the system messages. You might want to review and customize these prompts to match your specific business rules and tone. Requirements Gmail** Account OpenAI** Account (or another LLM provider for the agents) Telegram** (or Slack/other notification tool of your choice) Customising this workflow You can easily adapt this template to suit your needs! New Categories:* Modify the *Text Classifier** node to add or remove categories (e.g., "Job Applications," "Partnerships"). You would then add a new LLM Agent and routing logic for the new category. Different LLMs:* You can swap the OpenAI nodes for any other LLM service supported by n8n, such as *Gemini* or *Anthropic Claude**, by simply changing the node type or model ID. More Actions:* Instead of just sending a notification to Telegram, you could modify the logic to create a task in *ClickUp, a lead in **Salesforce, or an entry in a Google Sheet when a "Sales Opportunity" email is identified. 📬✨

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.