Workflow Templates

How it works When a meeting ends in Fireflies, the transcript is automatically retrieved and sent to OpenAI for analysis. The AI evaluates objection handling, call effectiveness, and extracts key objections raised during the conversation. It then generates specific objection handlers for future calls. The analysis is formatted into a structured report and sent to both Slack for immediate visibility and Google Drive for centralized storage. Set up steps Prerequisites: Fireflies account with API access OpenAI API key Slack workspace Google Drive connected to n8n Configuration: Connect Fireflies webhook to trigger on meeting completion Add OpenAI API key in the AI analysis nodes Configure Slack channel destination for feedback delivery Set Google Drive folder path for report storage Adjust AI prompts in sticky notes to match your objection categories and sales methodology

🤖 Automated SEO Audit with a Team of AI Specialists This workflow performs a comprehensive, automated monthly SEO and performance audit for any website. It uses a "team" of specialized AI agents to analyze data from multiple sources, aggregates their findings, and generates a final strategic report. Every month, it automatically fetches data from Google Analytics, Google Search Console, and Google PageSpeed Insights, and also performs a live crawl of the target website's homepage. Key Features Fully Automated**: Runs on a schedule to deliver monthly reports without manual intervention. Multi-Source Analysis**: Gathers data from four key marketing sources for a 360° view. AI Agent Team**: Uses a sophisticated multi-agent system where each AI specializes in one area (Analytics, Performance, Technical SEO). Master Analyst**: A final AI agent synthesizes all specialist reports into a single, actionable strategic plan. Automated Storage**: All individual and final reports are automatically saved to a designated Google Sheet. ⚙️ Setup Instructions To use this template, you must configure your credentials and set your target website. 1. Set Your Target Domain (Crucial!): Find the Set Target Website node at the beginning of the workflow. In the "Value" field, replace https://www.your-website.com with the URL of the website you want to audit. This will update the URL across the entire workflow automatically. 2. Configure the Schedule Trigger: Click on the Schedule Trigger node to set when you want the monthly report to run. 3. Connect Your Google Credentials: Google Analytics**: Select your credential in the Get a report node. Google Search Console**: Select your credential in the Search Console (HTTP Request) node. Google Sheets*: Select your credential in *all Google Sheets nodes. Google PageSpeed API Key**: Go to the "Credentials" tab in n8n and create a new "Generic Credential" with the type "API Key - Query Param". Name it Google API Key. The "Parameter Name" must be key. Paste your PageSpeed API key into the "API Key" field. Go back to the PageSpeed Insight node, select "API Key - Query Param" for Authentication, and choose your new credential. 4. Connect OpenAI Credentials: This template uses multiple OpenAI Chat Model nodes. Configure each one with your OpenAI API key. 5. Set Your Google Sheet: In each of the Google Sheets nodes, replace the hardcoded "Document ID" with the ID of your own Google Sheet where you want to store the reports. 🔬 Workflow Explained Phase 1: Data Collection: The Schedule Trigger starts the workflow. Four parallel branches collect data from Google Analytics, PageSpeed Insights, Search Console, and a direct website crawl. Phase 2: Data Processing & Specialist Analysis: Each data source is processed by a dedicated Code node to format the data. The formatted data is then sent to a specialized AI agent (ANALYTICS SPECIALIST, PERFORMANCE SPECIALIST, etc.) for in-depth analysis. Phase 3: Report Aggregation: A Merge node waits for all four specialist reports to be completed. A DATA AGGREGATOR node then combines them into a single, comprehensive package. Phase 4: Master Synthesis & Storage: The final MASTER ANALYST agent receives the aggregated data and produces a high-level strategic summary with actionable recommendations. This final report is then saved to Google Sheets.

