I Automated My Outreach. The Hard Part Was Not the Automation.

A few weeks ago at work, I was given a task. Reach out to potential clients. Not warm leads. People who had never heard of us. So I started by scraping emails. That part alone took time. Finding the right people, the right companies, making sure the data was clean enough to use. Not glamorous work but necessary if you want any real shot at growth. Then came the part I had not thought about. Writing to all of them. Not a generic blast. Something that actually addressed what each person was looking for. For the first few it felt manageable. By the 15th I was copy pasting and swapping names then I tried Mergo tool first. Sends emails at scale but personalization is limited. Every email still felt like a template. That is when I built something instead. Got to know about n8n through a program I was doing. I opened n8n and started connecting nodes. Google Sheets node to pull the company data, name, industry, what service they seemed to need. OpenAI API to handle the actual writing, with a prompt that passed through each persons details and generated an email tailored to their situation. It broke the first time because the field names in my Sheet had spaces in them and n8n was not reading them the way I expected. Not an AI problem. A data formatting problem I had never thought about because I had never needed to. Fixed that. Ran it again. Every email was generating but each one started with "Dear \[Name\]" literally, the variable was not passing through correctly into the prompt. Another hour inside n8n figuring out expression syntax. Third run. It worked. The entire list, every company, every email written around what they specifically seemed to need, done without me writing a single one manually. Last week, we got good responses. Few people actually interested in what we offer. Not a huge number but real ones. The automation took a weekend. Understanding what to automate took longer than that.