Solutions Showcase: part 2 of 7

The complete text of the site in 7 parts. Parts:

Part 1 has the contents list of every section and case study.

Case studies in full

Looker Studio: Facebook Ads Dashboard

A Looker Studio dashboard rolling up Facebook ad spend, revenue, ROAS and profit margin across a 9-month window.

Section: Looker Studio

01. Project Overview

This dashboard is part of a larger multi-channel paid media reporting setup. It provides a dedicated view of Facebook advertising performance, allowing marketing and finance teams to review campaign-related spending, revenue, and performance indicators in one place.

Paid Media Reporting

Part of a larger multi-channel Looker Studio report, this page rolls up spend, revenue and profit for Facebook campaigns specifically, alongside a daily revenue-vs-spend trend.

The dashboard runs on Looker Studio so paid media and finance read from the same live numbers instead of a separate export from Meta.

02. The Challenge

Facebook advertising performance involves several interconnected metrics. Reviewing spend, revenue, purchases, orders, ROAS, and profit margin separately makes it harder to understand overall performance across a reporting period.

A consolidated dashboard helps make these indicators easier to review and compare.

03. The Solution

A dedicated Facebook Ads overview was created in Looker Studio, combining key financial and performance metrics with a revenue-versus-spend trend chart.

The dashboard includes:

04. Dashboard Overview

The dashboard presents high-level KPIs at the top and a revenue-versus-spend chart below. This makes it easier to scan the main figures and observe how spending and revenue move over time.

Image: Facebook performance overview across a 9-month window: spend, revenue, ROAS and profit margin alongside a daily revenue-vs-spend trend.

Dashboard highlights:

These figures are reproduced from the supplied dashboard screenshot. The displayed profit and profit-margin figures may require reconciliation before being used for financial decisions.

05. Technology and Integration

The report provides a dedicated Facebook performance view within the wider multi-channel reporting environment.

06. Outcome

The dashboard brings Facebook advertising and financial indicators into one reporting interface. It supports performance reviews by making spend, revenue, order volume, and ROAS easier to compare without relying solely on separate platform views or manual exports.

Page · Plain text

Power BI: One Live View of a Multi-Site Clinic Network

A governed Power BI model unifying scheduling, EHR, billing and finance across four systems into two role-based dashboards refreshed every morning.

Section: Power BI

Power BI Case Study · Healthcare

Multi-site clinic network: scheduling, EHR, billing & finance unified · 6-week engagement

Reports that used to take days across sites now land by 6am, and we act on them the same morning.

Operations Director

The network ran on four disconnected systems: scheduling, the EHR, billing/claims and finance. Leadership could never see patient flow, provider utilisation and revenue-cycle health in the same place, and each site’s monthly report was rebuilt by hand. I consolidated all four into one governed Power BI model behind two role-based dashboards, refreshed automatically every morning, turning days of manual reporting into a screen the team reads with their coffee.

What Was Leaking

Dashboard One: Patient Flow & Utilisation

Appointments vs utilisation, department mix, top sites, a day-by-hour utilisation heat map and capacity gauge.

Image: Patient Flow & Utilisation: Executive Overview

Dashboard Two: Revenue Cycle & Claims

Billed vs collection rate, a claims funnel, AR aging buckets and net revenue by payer.

Image: Revenue Cycle & Claims

How It’s Built

StageWhat We BuiltTools
Sources4 systems: Scheduling · EHR · Billing · GLREST / API / file connectors
CleanKey standardisationPower Query
ModelStar schema, shared date table, DAXPower BI model + DAX
SecureRLS by site, per-site accessRLS roles
Deliver06:00 refresh via gateway & servicePower BI Service + gateway

The Impact

After six weeks

With utilisation and no-shows visible by site and hour, the network reallocated clinic slots and tightened reminders, lifting utilisation five points while trimming no-shows, and replacing days of manual work with an automatic 6am refresh reconciled to the ledger.

Page · Plain text

LoanPro MCP Server: AI-Powered Financial Data Access & Account Analysis

Connecting AI assistants to LoanPro through a secure Model Context Protocol server for customer lookups, loan data retrieval, and past-due account triage.

Section: AI Agents

Overview

Accessing customer and loan information in LoanPro previously required users to search records and review account details manually. A custom MCP server now connects AI assistants such as Claude with LoanPro, allowing users to retrieve financial information and review accounts through conversational requests.

The Problem

Loan and customer information is stored inside LoanPro, while users want to access and understand it through conversational AI. Manually searching for customers, opening loan profiles, and reviewing transactions and balances makes account reviews repetitive. Identifying past-due accounts that meet specific balance thresholds also requires retrieving and filtering records. An integration layer was needed to connect AI assistants with LoanPro through controlled API operations.

How It Works

  1. Submit a Request: A user asks Claude to find a customer or review a loan account.
  2. Connect Through MCP: The AI client connects to the Go-based MCP server using SSE or stdio.
  3. Select a Tool: The assistant selects an available tool, such as search_customers, and provides the required arguments.
  4. Process the Request: The server prepares the corresponding LoanPro API operation.
  5. Retrieve Financial Data: The server requests customer, loan, transaction, or balance information from LoanPro.
  6. Normalize the Response: Go processes the returned JSON data and handles inconsistent identifier formats.
  7. Apply Review Logic: Available tools and predefined prompts support customer reviews and past-due account filtering.
  8. Return Results: The processed information is sent back to the AI assistant for a readable response or account summary.

Architecture flow:

Tech Stack

ToolPurpose
GoMCP server and request processing.
MCPConnects AI assistants with LoanPro tools.
LoanPro APIRetrieves customer and financial records.
ClaudeConversational AI interface.
DockerContainerized deployment.

The team can continue using LoanPro while accessing its selected capabilities through a compatible AI assistant.

Where This Pattern Applies

This solution is not limited to loan management. The same approach can connect AI assistants with business platforms through APIs.

Example — Insurance: An AI assistant can retrieve policyholder records, access claim information, and prepare summaries for review.

Other applications include:

The general pattern is to connect an AI assistant to a business API through a dedicated server, expose specific tools, retrieve relevant data, and return structured results. The API, available tools, and business rules change according to the platform.

Page · Plain text

AI-Powered Facebook Content Generation Engine

An automated content generation system that transforms viral social media posts into original, branded creatives for more than 100 Facebook pages using n8n, Airtable, and AI agents.

Section: n8n Automations

Overview

This solution makes it easier to create and manage content for more than 100 Facebook pages. Airtable is used as the main workspace, while n8n handles the automation. The system collects source content, rewrites captions, recreates images, and adds branding for each page. Virtual assistants can then review the content and schedule it through Post Planner.

The Problem

Managing content for many Facebook pages takes a lot of time and effort. Virtual assistants have to find trending posts, rewrite captions, recreate images, and add the correct branding for each page. Doing all of this manually makes the process slow and difficult to manage. A single system was needed to bring these tasks together and make content creation easier.