Access live KuCoin Spot Market data instantly in Telegram! This workflow integrates the KuCoin REST API with Telegram and an optional GPT-4.1-mini formatter, delivering real-time insights like latest prices, 24h stats, order book depth, trades, and candlesticks — all structured into clean Telegram messages. 🔎 How It Works A Telegram Trigger listens for user commands. User Authentication validates the Telegram ID against an allowlist. A SessionId is generated from the chat ID to support memory across turns. The KuCoin AI Agent orchestrates API requests: 24h Stats → /api/v1/market/stats?symbol=BTC-USDT Order Book Depth → /api/v1/market/orderbook/level2_100?symbol=BTC-USDT Latest Price → /api/v1/market/orderbook/level1?symbol=BTC-USDT Best Bid/Ask → /api/v1/market/orderbook/level1?symbol=BTC-USDT Klines (Candles) → /api/v1/market/candles?symbol=BTC-USDT&type=15min&limit=20 Recent Trades → /api/v1/market/histories?symbol=BTC-USDT Average Price (via Ticker) → /api/v1/market/orderbook/level1?symbol=BTC-USDT Utility Tools process results: Calculator → spreads, % changes, averages. Think → reshapes JSON, selects fields, formats outputs. Message Splitter breaks outputs >4000 chars (Telegram limit). Final report is sent back via Telegram SendMessage in human-readable format. ✅ What You Can Do with This Agent Get 24h rolling statistics (open, high, low, close, last, volume). Retrieve full order book depth (20, 100 levels) or best bid/ask. Monitor real-time latest prices with spreads. Analyze candlestick data (OHLCV) across supported intervals. View recent public trades with price, size, side, and time. Use average price proxies from bid/ask + last trade. Receive structured Telegram reports — not raw JSON. 🛠️ Setup Steps Create a Telegram Bot Use @BotFather to create a bot and copy its token. Configure in n8n Import KuCoin AI Agent v1.02.json. Update User Authentication node with your Telegram ID. Add Telegram API credentials (bot token). Add OpenAI API key. (Optional) Add KuCoin API key Deploy & Test Activate the workflow in n8n. Send a query like BTC-USDT to your bot. Instantly receive structured KuCoin Spot Market insights in Telegram. 📤 Output Rules Responses grouped into Price, 24h Stats, Order Book, Klines, Trades. No raw JSON (only human-readable summaries). No financial advice or predictions. Always fetch directly from KuCoin’s official API. 📺 Setup Video Tutorial Watch the full setup guide on YouTube: If you want, I can also update embed links & thumbnails elsewhere to match this. ⚡ Unlock KuCoin Spot Market insights in Telegram — fast, reliable, and API-key free. 🧾 Licensing & Attribution © 2025 Treasurium Capital Limited Company Architecture, prompts, and trade report structure are IP-protected. No unauthorized rebranding permitted. 🔗 For support: Don Jayamaha – LinkedIn

Description  Automatically ingests new employee data, extracts relevant signals, scores attrition risk, and notifies HR/managers with structured insights and recommended actions. Built on Azure OpenAI Chat with Structured Output Parser and true/false routing for escalation. What This Template Does  Trigger for new data: Starts when a new profile, survey, or report file is added. Download & extract: Retrieves the file and converts PDFs/text into analyzable content. Analyze signals: Uses Azure OpenAI Chat to interpret sentiment, workload, performance notes, feedback, and changes (role, compensation, manager, location). Structured parsing: Maps to fields like risk_score, risk_level, key_drivers, recommended_interventions, escalation_required. Logic routing: Applies thresholds (e.g., risk_score ≥ 0.7) and flags for urgent follow-up. Email alerts: Drafts and sends tailored notifications to HR/manager with action steps. Key Signals Considered  Sentiment & language: Negative tone, burnout cues, disengagement in feedback. Activity trends: Drop in participation, delayed responses, meeting absenteeism. Performance & goals: Recent rating changes, missed OKRs, quality issues. Role & compensation: Lateral moves, pay gaps vs. market, stalled progression. Managerial context: Team churn, conflict mentions, low recognition frequency. Features  Azure OpenAI Chat: Interprets unstructured text into consistent risk fields. Structured Output Parser: Guarantees schema for downstream decisions. Conditional Logic (true/false): Threshold checks for escalation. Memory: Maintains context across multiple files per employee for trend-aware scoring. Calculate avg span: Computes tenure or recency metrics used in risk scoring. Email Composer & Sender: Generates and dispatches HR-ready alerts. Requirements  n8n instance with access to employee data sources (Drive, Inbox, HR folder). Extract From PDF configured for clean text output. Azure OpenAI credentials (e.g., GPT‑4o‑mini) connected to Chat Model. Email service (Gmail/SMTP) set in n8n Credentials. Parser schema aligned to your People Analytics fields (risk_score, drivers, actions).

