by Davide
This workflow automates analyzing Gmail threads and drafting AI-powered replies with the new model Anthropic Sonnet 4.5. This workflow automates the process of analyzing incoming emails and generating context-aware draft replies by examining the entire email thread. Key Advantages ✅ Time-Saving – Automates repetitive email replies, reducing manual workload. ✅ Context-Aware Responses – Replies are generated using the entire email thread, not just the latest message. ✅ Smart Filtering – The classifier prevents unnecessary drafts for spam or promotional emails. ✅ Human-in-the-Loop – Drafts are created instead of being sent immediately, allowing manual review and corrections. ✅ Scalable & Flexible – Can be adapted to different accounts, reply styles, or workflows. ✅ Seamless Gmail Integration – Directly interacts with Gmail threads and drafts via OAuth. How it Works This workflow automates the process of analyzing incoming emails and generating context-aware draft replies by examining the entire email thread. Trigger & Initial Filtering: The workflow is automatically triggered every minute by the Gmail Trigger node, which detects new emails. For each new email, it immediately performs a crucial first step: it uses an AI Email Classifier to analyze the email snippet. The AI determines if the email is a legitimate message that warrants a reply (categorized as "ok") or if it's spam, a newsletter, or an advertisement. This prevents the system from generating replies for unwanted emails. Context Aggregation: If an email is classified as "ok," the workflow fetches the entire conversation thread from Gmail using the threadId. A Code Node then processes all the messages in the thread, structuring them into a consistent format that the AI can easily understand. AI-Powered Draft Generation: The structured conversation history is passed to the Replying email Agent with Sonnet 4.5. This agent, powered by a language model, analyzes the entire thread to understand the context and the latest inquiry. It then drafts a relevant and coherent HTML email reply. The system prompt instructs the AI not to invent information and to use placeholders for any missing details. Draft Creation: The final step takes the AI-generated reply and the original email's metadata (subject, recipient, threadId) and uses them to create a new draft email in Gmail. This draft is automatically placed in the correct email thread, ready for the user to review and send. Set up Steps To implement this automated email reply system, you need to configure the following: Configure Gmail & OpenAI Credentials: Ensure the following credentials are set up in your n8n instance: Gmail OAuth2 Credentials: The workflow uses the same Gmail account for the trigger, fetching threads, and creating drafts. Configure this in the "Gmail Trigger," "Get a thread," and "Create a draft" nodes. OpenAI API Credentials: Required for both the "Email Classifier". Provide your API key in the respective OpenAI Chat Model nodes. Anthropic API Credentials: Required for the main "Replying email Agent." Provide your API key in the respective Antrhopic Chat Model nodes. Review AI Classification & Prompting: Email Filtering: Check the categories in the Email Classifier node. The current setup marks only non-advertising, non-newsletter emails as "ok." You can modify these categories to fit your specific needs and reduce false positives. Reply Agent Instructions: Review the system message in the Replying email Agent. You can customize the AI's persona, tone, and instructions (e.g., making it more formal, or instructing it to sign with a specific name) to better align with your communication style. Need help customizing? Contact me for consulting and support or add me on Linkedin.
by Rahul Joshi
📘 Description This workflow automates the full lifecycle of a data-consent complaint: receiving the complaint, validating the payload, normalizing the data into a clean ticket format, storing it in a compliance sheet, generating a formal acknowledgement email for the user, and sending an internal Slack alert for the compliance team. Everything moves from intake → classification → communication → escalation with zero manual handling. AI-generated messages follow DPDP-compliant tone and structure. ⚙️ What This Workflow Does (Step-by-Step) ▶️ Receive Consent Complaint (Webhook) Accepts a POST request containing complaint details: name, email, issue type, description, and metadata. 🔍 Check Required Fields (IF) Validates that the complaint includes a non-empty description. Valid → processed Invalid → logged to a separate sheet. 🧹 Clean & Normalize Complaint Data (Code) Constructs a unified ticket object with: auto-generated ticketId normalized fields (action, email, issueType, description) priority scoring timestamp source metadata Sets default status to Open. 📄 Log Invalid Complaint Records (Google Sheets) Stores incomplete submissions for later review. 📥 Store Complaint Ticket in Consent Dispute Sheet (Google Sheets) Appends the cleaned ticket into the Consent Dispute sheet including all metadata for traceability. 🧠 Generate Acknowledgement Email (AI) Creates a DPDP-compliant support email: mentions user name references ticket ID summarizes issue sets response window (48–72 hours) avoids legal or internal disclosures uses formal, respectful tone ⚙️ Configure GPT-4o – Email Generator Supplies the AI model for email generation. 📝 Extract Email Subject + Body (Code) Splits the AI-generated email into structured fields: subject and message. 📧 Send Acknowledgement Email to User (Gmail) Delivers the formatted acknowledgement directly to the user who filed the complaint. ⚙️ Configure GPT-4o – Slack Summary Model Supplies the AI model for internal Slack summary generation. 🔔 Generate Slack Incident Summary (AI) Produces an internal, action-focused Slack message containing: ticket ID user details issue type description timestamp priority recommended next step No greetings, no email formatting. 📡 Slack – Notify Compliance Team Sends the incident summary to the assigned Slack user or channel for quick action by compliance. 🧩 Prerequisites Live webhook endpoint Google Sheets OAuth (Techdome) Gmail OAuth Slack API credentials Azure OpenAI GPT-4o enabled 💡 Key Benefits ✅ Zero-touch intake → acknowledgement → escalation ✅ DPDP-compliant communication with users ✅ Structured ticket normalization and prioritization ✅ Instant Slack alerts for compliance action ✅ Full audit trail in Google Sheets 👥 Perfect For Data privacy teams Compliance & grievance redressal units SaaS platforms handling consent disputes Organizations needing DPDP-aligned automated workflows
by Zeinabsadat Mousavi Amin
This workflow automates the entire UX research planning process — from gathering context to delivering a ready-to-share Google Doc report. Built for UX researchers and designers, it combines AI-powered generation with human feedback loops to make research planning faster, smarter, and more collaborative. 🧠 What it does Collects context** through an online form (organization, product, and research goals) Generates research questions** automatically using an AI Agent Sends approval emails** to the researcher or designer for review and feedback Refines and rewrites** questions based on user input Recommends suitable research methods** for each question, with clear rationales Formats the content** into a structured, professional HTML report Creates and updates a Google Doc** with the final approved research plan 🎯 Who it’s for Perfect for UX teams, design researchers, and product designers who want to streamline their workflow without losing human oversight. Whether you’re preparing a usability study or strategic research plan, this automation helps you focus on insight — not administration. Result: a fully-approved, polished UX Research Plan — ready for collaboration and presentation.
by Aitor | 1Node
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automates the distribution and scheduling of video content across multiple social platforms (TikTok, YouTube, Facebook, Instagram, Threads) through Postiz. Videos are collected from Google Drive, approved manually, and scheduled via the Postiz community node. 🧾 Requirements Google Drive** account with access to the folder that will watch for new items uploaded. videos in mp4 format ready to be shared or, alternatively you can connect a community node from Cloud Convert to convert the format before uploading into Postiz. Postiz account with integrations for TikTok, YouTube, Facebook, Instagram, and Threads 🔗 Useful Links Postiz Docs Postiz Community Node 🔄 Workflow Steps Trigger: Google Drive File Added Watches your selected Google Drive folder for new file uploads. Download File Downloads the detected video from Drive. Upload to Postiz Video is uploaded to Postiz to prepare for social scheduling. Set Fields Manual setting of social options Extract Datetime (AI) Uses OpenAI to find/predict intended publish date & time, as the datetime format is required to schedule on Postiz Get Social Integrations Fetches a list of user’s connected platforms from Postiz. Split and Filter Integrations Splits the process per platform (TikTok, YouTube, Facebook, Instagram, Threads). Schedule Post For each enabled platform, schedules the video with chosen options. 🙋♂️ Need Help? Connect with 1 Node
by WeblineIndia
Send daily applicant digest by role from Gmail to hiring managers with Google Gemini This workflow automatically collects all new job application emails from your Gmail labeled as applicants in the last 24 hours. Every day at 6:00 PM (Asia/Kolkata), it extracts structured details (name, email, phone, role, experience, skills, location, notice, summary) from each applicant (using Gemini AI or OpenAI). It then groups applicants by role and manager, compiles a neat HTML table digest for each manager and emails them a single summary — so hiring managers get everything they need, at a glance, in one place. Who’s It For Recruiters and hiring managers tired of digging through multiple application threads. Small HR teams / agencies not yet on a full applicant tracking system. Anyone wanting a consolidated, role-targeted applicant update each day. Teams that want to automate candidate triage using Google Workspace and AI. How It Works Schedule Trigger (6PM IST): Runs automatically at 18:00 India time. Fetch Applicant Emails: Reads Gmail for emails labeled 'applicants' from the past 24 hours. Prepare Email Text: Converts email content to plain text for reliable AI extraction. Extract Applicant Details: Gemini/OpenAI extracts applicant’s info in structured JSON. Assign Manager Emails: Routes each applicant to the correct manager via role→email mapping or fallback. Group & Build HTML Tables: Organizes applicants by manager and role, builds summary tables. Send Digest to Managers: Sends each manager one HTML summary email for their new applicants. How to Set Up Create/verify Gmail label applicants and set up filters to route job emails there. Import the workflow: Use your Google/Gmail and Gemini/OpenAI accounts as credentials. Configure connections: Gmail with OAuth2 (IMAP not required, uses Gmail API) Gemini or OpenAI API key for extraction Set role→manager mapping in the “Assign Manager Emails” node (just edit the map!). Adjust time / defaults: Edit schedule and fallback email if you wish. Test it: Send yourself a test application, label it, check workflow logs. Requirements Gmail account (with OAuth2 enabled and 'applicants' label set up) Gemini or OpenAI API key for structured AI extraction n8n instance (self-hosted or cloud) SMTP credentials (if using direct email instead of Gmail node) At least one valid hiring manager email mapped to a role How to Customize the Workflow Centralize config with a Set node (label name, fallback/manager email, model name, schedule). Add attachment-to-text conversion for applications with resume attachments. Normalize role names in the mapping code for more robust routing. Enable additional delivery: Slack, Teams, Google Sheets log, extra Cron for mid-day urgents. Refine AI extraction prompt for specific fields (add portfolio URL, etc.). Change schedule for daily, weekly or per-role timing. Add‑Ons / Extensions Resume Text Extraction:** Add PDF/DOCX to text parsing for attachment-only applications. ChatOps:** Send the summary to Slack or Teams channels along with/instead of email. Applicant Logging:** Auto-log every applicant/action into Google Sheets, Notion or Airtable. Multi-timezone:** Duplicate/modify the Cron trigger for different manager regions or urgency levels. Use Case Examples Tech Hiring:** Java, Python, Frontend candidates are automatically routed to their respective leads. Small Agency:** All applications summarized for reviewers, with per-role breakdowns. HR Operations:** Daily rollups sent before hiring sync, facilitating fast decision-making. Common Troubleshooting | Issue | Possible Cause | Solution | |-----------------------------------------|----------------------------------------------------------|-------------------------------------------------------------| | No emails processed | No 'applicants' label or wrong time window | Check Gmail filters and adjust search query in fetch node | | All digests go to fallback manager | Incorrect or missing role → manager mapping | Normalize role text in assignment node, expand map | | AI Extraction returns bad/missing JSON | Wrong prompt, high temperature or missing field names | Tighten prompt, lower temperature, check example response | | Duplicate/Old Emails appear | Date filter not correct | Use 'newer_than:1d' and keep 'mark as read' in email node | | SMTP/Gmail Send errors | Auth problem, quota or app password missing | Use OAuth2, check daily send caps and app password settings | | Blank or partially filled summary table | AI unable to parse poorly formatted/empty email | Improve sender email consistency, add fallback handling | | Attachments not processed | No attachment extraction node | Add attachment-to-text parsing before AI node | Need Help? If you get stuck, need help customizing a mapping or adding nodes or want to integrate extra steps (e.g., resume text, Slack), just ask! We're happy to guide you step by step, review your workflow, or help you troubleshoot any errors. Contact WeblineIndia — Your n8n Automation partner!
by Rahul Joshi
This workflow converts raw ClickUp task updates—received directly through a webhook—into fully automated release documentation. It validates incoming payloads, fetches and cleans task details, enriches them with AI-generated metadata, produces structured release notes using GPT-4o, publishes them to Notion, notifies stakeholders on Slack, emails a formatted summary, and logs the release into Google Sheets. The system handles malformed events gracefully by logging invalid payloads and continues only when a valid task_id is present. It extracts structured fields (title, description, links, priority, assignee), then augments them with AI-driven classifications such as risk level, change type, module, and impact score. GPT-4o generates polished release notes following a strict template. Finally, the workflow distributes the release across multiple channels while maintaining an auditable, centralized history. ⚙️ What This Workflow Does (Step-by-Step) 🟢 Webhook — Receive ClickUp Task Update Captures incoming events from ClickUp via POST and forwards the raw body for parsing. 🧹 Code in JavaScript — Extract task_id Parses the raw webhook body and safely extracts task_id. Invalid JSON → forwarded to error logging. 🔍 Validate Incoming ClickUp Task Event Checks if task_id exists. Valid → continue workflow Invalid → log error to Google Sheets 📄 Fetch Full Task Details from ClickUp Retrieves full task metadata: title, description, status, priority, links, assignee details, and due date. 🧩 Extract Clean Task Fields from ClickUp Data Normalizes and structures the task fields into a clean, usable JSON object. 🧠 Provide GPT-4o Model for Metadata Extraction Loads the language model for metadata generation. 🔍 Generate Release Metadata via AI AI generates structured metadata including: • risk_level • change_type • module • impact_score • requires_testing 🧹 Parse AI Metadata JSON Output Parses stringified JSON from the AI node into valid structured JSON. Malformed metadata → returned as an error object. 🔀 Merge Task Details with Metadata Combines clean task fields with AI-generated metadata into a complete release-ready object. 🧠 Provide GPT-4o Model for Release Notes Supplies the language model needed to generate formal release notes. ✍️ Generate Structured Release Notes via AI Produces uniform release notes containing: • Summary • Improvements & Features • Bug Fixes • Impact Analysis • Known Issues 📝 Extract Release Notes Title & Final Output Extracts title from markdown and prepares final content for publishing. 📘 Create Release Notes Page in Notion Saves the release notes as a new page in the Notion Release Notes database. 💬 Post Release Announcement to Slack Sends formatted release notes + Notion link to the specified Slack user/channel. 📧 Send Release Summary Email Sends a structured HTML email with the release summary, full notes, and Notion link. 📊 Append Release Log Entry to Google Sheet Writes a complete release log entry including: • task ID • title • priority • module • risk level • Notion URL • Slack message URL • release date 🛑 Log Invalid ClickUp Events to Google Sheet Stores any invalid or incomplete webhook payload for debugging and auditing. 🧩 Prerequisites • ClickUp API token • Public webhook endpoint in n8n • Azure OpenAI GPT-4o credentials • Notion API integration • Slack API token • Google Sheets OAuth • Gmail OAuth 💡 Key Benefits ✔ Converts ClickUp updates directly into finished release documentation ✔ AI-powered metadata ensures consistent classification ✔ Instant multi-channel dissemination: Slack + Email + Notion ✔ Automatic logging for audit, QA, and release governance ✔ Eliminates manual writing, formatting, and cross-platform updates 👥 Perfect For Product teams running constant sprints Engineering teams needing reliable release documentation Teams using ClickUp as their primary task manager Organizations with multi-channel release communication needs
by Rahul Joshi
📘 Description This workflow automatically detects new product launches posted on Hacker News under “Show HN,” evaluates their launch strength, converts each launch into a tracked Asana task, and generates a clean daily founder digest delivered via Slack and email. The system runs on a daily schedule, fetches recent Show HN posts directly from Hacker News, filters for real launch signals, extracts structured launch metadata, and scores each launch based on engagement indicators such as points, comments, and context. Every detected launch is immediately logged as an actionable Asana task with full context for follow-up. All launches are then aggregated and analyzed by an AI engine that produces two outputs: a compact, skimmable Slack digest and a structured, email-ready launch briefing grouped by signal strength. Any workflow failure triggers a real-time Slack alert with diagnostic details. This workflow replaces manual Hacker News monitoring, launch tracking, task creation, and digest writing with a fully automated launch intelligence and execution pipeline. ⚙️ What This Workflow Does (Step-by-Step) ⏰ Trigger Daily Show HN Launch Scan Runs automatically on a daily schedule. 📰 Fetch Recent Show HN Posts from Hacker News Pulls the latest “Show HN” posts using native Hacker News data. 🔍 Filter Likely Product Launch Announcements Scans titles and descriptions for launch indicators such as: • Launch • Beta • v1 • API • Platform • Tool 🧠 Normalize Launch Metadata and Score Signal Strength Extracts and structures: • Product name • Description • Product URL • Hacker News discussion link • Author and publish date • Points and comments Assigns launch strength (High / Medium / Low). 📋 Create Asana Task for Detected Product Launch Creates a follow-up task with: • Full launch context • Engagement metrics • Signal strength • Direct links • Auto-assigned due date 📦 Aggregate Launch Items for Digest Generation Combines all detected launches into a single dataset for analysis. 🧠 Generate Daily Founder Launch Digest (AI) Creates: • A Slack-ready daily launch summary • A clean, structured, email-ready digest • Grouped by launch signal strength 🧠 LLM Reasoning Engine for Launch Digest Ensures clarity, structure, and readability across outputs. 🔄 Parse Digest Output into Slack and Email Payloads Separates AI output into delivery-ready formats. 📣 Send Daily Founder Launch Digest to Slack Posts the daily launch summary to Slack. 📧 Send Daily Founder Launch Digest via Email Delivers an inbox-optimized version of the launch digest. 🚨 Error Handler Trigger → Slack Alert Any workflow failure sends a detailed Slack alert with node name, error message, and timestamp. 🧩 Prerequisites • Hacker News API access (n8n HN node) • Asana OAuth credentials • Azure OpenAI API credentials • Slack API credentials • Gmail OAuth credentials • n8n schedule trigger enabled 💡 Key Benefits ✔ Detects real product launches automatically ✔ Scores launch strength using engagement signals ✔ Converts launches into actionable Asana tasks ✔ Produces clean Slack and email digests daily ✔ Eliminates manual Hacker News monitoring ✔ Maintains consistent launch intelligence flow ✔ Provides instant error visibility via Slack 👥 Perfect For Startup founders Product scouts and VC analysts Growth and partnerships teams Innovation and market research teams Anyone tracking early-stage product launches without manual effort
by Rahul Joshi
Description This workflow automates personalized candidate communication for both shortlisted and rejected applicants. It fetches candidate details, processes resumes, checks for errors, and uses GPT-4o to generate professional HTML emails. Shortlisted candidates receive congratulatory onboarding plans, while rejected candidates receive polite rejections with learning resources. What This Template Does (Step-by-Step) ⚡ Manual Trigger – Starts the workflow execution. 📑 Candidate Data Fetch (Google Sheets) – Pulls structured candidate data (name, email, resume link, skills, job info, status). 📥 Resume Downloader (Google Drive) – Downloads candidate resumes from sheet links. ✅ Resume File Check (If Condition) – Ensures the resume file is valid before proceeding. ⚠️ Error Logging (Google Sheets) – Records failed or missing resumes in a dedicated sheet for audit. 📄 PDF → Text Extractor – Extracts raw resume text for deeper AI analysis. 🧩 Candidate Data Builder (Code Node) – Combines Google Sheets data with extracted resume text into a single enriched JSON object. 🎯 Shortlisted vs Rejected (If Condition) – Splits candidates into two flows based on their status field. Shortlisted Path 🎉 Congrats + Onboarding Plan (LLM Chain) – GPT-4o generates a congratulatory HTML email including: Identified skill gaps Recommended online courses (Coursera/Udemy/LinkedIn Learning) Next onboarding steps 📧 Candidate Mailer – Shortlisted (Gmail) – Sends the onboarding email directly to the candidate. Rejected Path 🙏 Polite Rejection + Learning Plan (LLM Chain) – GPT-4o generates a professional rejection email including: Empathetic rejection message Constructive feedback on skill gaps Learning resources to improve for future opportunities 📧 Candidate Mailer – Rejected (Gmail) – Sends the polite rejection + learning plan to the candidate. Prerequisites Google Sheets (candidate database + error log) Google Drive (resume storage) Gmail API (for sending candidate emails) Azure OpenAI (GPT-4o-mini model access) Key Benefits ✅ Automates candidate communication (both shortlisted & rejected) ✅ Delivers professional, HTML-ready emails ✅ Enhances candidate experience with personalized learning plans ✅ Prevents silent rejections by providing constructive resources ✅ Improves employer branding with empathetic communication ✅ Error resilience via logging and validation steps Perfect For Recruitment teams managing high candidate volume Companies looking to humanize rejections HR departments that want automated but personalized communication Organizations investing in candidate experience & employer brand
by Apurva Mishra
AI Email Manager: Auto Summary, Labeling, and CRM Logging via n8n + Gemini Overview This workflow turns your Gmail inbox into a fully autonomous AI Email Agent that reads, summarizes, categorizes, and organizes emails in real-time. Built with n8n, Google Gemini, Notion, and Google Sheets, it’s perfect for founders, freelancers, and agencies who receive a ton of emails daily and want to automate the triage process without losing control. How It Works Gmail Trigger — Detects new incoming emails. Process Email Data — Extracts sender info, subject, and content in a clean structured format. AI Email Analyzer — Uses Gemini AI to summarize the email and decide the most relevant label (e.g., Project Updates, Client Requests, Invoices, etc.). Create Gmail Label (if not exists) — Dynamically creates a new label if the AI recommends one that doesn’t exist. AI Agent + Add Label to Email — Applies the correct Gmail label automatically using the message ID. Logs in Notion & Google Sheets — Every processed email (summary, sender, date, label) is logged for tracking and analytics. Who It’s For Entrepreneurs & Founders — Manage investor, client, and product update emails automatically. Agencies & Teams — Classify and track client emails effortlessly across projects. Freelancers & Consultants — Get AI summaries and organize leads without manually labeling emails. Tech Builders — Anyone building AI automation tools and SaaS products around inbox management.
by Gilbert Onyebuchi
A complete email campaign automation system featuring dual-mode access control (Demo/Pro), usage tracking, and professional email delivery. Perfect for SaaS products, marketing agencies, or anyone building newsletter tools with freemium models. WHAT IT DOES This workflow manages email newsletter campaigns with built-in rate limiting for free users and unlimited access for premium users. It automatically tracks daily usage, manages user data in Google Sheets, delivers emails via SendGrid, and sends real-time notifications through Telegram. KEY FEATURES Dual-Mode System: Demo mode (5 emails/day) and Pro mode (unlimited) Smart Rate Limiting: Automatic daily counter reset User Management: Automatic new user registration and tracking Google Sheets Integration: Stores user data, send counts, and usage history Professional Email Delivery: SendGrid integration for reliable sending Real-Time Monitoring: Telegram notifications for every send Ready-to-Use Templates: 4 professional email designs included (Modern, Professional, Promotional, Newsletter) Live Preview: See exactly how emails look before sending HTML Export: Copy email HTML for use in any platform HOW IT WORKS User accesses the Email Newsletter Builder web form Designs email using one of 4 professional templates Chooses Demo or Pro mode Webhook receives the email data and configuration Workflow checks mode (Demo/Pro) For Demo mode: Queries Google Sheets for user email Checks if user exists and validates daily limit (<5 sends) If new user: Creates database entry If existing user + under limit: Increments counter If limit reached: Returns error message For Pro mode: Sends immediately without limits SendGrid delivers the email Google Sheets updates with new send count and timestamp Telegram notification sent to admin Success/error response returned to user SETUP REQUIREMENTS Google Sheets account (free) SendGrid account (free tier: 100 emails/day) Telegram account + bot (free) n8n instance (self-hosted or cloud) SUPPORT & FEEDBACK Questions or issues? Connect with me on LinkedIn Want to see it in action? Try the live demo: Click here ⭐ If you find this workflow helpful, please give it a rating and share your feedback!
by Abdullah Alshiekh
📝 Description: This template is designed for healthcare providers, sales reps, and medical tourism companies who need to process diagnosis emails efficiently. It automates the full flow from email to report delivery. When a new diagnosis email arrives: The email content is captured and parsed by an AI agent (Gemini or any customizable LLM). Patient and medical data is extracted into structured fields (e.g., name, phone, diagnosis). Data is logged into a Google Sheet for records. A Google Docs medical report is generated using a predefined template. The report is exported as PDF and emailed to stakeholders (e.g., managers or sales team). This template supports custom AI models, customizable Google Docs templates, and flexible filtering based on sender email. 🛠️ Features Gmail email trigger (customizable sender filter) AI-powered diagnosis parsing using Gemini (easily switchable to OpenAI or others) Google Sheets log Google Docs templated report (auto-filled) PDF export and email sending Full flexibility & customization 🔧 Requirements Before using this template, you'll need: A connected Gmail account (to receive diagnosis emails) A valid Google Sheets integration (create your own sheet with the desired columns) A Google Docs template document that includes placeholder tags like {{patient_name}}, {{date}}, etc. A Gemini or OpenAI API connection for the AI agent (fully customizable) Note: You must replace all Google Drive, Docs, and Sheets references with your own documents. This template does not grant access to the original creator's files. ⚙️ Customization Tips In the Gmail Trigger node, change the sender filter to match the doctor’s email you want to process. Modify the AI prompt if your use case needs different extracted fields. Replace the Google Docs template link with your own file and customize its structure and variables. Change recipient email addresses in the final Gmail node to notify the correct team members. Optional: Add fallback flows or error branches for when AI fails or input is malformed. 🧠 Use Case Examples Medical tourism agencies auto-generating patient reports for incoming diagnosis summaries Clinics storing structured data from messy email inputs Sales teams instantly notified of new leads with completed medical summaries
by Rully Saputra
Automate Lighthouse report alerts to messenger and Google Sheets Who’s it for This workflow is ideal for developers, SEO specialists, performance engineers, and digital agencies who want to continuously monitor website performance using Core Web Vitals. It’s also perfect for product or infrastructure teams that need real-time alerts when a site underperforms and want a historical log of reports in Google Sheets. What it does This automation periodically fetches a Lighthouse report from the PageSpeed Insights API, checks whether any of the Core Web Vitals (CWV) scores fall below a defined threshold, and sends a notification to Telegram (or any other preferred messenger). It also logs the summarized report in a specific row within a Google Spreadsheet for long-term tracking and reporting. The CWV audit results are processed using JavaScript and passed through a summarization step using Gemini Chat, making the audit descriptions concise and actionable. How to set up Configure the Schedule Trigger node to run at your preferred frequency. Set your target URLs and API Key, then connect the HTTP Request node to Google PageSpeed Insights. Update the JavaScript Code node to filter and parse only CWV metrics. Define thresholds in the IF Node to trigger Telegram messages only when needed. Connect your Telegram (or other messenger) credentials. Set up the Google Sheets node by linking your account and choosing the sheet and range to log data. Requirements Google account with access to Google Sheets Telegram bot token or any preferred messenger API key for PageSpeed Insights Gemini Chat integration (optional for summarization, can be replaced or removed) How to customize the workflow Swap Telegram for Slack, Discord, or email by replacing the Send Notification node. Adjust the CWV thresholds or include other Lighthouse metrics by modifying the IF Node and JavaScript logic. Add multiple URLs to monitor by introducing a loop or extending the schedule with different endpoints. Replace the Gemini Chat model with OpenAI, Claude, or your custom summarizer if needed.