AK
← All projects

AI Automation

Dubai Agency Outreach — Website-Aware Email Drafts

Finds Dubai-based agencies on Google Maps, reads each company's website, and uses AI to write a personalised subject line, first line, and email body — saved as Gmail drafts, never sent automatically.

n8nApifyGoogle MapsHTTP RequestHTML ExtractOpenAIGoogle SheetsGmail
n8n workflow — Apify dataset, code filter, HTTP request to company site, HTML extract, LLM chain, then Google Sheets and Gmail draft

How it flows

  1. 1Apify finds Dubai agencies on Google Maps
  2. 2Keep only companies with both a website and an email
  3. 3HTTP Request opens each website
  4. 4HTML node extracts the readable text
  5. 5LLM writes subject, first line, and body from what the site says
  6. 6Save to Google Sheets and create a Gmail draft

The problem

Generic cold emails get ignored. A personalised email takes ten minutes of research per company. This workflow does the research.

Node by node

  1. Manual Trigger — starts the run.
  2. Apify — finds Dubai-based agencies on Google Maps and collects company details (10 results in the test run).
  3. Code 1 — keeps only companies that have both a website and an email address (7 remained).
  4. HTTP Request — visits each company’s website.
  5. HTML — extracts the readable text from the page.
  6. Code 2 — cleans the scraped text and trims it to a sensible length.
  7. Basic LLM Chain + OpenAI Chat Model — reads the website text, understands what the agency does, and writes three things: a customised first line, a subject, and an email body.
  8. Code 3 — organises the company details and the AI copy for output.
  9. Google Sheets — saves everything to a spreadsheet.
  10. Gmail Draft — creates a personalised draft for each company. Nothing is sent without a person reviewing it.

Result

Seven ready-to-review drafts in Gmail, each one opening with something specific about the agency, plus a tracking sheet — in under a minute.

More AI Automation projects