AI-Powered Invoice Extraction & Automation System Workflow Aim The aim of the Invoice Data Automation workflow is to streamline invoice processing by extracting, validating, and storing invoice details automatically. It uses AI to read invoices (from images/PDFs), structures the data in JSON, checks for missing or duplicate entries, and records the information in a Google Sheet while also uploading the original invoice to Google Drive. Additionally, it sends email notifications for successful entries, duplicates, or missing fields. Goal The goal is to: Allow users to upload invoice images/files via chat. Extract invoice data using AI and format it into a structured JSON. Validate mandatory fields like invoice_id, shop_name, date, Total, and items. Check if the invoice already exists in the Google Sheet. Append new invoices to Google Sheets and upload the original file to Google Drive. Notify the user via email about success, duplicates, or errors. This ensures that invoices are processed accurately, efficiently, and securely with minimal manual effort. Requirements The workflow relies on specific components and configurations: n8n Platform The automation is built and hosted on n8n, which orchestrates the entire workflow. Node Requirements When chat message received – Triggers the workflow when a user submits an invoice. Analyze image1 – Uses Google Gemini Vision AI to extract invoice data from the uploaded file. AI Agent1 + Google Gemini Chat Model1 – Restructures the extracted data into strict JSON format. Make data in JSON structure format – Prepares and organizes the structured output. Get data – Looks up the Google Sheet to check if the invoice already exists. check if Data exist or not in table – Decides whether to process as new data or duplicate. New data add using payload / Check Mandatory fields – Ensures invoice JSON is valid and complete. If – check missing field – Branches based on whether mandatory fields are present. no missing field – new data add using payload 2 – Passes only verified invoices forward. Append data to sheet – Saves invoice data in Google Sheets. Upload invoice to drive – Uploads the original invoice file to Google Drive. Send successful email – Notifies the user of successful entry. Duplicate entry send mail – Alerts the user if the invoice already exists. Send missing field error on mail – Sends an error email if mandatory fields are missing. Credentials Google Gemini (PaLM) API** – For AI-based invoice data extraction and formatting. Google Sheets API** – For storing structured invoice records. Google Drive API** – For uploading original invoices. Gmail API** – For sending success, duplicate, and error notifications. Input Requirements Invoice file (Image or PDF). Output Structured invoice data in Google Sheets. Original invoice stored in Google Drive. Notifications sent via Gmail (success, duplicate, or error). API Usage Google Gemini (PaLM API):** Used in Analyze image1 and AI Agent1 to extract and structure invoice data. It ensures fields like invoice_id, shop_name, date, and items are clearly formatted. Google Sheets API:** Used in Get data and Append data to sheet nodes to validate duplicates and store new invoices. Google Drive API:** Used in Upload invoice to drive to securely store the original uploaded invoice file. Gmail API:** Used in Send successful email, Duplicate entry send mail, Send missing field error on mail to notify users about the status of invoice processing. Workflow Summary The Invoice Data Automation workflow automates the entire process of invoice handling by: Receiving invoice uploads via chat. Extracting invoice details with AI (Google Gemini). Structuring and validating the data in JSON format. Checking Google Sheets for duplicates. Appending new invoices to the sheet and uploading originals to Google Drive. Sending email notifications to keep the user updated on the process outcome. This end-to-end automation ensures invoices are handled with speed, accuracy, and transparency, reducing manual work and eliminating common errors in invoice management.

