Workflow Templates

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Automated Review Intelligence System Transform customer feedback into actionable intelligence with this Automated Review Intelligence System! This workflow collects reviews from platforms like Trustpilot using advanced web scraping, analyzes sentiment and patterns with AI, and generates comprehensive business intelligence reports. Perfect for customer experience teams monitoring brand reputation and customer satisfaction across review platforms. What This Template Does Triggers manually to start review collection from specified sources. Validates URL format to ensure proper review source configuration. Uses AI agent with Decodo scraper to extract review data from platforms. Parses and structures review data (ratings, comments, dates, locations). Enriches review data with metadata and quality metrics. Stores all review data in Google Sheets for historical tracking. Reads aggregated reviews for comprehensive analysis. Generates AI-powered summaries and key insights from review patterns. Sends email reports with actionable business intelligence. Provides error alerts for processing issues and invalid URLs. Key Benefits Automated collection of customer reviews from multiple platforms AI-powered sentiment analysis and pattern recognition Historical tracking of review trends and customer satisfaction Actionable business intelligence from customer feedback Real-time alerting for review processing issues Centralized review database for team visibility Features Manual trigger for on-demand review intelligence URL validation and error handling AI-powered review collection and analysis Decodo web scraping for reliable data extraction Structured data parsing for consistent formatting Google Sheets integration for data centralization Automated summary generation with key insights Email reporting for stakeholder communication Multi-platform review source support Historical trend analysis capabilities Requirements Decodo API credentials for web scraping OpenAI API credentials for AI analysis Google Sheets OAuth2 credentials with edit access Gmail OAuth2 credentials for email reports Environment variables for configuration settings Review source URLs (Trustpilot, etc.) Target Audience Customer experience and success teams Product management and development teams Marketing and brand reputation managers Business intelligence and analytics teams Customer support operations teams E-commerce and retail businesses Step-by-Step Setup Instructions Connect Decodo API credentials for review scraping functionality Set up OpenAI credentials for AI analysis and summary generation Configure Google Sheets with required review data headers Add Gmail credentials for report delivery and error notifications Set your target review source URLs (Trustpilot, etc.) Test with sample review pages to verify data extraction Customize summary reports for your business intelligence needs Define alert recipients for error notifications and reports Run manually to generate your first review intelligence report Pro Tip: Use coupon code "YARON" for free Decodo credits to enhance your review intelligence capabilities! This workflow ensures you stay informed about customer sentiment with automated review collection, intelligent analysis, and actionable business insights!

📩 Automatically Log Transactions from Gmail into Notion and Get Telegram Alerts Who’s it for This workflow is for individuals or entrepreneurs who receive bank alerts, invoices, and payment emails in Gmail and want them to be automatically organized in Notion — while also receiving quick Telegram notifications for each transaction. If you manage personal or business finances and find it tedious to manually record every debit, credit, or invoice — this automation does it all for you. How it works The workflow acts as an AI-powered Accountant Agent that reads incoming Gmail messages and decides whether each email represents a Debit Transaction, Credit Transaction, Debit Invoice, or Credit Invoice. The Gmail Trigger watches your selected inboxes (like forwarding@bayesian-labs.com, support@bayesian-labs, anoop.karnik@bayesian-labs). The Classifier (GPT-5-nano) determines the correct transaction type. The appropriate Agent (GPT-5) then extracts amount, currency, and description details. The Agent uses Notion API tools to log structured data into your Personal Finance System Notion template (Financial Transactions & Income databases). Finally, a Telegram notification is sent summarizing the entry (From, To, Subject, Snippet). In short: every time your bank emails you — Notion gets updated, and you get notified. How to set up Duplicate the Personal Finance System Notion template into your workspace. Create a Telegram Bot with BotFather → copy the bot token and your chat ID. Generate an OpenRouter API key for GPT-5 / GPT-5-nano. Create a Notion Integration Token and connect it to your duplicated finance databases. Add your Gmail accounts (forwarding@, support@, and/or personal Gmail) under Gmail OAuth2 credentials in n8n. Import the workflow JSON into n8n → fill in the credential names as listed below: n8n_cloud_regular_usage → OpenRouter Notion account → Notion API Accountant AI → Telegram Bot Gmail OAuth2 for each inbox trigger Once active, n8n polls Gmail every minute, classifies emails, updates Notion, and sends Telegram updates. Requirements n8n instance (self-hosted or cloud) Gmail accounts connected via OAuth2 OpenRouter API key Telegram bot token & chat ID Notion integration token Your duplicated Personal Finance System Notion template How to customize the workflow You can extend this workflow to: Track credit card statements, subscriptions, or payroll notifications. Add Slack or WhatsApp alerts alongside Telegram. Include live FX rates for USD→INR conversion using an API node. Connect Google Sheets as a backup ledger or export target. Add error-handling branches to mark Gmail messages as processed or label them “Logged to Notion”.

