Back to Catalog

Monitor core web vitals with Lighthouse, Gemini AI, Telegram alerts & Google Sheets

Rully SaputraRully Saputra
665 views
2/3/2026
Official Page

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

  1. Configure the Schedule Trigger node to run at your preferred frequency.

  2. Set your target URLs and API Key, then connect the HTTP Request node to Google PageSpeed Insights.

  3. Update the JavaScript Code node to filter and parse only CWV metrics.

  4. Define thresholds in the IF Node to trigger Telegram messages only when needed.

  5. Connect your Telegram (or other messenger) credentials.

  6. 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.

Monitor Core Web Vitals with Lighthouse, Gemini AI, and Telegram Alerts

This n8n workflow automates the process of monitoring Core Web Vitals for a specified URL using Google Lighthouse, summarizing the results with Google Gemini AI, and sending alerts via Telegram. It also logs the Lighthouse scores to a Google Sheet for historical tracking.

What it does

  1. Schedules Checks: Triggers at a set interval (e.g., daily, weekly) to perform web vital checks.
  2. Fetches Lighthouse Report: Makes an HTTP request to the Google Lighthouse API to get a performance report for a predefined URL.
  3. Extracts Key Metrics: Processes the Lighthouse report to extract crucial Core Web Vitals scores (Performance, Accessibility, Best Practices, SEO).
  4. Filters for Low Scores: Checks if any of the extracted scores fall below a predefined threshold (e.g., 90).
  5. Summarizes with AI (if needed): If any scores are below the threshold, it uses Google Gemini AI (via a LangChain Summarization Chain) to create a concise summary of the Lighthouse report, highlighting areas for improvement.
  6. Sends Telegram Alert: If scores are low, it sends a detailed alert message to a specified Telegram chat, including the URL, the low scores, and the AI-generated summary.
  7. Logs to Google Sheets: Appends the current date, URL, and all Lighthouse scores to a Google Sheet for long-term monitoring and analysis, regardless of whether an alert was sent.

Prerequisites/Requirements

  • n8n Instance: A running n8n instance.
  • Google Lighthouse API Key: Access to the Google Lighthouse API (or a similar service if modified).
  • Google Sheets Account: A Google account with access to Google Sheets. You'll need to create a new spreadsheet or specify an existing one.
  • Telegram Bot Token: A Telegram Bot API token and the Chat ID where you want to receive alerts.
  • Google Gemini AI (LangChain) Credentials: Credentials for Google Gemini AI to be used with the LangChain nodes.

Setup/Usage

  1. Import the Workflow: Import the provided JSON into your n8n instance.
  2. Configure Credentials:
    • Google Sheets: Set up your Google Sheets credential. You'll need to authorize n8n to access your Google Sheets.
    • Telegram: Set up your Telegram credential with your Bot Token.
    • Google Gemini Chat Model: Configure your Google Gemini AI credentials within the Google Gemini Chat Model node.
  3. Customize Nodes:
    • Schedule Trigger (Node 839): Adjust the schedule as needed (e.g., daily, weekly, specific times).
    • HTTP Request (Node 19):
      • Update the URL for which you want to run Lighthouse audits.
      • Ensure the Lighthouse API endpoint and any required API keys are correctly configured.
    • Code (Node 834): This node extracts and formats the data from the Lighthouse report. Review and adjust if the Lighthouse API response structure changes or if you need to extract different metrics.
    • If (Node 20): Modify the conditions to set your desired thresholds for Core Web Vitals (e.g., performance < 90).
    • Summarization Chain (Node 1121): Ensure the prompt for the AI summarization is appropriate for your needs.
    • Telegram (Node 49):
      • Enter the Chat ID where you want the alerts to be sent.
      • Customize the message template to include the information you deem most relevant.
    • Google Sheets (Node 18):
      • Specify the Spreadsheet ID and Sheet Name where the data should be logged.
      • Ensure the column headers in your Google Sheet match the data being sent from the Code node (e.g., Date, URL, Performance, Accessibility, Best Practices, SEO).
  4. Activate the Workflow: Once configured, activate the workflow to start monitoring your web vitals.

Related Templates

Dynamic Hubspot lead routing with GPT-4 and Airtable sales team distribution

AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) 🧠 AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative β€” all powered by AI logic, sir. --- πŸ’‘ Key Advantages ⚑ Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. 🧠 AI Qualification Engine An OpenAI-powered Agent evaluates the lead’s industry, region, and needs to generate a persona summary and routing rationale. πŸ“Š Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. πŸ’¬ Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. πŸ” Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. --- βš™οΈ How It Works HubSpot Trigger – Captures a new lead as soon as it’s created in HubSpot. Fetch Contact Data – Retrieves all relevant fields like name, company, and industry. Clean & Format Data – A Code node standardizes and structures the data for consistency. Airtable Record Creation – Logs the lead data into the β€œLeads” table for centralized tracking. AI Agent Qualification – The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update – Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification – Sends a real-time message tagging the rep with lead info. Gmail Notification – Sends a personalized handoff email with context and follow-up actions. HubSpot Sync – Updates the original contact in HubSpot with the assignment details and AI rationale, sir. --- πŸ› οΈ Setup Steps Trigger Node: HubSpot β†’ Detect new leads. HubSpot Node: Retrieve complete lead details. Code Node: Clean and normalize data. Airtable Node: Log lead info in the β€œLeads” table. AI Agent Node: Process lead and match with sales team. Slack Node: Notify the designated representative. Gmail Node: Email the rep with details. HubSpot Node: Update CRM with AI summary and allocation status, sir. --- πŸ” Credentials Required HubSpot OAuth2 API – To fetch and update leads. Airtable Personal Access Token – To store and update lead data. OpenAI API – To power the AI qualification and matching logic. Slack OAuth2 – For sending team notifications. Gmail OAuth2 – For automatic email alerts to assigned reps, sir. --- πŸ‘€ Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir --- πŸ’¬ Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular β€” perfect for scaling across global sales teams, sir.

MANISH KUMARBy MANISH KUMAR
113

Track daily moods with AI analysis & reports using GPT-4o, Data Tables & Gmail

Track your daily mood in one tap and receive automated AI summaries of your emotional trends every week and month. Perfect for self-reflection, wellness tracking, or personal analytics. This workflow logs moods sent through a webhook (/mood) into Data Tables, analyzes them weekly and monthly with OpenAI (GPT-4o), and emails you clear summaries and actionable recommendations via Gmail. βš™οΈ How It Works Webhook – Mood β†’ Collects new entries (πŸ™‚, 😐, or 😩) plus an optional note. Set Mood Data β†’ Adds date, hour, and note fields automatically. Insert Mood Row β†’ Stores each record in a Data Table. Weekly Schedule (Sunday 20:00) β†’ Aggregates the last 7 days and sends a summarized report. Monthly Schedule (Day 1 at 08:00) β†’ Aggregates the last 30 days for a deeper AI analysis. OpenAI Analysis β†’ Generates insights, patterns, and 3 actionable recommendations. Gmail β†’ Sends the full report (chart + AI text) to your inbox. πŸ“Š Example Auto-Email Weekly Mood Summary (last 7 days) πŸ™‚ 5 β–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆβ–ˆ 😐 2 β–ˆβ–ˆβ–ˆβ–ˆ 😩 0 Average: 1.7 (Positive πŸ™‚) AI Insights: You’re trending upward this week β€” notes show that exercise days improved mood. Try keeping short walks mid-week to stabilize energy. 🧩 Requirements n8n Data Tables enabled OpenAI credential (GPT-4o or GPT-4 Turbo) Gmail OAuth2 credential to send summaries πŸ”§ Setup Instructions Connect your credentials: Add your own OpenAI and Gmail OAuth2 credentials. Set your Data Table ID: Open the Insert Mood Row node and enter your own Data Table ID. Without this, new moods won’t be stored. Replace the email placeholder: In the Gmail nodes, replace your.email@example.com with your actual address. Deploy and run: Send a test POST request to /mood (e.g. { "mood": "πŸ™‚", "note": "productive day" }) to log your first entry. ⚠️ Before activating the workflow, ensure you have configured the Data Table ID in the β€œInsert Mood Row” node. 🧠 AI Analysis Interprets mood patterns using GPT-4o. Highlights trends, potential triggers, and suggests 3 specific actions. Runs automatically every week and month. πŸ”’ Security No personal data is exposed outside your n8n instance. Always remove or anonymize credential references before sharing publicly. πŸ’‘ Ideal For Personal mood journaling and AI feedback Therapists tracking client progress Productivity or self-quantification projects πŸ—’οΈ Sticky Notes Guide 🟑 Mood Logging Webhook POST /mood receives mood + optional note. ⚠️ Configure your own Data Table ID in the β€œInsert Mood Row” node before running. 🟒 Weekly Summary Runs every Sunday 20:00 β†’ aggregates last 7 days β†’ generates AI insights + emails report. πŸ”΅ Monthly Summary Runs on Day 1 at 08:00 β†’ aggregates last 30 days β†’ creates monthly reflection. 🟣 AI Analysis Uses OpenAI GPT-4o to interpret trends and recommend actions. 🟠 Email Delivery Sends formatted summaries to your inbox automatically.

Jose CastilloBy Jose Castillo
105

Create, update, and get a person from Copper

This workflow allows you to create, update, and get a person from Copper. Copper node: This node will create a new person in Copper. Copper1 node: This node will update the information of the person that we created using the previous node. Copper2 node: This node will retrieve the information of the person that we created earlier.

Harshil AgrawalBy Harshil Agrawal
603