Automated Email Verification & Digital Health Card Generator Overview Transform your clinic's patient check-in process with this fully automated pre-registration system. When patients submit their appointment information through your website, this workflow instantly verifies their email, generates a professional digital health card with a scannable QR code, stores it securely in Google Drive, and sends personalized notifications to both the patient and your reception team—all in under 20 seconds. What This Workflow Does This comprehensive automation handles the entire patient pre-check-in journey: Receives Patient Data - Webhook captures form submissions from your website or app with patient details (name, email, phone, appointment date/time, symptoms, age, gender) Validates & Cleans Data - Automatically validates required fields, cleans input data, and generates a unique patient ID with timestamp for tracking Verifies Email Address - Uses VerifiEmail API to ensure email deliverability by checking RFC compliance, MX records, and filtering out disposable/spoof emails Generates QR Code - Creates a unique verification URL and scannable QR code for instant patient identification at reception Builds Professional Health Card - Generates a beautiful, responsive HTML health card featuring: Patient information grid (name, ID, email, phone, age/gender, appointment) Chief complaints/symptoms section Embedded QR code for quick check-in Important appointment instructions Modern gradient design with mobile-responsive layout Converts to PNG Image - Uses HTMLCSSToImg API to convert the HTML card into a high-quality PNG image (900x1200px) Stores in Google Drive - Uploads the health card to an organized "Patients record" folder with patient ID-based naming for easy retrieval Emails Patient - Sends a beautifully formatted email to the patient containing: Their health card as a PNG attachment Appointment details and confirmation Google Drive link for backup access Check-in instructions and preparation tips Notifies Reception Team - Sends real-time Slack message to clinic reception with patient details, verification status, and Drive link Logs to Database - Records complete patient information, timestamps, verification status, and file links in Google Sheets for tracking and analytics Returns Success Response - Sends JSON response back to the website form with patient ID, confirmation, and Drive link Key Features ✅ Email Verification - VerifiEmail API integration prevents failed deliveries and fake emails ✅ Unique Patient IDs - Timestamp-based IDs ensure no duplicates (format: PAT-{timestamp}-{random}) ✅ QR Code Generation - Free QR Server API creates scannable codes for instant check-in ✅ Professional Design - Modern, gradient-styled health cards with responsive layout ✅ Multi-format Output - PNG image format for easy viewing on any device ✅ Cloud Storage - Secure Google Drive storage with organized folder structure ✅ Multi-channel Notifications - Email to patient + Slack to staff for complete coverage ✅ Comprehensive Logging - Google Sheets database for analytics and record-keeping ✅ Error Handling - Graceful failure for invalid emails with user notification ✅ Webhook Response - Real-time feedback to website form for seamless UX ✅ Indian Locale Support - Date/time formatting in Indian format with 12-hour time ✅ Mobile Responsive - Health cards look great on both desktop and mobile devices Perfect For 🏥 Medical Clinics & Healthcare Providers - Streamline patient pre-registration and reduce waiting times 🦷 Dental Practices - Digital check-in for appointments with patient history 💉 Diagnostic Centers - Pre-appointment verification for lab tests and scans 👨‍⚕️ Specialist Doctors - Organized patient records with symptoms documentation 🏃 Physiotherapy Clinics - Track patient visits and treatment history 💆 Wellness Centers & Spas - Appointment management with customer details 🐕 Veterinary Clinics - Pet owner pre-registration system 📋 Any Appointment-Based Business - Adaptable to salons, consultancies, or service providers Business Benefits 💰 Reduced No-Shows - Email verification ensures valid contact information ⏱️ Time Savings - Eliminates manual data entry at reception 📊 Better Analytics - Automated logging provides insights into patient flow ✨ Professional Image - Modern, branded health cards improve patient experience 🔒 Secure Records - Cloud storage with organized folder structure 📱 Contactless Check-in - QR codes enable touch-free reception process 🎯 Improved Communication - Multi-channel notifications keep everyone informed 🚀 Scalable System - Handles high volumes without additional staff Required Services & Credentials VerifiEmail API - Email verification service Sign up at: https://verifi.email HTMLCSSToImg API - HTML to image conversion Sign up at: https://htmlcsstoimg.com Google Drive - Cloud file storage Requires: Google Account with Drive access Gmail - Email delivery Requires: Google Account Slack - Team notifications Requires: Slack workspace Google Sheets - Database logging Requires: Google Account Customization Options Change Health Card Design: Edit the "Build Health Card HTML" node Modify CSS styles, colors, layout, fonts Add clinic logo by including `` tag in header Adjust Email Template: Edit the "Email Health Card to Patient" node Customize subject line, message content, styling Add clinic branding and contact information Modify Slack Message: Edit the "Notify Reception Team" node Change message format, add emojis, include additional fields Integrate with different channels Add PDF Generation: Insert an additional HTTP Request node after "Build Health Card HTML" Use a PDF conversion API (like PDFMunk or Puppeteer) Upload both PNG and PDF to Google Drive Add SMS Notifications: Insert Twilio or similar SMS node after email verification Send appointment confirmation via SMS Include patient ID and appointment time Multi-language Support: Modify the HTML template to support multiple languages Add language detection based on patient input Translate email and Slack messages Troubleshooting Guide Email Verification Fails: Check VerifiEmail API key is correct Verify API quota hasn't been exceeded Test with known valid email address Image Generation Fails: Check HTMLCSSToImg API credentials Verify HTML content is valid (no syntax errors) Check API rate limits Google Drive Upload Fails: Re-authenticate Google Drive OAuth2 credentials Check folder permissions Verify folder ID is correct Email Not Sending: Re-authenticate Gmail OAuth2 credentials Check email attachment size limits Verify "Less secure app access" if using password auth Slack Message Not Posting: Check Slack app permissions Verify channel exists and bot is invited Re-authenticate Slack credentials Google Sheets Not Logging: Re-authenticate Google Sheets credentials Verify sheet name and column headers match exactly Check sheet permissions Performance & Scalability Expected Performance: Single execution: 15-20 seconds Concurrent executions: Supports multiple parallel workflows API rate limits: Respects all third-party API limits Volume Handling: Small clinics: <50 patients/day - Perfect Medium practices: 50-200 patients/day - Excellent Large hospitals: 200+ patients/day - Consider API tier upgrades Security & Compliance ✅ Data Privacy - Patient data transmitted securely via HTTPS ✅ Access Control - OAuth2 authentication for all Google services ✅ Secure Storage - Files stored in private Google Drive folders ✅ Audit Trail - Complete logging in Google Sheets with timestamps ✅ Email Verification - Prevents data leakage to invalid addresses ✅ No Data Storage in n8n - Patient data passes through, not stored Tags healthcare, medical, clinic, patient-management, appointment, email-verification, qr-code, google-drive, gmail, slack, automation, workflow, pre-checkin, health-card, verifi-email, htmlcsstoimg, medical-records, patient-portal, healthcare-automation, clinic-management Category Healthcare & Medical Subcategory Patient Management & Appointment Systems License MIT License - Free to use, modify, and distribute with attribution