How It Works

  1. Submit Source Content: Virtual assistants add a link to a trending post, meme, or news item in Airtable.
  2. Collect Source Content: n8n retrieves the content and related information from the submitted link.
  3. Rewrite Captions: AI agents rewrite the original captions to create fresh versions.
  4. Recreate Images: AI tools process the original images and create new versions.
  5. Add Page Branding: The system applies the correct templates, logos, and branding for each Facebook page.
  6. Save the Final Content: The generated captions and images are saved in Airtable for review.
  7. Schedule Posts: Virtual assistants review the completed content and schedule it through Post Planner.

Result

The system brings content collection, AI content creation, and page branding together in one workflow.

Tech Stack

Where This Pattern Applies

This approach can help any organization that manages content for multiple social media accounts.

The same approach can be used to collect content, create new versions with AI, add the right branding, and prepare posts for publishing from one central workspace.

Page · Plain text

Weekly Marketing Performance Tracker (Google Sheets)

A Google Sheets weekly tracker that brings Google Analytics traffic and Klaviyo email and SMS performance into one view.

Section: Dashboards & Reporting

1. Project Overview

This project brings acquisition and retention metrics together in a centralized Google Sheets tracker. Marketing teams can review website traffic, customer acquisition, email and SMS sales, and subscriber growth without switching between separate platforms.

Category: Dashboards & Reporting

Tools: Google Sheets, Google Analytics, Klaviyo

2. The Challenge

Marketing performance data was spread across different platforms, making it harder to compare acquisition and retention results in one place.

3. The Solution

A centralized Google Sheets tracker organizes Google Analytics and Klaviyo metrics into weekly and monthly dashboards.

The tracker includes:

4. How It Works

The tracker brings data from both platforms into one reporting view, where the team can compare acquisition and retention metrics over time.

Workflow

Google Analytics + Klaviyo → Consolidated Google Sheets Tracker → Weekly & Monthly Dashboards → Marketing Performance Review

5. Dashboard Highlights

Weekly Dashboard

The weekly dashboard displays traffic sources alongside Klaviyo email and SMS performance. Teams can review weekly changes in website acquisition, sales, and subscriber growth.

Monthly Dashboard

The monthly dashboard provides a broader reporting view for reviewing performance trends over a longer period.

Image: Weekly dashboard tracking Google Analytics traffic by source alongside Klaviyo email and SMS sales and subscriber counts.

6. Business Value

7. Final Outcome

The Weekly Marketing Performance Tracker provides a single reporting view for Google Analytics traffic and Klaviyo email and SMS performance. By organizing these metrics into weekly and monthly dashboards, it makes cross-channel performance easier to review and compare.

Technology Stack: Google Sheets, Google Analytics, Klaviyo

Page · Plain text

AI Task Delegator: Slack to Monday.com

Automating the conversion of Slack requests into structured and assigned Monday.com tasks.

Section: Make Automations

1. Overview

This automation connects Slack with Monday.com to convert qualifying messages into structured tasks. An AI agent extracts task details from the original Slack message, while configured mappings determine the appropriate Monday.com board and task owner. The workflow also creates explicitly listed subtasks and sends a confirmation back to Slack.

2. The Problem

Teams often share work requests through Slack, but important action items can get buried in conversations. Manually converting these requests into Monday.com tasks requires reviewing messages, extracting details, selecting the correct board, and assigning owners. This repetitive process takes time and can result in inconsistent task information or missed action items.

3. How It Works

  1. Capture Slack Event: The workflow detects qualifying Slack messages or reactions through a configured event trigger.
  2. Retrieve Original Message: It retrieves the complete Slack message to provide context for AI processing.
  3. Extract Task Information: The AI agent generates a task title and description and identifies mentioned Slack user IDs and explicitly listed subtasks.
  4. Retrieve User Details: The workflow uses extracted Slack IDs to retrieve the corresponding user information where required.
  5. Determine Board and Owner: Configured user and channel mappings identify the appropriate Monday.com board, group where applicable, and task owner.
  6. Create Monday.com Task: The workflow creates the main task using the extracted title and adds its description and original Slack message context.
  7. Create Subtasks: If the request contains explicitly listed subtasks, the workflow iterates through them and creates them under the main task.
  8. Send Slack Confirmation: After task creation, the workflow sends a confirmation in the original Slack conversation with a link to the Monday.com task.

4. The Result

The automation connects Slack requests directly with Monday.com task management. It reduces manual task entry, structures incoming requests, applies configured board and owner mappings, and preserves the original conversation context. It also supports automatic subtask creation and sends confirmation through Slack.

Execution Metrics

MetricResult
Total Executions4,856
Successful Executions4,826
Failed Executions16
Success Rate99.4%
Average Execution Time0.63 seconds

Metrics are based on the available execution logs and may vary depending on message volume, task complexity, and the number of subtasks processed.

5. Tech Stack

Make: Coordinates the automation, processes Slack events, manages AI extraction, handles routing, and creates Monday.com tasks and subtasks.

Slack: Provides the triggering messages or reactions, original conversation context, user information, and task confirmations.

OpenAI: Uses GPT-4.1 mini and GPT-4.1 nano to extract and structure task information from Slack messages.

Monday.com: Receives the structured tasks, mapped owners, and explicitly listed subtasks.

6. Where This Pattern Applies

This automation pattern can be applied wherever teams receive work requests through communication platforms and need to organize them in task-management systems. Examples include internal operations, customer support, marketing coordination, project management, and administrative task tracking.

Page · Plain text

Contract Intake Tool

AI-Powered Contract Validation, Human Review, Automated Google Drive Filing, Folder Organization, Missing-Term Detection & Document Tracking.

Section: Custom SaaS Platforms

Overview

The Contract Intake Tool is a web app that uses Claude AI to extract key terms from supplier contracts, flags missing information for human review, and automatically files approved contracts into the correct Google Drive folders. It also maintains a record of all filing activities..

Business Problem

Supplier contracts such as hotel, venue, and bus services) Were reviewed and filed manually, making the process time-consuming. Important terms like cancellation clauses, fees, and tax rates could be missed, and contracts sometimes ended up in the wrong Google Drive folders, making them difficult to find later for billing or disputes.

Proposed Solution

Supplier contracts (hotel, venue, bus) were being reviewed and filed by hand. That was slow, and important terms (cancellation clauses, fees, tax rates) could get missed, and contracts sometimes ended up in the wrong Drive folder, making them hard to find later for billing or disputes.

Goal

How It Works

1. Scan

User uploads the PDF and picks a category (Hotel / Venue / Buses / Other). The text is extracted from the PDF and sent to Claude (Anthropic’s AI), which pulls out the specific terms that category requires, e.g. for Hotel: room rate, attrition clause, cancellation terms, tax rate. Each term comes back marked Found or Not Found.

2. Review

Anything Not Found must be manually checked and ticked off by a person before the contract can be filed. The tool never files something incomplete without a human saying it’s okay.

Image: The review screen after a scan: each key term (group name, number of rooms, rate, attrition, cancellation, additional fees and tax rate) with the text found in the contract and a Found status, plus a File button. The group name and company name are blurred.

3. File

Using the contract’s group name (e.g. “State University - Alpha Chapter”) and date, the tool works out the correct folder path, Year → Season → University → Chapter → Category, and uploads the PDF there automatically. It only creates the last two folder levels itself; everything above that must already exist in Drive. Every filing is logged (who, what, where).

