Quick Overview This workflow polls Gmail for unread ecommerce review notification emails, extracts key review details, checks Google Sheets to prevent duplicate processing, uses OpenAI to classify sentiment and urgency, posts routed alerts to Slack, and logs each processed review and its AI metadata back to Google Sheets. How it works Polls Gmail every minute for unread emails with the “Reviews” label. Extracts the message ID, received time, customer details, product name, star rating, and review text from the email content. Reads the existing review audit log from Google Sheets and skips processing if the message ID already exists or the review text is too short. Sends the review details to OpenAI to return a JSON classification with sentiment, urgency, themes, summary, suggested action, and a sentiment score. Routes the review based on sentiment and urgency, escalating low-star or high-urgency negative reviews and optionally notifying on positive reviews. Posts a formatted alert to the selected Slack channel when notification is enabled. Appends the review (including route, AI fields, and whether Slack was notified) to Google Sheets as an audit log.
Tags
Google SheetsOpenAISlackRelated workflows
See all Google Sheets→WAnalyze Website Backlinks with Top Backlink Checker API and Google Sheets Logging
Backlink Checker with Google Sheets Logging (Seo) Description: This workflow helps you analyze top backlinks using Semrush API and logs the results directly into Google Sheets for easy SEO tracking and reporting. It integrates the Top Backlink Checker API from RapidAPI, providing in-depth backlink analysis, and combines that with Google Sheets for efficient data storage and tracking. Node-by-Node Explanation: 1. On form submission Captures the website URL submitted by the user through a form. This node triggers the workflow when the form is filled with a website URL. The Top Backlink Checker API (via RapidAPI) is used to check backlinks after this step. 2. Check webTraffic Sends a request to the Top Backlink Checker API to gather traffic data for the submitted website. This includes important metrics like visits, bounce rate, and more, which will later be stored in Google Sheets for analysis. 3. Reformat output Extracts and re-formats the traffic data received from the Top Backlink Checker API. This node cleans and structures the raw data for easier processing, ensuring it is usable for later stages in the workflow. 4. Reformat Processes the backlink data received from the Top Back
WSEO Keyword Difficulty & SERP Analysis with RapidAPI and Google Sheets
🚀 Automated Keyword Difficulty & SERP Checker with Google Sheets Integration Description: This n8n workflow automates keyword SEO analysis by collecting user input via a form, querying the Difficulty Checker API on RapidAPI to retrieve keyword difficulty and SERP data, and storing the results in Google Sheets for further SEO tracking and decision-making. 🔗 Node-by-Node Breakdown 1. 📝 On form submission Triggers the workflow by capturing keyword and country from a user-submitted form. 2. 🌐 Keyword Difficulty Checker Makes a POST request to the Keyword Difficulty Checker API on RapidAPI to fetch keyword difficulty index and SERP results. 3. 📦 Reformat 1 Extracts only the keywordDifficulty value from the API response JSON. 4. 📊 Keyword Difficulty Checker1 Appends the keyword and its difficulty index to the "backlink overflow" Google Sheet for structured keyword tracking. 5. 📦 Reformat 2 Extracts the serpResults list from the API response for additional ranking data. 6. 📄 SERP Results Stores the extracted SERP data into the "backlinks" Google Sheet for ranking comparison and analysis. ✅ Benefits of This Workflow Automation of SEO research* — Eliminates manual keyword analysis b
WAutomate Lead Intake & Deduplication with Google Forms, Sheets and GoHighLevel CRM
Description: Eliminate duplicate entries and streamline your lead management process with this n8n workflow template! Automatically capture new form submissions, check against existing records, update duplicates, and sync leads seamlessly into GoHighLevel (GHL) CRM and your Google Sheets database. This automation monitors Google Form submissions in real time, verifies if a lead already exists, and routes them accordingly: ✅ New leads are created in GoHighLevel and logged in your master database. ♻️ Duplicates are updated with the latest details and tracked in a dedicated duplicate log. Perfect for sales, marketing, and operations teams that need clean, accurate, and up-to-date lead records without manual effort. What This Template Does 📥 Captures new lead form submissions from Google Sheets 🔎 Checks existing records to detect duplicate entries 🆕 Creates new contacts in GoHighLevel CRM for unique leads ♻️ Updates existing GHL contacts with fresh submission details 📂 Logs new leads in a master database spreadsheet 📑 Tracks duplicate leads in a dedicated log for analytics 🌟 Fully automated: ensures a clean, organized, and deduplicated lead pipeline How It Works Google Sheets Tri