This enterprise-grade n8n workflow automates the Pharmaceutical Raw Material COA Verification & Vendor Quality Scoring System — from upload to final reporting — using AI-powered document extraction, specification matching, and dynamic vendor scoring. It processes Certificates of Analysis (COAs) to validate compliance, assign quality scores, generate approvals or CAPA requests, and notify stakeholders, ensuring regulatory adherence and vendor accountability with full audit trails and zero manual data entry. Key Features Webhook-triggered COA Upload** for seamless integration with file-sharing systems AI Document Extraction** to parse test results and data from uploaded COAs Automated Specification Analysis** matching against predefined quality standards Weighted Vendor Scoring** based on compliance metrics and historical performance Compliance Decision Engine** with approve/reject branching and CAPA flagging Dynamic Certificate Generation** for approved materials, including digital signatures Vendor Database Synchronization** to update scores and records in real-time Targeted Email Notifications** for QA, production, and executive teams Executive Reporting Dashboard** with summaries, scores, and verification logs Audit-Ready Logging** for all steps, deviations, and decisions Workflow Process | Step | Node | Description | | ---- | ----------------------------------- | -------------------------------------------------------- | | 1 | START: Upload COA | Webhook trigger receives uploaded COA file for verification process | | 2 | EXTRACT: Parse COA | Extracts test results and data from the COA document using AI parsing | | 3 | ANALYZE: Vendor Compliance | Compares extracted data against specifications and flags deviations | | 4 | SCORE: Vendor Quality Rating | Calculates weighted compliance score based on test results and history | | 5 | DECISION: Compliance Route | Evaluates score/status: Branches to approve (green) or reject (red) path | | 6 | APPROVED: Generate Approval Cert (Approved Path) | Creates digital approval certificate for compliant materials | | 7 | Update Vendor Database | Saves verification record, score, and status to vendor database | | 8 | NOTIFY: Email Alert | Sends detailed notifications to QA/production teams | | 9 | REPORT: Final Report | Generates executive summary with COA scores and verifications | | 10 | REJECT: Generate Rejection Report (Reject Path) | Produces rejection report with deviation details | | 11 | Request CAPA | Initiates Corrective and Preventive Action (CAPA) process | | 12 | PATH REJECTED | Terminates rejected branch with audit log entry | Setup Instructions 1. Import Workflow Open n8n → Workflows → Import from Clipboard Paste the JSON workflow 2. Configure Credentials | Integration | Details | | ----------------- | -------------------------------------------------- | | File Storage (e.g., Google Drive/AWS S3) | API key or OAuth for COA upload handling | | AI Extraction (e.g., Claude or OCR Tool) | API key for document parsing (e.g., claude-3-5-sonnet-20241022) | | Database (e.g., PostgreSQL/Airtable) | Connection string for vendor records and specs | | Email (SMTP/Gmail) | SMTP credentials or OAuth for notifications | 3. Update Database/Sheet IDs Ensure your database or Google Sheets include: VendorDatabase for scores and history Specifications for quality standards 4. Set Triggers Webhook:** /coa-verification (for real-time file uploads) Manual/Scheduled:** For batch processing if needed 5. Run a Test Use manual execution to confirm: COA extraction and analysis Score calculation and branching Email notifications and report generation (use sample COA file) Database/Sheets Structure VendorDatabase | vendorId | coaId | score | complianceStatus | lastVerified | deviations | capaRequested | |--------------|-------------|----------|--------------------|--------------------|--------|--------------------|---------------| | VEND-123456 | COA-789012 | 92.5 | Approved | 2025-11-04T14:30:00Z | None | No | Specifications | materialType | testParam | specMin | specMax | weight | |--------------|-------------|----------|--------------------|--------------------|--------|--------------------|---------------|----------| | API Excipient | Purity (%) | 98.0 | 102.0 | 0.4 | System Requirements | Requirement | Version/Access | | --------------------- | ---------------------------------------------- | | n8n | v1.50+ (AI and database integrations supported) | | AI Parsing API | claude-3-5-sonnet-20241022 or equivalent OCR | | Database API | SQL connection or Google Sheets API | | Email API | https://www.googleapis.com/auth/gmail or SMTP | | File Storage | AWS S3 or Google Drive API access | Optional Enhancements Integrate ERP Systems (e.g., SAP) for direct material release Add Regulatory Export to PDF/CSV for FDA audits Implement Historical Trend Analysis for vendor performance dashboards Use Multi-Language Support for global COA extraction Connect Slack/Teams for real-time alerts beyond email Enable Batch Processing for high-volume uploads Add AI Anomaly Detection for predictive non-compliance flagging Build Custom Scoring Models via integrated ML tools Result: A fully automated quality assurance pipeline that verifies COAs, scores vendors, and drives compliance decisions — ensuring pharmaceutical safety and efficiency with AI precision and complete traceability. Explore More AI Workflows: Get in touch with us for custom n8n automation!