Image: The Google Drive folder tree the contracts are filed into: Formal Contracts, then the year, then (inside 2027) a season folder, Spring 2027, and a group folder. One folder name and its owner are blurred.

Key Features

  1. AI-Powered Term Extraction: Extracts required contract terms using Claude AI.
  2. Missing Term Review: Flags missing information (Not Found) for manual review before filing.
  3. Automated Google Drive Filing: Files contracts into the correct folder based on group name, date, and category.
  4. Filing Activity Log: Records who filed the contract, what was filed, where it was stored, and when.
  5. Category-Based Checks: Checks contract terms according to the selected category (Hotel / Venue / Buses / Other).

What It’s Built With

Next.js (web framework) + TypeScript, Google Drive API, Claude for the AI extraction, Postgres for the log. PDF text extraction is done with a JavaScript library.

Page · Plain text

AI-Powered Meta Ads Reporting

An AI reporting system that pulls Meta Ads data, flags underperforming ads in real time, and recommends budget and creative changes.

Section: AI Agents, AI Agents for Ecommerce

AI-Powered Meta Ads Reporting

Automating Meta Ads performance reporting, identifying underperforming campaigns, and generating AI-driven optimization recommendations.

Project Overview

This system is designed to collect Facebook and Instagram campaign data, analyze performance using AI, and recommend changes to budgets, targeting, and creatives. It aims to help marketers make faster, data-driven decisions while reducing manual reporting work.

Platforms: Meta Ads, Instagram

01. The Problem

Manual campaign analysis required marketers to collect data across campaigns and ad sets, identify underperforming ads, and decide when to adjust budgets or creatives. This process was time-consuming and made timely optimization difficult as campaigns scaled.

02. The Solution

An AI-powered reporting system designed to automate data collection, analyze campaign performance, flag potential issues, and provide actionable recommendations for improving campaign results.

03. Key Features

04. System Workflow

05. System Architecture

Phase 1 — Data Collection and Normalization

Collect campaign metrics, including impressions, clicks, CTR, conversions, ROAS, CPA, spend, and budget utilization, then prepare the data for analysis.

Phase 2 — AI-Powered Analysis

Analyze performance data to detect trends, anomalies, low ROAS, and CTR below defined benchmarks.

Phase 3 — Optimization Recommendations

Generate suggestions for budget allocation, audience targeting, and creative improvements, prioritized by their potential impact on KPIs.

Phase 4 — Reporting and Alerts

Present performance metrics in dashboards and notify users when defined KPI thresholds are breached.

Phase 5 — AI-Assisted Campaign Management

Allow users to request campaign changes through natural language, with validation and tracking of adjustments and their subsequent KPI impact.

06. Reported Results

The original case study reports the following outcomes after automation:

These figures are reported in the supplied case study and have not been independently verified.

07. Final Outcome

The system aims to replace repetitive manual analysis with automated reporting, AI-generated insights, performance alerts, and optimization recommendations, allowing marketers to focus more on campaign strategy and testing.

Page · Plain text

Supplement Operations Dashboard

A centralized analytics dashboard for monitoring orders, inventory levels, shipping performance, unit economics, and stock alerts.

Section: Looker Studio

Overview

Managing supplement operations requires visibility into orders, inventory, shipping, product costs, and stock alerts. This project brings these areas together in an interactive Google Looker Studio dashboard, allowing users to review operational information, apply filters, and monitor different business activities from one interface.

The Problem

Operational information is often spread across separate reports and spreadsheets. Reviewing order statuses, checking stock availability, comparing regional shipping costs, and identifying inventory warnings can require repeated manual filtering and switching between data views.

A centralized dashboard was needed to organize these areas and make operational information easier to access, compare, and review.

How It Works

  1. Access the Dashboard: Users open the dashboard and navigate through the sidebar to the required operational section.
  2. Review Orders: The Order Management section displays product details, quantities, order statuses, expected delivery dates, and tracking information.
  3. Monitor Inventory: Users review available stock, days and weeks of supply, regions, and critical or warning indicators.
  4. Check Inventory Forecasts: The forecasting view presents current stock alongside average demand over 14 and 30 days and replenishment recommendation fields.
  5. Analyze Shipping: The Shipping Analytics section compares regional shipping costs and average bottles per order.
  6. Review Unit Economics: Users examine product prices, stock in hand, expiry dates, and cost of goods sold (COGS).
  7. Monitor Alerts: The Alerts section presents alert distribution and recent shipment-related notifications.
  8. Filter and Investigate: Available search fields, product filters, region selectors, and status filters help users narrow the information and identify records requiring attention.

Result

The dashboard provides a single interface for reviewing six operational areas: Overview, Order Management, Inventory, Shipping Analytics, Unit Economics, and Alerts.Users can move between dedicated reporting views, compare regional and product-level information, review inventory conditions, and identify shipment-related alerts without switching between separate reporting interfaces.

MetricObserved Output
Items tracked daily170
Alert channels2 (Email + Slack)
Source platforms3 (Amazon, Shopify + Google Sheets)
Alert levels2

Tech Stack

Google Looker Studio: Dashboard interface, interactive filters, data tables, charts, and operational reporting.

Where This Pattern Applies

The same dashboard approach can be used by businesses that need to monitor several operational areas through one reporting interface.

The general pattern is to organize information from different operational areas into dedicated dashboard views, provide relevant filters and indicators, and make important records easier to review.

Page · Plain text

Production Linux Server Audit and Repair for a Data Subscription Site

An audit of the single Ubuntu server behind a financial-data subscription site, a fix for its silently failed social-posting pipeline, and a documented setup so it can be maintained safely.

Section: Python Automation

Project Overview

A financial-data subscription site ran its Python backend, data pipelines, scheduled jobs, publishing automation, and social-posting pipeline on a single Ubuntu VPS. The project focused on auditing the server, repairing a silently failed social-posting pipeline, and documenting the setup for safer maintenance.

Technology: Python, Flask, SQLite, systemd, cron, Nginx, Gunicorn, Cloudflare Tunnel, Stripe, WordPress, Brevo

01. The Problem

The server supported several interconnected services and automated workflows. The social-posting pipeline had silently stopped working, and the client needed a server audit, a repair, and a clear maintenance roadmap.

02. What Was Done

03. How the System Runs

04. Workflow

Nightly Data Pipeline

Scheduled systemd Timer → nightly_pipeline.sh → Ingest OHLC Data → Run Scanners → Build JSON → Back Up Database to Google Drive → Build Newsletter and Blog Post → Publish via WordPress REST API → Send Daily Email via Brevo

Live Data Pipeline

Scheduled systemd Timer → live_pipeline.py → Real-Time Signals and Options Pricing

API Service

Flask API → Gunicorn on Port 5500 → Nginx → Cloudflare Tunnel

Social Content Pipeline

Cron Schedule → Content Engine → Render PNG/MP4 Cards → Publish to Instagram, X, and TikTok

20:00 ET  systemd timer  → nightly_pipeline.sh
                            ingest OHLC → run scanners → build JSON → DB backup to Drive (rclone)
                            → build newsletter + blog post (publish via WP REST API)
                            → send daily email (Brevo)
