I don't just talk about automation. I build things that actually run.

The problem it solves. When someone clicks a Microsoft (Bing) ad, Microsoft can see the click, but it loses track of what happens after that. The person might fill out a form, become a lead in HubSpot, turn into an SQL a few days later, and eventually become a customer. Microsoft sees almost none of that.

That means its bidding algorithm is learning from clicks and form submissions, rather than from the people who actually become customers.

Offline conversion tracking fixes that. Every ad click comes with a unique msclkid. I store that ID on the HubSpot contact, and when the contact later becomes an MQL, SQL, or closed-won customer, I send that information back to Microsoft. For closed-won deals, I can even send the deal value.

So instead of learning, "this type of person fills out forms," Microsoft can start learning, "this type of person actually becomes a customer."

How the direct API version works. HubSpot sends a webhook to n8n whenever something relevant changes on a contact or deal. From there, the workflow checks what happened and decides whether it needs to send a new conversion to Microsoft.

For example, if a contact becomes an MQL or SQL, it first checks whether they actually came from a Microsoft ad by looking for the msclkid. Organic leads are ignored. It also checks whether that conversion has already been uploaded, so the same person doesn't get counted twice.

If everything looks good, n8n sends the conversion directly to Microsoft's Offline Conversions API. For closed-won deals, it also sends the deal value in EUR.

Once Microsoft has received it, the workflow updates a property in HubSpot to basically say: "We've already sent this one." That small step is what stops duplicate conversions if HubSpot triggers the workflow again later.

Calling Microsoft’s API directly is probably the cleaner setup. But there’s another option: Microsoft Ads can also import offline conversions from a Google Sheet on a schedule.

It’s a bit less elegant, but I actually like it for a few reasons. You can open the sheet and see exactly what’s being sent to Microsoft, it’s easier for someone else to troubleshoot, and you don’t have to rely as much on API authentication working perfectly.

So instead of sending conversions straight to Microsoft, this version writes them into a Google Sheet. Microsoft then imports that sheet automatically.

The part I like most is actually the boring bit.

Once a week, the workflow checks the sheet, keeps the last 14 days of conversion data, removes everything older, and writes the recent rows back.

It sounds like a small detail, but it matters. Microsoft keeps coming back to the same sheet to import conversions. If you never clean it up, you eventually end up with months or years of old data sitting there and being checked again and again.

That’s the kind of thing you probably wouldn’t bother building into a quick demo. But if the automation is supposed to keep running for months without anyone thinking about it, it suddenly becomes important.

The first version worked, but once I started running it every day, the weak spots became pretty obvious. So v2 is basically the version I wish I’d built the first time. I’m keeping both here because I think it’s useful to see how the workflow changed.

LLM “memory” → actual state. In v1, I basically told the LLM: “rotate through the countries and don’t repeat yourself.” Which works... until it doesn’t. Language models aren’t databases. In v2, a code node keeps track of how often each country has been used, so the rotation is predictable and doesn’t repeat.

One lead at a time → batches. v1 processed leads individually and waited 30 seconds between requests. Fine for a demo, painfully slow in practice. v2 checks new leads against everything already processed, then sends them in batches of 25 for enrichment and 50 for campaign creation. It also retries failed jobs up to 12 times instead of waiting around indefinitely.

Guessing → saying “I don’t know.” The first version always tried to come up with an email address, even when the evidence was weak. That’s obviously not great if you’re actually going to email people. v2 validates addresses, filters out personal email domains, and tells the model to return UNKNOWN when it isn’t confident. Those leads simply get dropped.

Silent failures → Slack alerts. This was probably the most important change. If an API call fails, v2 sends me a Slack message with the error and the payload that caused it.

It’s a small addition, but it’s also the kind of thing that separates a workflow that looks good in a demo from one you can actually leave running every day.

The problem it solves. Finding the right people takes time. Finding a decent work email for each of them takes even longer. This workflow does both every morning before I’ve had coffee.

Two ways of finding leads. Each day, it generates a new Google search like site:linkedin.com/in "Warranty Manager" "Denmark", rotating through different job titles and countries. The workflow keeps track of what it has already searched, so it doesn’t just run the same query again tomorrow.

At the same time, Apollo searches for people matching the same profile. The two sources are then combined, duplicates are removed, and the leads move through the rest of the workflow in batches.

Enrichment first, AI second. Dropcontact gets the first shot at finding a verified business email. If it comes back empty, GPT-4o tries to work out the most likely address from the person’s name and company domain.

But I didn’t want the AI confidently inventing email addresses, so there are a few checks after that. The address has to pass basic validation, personal domains are filtered out, and if the model isn’t confident enough, it returns UNKNOWN. Those leads get dropped instead of emailed.

Then it hands the interesting part back to me. Qualified leads are added to an Instantly campaign. The next day, the workflow checks for replies. If someone responds, I get a Slack notification and take over from there.

That’s basically the idea: automate the repetitive part of finding and reaching the right people, then bring a human in as soon as there’s an actual conversation.

One important caveat: AI-inferred emails are still guesses, not verified addresses. I’d always run them through a proper bounce check before sending. And if you’re doing cold outreach in the EU, make sure your setup actually complies with the rules that apply to you.