Who is this for? This workflow is ideal for freelancers, accountants, and finance teams who receive invoices in Gmail and want to automate their tracking process with AI. If your inbox fills up with invoice-related messages and you want to automate how they’re handled, this AI-powered solution is for you. What does it solve? Automatically detects and processes invoices from your Gmail inbox. Uses OpenAI GPT-4o to extract payment amount, due date, subject line, and sender details. Sends real-time Slack notifications so you never miss a payment. Eliminates manual sorting of invoice-related emails. Great for improving productivity and ensuring timely payment tracking. How it works Every hour, the workflow checks for unread emails in your Gmail inbox. It sends the email content to OpenAI to determine if it's invoice-related email. If it is: It extracts key fields like due date, amount due, subject, and sender. Then sends a Slack message with these details. If it's not invoice-related, it simply ignores the email. How to setup? Connect these accounts: Gmail using OAuth2 Slack using OAuth2 OpenAI (API Key under credentials) Customize the Slack message (optional): In the Slack node, you can modify the text to show more fields or personalize the formatting. Adjust the schedule: By default, the workflow runs hourly. You can change the frequency in the Schedule Trigger node. Modify the AI logic (optional): Update the AI Agent prompt to detect additional types like receipts or payment confirmations. How to customize this workflow to your needs Notify a Slack channel instead of a user:** Just switch the recipient in the Slack node. Add labels in Gmail:** Add nodes to label or archive invoice emails once detected. Expand detection:** Modify the AI prompt to detect other financial or transactional emails.

Generate and send personalized lead emails from Google Sheets via OpenAI to Gmail with Slack alerts Description This template triggers when a new row appears in Google Sheets (from any intake form that writes to the sheet). It validates key fields, performs light deduplication by email or phone, and sends the data to OpenAI to generate a concise, brand-safe first-touch email. At the same time, the model classifies each lead as High, Medium, or Low based on your criteria for budget, services, and timeline. The email is sent immediately from your connected Gmail (or SMTP) account. The sales team is notified in Slack with the lead’s name, contact details, services of interest, budget, and a deep link to the exact Google Sheets row. The Google Sheet is then updated with send status, lead type, and a timestamp for easy tracking. Setup: Connect Google Sheets (read/write), Gmail/SMTP, Slack (webhook or app), and an OpenAI API key. Provide brief classifier rules and a short tone guide with one clear CTA (reply or booking link). Include a one-line opt-out in the email body to stay compliant. Expected headers are: Timestamp, Name, Email Address, Phone Number, Services Interested In, Budget Range, Preferred Contact Time, Project Timeline, and Additional Comments. The trigger checks the sheet every minute and processes after-hours submissions right away. You can extend the flow with calendar booking links, territory routing, or rate limits as needed.

