Monitor core web vitals with Lighthouse, Gemini AI, Telegram alerts & Google Sheets
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.
By Rully SaputraAutomated content & promo tweet scheduler with Gemini AI and Google Sheets
Twitter Automation (n8n Template) 🚀 What it does Posts a unique tweet every 2 hours 70% content tweets (10 proven templates) 30% promo tweets pulled from Google Sheets Logs past tweets to avoid duplicates --- ✅ Requirements n8n Google Sheets with 2 tabs: posts → log of past tweets (PAST TWEETS, Date) promo → promo source (name, last_posted, optional extra fields) Twitter (X) account with OAuth2 write access Gemini API key (for text generation) --- ⚡ Results Automated motivational posts Automated promo posts --- 🔄 How It Works Triggers every 2 hours (optional: random delay up to 120 min). Randomly selects content (70%) or promo (30%). Content path: checks posts, generates tweet, logs new one. Promo path: picks row from promo, generates tweet, updates last_posted. Posts to Twitter automatically. --- 🎯 Content Templates Transformation · Hook–List–Takeaway · Interesting Fact · Metaphor · Contrast · Motivation · Triad · Comparison · 80/20 Rule · Callout --- ⚙️ Customization | Setting | Where | Example | |---------|-------|---------| | Ads probability | Code node | Change Math.random() < 0.3 → 0.2 for 20% | | Templates | Code node | Edit the templates array | | Cadence | Schedule Trigger | Cron or fixed hours | | Random delay | Time randomizer | Enable node (0–120 mins) | --- 🛠️ Troubleshooting | Issue | Fix | |-------|-----| | Repeated tweets | Ensure posts has column PAST TWEETS | | Not posting | Reconnect Twitter creds with write access | | Promo never used | Increase ads probability (e.g., 0.4) |
By Jay Emp0SmartLead sheet sync: auto-capture client inquiries to Google Sheets
Capture client inquiries from any webform and send them straight into Google Sheets — automatically. No code. No headaches. 🚀 What It Does: SmartLead Sheet Sync is a plug-and-play automation that: • Instantly receives form submissions from your website or funnel via a webhook • Extracts and formats key info (like name, email, business name, message, timeline, budget) • Logs everything into a Google Sheet — in real time Perfect for freelancers, digital agencies, consultants, and productized service owners who want to stop copying/pasting leads manually. ⸻ ⚙️ What You Get: • A pre-built 3-step automation (Webhook → Code → Google Sheet) • Ready-to-use setup in n8n (free and open source automation tool) • Clean, editable JavaScript code to format your incoming lead data • Google Sheet connection that logs every new inquiry in its own row
By David Olusola