Automate and Distribute Weekly and Monthly Marketing Analytics Reports Who's it for? This workflow is designed for marketing teams, data analysts, and business owners who need to consistently track key performance indicators (KPIs). It saves hours of manual data collection and reporting, ensuring stakeholders receive timely updates automatically. What it does This workflow automates the entire process of creating and distributing regular analytics reports. On a recurring weekly and monthly schedule, it: Fetches Data: Gathers the latest data from Google Analytics (users, sessions, conversions), your advertising platform (ad spend), and your CRM (new customers, revenue). Calculates KPIs: Processes the raw data to calculate essential business metrics, including Monthly Active Users (MAU), Customer Acquisition Cost (CAC), Lifetime Value (LTV), LTV:CAC ratio, and conversion rates. Logs Historical Data: Appends the newly calculated KPIs to a Google Sheet, creating a historical record for trend analysis. Generates a Report: Creates a new Google Slides presentation to serve as the main report. Distributes the Report: Emails a summary of the key metrics to a predefined list of recipients, including a link to the full Google Slides report. Provides Error Alerts: If any step in the process fails, it sends an immediate notification to a designated Slack channel so you can address the issue quickly. How to set up Configure Credentials: Add your credentials for Google Analytics, Google Sheets, Google Slides, Gmail, Slack, and the HTTP Request nodes (for your ad platform and CRM). Fill in Placeholders: In the "Workflow Configuration" node, replace all placeholder values with your specific information: gaPropertyId: Your Google Analytics Property ID. adPlatformApiUrl: The API endpoint for your advertising platform. crmApiUrl: The API endpoint for your CRM. reportSpreadsheetId: The ID of the Google Sheet where data will be stored. slidesTemplateId: The ID of your Google Slides report template. reportRecipients: A comma-separated list of email addresses for report distribution. slackChannel: The Slack channel ID for error notifications. Activate Workflow: Turn the workflow on. It will now run based on the schedule defined in the "Weekly/Monthly Schedule" trigger node. How to customize the workflow Adjust Schedule:** Modify the "Weekly/Monthly Schedule" node to change the reporting frequency (e.g., daily, bi-weekly). Change Reporting Period:** In the "Workflow Configuration" node, change the reportPeriodDays value to adjust the lookback window (e.g., set to 30 for a monthly report). Customize KPIs:** Edit the Javascript in the "Calculate KPIs (MAU, LTV, CAC)" node to add or modify metrics. Enhance the Report:** Expand the "Create Google Slides Report" node to dynamically add charts and data from the calculated KPIs into the slides.

