Workflow Templates

📬 SPAM MANAGER FOR LEAD GENERATION Automatically identifies and manages spam replies from your outreach inbox; such as “Delivery failed” or “There was a problem with your delivery” which comes from "mailer-daemon@googlemail.com" for Gmail. This is to remove these messages to keep your email lists clean and improve domain reputation. 🎯 Who it’s for This workflow is designed for lead generation managers, outreach specialists, and freelancers who send cold or automated emails at scale. It helps you automatically filter and manage bounce or spam responses without manually combing through your inbox, ensuring your sender domain stays healthy and your lead lists remain accurate. ⚙️ How it works Trigger: Watches your Gmail inbox for replies from system senders like mailer-daemon@googlemail.com. Extract Email: Pulls out the email address from each bounce or spam message. Merge: Compares the extracted address with your main lead sheet. Update Sheet: If the email exists in your main sheet, it updates that record’s SPAM field to "YES". Otherwise, it adds the address to a dedicated Unsubscribe or Bad Emails table. Mark as Read: Tags and marks the email as processed in Gmail for better visibility. 🧩 Requirements To run this workflow, you’ll need: Gmail Credentials** → For reading and tagging emails. NocoDB API Token** → For reading and updating your lead list and spam records.(You can use Sheets, Airtable or any other DB you use). Both can be securely added through the n8n Credentials Manager. 🧠 How to Customize Sender Filter:** Change the Gmail Trigger to include other mailer domains or error messages. Data Storage:** Replace NocoDB with Google Sheets or Airtable. Tagging:** Adjust or remove the Gmail label used for spam-marked messages. Message Matching:** Edit the MERGE code node to fit your column names (e.g., Email, Address, etc.). 💡 Why this workflow matters By automating spam and bounce handling, you: Keep your lead database clean and current Reduce bounce rates and spam flags Improve your email deliverability and sender score Save time spent manually checking failed emails 🪄 Quick Setup Tips Add your Gmail and DB credentials under the Credentials tab. Update the DB project and table IDs in relevant nodes. Test with a few known bounce messages to verify connection and matching. Optional: Add a “SPAM” tag in Gmail for quick inbox filtering. "UNSUBSCRIBE" is used in this workflow. 🧾 Workflow Info Workflow Name: SPAM MANAGER FOR LEAD GENERATION Category: Email & Data Hygiene Version: 1.0 Created for: Outreach and CRM Automation Author: Itunu Portfolio: Itunu’s Automation Portfolio

Who is this for This workflow is built for agencies, freelancers, and local service businesses who want to automate prospecting. If you sell services to local businesses -- web design, SEO, bookkeeping, HVAC -- this workflow finds your prospects and reaches out for you. How it works A manual trigger kicks off the workflow with your configured search parameters (business type and city). ScraperCity's Google Maps scraper extracts up to 500 business listings -- names, websites, addresses, and phone numbers. The workflow polls until the scrape completes, then downloads and parses the results. For each business with a website, the ScraperCity email finder locates the owner's email address using the business domain. Once emails are found, Gmail sends a personalized outreach message to each contact using their business name and city. How to set up Create a free ScraperCity account at app.scrapercity.com and copy your API key. In n8n, create an HTTP Header Auth credential named "ScraperCity API Key" with the header name Authorization and value Bearer YOUR_KEY. Connect your Gmail account via OAuth2 in n8n credentials. Open the Configure Search Parameters node and update the business type, city, and your sender details. Customize the email subject and body in Send Outreach Email. Requirements ScraperCity account (app.scrapercity.com) -- free tier available Gmail account connected via n8n OAuth2 n8n instance (cloud or self-hosted) How to customize the workflow Change businessType and locationQuery in Configure Search Parameters to target any niche or city. Edit the email body in Send Outreach Email to match your offer. Add a Google Sheets node after Send Outreach Email to log sent contacts. Increase maxCrawledPlacesPerSearch up to 500 for larger campaigns.