15:45 ET  systemd timer  → live_pipeline.py (real-time signals + options pricing)
always    systemd service → gunicorn Flask API :5500 behind nginx + Cloudflare Tunnel
cron      08:15 / 08:45 / every 15 min market hours / 21:00 → content engine renders PNG/MP4 cards and posts to IG / X / TikTok

05. Technology and Integrations

Python, Flask, SQLite, systemd, cron, Bash, Nginx, Gunicorn, Cloudflare Tunnel, rclone, JWT authentication, Stripe, WordPress REST API, Brevo, and the Post for Me API.

06. Outcome

The server was audited, the failed social-posting pipeline was repaired, scheduling was stabilized, and the architecture was documented to support safer ongoing maintenance.

Page · Plain text

Automated Meeting Transcription and Case Management

Automating Webex meeting transcript retrieval, case matching, document storage, and record tracking using Zapier.

Section: Zapier Automations

Overview

Meeting transcripts previously required manual handling, from retrieving recordings and identifying the correct client case to storing documents and updating tracking records. The Zapier automation connects these steps, using Calendly matching or AI-assisted case identification to route transcripts into the appropriate Box folders and update Google Sheets.

The Problem

Teams handling Webex meetings need to retrieve transcripts, identify the correct client or case, and store documents in the right folders. When these tasks are handled manually, transcripts can be difficult to match with the correct records, and tracking sheets may not stay up to date. Managing different meeting sources also adds repetitive work and increases the chance of misplaced or untracked documents.

How It Works

  1. Capture Meeting Information: A webhook starts the workflow when meeting-related data is received.
  2. Retrieve Meeting Details: Webex provides meeting information and participant details.
  3. Check Transcript Availability: Filters check whether the meeting meets the required transcription conditions.
  4. Format Meeting Data: Meeting dates and times are prepared for further processing.
  5. Match the Meeting: Zapier routes the meeting through either Calendly matching or AI-assisted case identification.
  6. Identify the Case Folder: The workflow locates the corresponding folder in Box.
  7. Process the Transcript: The transcript is retrieved and uploaded to the appropriate Box folder.
  8. Update Records: Google Sheets records the meeting and processing information.

Results

The automation brings transcript retrieval, case matching, document storage, and tracking into one coordinated workflow. It provides two matching paths for handling meetings and helps keep transcript files and associated case records organized across connected applications.

Tech Stack

ToolRole in the Workflow
ZapierConnects applications and manages filters, loops, and workflow paths.
WebexProvides meeting details, participant information, and transcript access.
CalendlySupplies event information for meeting matching.
AI by ZapierAssists in identifying case numbers from client records.
Microsoft ExcelProvides case-related information through CSV data.
BoxStores transcripts in the relevant folders.
Google SheetsMaintains meeting and processing records.

The team can continue using its existing applications without needing to move its meeting records or document storage to a new platform.

Where This Pattern Applies

This solution is not limited to meeting management. The same approach can help any team that needs to match incoming documents or records with existing client information.

Example – Insurance: An incoming claim document can be matched with a customer record, stored in the correct claim folder, and logged in a tracking sheet.

Other applications include:

The general pattern is to capture incoming information, identify its matching record, store the associated document, and update the tracking system. The matching rules and connected applications change according to the business process.

Page · Plain text

AI-Powered RAG Chatbot for The Fast Bite: Seamless Ordering and Query Handling

Create an AI-powered chatbot that helps The Fast Bite( a fast food restaurant) customers with menu queries, placing orders, and providing restaurant details in a fast and friendly manner.

Section: AI Agents

AI-Powered RAG Chatbot for The Fast Bite

An AI-powered chatbot that answers customer questions about menu items, restaurant information, and opening hours using an automatically updated knowledge base.

Project Overview

The Fast Bite chatbot uses Google Gemini and Pinecone to retrieve relevant information and generate helpful responses. Restaurant information is processed from files stored in Google Drive, allowing the chatbot’s knowledge base to be updated when new information is added.

Technology Stack: Google Drive, Google Gemini, Pinecone Vector Store

01. The Challenge

Customers need quick answers about menu items, food options, restaurant hours, and other frequently asked questions. Keeping this information current and responding consistently can require manual effort, especially when menu details or restaurant information change.

02. The Solution

An AI-powered Retrieval-Augmented Generation (RAG) chatbot was developed to process restaurant information, store it in a searchable vector database, and use that knowledge to answer customer questions.

The solution combines:

03. How the System Works

Knowledge Base Preparation

When a new file is added to the designated Google Drive folder, the workflow detects the file and downloads it for processing.

Information Processing

Google Gemini helps process the content into information suitable for retrieval. The processed information is then prepared for storage in the vector database.

Vector Storage

Pinecone stores the processed knowledge so the chatbot can search for relevant information when a customer asks a question.

Customer Query Handling

When a customer submits a question, the chatbot retrieves relevant knowledge and uses an AI model to generate a helpful response based on the available information.

Detailed working Flow:

DEMO

04. Workflow

Image: Simple analogy

05. Key Features

06. Technology Stack

TechnologyPurpose
Google DriveStores source documents and restaurant information
Google GeminiProcesses content and generates responses
Pinecone Vector StoreStores and retrieves relevant knowledge
AI Chat InterfaceReceives customer questions and displays answers

07. Outcome

The result is a reusable RAG workflow for restaurant customer support that can be maintained by updating the underlying source information.

The Fast Bite chatbot provides a convenient way for customers to ask questions about restaurant information and receive AI-generated answers. By combining Google Drive, Gemini, and Pinecone, the solution connects document updates with knowledge retrieval and conversational responses.

Page · Plain text

Cold Email Copy Generation with Automatic Quality Checks

An AI tool that writes five cold email sequences in spintax format in minutes and checks each one against eight quality rules, rewriting any that fail.

Section: Python Automation

Overview

Cold email copy generation and quality control. Instead of spending hours writing email variations by hand in spintax format and checking each line against banned phrases and formatting rules, teams now get five production-ready email sequences in minutes.

The Problem

Creating cold email variations meant hours of manual work. Writers had to draft email sequences by hand, then apply spintax format line by line, a tedious process where every variation had to be written and formatted separately. Quality control was completely manual: each line had to be checked against banned phrases and banned words, word counts verified, spintax coverage confirmed, and offer rotation rules checked. With no automated checklist, mistakes slipped through before emails went into the sending tool. Creating five email sequences took 5 to 10 hours of work, was error-prone, and depended entirely on someone being available to do it correctly.

What the Automation Does

Image: The team interface: a chat assistant on the left, a button to generate the week’s strategy, and Copy Variations and History at the top.

Step 1: Email sequences are generated

The automation takes the email parameters and requirements, then uses AI to generate five complete cold email sequences in full spintax format, with multiple variations per email step (A/B variants) so testing options are built in.

Step 2: Automatic quality checks run

Every generated copy is automatically checked against eight quality rules: word count, spintax coverage on every line, banned phrases, banned words, offer accuracy, hook uniqueness, offer rotation compliance, and more. If a copy passes all checks, it is flagged as production-ready. If it fails, the system automatically rewrites it (up to three retries) to meet the requirements.

Step 3: Ready-to-send copies are delivered