Who's it for This workflow is perfect for n8n users and teams who want to stay up-to-date with the latest n8n releases without manually checking GitHub. Get AI-powered summaries of new features and bug fixes delivered straight to your inbox. What it does This workflow automatically monitors the n8n GitHub releases page and sends you smart email notifications when new updates are published. It fetches release notes, filters them based on your schedule (daily, weekly, etc.), and uses OpenAI to generate concise summaries highlighting the most important bug fixes and features. The summaries are then formatted into a clean HTML email and sent via Gmail. How to set up Configure the Schedule Trigger - Set how often you want to check for updates (daily, weekly, etc.) Add OpenAI credentials - Connect your OpenAI API key or use a different LLM Add Gmail credentials - Connect your Google account Set recipient email - Update the "To" email address in the Gmail node Activate the workflow and you're done! Requirements OpenAI API account (or alternative LLM) Gmail account with n8n credentials configured How to customize Adjust the schedule trigger to match your preferred notification frequency The filtering logic automatically adapts to your schedule (24 hours for daily, 7 days for weekly, etc.) Modify the AI prompt to focus on different aspects of the release notes Customize the HTML email template to match your preferences

📧📅 Turn Daily Emails and Calendar Summaries into Slack Notifications Here’s a workflow that automates daily Slack notifications with a concise summary of unread emails (from the last 7 days) and Google Calendar events (for the current day). It integrates Gmail, Google Sheets, Google Calendar, Gemini AI, and Slack to provide a clear snapshot of your workday. 💡 How It Helps You 📥 Fetches unread emails from Gmail for the past 7 days 🗂️ Filters emails based on Name, Email, and Subject defined in Google Sheets 📅 Fetches Google Calendar events for the current day 🤖 Summarizes emails and calendar events using Gemini AI 🔗 Merges both summaries and sends them as a formatted Slack notification ⏰ Runs automatically on a scheduled cron trigger 🛠️ What’s Needed to Start 📧 Gmail account (with unread emails access) 📑 Google Sheets (with Name, Email, Subject filter list) 📅 Google Calendar 🤝 Gemini AI with credentials 💬 Slack workspace & dedicated channel for notifications ⚡ Set Up in Minutes 📑 Create a Google Sheet with columns: Name, Email, Subject 🔑 Configure Gmail, Google Sheets, Google Calendar, and Slack credentials in n8n 🤖 Add Gemini AI credentials for summarization 📝 Update the Google Sheet name and file name in the Sheet node 💬 Update Slack channel ID in the workflow ✅ Activate the workflow to receive daily notifications ✨ Stay on top of important emails and upcoming meetings without manual checking!

