← Back to Work

LDC Strategies

AI Automation Work

A series of practical automation workflows built during an internship at LDC Strategies, an AI and web agency. Each workflow solves a real business problem, connecting tools like OpenAI, Google Sheets, Twilio, and GoHighLevel through n8n.

Status: Built & Deployed · 2025 · 2026

Workflows Built

AI Lead Intake & Spam Filter

A form submission triggers the workflow. Empty messages are filtered first. GPT-4o then reads the submission and decides if it is spam or a genuine inquiry. Spam is flagged, notified, and saved to a separate sheet. Legitimate leads get an automated reply confirming receipt and are saved to the leads sheet.

n8n OpenAI Gmail Google Sheets

Advanced Lead Pipeline with Scoring

A full webhook-based lead system. Every submission is logged raw, then classified by type, Website, SEO, Ecommerce, CRM, Automation, AI, using JavaScript regex and AI. Leads are then scored 0 to 100 based on email quality, message detail, company name, and intent signals. AI spam filtering runs before any notifications fire.

n8n OpenAI Gmail Google Sheets GoHighLevel

Automated Company Research

When a lead submits their details, the workflow searches for their company website using Serper, scrapes it with FireCrawl, and sends the content to GPT-4o-mini which generates a structured pre-call sales brief covering industry, services, revenue signals, market position, and pain points. The brief is pushed to GoHighLevel CRM, posted to a Slack channel, and saved to Google Sheets before a human has seen the lead.

n8n OpenAI Serper FireCrawl GoHighLevel Slack Google Sheets

Lead Form + Company Research

A form-triggered version of the company research pipeline. A lead submits their name, company, email, and revenue. GPT resolves the company domain, FireCrawl scrapes the site, and GPT-4o-mini generates a research brief which is saved automatically to Google Sheets. Falls back gracefully if no domain can be found.

n8n OpenAI FireCrawl Google Sheets

Application Follow-Up Engine

Monitors a Google Sheet for new internship and job applications logged via a form. Waits exactly 7 days, then reads the sheet again to check if a response has been recorded. If the response column is still empty, it fires an automated Gmail reminder to follow up with the company.

n8n Google Sheets Gmail

Daily SMS Appointment Reminders

Runs every morning at 9am via a scheduled trigger. Pulls all booked appointments from a Google Sheet, filters for any scheduled for the following day that have not yet been reminded, and sends a personalised SMS via Twilio. Updates the sheet to mark each reminder as sent, then emails a daily summary showing how many reminders fired or confirming none were needed.

n8n Google Sheets Twilio Gmail

Tools & Integrations

Automation

All workflows were built in n8n, a visual workflow automation platform. Logic was handled through a mix of built-in nodes, custom JavaScript code nodes, and conditional branching.

AI & Intelligence

OpenAI GPT-4o and GPT-4o-mini powered spam filtering, lead type classification, lead scoring, company domain resolution, website brief generation, and pre-call sales research.

APIs & Data

FireCrawl for website scraping, Serper for Google Search lookups, Twilio for SMS, Google Sheets for data storage, GoHighLevel for CRM updates, Slack for team notifications, and Gmail for automated emails.