Title: Gracewell Automated Registration Tracker Suite version: 1.0 tags: [education, automation, google-sheets, gmail, dashboard, form-tracking, workflow-suite] category: Academic Automation Description: Automate the real-time tracking of Google Form submissions using Google Sheets and n8n. This 3-workflow suite includes a live dashboard with submission statistics and two companion workflows To send acknowledgement and reminder emails to students — all seamlessly connected through n8n webhooks. 🚀 Gracewell Automated Registration Tracker Suite A fully automated, real-time monitoring system for student form submissions — built with Google Sheets, Gmail, and n8n. The suite provides a live dashboard, auto-generated summary analytics, and instant messaging (email or WhatsApp) capabilities. 🧩 Workflow Suite Overview | Workflow | Purpose | Webhook | Output | |-----------|----------|----------|----------| | 1️⃣ Live Dashboard | Displays summary of submissions and includes trigger buttons | /live-tracking | HTML Dashboard | | 2️⃣ Send Acknowledgements | Sends thank-you emails to completed respondents | /send-acknowledgements | HTML Confirmation Page | | 3️⃣ Send Reminders | Sends personalized reminders to pending students | /send-reminders | HTML Confirmation Page | 🧠 Who Is This For Educators managing student registration or feedback Department coordinators tracking submission completion EdTech and training institutions handling digital enrolments Universities automating exam registration or attendance forms ⚙️ Problem It Solves Manual form tracking is slow, repetitive, and prone to error. This workflow suite provides: ✅ Automated reconciliation of student vs. response data ✅ Instant calculation of pending and completed submissions ✅ One-click acknowledgement and reminder dispatch ✅ Web-based dashboard with summary visualization 📊 Workflow 1: Live Tracking Dashboard Steps Google Sheets – Student List → Reads master student sheet Google Sheets – Form Responses → Reads live form entries Code Node → Compares Register Nos. and generates HTML dashboard Respond to Webhook → Displays HTML with summary and control buttons Output A clean web dashboard showing: Total, Submitted, Pending, Completion % ✅ Completed list and ⚠️ Pending list Two buttons: Send Acknowledgements Send Reminders 💌 Workflow 2: Send Acknowledgements Steps Webhook Trigger → /send-acknowledgements Google Sheets – Student List & Form Responses Merge Node → Combines matching rows Code Node → Generates personalized thank-you emails Gmail Node → Sends messages Respond Node → Displays confirmation message Email Template > Subject: ✅ Thank You for Your Submission > Body: > Dear {{name}}, > Thank you for completing your form (Reg No: {{reg}}). > We appreciate your prompt response. > – Gracewell ⚠️ Workflow 3: Send Reminders Steps Webhook Trigger → /send-reminders Google Sheets – Student List & Form Responses Merge Node → Aligns both data sets Code Node → Identifies pending students Gmail Node → Sends customized reminder Respond Node → Confirms completion Email Template > Subject: ⚠️ Reminder: Please Complete Your Form > Body: > Dear {{name}}, > You haven’t yet completed your form (Reg No: {{reg}}). > Please complete it at the earliest. > – Gracewell 🛠️ Setup Instructions Step 1 – Connect Accounts Connect Google Sheets (OAuth2) Connect Gmail for sending messages Step 2 – Prepare Sheets Student List Sheet:** Columns → Register No., Student Name, Contact, Email Form Response Sheet:** Columns → Timestamp, Reg No, Email Address Step 3 – Deploy URLs | Workflow | Webhook Endpoint | |-----------|------------------| | Dashboard | /live-tracking | | Acknowledgements | /send-acknowledgements | | Reminders | /send-reminders | 🎨 Optional Customizations Add institution name/logo to dashboard HTML Include charts (Chart.js) for submission visualization Auto-refresh every 60 seconds Integrate WhatsApp messaging via Twilio or Gupshup Log emails into a “Mail Logs” sheet 🧩 Version Summary | Workflow | Version | Description | |-----------|----------|-------------| | Live Dashboard | v3 | Interactive HTML dashboard with controls | | Send Acknowledgements | v1 | Personalized thank-you email sender | | Send Reminders | v1 | Automated reminder email sender | Need help customizing? ✉️ Contact Me 💼 LinkedIn ✨ Credits Developed by Dr. J. Jeffin Gracewell Empowering education through intelligent automation 💡 We are open for and Customizing development

