Google Sheets Workflows
11 Ergebnisse — ausschließlich quellenverknüpfte n8n-Referenzen
W
Monitor weekly LLM share of voice with OpenRouter, Google Sheets, and email reports
Quick overview This workflow runs weekly to query multiple LLMs via OpenRouter with prompts from Google Sheets, analyzes brand mentions and domain citations, aggregates weekly Share of Voice metrics, and emails an HTML visibility report. How it works Runs every week on a schedule trigger. Reads active prompts from a Google Sheets “prompts” tab and expands them into multiple model runs (including repeated runs per model) to create OpenRouter chat completion requests. Sends each request to OpenRouter, normalizes the response into answer text and extracted citation URLs, and appends the results to the Google Sheets “runs” tab. Loads brand definitions from the Google Sheets “brands” tab, scans the latest successful runs for brand mentions and matching citation domains, and writes one mention/citation record per brand-run to the “mentions” tab. Aggregates the mention and citation results into weekly metrics per model (and an “all models” total), including mention rate, citation rate, Share of Voice, and average first-mention position, and appends them to the “weekly_agg” tab. Builds an HTML report that compares the current week to the previous week, flags alerts (SoV drop > 5pp or citat
WCollect post-purchase product reviews with WooCommerce, Google Sheets, and SMTP
Quick overview This workflow sends post-purchase review request emails for WooCommerce orders, stores expiring form links in Google Sheets, optionally shortens links with Dub.co and delays delivery, serves a hosted rating form via n8n webhooks, and submits collected reviews back to WooCommerce. How it works Receives an order completion event via a WooCommerce webhook or an external POST webhook and returns a 200 OK response. Normalizes the incoming order payload, generates a unique form token and expiry, and builds a customer-specific review form URL. Fetches each product’s image and permalink from the WooCommerce REST API, aggregates the product list, and appends the form record to a Google Sheets tab. Optionally shortens the form URL using the Dub.co API and optionally waits a configured number of days before sending the message. Renders an HTML email containing the ordered products and the review link and sends it via SMTP to the customer. When the customer opens the review link, looks up the form token in Google Sheets, validates status/expiry, and serves either the multi-product rating form HTML or an error page. When the form is submitted, validates the token again, posts eac
Handle portfolio contact form submissions with webhook, SMTP and Google Sheets
Quick Overview This workflow receives portfolio contact form submissions via a webhook, validates and normalizes the input, then logs the message to Google Sheets and sends a confirmation email via SMTP before returning a JSON success or error response. How it works Receives a POST request on a webhook endpoint for contact form submissions. Validates that name, email, and message are present and within length/format limits, and returns a 400 JSON error response for invalid requests. Normalizes the fields (trim text, lowercase email, set defaults, add timestamp and source) for valid submissions. Appends the submission details to a Google Sheets spreadsheet. Sends a personalized HTML confirmation email to the submitter using SMTP. Returns a 200 JSON success response with basic submission details and CORS headers. Setup Configure the webhook URL in your portfolio contact form and restrict allowed origins/CORS to your domain. Add a Google Sheets OAuth2 credential and set the target spreadsheet and sheet where submissions should be appended. Ensure the Google Sheet has columns that match the fields being written (Name, Email, Subject, Message, Phone, Timestamp, Source). Add an SMTP cred
WReal-Time Security Threat Dashboard with Google Sheets, AI Risk Analysis & Email Alerts
👤 Who it’s for Blue Team leads, CISOs, and SOC managers who want automated visibility into threat metrics, endpoint alerts, and response actions — without needing a full SIEM or BI platform. Great for teams using Modules 1–5 and now ready to report, review, or share BlueOps data across stakeholders. ⚙️ How it works / What it does Fetches threat + response data from up to 5 Google Sheets Aggregates data into four key slices: summary_metrics: Total threats, actions, endpoints daily_trends: Time-based charting top_assets: High-risk endpoints or systems actions_taken: Logged IR activity Generates a clean HTML report and sends via email Logs report summary to a central reporting tracker sheet Optionally converts and stores PDF versions or links 🛠️ How to set up Google Sheets: Connect your live sheets from previous BlueOps modules (M1–M5) Email Setup: Insert sender credentials and recipient(s) Customize Your Charts: Edit the “📈 Format Charts” and “📋 Structure Report Body” nodes Trigger Options: Run weekly, monthly, or on-demand via Webhook/Cron Add PDF Generator (Optional): Use Puppeteer, HTML → PDF services, or internal scripts 📋 Requirements Google account with access to all BlueO
WYouTube to WhatsApp Sales Automation with WordPress, FluentCRM and Whinta
🚀 WhatsApp Automation Template Designed & Developed by Infridet Solutions Private Limited 🔧 Objective: Automate your lead nurturing and sales process from YouTube/Instagram → Landing Page → CRM → Email → WhatsApp → Sales → Deal Closure using tools like: 🌐 WordPress (Landing Page + Fluent Forms) 🧾 Google Sheets (Backup Log) 📩 FluentCRM (Lead Tagging + Email Sequences) 💬 Whinta.com (WhatsApp Messaging API) ⚙️ N8N (Workflow Automation Engine) 🧩 System Flow Overview: Lead Source: YouTube or Instagram CTA Landing Page: Built on WordPress with a story-driven design Form Capture: Fluent Forms with dynamic input fields Data Sync: Backup to Google Sheets Push lead to FluentCRM and tag as New Lead Email Sequence: Warm-up emails (1 to 5) Introduce offer or service WhatsApp Outreach: Send personalized message via Whinta Triggered 1 hour after form fill or last email Sales Follow-Up: Sales team handles replies manually CRM tag updated to Customer upon closing 📁 Folder Structure (Optional Git/Zip File): 📦 WhatsApp-Automation-Infridet/ │ ├── whatsapp-automation-n8n.json # N8N Flowchart Import File ├── email-templates.docx # Warm-up Email Scripts ├── whinta-api-integration.pdf # API Docum
WTrack Amazon Product Prices with ScrapeOps API & Google Sheets Alerts
Amazon Product Price Tracker This workflow automatically monitors Amazon product prices, tracks price changes, and sends alerts when significant price fluctuations occur. Built with ScrapeOps' structured data API, it provides a reliable, maintenance-free solution for price tracking without worrying about anti-bot measures or complex selectors. What This Workflow Does Monitors multiple Amazon products simultaneously using their ASINs Calculates both absolute and percentage price changes Sends customizable email alerts when prices cross defined thresholds Maintains a historical record of all price data for trend analysis Updates a Google Sheets with the latest price information Prerequisites A ScrapeOps API key (register at https://scrapeops.io) Google account for Google Sheets integration SMTP email configuration for alerts Setup Instructions Spreadsheet Setup Make a copy of the template spreadsheet: https://docs.google.com/spreadsheets/d/1hRv-TBXrpN6rkIU65WorttNHt-IPWas_An0sF4Of39U Add your Amazon product ASINs in the "Products to Monitor" sheet Set your desired alert thresholds for price increases/decreases Workflow Configuration Add your ScrapeOps API key to the "Setup" node Upda
WTrack n8n Community Topics with Keywords and Save to Google Sheets
This template is designed for community managers, developers, and enthusiasts who want to monitor and capture discussions on the n8n community forum by specific keywords. By tracking new topics that match your provided keyword, the workflow automatically logs them into a Google Sheet, helping you keep a pulse on trending discussions and manage community insights effortlessly. How it Works Keyword Monitoring: The workflow continuously monitors the n8n community forum for new topics containing your specified keyword. Data Extraction: When a matching topic is found, relevant details such as id, title, URL, and posting time are extracted. Google Sheets Integration: The extracted information is automatically appended as a new row in your Google Sheet, providing an organized log of community discussions. Alert Option: Optionally, you can add notifications (e.g., Slack messages or emails) to alert you when a new topic is captured, ensuring you never miss an important update. Set Up Steps Import the Workflow: Download and import the workflow into your n8n instance. Configure Keyword Monitoring: In the HTTP Request node, set your desired keyword to filter the n8n community topics. Set Up Go
WUnique QRcode coupon assignment and validation for Lead Generation with SuiteCRM
This workflow is designed to manage the assignment and validation of unique QR code coupons within a lead generation system with SuiteCRM. How it Works This workflow automates the process of assigning unique QR code coupons to leads generated through a form submission, ensuring no duplicates are created, and validating the usage of coupons. Here's how it operates: Webhook Trigger: The workflow starts with a Webhook node that listens for incoming requests containing QR code data. A Set coupon node extracts the QR code value from the request parameters. Validation of QR Code: An If node checks if the QR code exists in the incoming data. If it does, the process proceeds; otherwise, a "No coupon" response is sent back. Coupon Lookup: The Get Lead node queries a Google Sheets document to check if the QR code corresponds to an existing lead. A subsequent Not used? node verifies whether the coupon has already been used by checking the "USED COUPON?" field in the sheet. Lead Duplication Check: When a new lead submits the form (On form submission), the Duplicate Lead? node checks if the email already exists in the system to prevent duplicates. Coupon Assignment: If the lead is not a duplica
Notify about Google Sheet changes in Slack and email
To notify by Slack and mail all modification on a Google Sheet
Create an invoice in Google Sheets based on Typeform submission
This form takes data from a Typeform submission and creates an invoice on Google Sheets
Send Typeform results to Google Sheet, Slack and email
Trigger on new Typeform form submission Write data to Google Sheet Check severity of problem If very severe post message to Slack If not so severe just send an email Assumptions Google Sheet Sheet in Spreadsheet called "Problems". Columns Names: Name Email Severity Problem Example Sheet: https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldTfp5lvh8HtS0-pNXH66b7qGZIiGRU Typeform Typeform formular with questions named exactly like the columns of the Google Sheet.