Think of this workflow as your personal news assistant that: Monitors multiple technology websites 24/7 Uses AI to read and understand each article Filters out low-quality content automatically. Saves the best articles to Notion with summaries. Sends you Telegram alerts for must-read content. Prerequisites (What You Need Before Starting) 1. Notion Account (Free) Sign up at notion.so You'll store all curated articles here 2. OpenAI Account (Paid) Sign up at platform.openai.com Cost: $0.01-0.02 per article ($15-30/month for 50 articles/day) Needed for AI content analysis 3. Telegram Account (Free) Download Telegram app Needed for instant notifications 4. RSS Feed URLs (Free) Included: TechCrunch, Dev.to, The Verge Optional: Add your own favorite tech blogs Step-by-Step Configuration STEP 1: Create Your Notion Database 1.1 Create New Database Open Notion (notion.so) Click "+ New Page" Select "Table" view Name it "Content Curator" 1.2 Add Required Properties Click "+ New Property" and add each: Title** (Rich Text) - Already exists by default URL** (URL type) Summary** (Rich Text) Category** (Select) - Add options: Technology, AI, Business, DevOps, Other Tags** (Rich Text) Sentiment** (Select) - Add options: Positive, Neutral, Negative Priority** (Number) Source** (Rich Text) Published** (Date) Added Date** (Date) Status** (Select) - Add options: New, Read, Archived 1.3 Get Database ID Open your Notion database Click "Share" button (top right) Click "Copy Link" Extract the ID from URL: URL: https://www.notion.so/28e3a42420b2801e8ef5c680e49afc2e ID: 28e3a42420b2801e8ef5c680e49afc2e Save this ID - you'll need it multiple times STEP 2: Create Notion Integration 2.1 Create Integration Go to: notion.so/my-integrations Click "+ New Integration" Name: "RSS Content Curator" Select your workspace Click "Submit" Copy the "Internal Integration Token" (starts with secret_) IMPORTANT: Save this token safely! 2.2 Connect Integration to Database Open your "Content Curator" database in Notion Click "•••" (three dots, top right) Scroll to "Add connections" Select "RSS Content Curator" Click "Confirm" STEP 3: Set Up OpenAI Go to: platform.openai.com Sign up or log in Add payment method (required) Navigate to: platform.openai.com/api-keys Click "+ Create new secret key" Name: "n8n-content-curator" Copy the key (starts with sk-) IMPORTANT: You can't see this key again - save it now! STEP 4: Create Telegram Bot 4.1 Create the Bot Open Telegram app Search for "@BotFather" Start chat with BotFather Send: /newbot Follow prompts: Bot name: "My Content Curator" Username: "my_content_curator_bot" Copy the HTTP API token Save this token 4.2 Get Your Chat ID Search for your bot in Telegram Start a chat and send any message Open in browser: https://api.telegram.org/bot<YOUR_BOT_TOKEN>/getUpdates (Replace <YOUR_BOT_TOKEN> with your actual token) Find "chat":{"id": followed by a number Copy that number (e.g., 8346316847) Save this Chat ID STEP 5: Import Workflow to n8n Log in to n8n Click "Workflows" → "Add Workflow" Click three dots (⋮) → "Import from File" Select RSS_AI_Content_Curator_Enhanced.json Click "Import" STEP 6: Configure Notion Credentials Four nodes need Notion connection: Get Existing Articles Get Old Articles (>30 days) Save to Notion Archive Old Articles For EACH node: Click the node Find "Credential to connect with" Click "Create New" Select "Notion API" Name: "My Notion Curator" Paste your Integration Token from Step 2.1 Click "Save" Update Database IDs: In each Notion node, find "Database ID" field Click refresh icon next to it Select "From list" Choose your "Content Curator" database Test: Click "Execute Node" Success = green checkmark ✓ STEP 7: Configure OpenAI Credentials Click on "AI Content Analysis" node Find "Authentication" section Under "HTTP Header Auth", click "Create New" Fill in: Name: Authorization Value: Bearer sk-YOUR_API_KEY_HERE (Replace with your actual OpenAI key from Step 3) Click "Save" STEP 8: Configure Telegram Credentials Click on "Telegram Notification" node Under "Credential to connect with", click "Create New" Select "Telegram API" Name: "My Telegram Bot" Paste Bot Token from Step 4.1 Click "Save" Update Chat ID: In "Telegram Notification" node Find "Chat ID" field Paste your Chat ID from Step 4.2 Test: Click "Execute Node" STEP 9: Test the Workflow Manual Test Run Verify all nodes show green (no errors) Click "Execute Workflow" (top right) Watch nodes light up in sequence Check for red error nodes If all green: Open Notion - should see new articles Check Telegram - may see notification if high-priority article found Expected Results: Workflow fetches from 3 RSS feeds Removes duplicate articles Checks which are new (not already in Notion) AI analyzes each article (summary, category, priority) Articles with priority ≥60 saved to Notion High-priority articles trigger Telegram notification STEP 10: Activate Automatic Execution Replace Manual Trigger Click "Manual Trigger" node Press Delete Click "+" to add node Search "Schedule Trigger" Select it Configure Schedule Choose one: Every 4 hours:** More updates, higher cost Every 6 hours:** Balanced (recommended) Every 12 hours:** Lower cost Daily at specific time:** Minimal cost Example for every 6 hours: Mode: "Every X" Value: 6 Unit: Hours Activate Click toggle switch (top right) Should turn green: "Active" Workflow now runs automatically!