This workflow automates the entire Calendly onboarding and offboarding process for company users. It relies on form submissions, Google Sheets as a source of truth, AI-generated HR emails, man-in-the-loop approval steps, and direct API interactions with Calendly. Key Advantages ✅ Full Automation of Routine HR Processes The workflow removes the need for HR to manually add or remove Calendly users. It handles data collection, checks eligibility, interacts with Calendly’s API, and updates records automatically. ✅ Centralized Data Management All onboarding/offboarding data is stored and maintained in a Google Sheet, ensuring a single source of truth for user status and activity tracking. ✅ Built-in Human Validation (Man-in-the-Loop) HR receives automated approval emails and must validate each action before a Calendly account is created or removed. This ensures: security accuracy compliance with internal policies ✅ AI-Generated Professional Communication OpenAI generates polished, consistent HTML emails for HR, improving communication quality and reducing manual writing time. ✅ Clean Separation of Onboarding and Offboarding Paths Both processes are independent but structured similarly, making maintenance easier and ensuring consistent logic. ✅ Direct Integration with Calendly’s API The workflow automatically: creates invitations retrieves organization membership deletes users This eliminates manual operations inside Calendly, greatly reducing administrative workload. ✅ Error Reduction & Traceability Since every action is logged in the Google Sheet, HR can easily track: when onboarding/offboarding occurred whether approval was given if Calendly access is active ✅ Improved User Experience The final screens (“Onboarding complete”, “Offboarding complete”, “Not approved”) provide immediate feedback to the requester. The workflow contains two parallel automation paths: 1. Onboarding Workflow How it works User submits the Onboarding Form The form collects first name, last name, and email. User is appended to the Google Sheet A new record is added with date, name, email, and a placeholder for the Calendly status. AI-generated email is prepared OpenAI generates a full HTML email notifying HR about the onboarding request. HR receives an approval request via email Using Gmail’s “send and wait” feature, HR must approve or reject onboarding. If approved: The system calls Calendly’s API to invite the user to the organization. The Google Sheet record is updated (CALENDLY = on). The process ends with a confirmation page. If rejected: The workflow ends with a “Not approved” page. 2. Offboarding Workflow How it works User submits the Offboarding Form Only the email is required. The system checks the Google Sheet It verifies if the email exists and if the user currently has Calendly access. If the user exists, the workflow: Uses AI to generate a professional offboarding request email. Sends an approval prompt to HR. If HR approves: The workflow retrieves the user’s Calendly membership via API. Deletes the user from the Calendly organization. Updates Google Sheets (CALENDLY = off). Ends with a confirmation page. If approval is denied: The workflow ends with a “Not approved” screen. Here's a description of the Calendly Onboarding and Offboarding workflow for n8n: How It Works This workflow automates user onboarding and offboarding processes for Calendly with human approval steps. The system operates through two parallel streams: Onboarding Process: Users submit their information (first name, last name, email) through an onboarding form Data is automatically recorded in a Google Sheets spreadsheet An AI agent generates a professional HTML email notification for HR The email is sent to HR with a double-approval mechanism requiring manual confirmation If approved, the system automatically adds the user to Calendly organization via API The spreadsheet is updated to mark the user as "on" for Calendly access User receives a completion confirmation Offboarding Process: Users submit their email through an offboarding form The system checks Google Sheets to verify the user exists and has Calendly access An AI agent generates an offboarding notification email for HR approval After HR double-approval, the system retrieves the user's Calendly membership via API The user is automatically removed from Calendly organization The spreadsheet is updated to mark Calendly access as "off" User receives offboarding completion confirmation Set Up Steps Prerequisites: Google Sheets spreadsheet with columns: DATE, FIRST NAME, LAST NAME, EMAIL, CALENDLY Calendly organization ID and API access Gmail account for sending approval emails OpenAI API access for email generation Configuration Steps: Google Sheets Setup: Create a spreadsheet with the required column structure Configure Google Sheets OAuth credentials in n8n Update the document ID in all Google Sheets nodes Calendly API Configuration: Replace "XXX" placeholders in HTTP Request nodes with actual Calendly API bearer tokens Set the correct Calendly organization ID in the Set nodes Verify API endpoints match your Calendly organization structure Email System Setup: Configure Gmail OAuth credentials for sending approval emails Update recipient email address from "info@n3w.it" to your HR department's email Adjust approval timeout settings as needed (currently 45 minutes) Form Configuration: Deploy both onboarding and offboarding forms Test form submissions to ensure data flows correctly Customize completion messages for both success and rejection scenarios AI Email Generation: Verify OpenAI API credentials are properly configured Test email template generation for both onboarding and offboarding scenarios Adjust system prompts if different email formatting is required Workflow Activation: Test both onboarding and offboarding flows end-to-end Verify approval emails are received and functional Confirm Google Sheets updates correctly Activate the workflow once testing is complete Need help customizing? Contact me for consulting and support or add me on Linkedin.