This automated n8n workflow distributes school notices to stakeholders (students, parents, and staff) via WhatsApp, email, and other channels. It streamlines the process of scheduling, validating, and sending notices while updating distribution status. System Architecture Notice Distribution Pipeline**: Daily Notice Check - 9 AM: Triggers the workflow daily at 9 AM via Cron. Read Notices getAll worksheet: Retrieves notice data from a spreadsheet. Validation Flow**: Validate Notice Data: Validates and formats notice data. Distribution Flow**: Process Notice Distribution: Prepares notices for multiple channels. Prepare Email Content: Generates personalized email content. Send Email Notice: Delivers emails to recipients. Prepare WhatsApp Content: Formats notices for WhatsApp. Send WhatsApp Notice: Sends notices via WhatsApp Business API. Status Update**: Update Notice Status: Updates the distribution status in the spreadsheet. Implementation Guide Import Workflow**: Import the JSON file into n8n. Configure Cron Node**: Set to trigger daily at 9 AM (e.g., 0 9 * * *). Set Up Credentials**: Configure SMTP and WhatsApp Business API credentials. Prepare Spreadsheet**: Create a Google Sheet with notice_id, recipient_name, email, phone, notice_text, distribution_date, and status columns. Test Workflow**: Run manually to verify notice distribution and status updates. Adjust Thresholds**: Modify validation rules or content formatting as needed. Technical Dependencies Cron Service**: For scheduling the workflow. Google Sheets API**: For reading and updating notice data. SMTP Service**: For email notifications (e.g., Gmail, Outlook). WhatsApp Business API**: For sending WhatsApp messages. n8n**: For workflow automation and integration. Database & Sheet Structure Notice Tracking Sheet** (e.g., Notices): Columns: notice_id, recipient_name, email, phone, notice_text, distribution_date, status Example: | notice_id | recipient_name | email | phone | notice_text | distribution_date | status | |-----------|----------------|-------------------|-------------|------------------------------|-------------------|-----------| | 001 | John Doe | john@example.com | +1234567890 | School closed tomorrow | 2025-08-07 | Pending | | 002 | Jane Smith | jane@example.com | +0987654321 | Parent-teacher meeting | 2025-08-08 | Sent | Customization Possibilities Adjust Cron Schedule**: Change to hourly or weekly as needed. Add Channels**: Integrate additional notification channels (e.g., Slack, SMS). Customize Content**: Modify email and WhatsApp message templates. Enhance Validation**: Add rules for data validation (e.g., email format). Dashboard Integration**: Connect to a dashboard tool for real-time status tracking. Notes The workflow assumes a Google Sheet as the data source. Replace spreadsheet_id and range with your actual values. Ensure WhatsApp Business API is properly set up with a verified phone number and token. Test the workflow with a small dataset to confirm delivery and status updates.