This workflow automates news aggregation and summarization by fetching relevant articles from Gnews.io and using AI to create concise, professional summaries delivered via Slack What Makes This Different: Real-Time News Aggregation** - Fetches current news articles from Gnews.io API based on user-specified topics AI-Powered Summarization** - Uses GPT-4.1 to intelligently select and summarize the most relevant articles Professional Formatting** - Generates clean, readable summaries with proper dates and article links Form-Based Input** - Simple web form interface for topic specification Automated Delivery** - Sends summarized news directly to Slack for immediate consumption Intelligent Filtering** - AI selects the top 15 most relevant articles from search results Key Benefits of Automated News Summarization: Time Efficiency** - Transforms hours of news reading into minutes of focused summaries Comprehensive Coverage** - AI ensures all important financial and business developments are captured Professional Quality** - Generates publication-ready summaries with proper formatting Real-Time Updates** - Always delivers the latest news on any topic Centralized Access** - All news summaries delivered to one Slack channel Customizable Topics** - Search for news on any subject matter Who's it for This template is designed for business professionals, financial analysts, content creators, journalists, and anyone who needs to stay updated on specific topics without spending hours reading through multiple news sources. It's perfect for professionals who want to stay informed about industry developments, market trends, or any specific subject matter while maintaining productivity. How it works / What it does This workflow creates an automated news summarization system that transforms topic searches into professional news summaries. The system: Receives topic input through a simple web form interface Fetches news articles from Gnews.io API based on the specified topic Maps article data to prepare for AI processing Uses AI to select the 15 most relevant articles related to financial advancements, tools, research, and applications Generates professional summaries with clear, readable language and proper formatting Includes article links and current date for complete context Delivers summaries via Slack notification for immediate review Key Innovation: Intelligent News Curation - Unlike basic news aggregators, this system uses AI to intelligently filter and summarize only the most relevant articles, saving time while ensuring comprehensive coverage of important developments. How to set up 1. Configure Form Trigger Set up n8n form trigger with "topic" field (required) Configure form title as "News Search" Test form submission functionality Ensure proper data flow to subsequent nodes 2. Configure Gnews.io API Get your API key**: Sign up at gnews.io and obtain your API key from the dashboard Add API key to workflow**: In the "Get GNews articles" HTTP Request node, replace "ADD YOUR API HERE" with your actual Gnews.io API key Example configuration**: { "q": "{{ $json.topic }}", "lang": "en", "apikey": "your-actual-api-key-here" } Configure search parameters**: Ensure language is set to "en" for English articles Test API connectivity**: Run a test execution to verify news articles are returned correctly 3. Configure OpenAI API Set up OpenAI API credentials in n8n Ensure proper API access and quota limits Configure the GPT-4.1 Model node for AI summarization Test AI model connectivity and response quality 4. Configure Slack Integration Set up Slack API credentials in n8n Configure Slack channel ID for news delivery Set up proper message formatting for news summaries Test Slack notification delivery 5. Test the Complete Workflow Submit test form with sample topic (e.g., "artificial intelligence") Verify Gnews.io returns relevant articles Check that AI generates appropriate news summaries Confirm Slack notification contains formatted news summary Requirements n8n instance** with form trigger and HTTP request capabilities OpenAI API** access for AI-powered news summarization Gnews.io API** credentials for news article fetching Slack workspace** with API access for news delivery Active internet connection** for real-time API interactions How to customize the workflow Modify News Search Parameters Adjust the number of articles to summarize (currently set to 15) Add more search depth options or date ranges Implement language filtering for different regions Add news source filtering or preferences Enhance AI Capabilities Customize AI prompts for specific industries or niches Add support for multiple languages Implement different summary styles (brief, detailed, bullet points) Add content quality scoring and relevance filtering Expand News Sources Integrate with additional news APIs (NewsAPI, Bing News, etc.) Add support for RSS feed integration Implement trending topic detection Add competitor news monitoring Improve News Delivery Add email notifications alongside Slack Implement news scheduling capabilities Add news approval workflows Implement news performance tracking Business Features Add news analytics and engagement metrics Implement A/B testing for different summary formats Add news calendar integration Implement team collaboration features for news sharing Key Features Real-time news aggregation** - Fetches current news articles from Gnews.io API AI-powered summarization** - Uses GPT-4.1 to intelligently select and summarize relevant articles Professional formatting** - Generates clean, readable summaries with proper dates and links Form-based input** - Simple interface for topic specification Automated workflow** - End-to-end automation from topic input to news delivery Intelligent filtering** - AI selects the most relevant articles from search results Slack integration** - Centralized delivery of news summaries Scalable news processing** - Handles multiple topic searches efficiently Technical Architecture Highlights AI-Powered News Summarization OpenAI GPT-4.1 integration** - Advanced language model for intelligent news summarization Content filtering** - AI selects the 15 most relevant articles from search results Professional formatting** - Generates clean, readable summaries with proper structure Quality consistency** - Maintains professional tone and formatting standards News API Integration Gnews.io API** - Comprehensive news search with article extraction Real-time data** - Access to current, relevant news articles Content mapping** - Efficiently processes article data for AI analysis Search optimization** - Efficient query construction for better news results Form-Based Input System n8n form trigger** - Simple, user-friendly input interface for topic specification Data validation** - Ensures required topic field is properly filled Parameter extraction** - Converts form data to search parameters Error handling** - Graceful handling of incomplete or invalid inputs News Delivery System Slack integration** - Professional news summary delivery Formatted output** - Clean, readable summaries with dates and article links Centralized access** - All news summaries delivered to one location Real-time delivery** - Immediate notification of news summaries Use Cases Financial analysts** needing to stay updated on market developments and industry news Business professionals** requiring daily news summaries on specific topics Content creators** needing current information for articles and social media posts Journalists** requiring comprehensive news coverage on specific subjects Research teams** needing to track developments in their field of expertise Investment professionals** requiring real-time updates on market trends Academic researchers** needing to stay informed about industry developments Corporate communications** teams requiring news monitoring for crisis management Business Value Time Efficiency** - Reduces news reading time from hours to minutes Cost Savings** - Eliminates need for manual news monitoring and summarization Comprehensive Coverage** - AI ensures all important developments are captured Scalability** - Handles unlimited topic searches without additional resources Quality Assurance** - AI ensures professional-quality summaries every time Real-Time Updates** - Always delivers the latest news on any topic Research Integration** - Incorporates current information for relevant, timely insights This template revolutionizes news consumption by combining AI-powered summarization with real-time news aggregation, creating an automated system that delivers professional-quality news summaries on any topic from a simple form submission.