📊 Google Sheets Leads → 🎲 Random Templates → ✉️ Personalized Emails → 📝 Status Tracking What this workflow does 📊 Reads leads list from Google Sheets (Name, Email, Send Status) 🔍 Filters out already-contacted leads (skips "SENT" status) 🎲 Randomly selects email template from template library ✏️ Personalizes subject and body with lead's name 📧 Sends emails one-by-one with delays between sends ✅ Updates Google Sheet with send status and timestamp 🔁 Loops through all unsent leads automatically Why it's useful ⚡ Automate cold outreach without manual copy-paste 🎯 Avoid duplicate sends—tracks who's been contacted 📝 Rotate email templates for A/B testing and variety 👤 Personalization makes emails feel human, not spammy ⏱️ Built-in delays prevent spam flags and rate limits 📊 Full audit trail of who received what and when How it works 📊 Google Sheets (Leads) → reads Name, Email, Send Status 🚦 IF Node → filters leads where Send Status ≠ "SENT" 🔄 Loop Over Items → processes leads one-by-one 📧 Google Sheets (Templates) → fetches Subject + Body templates 🎲 Code Node → picks random template 🔀 Merge → combines lead data with template ✏️ Edit Fields → replaces [Name] with actual lead name 📨 Send Email → delivers personalized message ⏳ Wait → adds delay between sends (avoids spam flags) ✅ Google Sheets (Update) → marks as "SENT" with timestamp What you'll need 📊 Google Sheet #1: Leads (columns: Name, Email, Send Status, Time) 📧 Google Sheet #2: Templates (columns: Subject, Body) 📬 SMTP credentials (SendGrid, Mailgun, etc.) 🔐 Google Sheets OAuth Setup steps 📊 Create "Leads" sheet with columns: Name | Email | Send Status | Time 📧 Create "Templates" sheet with columns: Subject | Body (use [Name] placeholder) 🔗 Connect Google Sheets OAuth credentials 📬 Add SMTP email credentials 🧭 Update both Google Sheets node IDs to point to your sheets ⚙️ Set "From Email" in Send Email node 🧪 Test with 2-3 test leads first Customization ideas ⏱️ Adjust Wait time (30s-5min) to control send rate 📊 Add click tracking with UTM parameters 🔔 Send Slack/Telegram notification when campaign completes 🎯 Add lead scoring—prioritize high-value leads first 📈 Log opens/replies to separate tracking sheet Who it's for 🧑‍💻 Freelancers doing cold outreach to agencies 📈 Sales teams running lead generation campaigns 🚀 Startups reaching out to potential customers 🎯 Marketers testing email copy variations 💼 Business developers nurturing prospect lists Quick Setup Guide Before You Start - What You Need: 📊 Google account for Sheets access 📧 SMTP email account (Gmail, custom domain, or email service) 📝 List of leads (names + emails) ✉️ Email templates ready (with [Name] placeholders) Want help customizing? 📧 anirpoke@gmail.com 🔗 LinkedIn