The problem it solves. Coming up with content ideas is easy. Knowing which ones are actually worth writing is harder. This workflow starts with a Semrush gap analysis and finds keywords competitors rank for that we don’t, then filters them by search volume and difficulty.

It checks what we’ve already written first. Before choosing anything, it looks at our Notion content calendar and removes topics we’ve already covered. From what’s left, it picks ten keywords: four with AI intent, four comparison-style searches like “best X” or “X vs Y,” and two wildcards. Easier opportunities get priority.

Then it researches each topic properly. For every keyword, the workflow pulls the current top 10 Google results and uses them to understand what is already ranking and where there might be room to add something better.

That context gets turned into a brief, and Claude writes the first draft using a fairly strict set of rules around tone, banned words, internal links, FAQs, HTML components and formatting.

I also made the output deliberately strict. Claude has to return one valid JSON object. If the structure is broken, the article gets rejected rather than quietly passing bad data into the next step.

It creates drafts, not finished articles. Everything ends up in Notion with the article, title tag, meta description, slug and target keywords ready for review.

That distinction matters to me. The automation can do a lot of the research and get you surprisingly far with a first draft, but I still want a person deciding whether something is actually worth publishing.

And one bug I found while documenting it: Notion only accepts 100 blocks in a single request. Longer articles were getting cut off, and although the workflow flagged that they were truncated, nothing actually did anything with the flag.

So if you adapt this one, make sure the remaining blocks get appended in a second API call. Exactly the kind of bug you don’t notice in a short test article, but definitely notice once the workflow starts running for real.

The problem it solves. Account executives walk into meetings cold, or burn their mornings digging through the CRM. This does the digging before anyone is awake.

Only the meetings that matter. At 07:00 it reads the day's calendar and drops everything internal — if every attendee is on the company domain, no prep is generated. For external meetings it takes the guest's email domain and looks the company up in HubSpot: firmographics, plus every open deal and its stage.

A brief with a fixed skeleton. Claude writes against a strict structure: who's in the room, company snapshot, where the deal stands, this meeting's one outcome to push for, tailored questions, likely objections with answers, the closest customer proof point, recommended next step. The prompt's best line: "If context is thin, say so rather than inventing."

Delivered where the AE lives. The brief is staged in Notion, a note is logged on the HubSpot company so there's a paper trail, and the AE gets a Slack DM with a one-line summary and the link.

Full disclosure: reviewing v1 for publication I found three real defects — the parse step computed the brief and never returned it, the Notion step was referenced but missing entirely, and the calendar pull had no date window (it would prep every meeting ever booked). All three are fixed in the version you'll receive, marked in the node notes.

The problem it solves. Building a prospect list by hand eats SDR hours, and the quality depends entirely on who's doing the digging. This turns it into a form: type an industry, a geography and a number, get back a screened list.

It's an agent, not a pipeline. Unlike everything else on this page, there's no fixed sequence in the middle. A research agent — Claude with live web search as a tool and session memory — keeps searching, reading and collecting until it has the requested number of real companies matching the profile. It decides its own next search based on what it's found so far.

The agent doesn't get the final say. Every company it proposes goes through a code-based screen: is it a real, established company, does it sell physical products, is it the right size? Then a dedupe check against every lead from every previous run — the workflow remembers what it has already delivered, so nobody gets prospected twice.

Everything is logged. Survivors land in a Google Sheet, every run writes an audit row — who asked, for what, how many made it through — and the final list goes to Clay for enrichment before outreach.

Worth knowing if you adapt it: the download uses placeholder references for the prompts and screening code — that's deliberate. The ICP rules are the whole product here; you have to define what a qualified prospect means for your business before this is worth running.

The problem it solves. Somewhere around 95% of B2B website visitors never fill in a form. They read the pricing page, maybe an integration page, and leave. RB2B de-anonymizes a chunk of that traffic — you get the person and the company, not just an IP.

n8n is the router. RB2B’s integration fires a webhook per identified profile. A code node normalizes the payload, and an IF node splits the stream: company records go to one Clay table, people to another. Two HTTP calls, done. It’s a small workflow, but it’s the load-bearing joint between identification and enrichment.

Clay does the thinking. The company table enriches every domain — industry, employee count, revenue, city, which page they visited — and runs the qualification columns. The people table enriches the person: title, LinkedIn, work email. Crucially, Clay also checks the CRM first: is this contact already in HubSpot? Is there already a meeting booked? If yes, the flow stops right there — nothing kills trust faster than cold-emailing someone your AE met last week.

Qualified people go to Instantly. Contacts that pass the ICP screen get pushed into an Instantly campaign. The messaging can reference what they actually looked at, because the visited page travels with the record.

The loop closes on replies. When someone answers, Instantly fires a webhook back into a dedicated Clay table. From there two things happen at once: a Slack notification with the full context, and an upsert into HubSpot. The SDR sees the reply minutes after it lands, with the whole story attached — who they are, what they visited, what they were sent.

Worth knowing if you adapt it: the qualification columns are the whole product here. Which industries, what size, which pages signal intent — that’s your ICP encoded in a table, and it’s different for every business. Budget a real afternoon for those columns and treat the rest as plumbing.