Enterprise Legal Vault: AI Classification & Multi-Jurisdictional Security 🎯 Description This enterprise-grade legal document management system provides end-to-end automation for securing, classifying, and managing the lifecycle of sensitive documents. It is designed to handle high-stakes data across multiple jurisdictions (GDPR, CCPA, HIPAA) with AI-powered intelligence. ✨ What This Workflow Does Intelligent Intake & Deduplication - Monitors Google Drive, Email, and Webhooks. It uses SHA-256 fingerprinting to ensure every document is unique and to prevent redundant processing. AI-Powered Analysis Engine - Utilizes OpenAI/Claude to classify documents (NDA, MSA, Employment Agreements), detect jurisdiction, and assign a composite Risk Score (1-100). Dynamic Security Enforcement - Translates business rules from Airtable into technical enforcement using the HTML to PDF (Lock) node: Ultra-High Risk (90+): AES-256 encryption with disabled Print, Copy, and Modify permissions. High Risk (50-89): AES-128 encryption with dynamic recipient-specific watermarking. Public Filings: Timestamped watermarking with no encryption. Lifecycle & Retention Automation - Automatically calculates retention expiry dates based on legal requirements. It sets Google Calendar renewal reminders at 90, 60, and 30-day intervals. Intelligent Distribution Matrix - Verified: Attached to HubSpot Deals and synced to Dropbox client folders. Review: Flagged items are sent to a manual review queue with a Slack preview. Failed: Isolated in a Quarantine folder with incident logging in Airtable. 💡 Key Features Jurisdictional Logic:** Automatically adapts security and retention rules based on regional laws fetched from Airtable. Forensic Watermarking:** Embeds tracking data (User ID, Timestamp) to deter and identify data leaks. Fail-Safe Quarantine:** Prevents unverified or risky documents from ever entering the primary company storage. 📦 Requirements HTML to PDF Node* - Essential for tiered *Lock** operations. Airtable** - Acts as the central "Business Rules Engine." Google Drive & HubSpot** - For storage and CRM synchronization. OpenAI/Claude API** - For document classification and risk assessment. 🚀 Benefits ✅ Zero Manual Security Setup - Documents are locked according to corporate policy the moment they are uploaded. ✅ Regulatory Compliance - Meets strict GDPR "Right to be Forgotten" and data localization standards automatically. ✅ Proactive Risk Management - High-liability clauses and auto-renewals are flagged instantly to the legal team. Tags: #legal #compliance #pdf-lock #encryption #gdpr #sec-ops #hubspot #airtable Category: Legal & Compliance Difficulty: Advanced