The team receives five email sequences with a pass or fail verdict on each. Every copy is either production-ready or clearly flagged as needing manual revision, so there are no surprises or quality issues after the copy goes into the sending tool.

Main Work Flow

Tools and Integrations Used

The Result

Teams no longer spend 5 to 10 hours writing and quality-checking email sequences by hand. Five production-ready sequences now generate automatically in minutes. Quality control shifted from a manual checklist to an automated pipeline that catches banned phrases, spintax gaps, word count violations and formatting mistakes instantly. Every copy follows the same proven structure with consistent formatting. What used to take hours of manual writing and QA now happens automatically, freeing the team to focus on strategy and testing instead of production work.

Summary

The tool automates the full cycle from email copy generation to quality-checked delivery. Teams provide their email requirements, the automation generates five complete sequences in spintax format, automatic quality checks verify everything, and production-ready emails are delivered in minutes instead of hours. The team stays in control, since they review and approve the output, while the repetitive writing and quality-checking work is handled automatically.

Page · Plain text

WhatsApp Voice & Business Agent with n8n

An AI-powered WhatsApp assistant that understands voice notes, text messages, and photos, then answers customer questions using product information stored in Supabase.

Section: n8n Automations, AI Agents for WhatsApp

Overview

This project is a WhatsApp business assistant for an online store. Customers can send a voice note, text message, or product photo and receive an answer based on the store’s product database. The system uses n8n to process incoming messages, OpenAI to understand different input types, and Supabase to retrieve product information. When a customer sends a voice note, the assistant can respond with a voice message. Conversation memory also helps maintain context across messages from the same customer.

The business problem

Online stores receive repeated questions about product availability, prices, and delivery. Customers may ask these questions through text, voice notes, or photos, making them difficult for simple chatbots to handle. Manual replies take time, while inaccurate answers about prices or stock can reduce customer trust.

How It Works

  1. Receive WhatsApp Messages: The WhatsApp Business Cloud API receives customer messages, including text, voice notes, and photos.
  2. Identify Message Type: n8n checks the incoming message and routes it to the correct processing path.
  3. Process Voice and Images: OpenAI transcribes voice notes and analyzes product photos. Text messages are passed through directly.
  4. Prepare the Message: n8n converts each input into a common text format and associates it with the customer's phone number.
  5. Retrieve Product Information: The AI agent uses the Supabase product database to find relevant information before preparing an answer. Conversation memory helps it maintain context.
  6. Send the Response: Text messages receive text replies. When the customer sends a voice note, the answer is converted into speech and returned as a WhatsApp voice message.

The Result

The completed workflow brings voice, text, and image-based customer enquiries into one WhatsApp assistant. It retrieves product information from Supabase before answering, supports both text and voice replies, and maintains conversation context for each customer.

Workflow Delivery Metrics

MetricResult
n8n nodes after cleanup21
Supported input types3
Reply formats2
AI models used4
Main agent workflows1
Workflow defects fixed2

Note: These figures describe the delivered workflow. Live customer response time, answer accuracy, and sales conversion have not yet been measured.

Tech Stack

Where This Pattern Applies

This pattern is useful for businesses that receive customer enquiries through WhatsApp and want to automate responses while keeping answers connected to reliable business data.

Page · Plain text

AI Calling Agent with Human Handover and Automatic AI Fallback

An AI-powered phone calling workflow using ElevenLabs and Twilio that allows callers to request a human representative and automatically return to the AI agent when the human does not answer.

Section: AI Agents

Overview

This solution is designed to connect an ElevenLabs AI voice agent with Twilio to manage incoming calls and human handovers. When a caller requests to speak with a person, the AI agent initiates a transfer to a designated human number. If the human answers, the caller is connected. If the call is not answered within the configured timeout, Twilio returns the caller to the AI agent so the conversation can continue.

The Problem

An AI calling agent needs to support more than automated conversations. Callers may sometimes need assistance from a human representative, and the transfer process should not leave them disconnected if the representative is unavailable.

A reliable call-handling workflow was needed to support incoming calls, human transfers, and automatic fallback to the AI agent without interrupting the caller's experience.

How It Works

  1. Receive Incoming Call: The caller dials the designated Twilio phone number, which routes the call through the inbound Twilio Function.
  2. Connect to ElevenLabs: The inbound function registers the call with ElevenLabs and connects the caller to the AI voice agent.
  3. Handle the Conversation: The ElevenLabs agent communicates with the caller and handles their request.
  4. Request Human Assistance: When the caller asks for a human representative, the AI agent invokes the connect_to_human webhook tool.
  5. Transfer the Call: The /connect-human Twilio Function initiates the transfer to the designated human phone number.
  6. Handle the Human Answer: If the human answers, Twilio connects the caller and the human representative.
  7. Return to AI When Unanswered: If the human does not answer before the timeout, the /after-dial function redirects the caller back to the AI agent.
  8. Continue the Conversation: The AI agent apologizes for the unavailable representative and continues assisting the caller.

Result

The proposed workflow brings AI call handling, human assistance, and automatic fallback into one connected calling experience.

It is designed to support:

  • Incoming calls routed to the ElevenLabs AI agent.
  • On-demand transfers to a human representative.
  • Automatic return to the AI agent when the human does not answer.
  • Continued conversations without requiring the caller to restart the call.

The workflow will be validated against three scenarios: a normal AI call, a successful human transfer, and an unanswered human transfer followed by an AI fallback.

Tech Stack

  • ElevenLabs: Provides the AI voice agent, conversation instructions, and connect_to_human webhook tool.
  • Twilio: Handles incoming calls, call transfers, and the return-to-AI process.
  • Call.com: Provides the caller number used for testing.
  • GHL: Retains the existing calendar functionality without changes.

Where This Pattern Applies

The same approach can be used in voice automation systems where callers need access to both AI assistance and human support.

  • Customer Support: Transfer complex customer queries to human agents.
  • Sales: Connect interested prospects with sales representatives.
  • Appointment Management: Escalate scheduling requests that require human assistance.
  • Service Businesses: Route customer calls to available staff while maintaining AI support when they are unavailable.
  • Call Centers: Combine automated call handling with human escalation and fallback.

The general pattern is to let AI handle routine conversations, transfer callers when human assistance is requested, and restore AI support when the human representative is unavailable.

Page · Plain text

From a Signed DocuSign Contract to a Master Sheet Row and an Itinerary Slide

Turning a signed DocuSign travel contract into a master sheet row, a filed contract and an itinerary slide, automatically.

Section: Make Automations

Project Overview

This Make automation supports operations for a group travel company that manages college formal events.

When a group signs a travel contract in DocuSign, the workflow processes the completed contract and supports three follow-up tasks: recording trip details in the master operations spreadsheet, filing the signed contract in the group's Google Drive folder, and producing a Friday, Saturday, and Sunday itinerary slide.

Tools: Make, DocuSign, Google Apps Script, Anthropic Claude (claude-sonnet-4-6), Google Sheets, Google Slides, and Google Drive.

01. The Challenge

Signed travel contracts contain information that must be transferred into several operational resources, including:

Manually transferring these details into the master sheet, filing the contract, and building a customer-facing itinerary is repetitive and can lead to errors.