📥 Invoice Intake & Notification Workflow This automated n8n workflow monitors a Google Drive folder for newly uploaded invoice PDFs, extracts essential information (like client name, invoice number, amount, due date), logs the data into a Google Sheet for recordkeeping, and sends a formatted Telegram message to notify the billing team. For step-by-step video build of workflows like this: https://www.youtube.com/@automatewithmarc ✅ What This Workflow Does 🕵️ Watches a Google Drive folder for new invoice files 📄 Extracts data from PDF invoices using AI (LangChain Information Extractor) 📊 Appends extracted data into a structured Google Sheet 💬 Notifies the billing team via Telegram with invoice details 🤖 Optionally uses Claude Sonnet AI model to format human-friendly summaries ⚙️ How It Works – Step-by-Step Trigger: Workflow starts when a new PDF invoice is added to a specific Google Drive folder. Download & Parse: The file is downloaded and its content extracted. Data Extraction: AI-powered extractor pulls invoice details (invoice number, client, date, amount, etc.). Log to Google Sheets: All extracted data is appended to a predefined Google Sheet. AI Notification Formatting: An Anthropic Claude model formats a clear invoice notification message. Telegram Alert: The formatted summary is sent to a Telegram channel or group to alert the billing team. 🧠 AI & Tools Used Google Drive Trigger & File Download PDF Text Extraction Node LangChain Information Extractor Google Sheets Node (Append Data) Anthropic Claude (Telegram Message Formatter) Telegram Node (Send Notification) 🛠️ Setup Instructions Google Drive: Set up OAuth2 credentials and specify the folder ID to watch. Google Sheets: Link the workflow to your invoice tracking sheet. Telegram: Set up your Telegram bot and obtain the chat ID. Anthropic & OpenAI: Add your Claude/OpenAI credentials if formatting is enabled. 💡 Use Cases Automated bookkeeping and invoice tracking Real-time billing alerts for accounting teams AI-powered invoice ingestion and summary

Description This workflow transforms your quick event notes into polished LinkedIn posts. Simply send a message via Telegram with your event name and personal notes, and the system will match it with your calendar events, generate a professional LinkedIn post. And even if you don't feel like posting it on LinkedIn, it still serves you because it saves everything to your database for future reference. In this way you can build a personal library of your professional networking activities and insights! Who Is This For? Professional Networkers: Business professionals who attend events regularly and want to share insights on LinkedIn without spending time on content creation. Event Enthusiasts: Conference attendees, meetup participants, and workshop goers who want to document and share their experiences professionally. Busy Professionals: Anyone who wants to maintain an active LinkedIn presence but lacks time to craft posts from scratch after events. What Problem Does This Workflow Solve? After attending events, I struggle with several challenges: Time Constraints: Writing thoughtful LinkedIn posts takes time. Writer's Block: Difficulty transforming my raw notes and experiences into engaging social media content. Data Organization: Keeping track of event details, personal insights, and networking opportunities in one place. How It Works Telegram Input: Send a message to your Telegram bot with the format "Event Name: Your personal notes" Message Parsing: The system extracts the event name and your personal notes from the message Calendar Matching: Searches your Google Calendar for events from the past 7 days that match the event name Data Enrichment: Combines your personal notes with event details (date, location, attendees) from your calendar AI Content Generation: Uses Claude Opus 4 to transform your notes into a professional LinkedIn post with relevant hashtags Database Storage: Saves the complete event information and generated LinkedIn post to Supabase Ready to Post: Provides you with a polished LinkedIn post ready for publication Setup Instructions n8n (Cloud or self-hosted) Telegram Bot (Create via @BotFather) Google Calendar API (OAuth2 credentials) Anthropic API (Claude access) Supabase (Database and API credentials) My Supabase table consists these columns: Event Date (datetime) Event Title (text) Location (text) Personal Notes (text) LinkedIn Post (text) Created Date (datetime) This workflow transforms the tedious task of creating LinkedIn content into an automated, intelligent system that helps you maintain an active professional presence while building a valuable archive of your networking and learning experiences.