Overview This workflow turns photos sent to a LINE bot into tiny AI-generated diary entries and saves everything neatly in Google Drive. Each time a user sends an image, the workflow creates a timestamped photo file and a matching text file with a short diary sentence, stored inside a year/month folder structure (KidsDiary/YYYY/MM). It’s a simple way to keep a lightweight visual diary for kids or daily life without manual typing. LINE Photo to AI Diary with Goo… Who this is for Parents who want to archive kids’ photos with a short daily comment People who often send photos to LINE and want them auto-organized in Drive Anyone who prefers a low-friction, “take a photo and forget” style diary How it works Trigger: A LINE Webhook receives an image message from the user. Extract metadata: The workflow extracts the messageId and replyToken. Download image: It calls the LINE content API to fetch the image as binary. AI diary text: OpenAI Vision generates a one-sentence, diary-style caption (about 50 Japanese characters). Folder structure: A KidsDiary/YYYY/MM folder is created (or reused) in Google Drive. Save files: The photo is saved as YYYY-MM-DD_HHmmss.jpg and the diary text as YYYY-MM-DD_HHmmss_diary.txt in the same folder. Confirm on LINE: The bot replies to the user that the photo and diary have been saved. How to set up Connect your LINE Messaging API credentials in the HTTP Request nodes. Connect your Google Drive credential in the Google Drive nodes and choose a root folder. Make sure the webhook URL is correctly registered in the LINE Developers console. Customization ideas Change the AI prompt to adjust tone (e.g., more playful, more sentimental). Localize the diary language or add an English translation. Add a second branch to post the saved diary entry to Slack, Notion, or email. Organize Google Drive folders by child’s name instead of only by date.