This n8n template demonstrates how to create an automated construction progress notification system for real estate companies. The workflow triggers daily at 8:00 AM IST to check a Google Sheet for contractor construction reports, automatically processes the data, and sends comprehensive project updates to buyers via email and WhatsApp. Perfect for real estate developers wanting to maintain transparent communication with buyers and ensure timely project status updates. Good to know Daily automated monitoring ensures no construction updates are missed Multi-channel communication (Email + WhatsApp) reaches buyers through their preferred method Smart filtering system only processes today's reports for relevant updates Comprehensive logging tracks all notification activities for audit purposes Built-in alert system notifies administrators when contractors fail to submit reports Handles multiple projects and contractors simultaneously without data conflicts How it works Daily Monitoring Workflow System triggers automatically every day at 8:00 AM IST to check for new construction reports Google Sheet configuration is set with Sheet ID, sheet name, and today's date for filtering All construction data is read from the designated Google Sheet containing contractor submissions Advanced filtering isolates only today's reports based on the Date column for processing Report Processing Workflow System checks if any construction reports were submitted for the current date If reports are found: Detailed notifications are prepared and sent to all registered buyers If no reports are found: Alert notifications are sent to administrators about missing submissions All project data is compiled into comprehensive summaries with progress percentages and status updates Notification Distribution Workflow Email notifications contain detailed construction summaries with all project information WhatsApp messages provide concise updates with key progress indicators and status Messages are personalized with project names, completion percentages, and contractor details Multiple recipients receive notifications simultaneously through both communication channels Activity Logging Workflow All notification activities are logged with precise timestamps and recipient information Success logs record project count, recipient numbers, and delivery confirmation Warning logs capture instances when no reports are found for administrative follow-up Complete audit trail maintains compliance and tracking for project management Google Sheet Structure Construction Reports Sheet Date - Report submission date (DD/MM/YYYY format) Project_Name - Name of the construction project Contractor_Name - Name of the responsible contractor Location - Project location or site address Progress_Percentage - Current completion percentage (0-100%) Status - Current project status (On Track, Delayed, Completed, etc.) Work_Description - Detailed description of today's construction activities Issues - Any problems or challenges encountered (optional) Budget_Status - Financial status update (On Budget, Over Budget, Under Budget) Next_Milestone - Upcoming project milestone or target date How to use Import the workflow into your n8n instance and configure Google Sheets integration Set up your Google Sheet with the required column structure for construction reports Configure email SMTP settings for professional construction update delivery Set up WhatsApp Business API for instant mobile notifications to buyers Add buyer email addresses and WhatsApp numbers to the notification recipient lists Contractors submit daily reports to the Google Sheet before 8:00 AM for same-day processing System automatically processes and distributes updates to all registered buyers Monitor logs for delivery confirmation and missing report alerts Requirements Google Sheets account for construction report data storage and management Email service integration (Gmail, SMTP, or corporate email system) WhatsApp Business API account for mobile messaging capabilities n8n instance with Google Sheets, Email, and WhatsApp connectors properly configured Valid credentials for all integrated services (Google OAuth, SMTP, WhatsApp API) Customising this workflow Construction update automation can be adapted for different project types and development scales Try popular use-cases such as weekly progress summaries, milestone notifications, or emergency construction alerts The workflow can be extended to include photo attachments from construction sites, weather impact assessments, and safety compliance reporting Integration possibilities include CRM systems for buyer management, project management tools for contractor coordination, and financial systems for budget tracking Notification scheduling can be adjusted for different time zones, multiple daily updates, or project-specific timing requirements Advanced features can include buyer feedback collection, contractor performance ratings, and automated delay notifications with mitigation plans

