Loading page
How it Works This workflow automatically monitors your Google Ads campaigns every day, analyzing performance with AI-powered scoring to identify scaling opportunities and catch issues before they drain your budget. Each morning at 9 AM, it fetches all active campaign data including clicks, impressions, conversions, costs, and conversion rates from your Google Ads account. The AI analysis engine evaluates four critical dimensions: CTR (click-through rate) to measure ad relevance, conversion rate to assess landing page effectiveness, cost per conversion to evaluate profitability, and traffic volume to identify scale-readiness. Each campaign receives a performance score (0-100 points) and is automatically categorized as Excellent (75+), Good (55-74), Fair (35-54), or Underperforming (0-34). High-performing campaigns trigger instant Slack alerts to your PPC team with detailed scaling recommendations and projected ROI improvements, while underperforming campaigns generate urgent alerts with specific optimization actions. Every campaign is logged to your Google Sheets dashboard with daily metrics, and the system generates personalized email reports—action-oriented scaling plans for top performers and troubleshooting guides for campaigns needing attention. The entire analysis takes minutes, providing your team with daily intelligence reports that would otherwise require hours of manual spreadsheet work and data analysis. --- Who is this for? PPC managers and paid media specialists drowning in campaign data and manual reporting Marketing agencies managing multiple client accounts needing automated performance monitoring E-commerce brands running high-spend campaigns who can't afford budget waste Growth teams looking to scale winners faster and pause losers immediately Anyone spending $5K+ monthly on Google Ads who needs data-driven optimization decisions --- Setup Steps Setup time: Approx. 15-25 minutes (credential configuration, dashboard setup, alert customization) Requirements: Google Ads account with active campaigns Google account with a tracking spreadsheet Slack workspace SMTP email provider (Gmail, SendGrid, etc.) Create a Google Sheets dashboard with two tabs: "Daily Performance" and "Campaign Log" with appropriate column headers. Set up these nodes: Schedule Daily Check: Pre-configured to run at 9 AM daily (adjust timing if needed). Fetch Google Ads Data: Connect your Google Ads account and authorize API access. AI Performance Analysis: Review scoring thresholds (CTR, conversion rate, cost benchmarks). Route by Performance: Automatically splits campaigns into high-performers vs. issues. Update Campaign Dashboard: Connect Google Sheets and select your "Daily Performance" tab. Log All Campaigns: Select your "Campaign Log" tab for historical tracking. Slack Alerts: Connect workspace and configure separate channels for scaling opportunities and performance issues. Generate Action Plan: Customize email templates with your brand voice and action items. Email Performance Report: Configure SMTP and set recipient email addresses. Credentials must be entered into their respective nodes for successful execution. --- Customization Guidance Scoring Weights: Adjust point values for CTR (30), conversion rate (35), cost efficiency (25), and volume (10) in the AI Performance Analysis node based on your business priorities. Performance Thresholds: Modify the 75-point Excellent threshold and 55-point Good threshold to match your campaign quality distribution and industry benchmarks. Benchmark Values: Update CTR benchmarks (5% excellent, 3% good, 1.5% average) and conversion rate targets (10%, 5%, 2%) for your industry. Alert Channels: Create separate Slack channels for different alert types or route critical alerts to Microsoft Teams, Discord, or SMS via Twilio. Email Recipients: Configure different recipient lists for scaling alerts (executives, growth team) vs. optimization alerts (campaign managers). Schedule Frequency: Change from daily to hourly monitoring for high-spend campaigns, or weekly for smaller accounts. Additional Platforms: Duplicate the workflow structure for Facebook Ads, Microsoft Ads, or LinkedIn Ads with platform-specific nodes. Budget Controls: Add nodes to automatically pause campaigns exceeding cost thresholds or adjust bids based on performance scores. --- Once configured, this workflow will continuously monitor your ad spend, identify opportunities worth thousands in additional revenue, and alert you to issues before they waste your budget—transforming manual reporting into automated intelligence. --- Built by Daniel Shashko Connect on LinkedIn
by Daniel ShashkoScrape physician profiles from BrowserAct to Google Sheets This workflow automates the process of building a targeted database of healthcare providers by scraping physician details for a specific location and syncing them to your records. It leverages BrowserAct to extract data from healthcare directories and ensures your database stays clean by preventing duplicate entries. Target Audience Medical recruiters, pharmaceutical sales representatives, lead generation specialists, and healthcare data analysts. How it works 1. Define Location: The workflow starts by setting the target Location and State in a Set node. 2. Scrape Data: A BrowserAct node executes a task (using the "Physician Profile Enricher" template) to search a healthcare directory (e.g., Healow) for doctors matching the criteria. 3. Parse JSON: A Code node takes the raw string output from the scraper and parses it into individual JSON objects. 4. Update Database: The workflow uses a Google Sheets node to append new records or update existing ones based on the physician's name, preventing duplicates. 5. Notify Team: A Slack node sends a message to a specific channel to confirm the batch job has finished successfully. How to set up 1. Configure Credentials: Connect your BrowserAct, Google Sheets, and Slack accounts in n8n. 2. Prepare BrowserAct: Ensure the Physician Profile Enricher template is saved in your BrowserAct account. 3. Setup Google Sheet: Create a new Google Sheet with the required headers (listed below). 4. Select Spreadsheet: Open the Google Sheets node and select your newly created file and sheet. 5. Set Variables: Open the Define Location node and input your target Location (City) and State. 6. Configure Notification: Open the Slack node and select the channel where you want to receive alerts. Google Sheet Headers To use this workflow, create a Google Sheet with the following headers: Name Specialty Address Requirements BrowserAct account with the Physician Profile Enricher template. Google Sheets account. Slack account. How to customize the workflow 1. Change the Data Source: Modify the BrowserAct template to scrape a different directory (e.g., Zocdoc or WebMD) and update the Google Sheet columns accordingly. 2. Switch Notifications: Replace the Slack node with a Microsoft Teams, Discord, or Email node to suit your team's communication preferences. 3. Enrich Data: Add an AI Agent node after the Code node to format addresses or research the specific clinics listed. Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates --- Workflow Guidance and Showcase Video #### Automate Medical Lead Gen: Scrape Healow to Google Sheets & Slack
by Madame AI Team | KaiDescription: Automate your entire supplier negotiation process with this AI-driven workflow that intelligently drafts, refines, and sends negotiation emails . Using advanced LLM reasoning and multi-angle strategies , it generates high-converting negotiation messages tailored to each supplier scenario. The workflow tracks replies, sends smart follow-ups , and logs outcomes automatically for full visibility. Perfect for procurement teams looking to reduce costs and eliminate manual back-and-forth communication . What This Template Does: Triggers when a new supplier entry is added to Google Sheets. Validates and structures supplier, product, and pricing data. Generates 3 AI-powered negotiation email drafts using different strategies. Selects the best-performing draft based on scoring logic. Refines the draft using AI self-critique for better tone and clarity. Sends the final negotiation email to the supplier via Gmail. Waits 24 hours and checks for supplier replies automatically. Detects whether a reply is received and routes the workflow accordingly. Sends an optimized follow-up email if no response is received. Logs negotiation details and outcomes in Notion. Updates Google Sheets with final status, pricing, and savings. Notifies the procurement team via Slack with results or retry alerts. Key Benefits: Fully autonomous negotiation process with zero manual effort AI-optimized messaging increases chances of better pricing Smart follow-ups ensure no supplier opportunity is missed Centralized tracking across Sheets, Notion, and Slack Data-driven decision making with scoring and insights Scalable procurement operations for high-volume supplier outreach Features: Google Sheets trigger-based workflow AI-powered negotiation using GPT-4o (multi-angle + self-critique) Automated email sending and reply detection via Gmail Intelligent retry logic using DPO-style optimization Notion logging for audit trails and reporting Slack alerts for real-time team notifications Built-in validation and structured data processing Requirements: Google Sheets account (for supplier data tracking) Gmail account (for sending and receiving emails) OpenAI API key (for AI-generated negotiation logic) Notion account (for logging negotiation outcomes) Slack account (for team notifications) Target Audience: Procurement and sourcing teams E-commerce and retail businesses managing suppliers Startups scaling vendor negotiations Automation agencies building AI-driven business workflows
by Rahul Joshi