Who’s it for Remote and distributed teams that schedule across time zones and want to avoid meetings landing on public holidays—PMs, CS/AM teams, and ops leads who own cross-regional calendars. What it does / How it works The workflow checks next week’s Google Calendar events, compares event dates against public holidays for selected country codes, and produces a single Slack digest with any conflicts plus suggested alternative dates. Core steps: Workflow Configuration (Set) → Fetch Public Holidays (via a public holiday API such as Calendarific/Nager.Date) → Get Next Week Calendar Events (Google Calendar) → Detect Holiday Conflicts (compare dates) → Generate Reschedule Suggestions (find nearest business day that isn’t a holiday/weekend) → Format Slack Digest → Post Slack Digest. How to set up Open Workflow Configuration (Set) and edit: countryCodes, calendarId, slackChannel, nextWeekStart, nextWeekEnd. Connect your own Google Calendar and Slack credentials in n8n (no hardcoded keys). (Optional) Adjust the Trigger to run daily or only on Mondays. Requirements n8n (Cloud or self-hosted) Google Calendar read access to the target calendar Slack app with permission to post to the chosen channel A public-holiday API (no secrets needed for Nager.Date; Calendarific requires an API key) How to customize the workflow Time window: Change nextWeekStart/End to scan a different period. Holiday sources: Add or swap APIs; merge multiple regions. Suggestion logic: Tweak the look-ahead window or rules (e.g., skip Fridays). Output: Post per-calendar messages, DM owners, or create tentative reschedule events automatically.

Split Test AI Prompts Using Supabase & Langchain Agent This workflow allows you to A/B test different prompts for an AI chatbot powered by Langchain and OpenAI. It uses Supabase to persist session state and randomly assigns users to either a baseline or alternative prompt, ensuring consistent prompt usage across the conversation. 🧠 Use Case Prompt optimization is crucial for maximizing the performance of AI assistants. This workflow helps you run controlled experiments on different prompt versions, giving you a reliable way to compare performance over time. ⚙️ How It Works When a message is received, the system checks whether the session already exists in the Supabase table. If not, it randomly assigns the session to either the baseline or alternative prompt. The selected prompt is passed into a Langchain Agent using the OpenAI Chat Model. Postgres is used as chat memory for multi-turn conversation support. 🧪 Features Randomized A/B split test per session Supabase database for session persistence Langchain Agent + OpenAI GPT-4o integration PostgreSQL memory for maintaining chat context Fully documented with sticky notes 🛠️ Setup Instructions Create a Supabase table named split_test_sessions with the following columns: session_id (text) show_alternative (boolean) Add credentials for: Supabase OpenAI PostgreSQL (for chat memory) Modify the "Define Path Values" node to set your baseline and alternative prompts. Activate the workflow. Send messages to test both prompt paths in action. 🔄 Next Steps Add tracking for conversions or feedback scores to compare outcomes. Modify the prompt content or model settings (e.g. temperature, model version). Expand to multi-variant tests beyond A/B. 📚 Learn More How This Workflow Uses Supabase + OpenAI for Prompt Testing