02. The Solution

A Make scenario automates the process after a DocuSign envelope is completed. It downloads the signed document, obtains structured contract data through a Google Apps Script web app, and uses Claude to generate the three-day itinerary text.

The workflow then routes the results into three paths: a new-contract path, an addendum path, and an archive path.

03. How It Works

Step 1: Detect the Signed Contract

The workflow starts when a DocuSign envelope is completed.

Step 2: Download the Document

Make downloads the signed contract for further processing.

Step 3: Extract Contract Information

An HTTP request sends the document to a Google Apps Script web app, which returns the contract fields as structured data.

Step 4: Generate Itinerary Text

Claude uses the structured fields to write the itinerary content for Friday, Saturday, and Sunday.

Step 5: Route the Results

A router directs the workflow into three paths:

The scenario connects with Google Sheets, Google Slides, and Google Drive as part of the downstream processing.

Image: Part of the Make scenario: the DocuSign trigger and download, the HTTP call to the Apps Script web app, Claude, and a router that splits into Google Sheets, Slides and Drive paths.

04. Workflow Architecture

The workflow uses a router to separate the processing paths after the contract information and itinerary text have been prepared.

05. Example Output: Three-Day Itinerary

The example itinerary slide presents a group's Friday, Saturday, and Sunday schedule. The supplied screenshot has group, date, hotel, and company details blurred for privacy.

Suggested placement: Include the itinerary screenshot here, after the workflow architecture section, to show an example of the generated output.

Image: An example three-day itinerary slide (group, dates, hotel and company details blurred for privacy).

06. Tools and Integrations

07. Outcome

The workflow automates key steps following contract completion, connecting signed-document processing with structured trip data, itinerary text generation, and downstream document handling.

Page · Plain text

Case Study Aircall Daily Warm Call

Automated pipeline that pulls fresh leads from a CRM every morning, sends a personalized heads-up email, and loads a ready-to-dial Aircall campaign before the sales rep even logs in.

Section: n8n Automations

Overview

This project automates daily warm-lead outreach using n8n, HubSpot, Gmail, and Aircall. Every weekday, it selects up to 30 eligible contacts, sends personalized emails, and adds successfully emailed contacts to a new Aircall campaign. It also updates HubSpot and maintains a backup log to prevent duplicate outreach.

The Problem

The sales team previously spent time every morning collecting warm leads from HubSpot, sending introductory emails, and manually adding contacts to Aircall campaigns.This repetitive process reduced selling time and created risks such as duplicate outreach, incorrect phone numbers, and calls being made to contacts who had not received the introductory email.

How It Works

  1. Scheduled Execution: n8n starts the workflow every weekday at 6:00 AM EST, before the sales team begins its day.
  2. Retrieve HubSpot Contacts: The workflow collects eligible contacts from a designated HubSpot segment, retrieving up to 500 contact IDs before applying the daily selection limit.
  3. Validate and Select Leads: It retrieves contact details, normalizes phone numbers into E.164 format, skips contacts already contacted that day, and selects up to 30 contacts.
  4. Prevent Duplicate Outreach: Selected contacts are marked in HubSpot with the current date. Their details are also saved in a backup data table for auditing.
  5. Send Personalized Emails: The workflow builds personalized HTML emails using the contact's first name and the sales representative's signature, then sends them through the representative's Gmail account.
  6. Create the Aircall Campaign: n8n duplicates a master Aircall campaign, adds the current date to its name, and prepares it for the selected contacts.
  7. Synchronize Email and Calls: Only contacts whose emails were successfully sent are added to the Aircall campaign. Their email activity is also logged on their HubSpot timeline.
  8. Launch the Campaign: The workflow launches the campaign so the sales representative can open Aircall and start calling without preparing the list manually.

The Result

The automation connects lead selection, personalized email outreach, and Aircall campaign preparation in one workflow. It removes the need to manually build daily call lists, keeps email and calling activities synchronized, and prevents contacts from being selected repeatedly on the same day.

Automation Testing Results

MetricResult
Contacts processed per test run30
Email delivery success rate100% (30/30)
Aircall contact loading successApproximately 93%
Duplicate contacts observedNone
Daily list and campaign preparationAutomated

Note: Results are based on structured testing and dry runs. The remaining Aircall loading failures were linked to malformed phone numbers in legacy CRM records. Call connection rates, email replies, and sales impact have not yet been measured.

Tech Stack

Where This Pattern Applies

Page · Plain text

Webex Recording Transcription and Case File Automation

Automating meeting transcription storage, case identification, and record tracking using Zapier, Webex, Box, Calendly, Microsoft Excel, AI, and Google Sheets.

Section: Zapier Automations

Overview

This solution automates the process of retrieving Webex meeting transcripts, matching meetings with client cases, storing documents in Box, and tracking records in Google Sheets. It uses Calendly matching for direct case identification and AI-assisted matching when a usable case number is not available.

The Problem

Meeting transcripts need to be associated with the correct client and case before they can be stored and tracked. Handling this manually requires staff to review meeting details, identify the relevant case, download transcripts, locate the correct Box folder, upload files, and update tracking records.

The process becomes more difficult when meeting information does not contain a usable case number. An automated approach was needed to support both direct case matching and matching through existing client records.

How It Works

  1. Receive Meeting Data: A Webhook triggers the automation when meeting-related information is received.
  2. Retrieve Webex Details: The workflow fetches meeting information and checks whether a transcription is available.
  3. Collect Participants: It retrieves participant details and formats meeting start and end times.
  4. Match Calendly Events: JavaScript compares meeting information with scheduled Calendly events and retrieves the corresponding invitee details.
  5. Identify the Case: The workflow checks whether a valid case number is available through the Calendly match.
  6. Use AI When Needed: If direct matching does not provide a usable case number, the workflow downloads client records from Excel as CSV and uses AI by Zapier to identify a matching client and case number.
  7. Find the Box Folder: The identified case number is used to search for the corresponding folder in Box.
  8. Download and Store the Transcript: The Webex transcription is retrieved and uploaded to the relevant Box folder.
  9. Update Tracking Records: Google Sheets logs the participant name, available case number, and Zapier run reference.

Result

The automation brings meeting retrieval, case identification, transcript storage, and record tracking into one connected process. It supports both direct Calendly-based matching and AI-assisted client matching, allowing transcripts to be routed according to the information available.Box maintains the associated transcript documents, while Google Sheets provides a record of the processed meetings and their related references.

Daily Processing Metrics

MetricDaily Volume
Meetings processed5
Meetings with available transcripts3
Transcripts uploaded to client folders in Box3

Tech Stack

Where This Pattern Applies

The same approach can be used wherever incoming documents or recordings need to be matched with existing client records and stored in the correct location.

The general pattern is to retrieve incoming information, identify its matching record, store the associated document, and update the tracking system. The matching logic and connected applications can be adapted to different business processes.

Page · Plain text

A Slack Bot That Answers Trip Questions from an Ops Master Sheet

A Make scenario that lets a team member ask a plain-English trip question in Slack and get an answer drawn only from the ops master sheet.

Section: Make Automations

Project Overview