How it works Checks if a website is up, sends the HTTP result to an AI model (ChatGPT) for analysis, and emails a clear success or failure message. Great for a quick “is this site up?” check you can trigger from any system via HTTP. Webhook — Receives a POST with the target URL. HTTP Request — Attempts to fetch the URL. Message a model — Uses ChatGPT to explain the status and cause of any error. IF — Checks if the HTTP status code equals 200. Gmail Success — Sends a success email with AI explanation. Gmail Error — Sends an error email with AI explanation and next steps. Set up steps Estimated setup: 5–10 minutes. Beginner friendly — no advanced config required. Add your Webhook URL where needed and connect your Gmail account. Keep detailed instructions and configuration notes inside Sticky Notes in your workflow. Inputs Send a POST request to your Webhook with: { "url": "https://example.com" }

Extract PDF Itineraries to Google Sheets with GPT-4.1-Mini & Gmail Notifications Overview Automates PDF data extraction using OpenAI GPT, saves to Google Sheets, sends email confirmations. Reduces manual entry by 90%. How It Works Receives PDF uploads via form Splits & loops through files AI extracts structured data Appends to Sheets with timestamps Sends confirmation email Prerequisites OpenAI API key (platform.openai.com) Google Workspace (Sheets & Gmail) n8n v1.0.0+ Setup Add OpenAI API key to n8n credentials Create Google Sheet with extraction columns, authorize OAuth2 Configure Gmail OAuth2 Import workflow JSON Edit AI prompt for your fields Activate & share form URL Customization Modify extraction prompts Adjust Sheets mapping Customize email templates Add error handling/validation Extend to Word/Excel files Use Cases Invoices, expense reports, resumes, contracts, forms, legal docs

Automated Support Ticket & Customer Notification System Let's build this workflow to streamline your customer support. Here is a detailed, node-by-node explanation of how it works and how to set it up in n8n. How It Works This workflow transforms your support inbox into a structured ticket system. When a new email arrives at your support address, the system automatically creates a new ticket (e.g., a Trello card), sends an instant confirmation email to the customer, and notifies your support team. This ensures every customer inquiry is captured, organized, and confirmed, guaranteeing no request gets missed. Setup Steps 1. Gmail Trigger: Watch Support Inbox Node Type:** Gmail Trigger Credentials:** YOUR_GMAIL_CREDENTIAL Parameters:** Operation: Watch for New Mails Folder: Inbox (or a specific folder for support emails, like Support) To: your-support-email@example.com Explanation:** This node is the starting point. It connects to your support email address and listens for new messages. As soon as a new email arrives, it triggers the rest of the workflow. 2. Trello: Create New Support Ticket Node Type:** Trello Credentials:** YOUR_TRELLO_CREDENTIAL Parameters:** Operation: Create Card Board ID: YOUR_SUPPORT_BOARD_ID List ID: YOUR_INCOMING_LIST_ID (e.g., "New Tickets") Name: New Support Request from {{ $json.from }} Description: Subject: {{ $json.subject }} Body: {{ $json.body }} Explanation:** This node takes the details from the incoming email and creates a new card on your Trello board. This turns every email into an actionable, trackable ticket for your support team. 3. Gmail: Send Automatic Confirmation Node Type:** Gmail Credentials:** YOUR_GMAIL_CREDENTIAL Parameters:** Operation: Send To: ={{ $json.from }} Subject: Re: {{ $json.subject }} Body: Hi there, thanks for reaching out. We've received your request and have created a new ticket. Our team will get back to you shortly. Explanation:** This node sends a quick, professional, and automated email back to the customer. This provides immediate peace of mind for the customer and confirms that their inquiry was successfully received. 4. Slack: Notify Support Team (Optional) Node Type:** Slack Credentials:** YOUR_SLACK_CREDENTIAL Parameters:** Operation: Post Message Channel: YOUR_SUPPORT_CHANNEL_ID (e.g., #support-channel) Text: New Support Ticket! A new ticket from {{ $json.from }} has been created in Trello. Explanation:** This optional but recommended node sends a real-time notification to your support team on Slack, letting them know that a new ticket is waiting for their attention. Final Step: Activation After configuring the nodes and connecting all credentials, click "Save" at the top of the canvas. Click the "Active" toggle in the top-right corner. The workflow is now live! Note: You can easily swap out the Trello node with a Zendesk or Jira node, and the Slack node with a Telegram or Microsoft Teams node, depending on your team's tools.