Send Weekly GitHub Digest with Releases, Commits, and Trending Repos Stay on top of the GitHub ecosystem with a single automated weekly email covering it all. How it works A schedule trigger fires every Monday at 9am and reads your config variables. Feel free to modify schedule. Three branches run in parallel: Releases: fetches the latest release from each watched repo via the GitHub API Commits: fetches recent commits or public events for each tracked repo or username Trending: scrapes github.com/trending for that day's actual trending repositories All three branches merge into a single Code node that builds one HTML email with three labeled sections. If any content was found, the email is sent via Gmail. Otherwise the workflow exits silently. Setup steps Connect your Gmail account. Open Set Variables and configure: recipient_email — where to send the digest release_repos — list of repos to watch for releases (e.g. n8n-io/n8n) tracked_entities — GitHub usernames or owner/repo paths to track commits- days_back — lookback window in days (default: 7) Activate.

Google Sheets → Stripe Payment Automation Workflow 📌 Overview This workflow automates the end-to-end process of generating and sending client payment links using Google Sheets and Stripe. Whenever a new or updated entry is added to the Google Sheet, the workflow will: Fetch client and invoice details. Create a Stripe Product and Price. Generate a Stripe Payment Link. Store the link back in the Google Sheet. Upload a copy of the invoice to Google Drive. Send a professional, formatted email with the payment link to the client using Gmail. 🔗 Demo Video: Watch on YouTube ⚡️ Workflow Steps Trigger – The workflow is triggered on any update in the Google Sheet. Filter – Ensures only relevant rows (e.g., PENDING invoices) proceed. Stripe Automation Create Stripe Product Create Stripe Price Generate Stripe Payment Link Google Drive – Store invoice files (if required). Google Sheets – Update the sheet with the generated Stripe Payment Link and timestamp. Gmail – Send a client-facing email with the invoice details and payment link. 🛠 Setup Guide Prerequisites n8n account** Google Sheets & Google Drive credentials** Gmail API credentials** Stripe API Key** Steps Clone/Import Workflow Import the workflow JSON file into your n8n instance. Configure Google Sheets Create a Google Sheet with columns: Order ID, Client Name, Client Email, Items Description, Due Date, Amount, Currency, Invoice Status, Invoice Link, Stripe Payment Link, Last Updated Connect your Google Sheets node to this sheet. Set Up Stripe Obtain your Stripe Secret Key from Stripe Dashboard. Add it in the Stripe nodes for Product, Price, and Payment Link creation. Google Drive Configure to store invoice backups (optional). Gmail Authorize Gmail and set up the Send Email node. Customize the email template with client details and the Stripe link. Test the Workflow Add a sample row in Google Sheets. Run the workflow manually or update the sheet to trigger automatically. Verify that the Stripe link is created, updated in the sheet, and emailed to the client. ✅ Now your workflow is ready to automatically manage client invoices and payments with Stripe + Google Sheets + Gmail + Google Drive.