This internal operations tool helps a group travel team find trip information using plain-English questions in Slack, without manually searching through a large Google Sheets workbook.

The team stores trip information in the MASTER tab of the Master Ops Fall 26/Spring27 workbook. Each row represents a group trip and contains information about dates, destinations, operations coordinators, sales representatives, contracts, hotels and rooming, transport, events, task due dates, and payment status.

Tools: Make, Slack, Google Sheets, and Anthropic Claude (claude-sonnet-4-6).

01. The Problem

The operations master sheet contains more than 55 labelled fields per trip, spanning columns A to BH.

Finding a specific detail—such as a group's hotel information or room counts—requires locating the correct trip row and navigating to the relevant column. This makes answering everyday operational questions more time-consuming.

02. The Solution

A six-module Make scenario connects Slack with Google Sheets and Claude to process questions and return relevant trip information.

The workflow:

03. How It Works

Step 1: Receive the Question

A custom webhook receives the incoming question and the Slack channel information.

Step 2: Identify the Search Terms

Claude interprets the plain-English question and converts it into structured search terms that can be used to find relevant trips.

Step 3: Search Google Sheets

The scenario searches the operations master sheet for trips matching the extracted criteria.

Step 4: Format the Matching Results

The matching spreadsheet rows are combined into readable text using a text aggregator.

Step 5: Generate the Answer

Claude uses the retrieved text to answer the original question. The answer is restricted to the information provided by the matching spreadsheet results.

Step 6: Reply in Slack

The final answer is posted back to the same Slack channel where the question originated.

Image: The Make scenario: a custom webhook, Claude turning the question into search terms, a Google Sheets search, a text aggregator, Claude answering from the results, and a Slack message.

04. Workflow Architecture

The scenario separates question interpretation, data retrieval, result formatting, and answer generation into distinct steps.

05. Example Use Case

A team member asks:

“How many groups do we have in Nashville from April 9–11, 2027?”

The bot searches for trips matching the destination and dates, then returns the matching groups with their trip dates and destinations in Slack. The example screenshot shows group names blurred for privacy.

Image: An example answer in Slack: the question, the search terms Claude worked out, and the matching groups with their dates and destination (group names blurred for privacy).

06. Tools and Integrations

07. Outcome

The scenario gives the operations team a conversational way to retrieve trip information from a large master sheet. Team members can ask questions in Slack and receive structured answers based on matching spreadsheet records, without manually searching across the workbook.

Page · Plain text

HubSpot Industry Classifier with Gemini

An automated workflow that classifies HubSpot companies into industry groups using Google Gemini and sends uncertain records for human review.

Section: n8n Automations, AI Agents

Overview

This project uses n8n and Google Gemini Flash to automatically classify company records in HubSpot. The workflow runs every hour, retrieves companies from a designated HubSpot list, and checks whether their industry group is already assigned. Gemini analyzes company information and suggests an industry based on the categories available in HubSpot.

To maintain CRM data quality, the workflow validates every suggested category and checks its confidence score before updating a record. Companies that cannot be classified reliably are marked as Needs R&D for human review. A dry-run mode also allows the team to test the workflow without changing live CRM records.

The Problem

Many HubSpot company records may have missing or inconsistent industry classifications. Updating these records manually takes time and can lead to inconsistent categories.

Using AI without proper checks also creates risks, such as invented industry groups, unreliable classifications, and repeated processing of companies that have already been classified.

How It Works

  1. Scheduled Execution: n8n starts the workflow every hour and loads its configuration, including the company limit, confidence threshold, and dry-run setting.
  2. Retrieve Company Records: The workflow retrieves companies from a designated HubSpot list, collecting up to 100 records per run.
  3. Check Company Information: It retrieves each company's name, domain, website, and existing industry group. Already classified companies and records without usable information are skipped.
  4. AI Classification: Google Gemini Flash analyzes the available company information and returns a suggested industry group, confidence score, exclusion flag, and reasoning.
  5. Validate the Result: n8n checks whether the suggested industry exists in HubSpot's allowed options. It also applies a minimum confidence threshold of 0.6 and limits confidence to 0.65 for companies without a domain.
  6. Update or Flag Records: Valid classifications are written to HubSpot with relevant classification details. Uncertain or excluded companies are marked as Needs R&D for human review.
  7. Control Updates: Dry-run mode prevents changes to live records during testing. A Wait node also separates updates to help manage HubSpot API rate limits.

The Result

The workflow provides an automated and controlled process for classifying HubSpot company records. It uses Gemini to suggest categories while HubSpot provides the approved industry options. Validation rules, confidence checks, and human-review routing help prevent unreliable classifications from being accepted automatically.

Workflow Configuration Metrics

MetricResult
n8n workflow nodes22
Execution scheduleEvery hour
Maximum companies per run100
Confidence threshold0.6
No-domain confidence cap0.65
AI modelGoogle Gemini Flash

Note: These figures describe the workflow configuration. Actual companies processed, classification accuracy, human-review rate, and time saved have not yet been measured.

Tech Stack

Where This Pattern Applies

This pattern is useful for businesses that need to enrich large datasets with AI while maintaining control over data quality and ensuring uncertain results receive human review.

Page · Plain text

Enterprise Ticketing & Revenue Data Pipeline

An automated reporting system that collects ticket sales data from multiple vendors, calculates festival revenue and attendance, and updates a central dashboard using Python and Google Cloud.

Section: Python Automation

Overview

Palm Tree Crew, a live music festival organizer, needed a reliable way to track ticket sales, revenue, and attendance across multiple festival locations. We developed a Python-based automation pipeline on Google Cloud that collects daily reports from Ticketmaster, Front Gate Tickets, and Posh through Gmail. The system processes the reports, applies the required business rules, stores the results in BigQuery, and updates a Google Sheets dashboard for the management team.

The Problem

The operations team had to download daily ticket reports from different vendors, extract the information from PDFs and emails, and manually enter the numbers into Google Sheets. They also had to calculate multi-day attendance and track revenue from separate VIP and sponsorship spreadsheets. This process took hours, increased the risk of errors, and made it difficult for management to view total revenue and remaining ticket capacity in one place.

How It Works

  1. Start the Automation: Google Cloud Scheduler triggers the Python service on Cloud Run at the scheduled reporting time.
  2. Collect Vendor Reports: The system uses the Gmail API to retrieve daily audit emails from Ticketmaster, Front Gate Tickets, and Posh.
  3. Extract Ticket Data: Custom Python parsers process Ticketmaster PDF reports and Front Gate HTML email tables to extract ticket sales information.
  4. Apply Business Rules: The system calculates daily attendance, 24-hour sales rates, and remaining capacity. It also splits two-day passes across the correct festival days.
  5. Store Data in BigQuery: Processed information is saved in three tables: raw reports, parsed report lines, and daily snapshots.
  6. Update the Dashboard: The Google Sheets API rebuilds the executive dashboard with ticket sales, revenue, attendance, sales rates, and remaining capacity.
  7. Include Offline Revenue: VIP table and sponsorship data from external spreadsheets is connected through Google Sheets IMPORTRANGE, bringing online and offline revenue into one view.

Result

The system brings ticket sales collection, revenue calculations, and reporting into one automated pipeline.

  • Replaces hours of manual report collection and data entry with scheduled automation.
  • Combines ticket sales data from multiple vendors in one dashboard.
  • Reduces manual calculation errors and duplicate ticket counting.
  • Provides a combined view of online ticket sales, VIP tables, and sponsorship revenue.
  • Displays daily attendance, sales rates, and remaining ticket capacity.
  • Allows new festival shows and ticketing platforms to be added through a standard onboarding template.

Tech Stack

  • Python: Handles report extraction, data processing, and business calculations.
  • Google Cloud Run: Hosts and runs the Python automation service.
  • Google Cloud Scheduler: Triggers the pipeline at scheduled intervals.
  • BigQuery: Stores original reports, parsed ticket data, and calculated daily snapshots.
  • Gmail API: Retrieves daily ticketing reports from vendors.
  • Google Sheets API: Builds and updates the executive dashboard.
  • IMPORTRANGE: Connects external VIP table and sponsorship revenue spreadsheets.

Where This Pattern Applies

The same approach can help organizations that collect operational and financial data from multiple external sources.

The general approach is to collect reports from different sources, extract and process the data, apply business rules, and deliver updated results through a centralized dashboard.

Page · Plain text

Salesbeast AI Outbound Sales Machine

An automated outbound sales system for discovering target companies, enriching decision-maker profiles, evaluating lead quality, and generating personalized email outreach.

Section: n8n Automations

Overview

Salesbeast is a three-layer AI-powered outbound sales system designed to automate company discovery, decision-maker identification, lead qualification, and personalized email generation.The system collects business information from multiple sources, evaluates potential leads using qualification rules, and uses AI to research decision-makers and prepare tailored email variations.

The Problem

Finding suitable companies and identifying the right people to contact requires searching multiple platforms, reviewing company websites, checking business information, and researching individual profiles.

After collecting this information, sales teams must manually assess lead quality and write personalized outreach messages. This process can become time-consuming and difficult to manage across large prospect lists.

How It Works

  1. Collect Company Data: D7 Networks identifies companies based on industry, location, and company size criteria.
  2. Enrich Business Information: Google Maps API retrieves ratings, reviews, phone numbers, and business hours. Website scraping collects company information, services, and blog content.
  3. Identify Decision-Makers: Apollo.io searches for employees based on job titles and retrieves contact details, LinkedIn profiles, and professional background information.
  4. Store Enriched Records: Company information, decision-maker profiles, and enrichment logs are organized in PostgreSQL.
  5. Qualify Leads: The qualification layer evaluates company size, Google ratings, review counts, industry, and business activity.
  6. Score and Segment: Leads receive a score out of 100 and are assigned categories such as Reputation Recovery, Moderate Reputation, High Authority, or industry-specific segments.
  7. Research Decision-Makers: AI analyzes company information and professional profiles to identify relevant pain points, opportunities, and talking points.
  8. Generate Personalized Emails: The system creates three email variations for each decision-maker: pain-focused, growth-focused, and authority-focused.
  9. Review Email Quality: Generated emails are scored, and only emails scoring above 75 are approved. Lower-scoring emails are rejected for regeneration.

Result

The system connects company discovery, contact enrichment, lead qualification, and personalized email generation into one automated process.

It provides:

The documented design specifies an average email quality score of 88/100. This is a design-document figure, not an independently verified production performance metric.

Image: Figure 1. Company Data Collection & Enrichment

Image: Figure 2. Decision-Maker Identification

Image: Figure 3. AI Lead Qualification & Email Generation

Tech Stack

n8n: Workflow automation and coordination across the three processing layers.

D7 Networks: Company discovery based on search criteria.

Google Maps API: Business details, ratings, reviews, and contact information.

Apollo.io: Decision-maker identification and professional profile enrichment.

AI Models: Lead research, qualification support, and personalized email generation.

PostgreSQL: Structured storage for leads, decision-makers, qualification results, and email variants.

Where This Pattern Applies

The general pattern is to combine business data collection, contact enrichment, qualification rules, and AI-assisted personalization into a connected outbound sales workflow.

Page · Plain text

Newsletter Generator: From a Google Sheets Row to a Draft Campaign

A Make scenario that turns one row of a Google Sheets newsletter planner into a finished draft campaign in Campaign Monitor, in one of three layouts chosen by the editor.

Section: Make Automations

Project Overview

This Make scenario automates the creation of newsletter draft campaigns using content stored in Google Sheets. Editors prepare the newsletter information in a spreadsheet, select one of three templates, and mark the row for creation. Make then builds the newsletter and creates a draft campaign in Campaign Monitor.

01. The Challenge

Creating a newsletter manually requires editors to copy titles, images, excerpts, links, and category labels into an email template. This process must be repeated for news articles, sponsored posts, a destination report, and a podcast episode.

02. The Solution

The Make scenario connects Google Sheets with Campaign Monitor to generate a newsletter draft from a single spreadsheet row. It uses the selected template to build the campaign content and updates the row when the process is complete.

03. How It Works

Step 1: Prepare the Newsletter

The editor fills in a Google Sheets row with the content for three news posts, three sponsored posts, a destination report, and a podcast episode.

Step 2: Select a Template

The editor chooses template 1, 2, or 3 and sets the Create Newsletter cell to Create.

Step 3: Find the Requested Row

Make searches the sheet on its schedule for a row marked Create and processes one row at a time.

Step 4: Route to the Selected Layout

A router directs the row to one of three routes based on the selected template number.

Step 5: Build the Newsletter

A code step assembles the newsletter content, including banners, images, category labels, titles, excerpts, links, and buttons. The layout varies according to the selected template.

Step 6: Create the Draft Campaign

An HTTP request sends the generated content to the Campaign Monitor API, which creates a draft campaign using the selected template.

Step 7: Update the Spreadsheet

After the campaign is created, Google Sheets is updated with the status Done.

Image: The Make scenario: Google Sheets searches for a row marked Create, a router picks one of three templates, a code step builds the newsletter content, an HTTP call creates the campaign from the template, and Google Sheets updates the row. A Skip step on each route handles errors.

04. Newsletter Content Structure

The generated newsletter includes:

News and sponsored posts include images, category labels, titles, excerpts, and links. The destination report includes a destination name and description, while the podcast section includes its date, title, description, and listening link.

05. Template Options

The scenario supports three newsletter layouts:

06. Content Handling

The code includes defaults for missing content. Missing news or sponsored-post images use a default image, missing links point to the main website, and each campaign receives a unique name with a timestamp. The subject line and header date default to the current month and year. Sender details and the subscriber list are also set in the code step.

07. Workflow Architecture

Each template route builds the campaign content and sends it to Campaign Monitor. A Skip step on each route handles errors.

08. Tools and Integrations

09. Review and Error Handling

The campaign is created as a draft in Campaign Monitor so the team can review it before sending. If Campaign Monitor returns an error, the scenario skips that run instead of stopping with an error.

10. Outcome

The scenario allows editors to prepare newsletter content in Google Sheets and generate a corresponding Campaign Monitor draft without manually copying each content block into the email editor. The team can review the generated draft in Campaign Monitor before sending it.

Page · Plain text

End of part 2 of 7. Continue with part 3.