Overview This workflow automatically reads school-related emails from Gmail, uses AI to understand what each email is about, and then organizes everything into Google Drive and Google Calendar. It classifies messages into schedules, “what to bring” lists, general notices, and contact information, creates calendar events when needed, saves text files in Drive, and sends you a daily reminder email about tomorrow’s important events. Email Auto-Triage and Organizat… Email Auto-Triage and Organization Hub Who this is for Parents or caregivers who get lots of school emails and want everything organized automatically Busy families who often forget dates, deadlines, or 持ち物 (things to bring) Anyone who wants school communication stored in a structured, searchable way in Drive and Calendar How it works Trigger: Gmail watch for new emails A Gmail Trigger node watches your inbox and starts the workflow whenever a new email arrives. It then loads the full message content (subject, body, metadata). Email Auto-Triage and Organizat… AI classification and extraction The email text is sent to an AI model, which returns a structured JSON object with: category: “Schedule”, “What to Bring”, “Notice”, or “Contacts” eventTitle, eventDescription, eventDate (ISO format) itemsToBring, contacts, subject, id, and hasAttachments This turns messy school emails into clean structured data. Email Auto-Triage and Organizat… Routing by category A Switch node routes each email based on its category and whether it has attachments: Schedule / What to Bring → create a calendar event and also save a notice file Notice → save a notice file only Any email with attachments → send to the attachment branch for optional photo storage Email Auto-Triage and Organizat… Save notices to Google Drive For all categorized emails, the workflow creates a text file in Google Drive containing: Title, date, category, items to bring, and a short description of the event or notice. Email Auto-Triage and Organizat… Create calendar events For “Schedule” and “What to Bring” emails, the workflow builds a summary and description (including 持ち物) and creates a Google Calendar event. If no end time is given, it defaults to one hour after the start. Email Auto-Triage and Organizat… Save photo attachments (optional) If the email has image attachments, the workflow: Downloads the attachments from Gmail Filters to only image files Saves the photos in a specified Google Drive folder, using the original file name Email Auto-Triage and Organizat… Extract and archive contact information The workflow also pulls out the sender’s contact info (From), links it to the email subject and timestamp, and saves it as a separate contact text file in Google Drive for easy reference. Email Auto-Triage and Organizat… Daily reminder for tomorrow’s events Every morning at a set time, a Schedule Trigger runs: It fetches all events from Google Calendar for “tomorrow” Filters down to events whose description includes “持ち物” Sends you an email summarizing tomorrow’s events and what you need to bring, so you can prepare in advance. Email Auto-Triage and Organizat… How to set up Connect your Gmail, Google Calendar, and Google Drive credentials in the respective nodes. In the Workflow Configuration node, set: photosFolderId – Drive folder for saved photos noticesFolderId – Drive folder for notice text files contactsFolderId – Drive folder for contact text files reminderEmail – email address that will receive the daily reminder Make sure the Gmail Trigger is pointing to the correct mailbox and is set to poll as often as you like. Confirm that the Google Calendar node uses the calendar where you want school events to appear. Turn the workflow on and test it with a few real school emails (schedules, what to bring, general notices). Email Auto-Triage and Organizat… Customization ideas Adjust the AI prompt in Extract Email Info to better match your school’s typical email style or to add more categories. Change the logic for calendar events (all-day events, different default times, or additional fields like location). Modify file naming patterns or folder structure in Google Drive (e.g., separate folders per child, per school year, or per class). Add logging to Google Sheets for a timeline view of all school communication. Forward or mirror important events/notices to other tools such as Slack, Notion, or a family LINE group.

Form Lead Scoring with AI → Google Sheets + Slack When a new lead fills out your Typeform or any other form, this workflow classifies the message with AI, stores it in the right Google Sheet tab, and can send your team a Slack alert. Benefits Get new leads in real time from any form Classify each lead with AI (hot / neutral / cold) Save leads to the correct Google Sheets tab automatically Send Slack alerts for hot leads so you act fast Keep your pipeline clean and easy to scan How It Works Webhook receives a new form submission Parse name, email, phone, message, and timestamp AI analyzes the message and returns hot / neutral / cold Route to the matching Google Sheets tab (Hot, Neutral, Cold) (Optional) Post a Slack message with key details Who Is This For Agencies running paid ads and lead forms Sales teams that need quick triage Coaches, creators, and SaaS teams with waitlists Setup Connect your form tool (Typeform or other) to a webhook Add Google Gemini (or your AI model) credentials Connect Google Sheets (Spreadsheet ID + Tab names) (Optional) Connect Slack and select a channel Test with a few submissions to check routing ROI & Monetization Respond faster to hot leads → higher close rates Save 2–4 hours/week on manual sorting Offer as “AI lead scoring” for clients ($500–$2k/month) Strategy Insights In the full walkthrough, I show how to: Write a short, reliable prompt for clear labels Map form fields cleanly into Sheets Format Slack alerts for quick reading Expand with auto-replies or CRM sync later Check Out My Channel For more AI automation systems that get real results, check out my YouTube channel where I share the exact strategies I use to build automation workflows, win clients, and scale to $20k+ monthly revenue.