Cockpit Sign up
[ AI ]

Generate hyper-personalized cold emails from enriched rows

Use Cockpit to turn LinkedIn and SEO enrichment data into reviewable cold-email drafts inside a spreadsheet workflow built for outbound teams.

Use this playbook

Overview

Generate hyper-personalized cold emails from enriched rows without moving between separate tools for enrichment, prompting, and review. This workflow starts with LinkedIn and company context, extracts a clean website domain, enriches that domain with Ahrefs SEO signals, and then feeds those fields into an AI-powered sequence step. Because source columns, enrichment outputs, generated drafts, and review decisions stay in the same Cockpit sheet, operators can see exactly what informed each message, test small batches before scaling, and refine prompts until the outreach sounds genuinely researched instead of lightly customized.

This use case is for teams that want to combine lead data, company research, and AI copy generation in one operational workflow. Instead of enriching data in one tool and writing prompts in another, you keep the whole personalization system inside Cockpit so each outbound draft remains traceable to the columns that produced it and easier to revise when the message needs improvement.

How it works

1

Start with LinkedIn-enriched rows

Contacts and company context ready

2

Extract domains and enrich SEO signals

Traffic and authority fields added

3

Generate AI sequence copy

Hyper-personalized cold email draft

4

Review and rerun rows

Approved drafts ready

Step-by-step process

  1. 1

    Start with contact and company rows

    Begin with spreadsheet rows that already contain LinkedIn profile and company context. In the walkthrough, the sheet includes LinkedIn URL, current job title, current company, company URL, and LinkedIn company details before any new personalization fields are added.

  2. 2

    Extract a usable website field

    Create a Subproperty column to pull the company website domain out of the LinkedIn JSON. The video uses the simplified website value so the next enrichment step can run against a clean domain instead of raw JSON, which makes the downstream enrichment and AI prompt much easier to manage.

  3. 3

    Enrich rows with SEO context

    Add an Ahrefs domain overview enrichment column and test it on the first 10 rows before running more broadly. Then extract the fields you want to reference in copy, including domain rating and traffic, while keeping richer nested traffic data available if the AI should use the full context later.

  4. 4

    Generate sequence copy with AI

    Create a Sequence column, switch the content to AI mode, choose a fast model such as deepseek/deepseek-v4-flash, and write a prompt that explains the offer and desired outcome. In the video, the prompt asks for a concise cold email for enterprise SEO services and attaches DR, traffic, and LinkedIn JSON as inputs so the draft has concrete evidence to work from.

  5. 5

    Preview, refine, and rerun

    Inspect the generated message for a sample row, then tighten the prompt when the output is too generic. The walkthrough improves the result by asking the model to mention important metrics, which turns the draft into a more specific outreach message that references the prospect's SEO numbers instead of sounding like a generic template.

Key outputs

Ahrefs SEO context

Enrichment

SEO fields extracted from the Ahrefs domain overview enrichment, including authority, traffic, and supporting context that give the AI concrete details to reference when writing the opener or value proposition.

  • Domain rating
  • Organic traffic snapshot
  • Traffic history JSON
  • Keyword value or related supporting metrics

Cold email draft

AI

The generated outreach message for each row, written from the attached enrichment and LinkedIn context and kept in the sheet for review, editing, approval, or rerun.

  • Opening line tied to company context
  • Metric mention grounded in enrichment data
  • Offer framing and value proposition
  • Call to action ready for sequence handoff

What makes a cold email feel hyper-personalized

Hyper-personalized outreach is not just about adding a company name or a role title. The message feels stronger when the prompt is fed with actual signals that are relevant to the offer. In this workflow, those signals come from LinkedIn company context and Ahrefs SEO data, which gives the AI a reason to mention traffic, authority, or other website-level details when writing the opener.

The sheet matters because it keeps the source data visible. You can see the original LinkedIn fields, the extracted domain, the SEO enrichment, and the generated email in one place. That makes it much easier to tell whether the draft is actually grounded in the data or just using it as a shallow decoration.

That is also why the review loop in the walkthrough is important. The first pass may be fine structurally but still too vague. By previewing a row, tightening the prompt, and rerunning, you can move from "AI wrote a email" to "AI wrote a message that uses the right metric for the right company."

  • Use a clean domain before enrichment so the data is reliable.
  • Expose only the metrics that actually help the email angle.
  • Keep generated drafts and review status in the same sheet.

This workflow is a strong fit for SEO agencies, growth consultants, and operators who sell services that can be tied back to website performance. If the offer is unrelated to traffic or search visibility, the same format still works, but the metrics should change to something more credible for the buyer. The point is to make each draft feel earned by the data, not embellished by the prompt.

To get started

  • Prepare rows with LinkedIn company details or similar source data
  • Extract a clean website domain into its own column
  • Run Ahrefs enrichment and attach the useful fields to the AI step
  • Review a small batch before expanding the run to the full sheet

When to use this

  • You want personalized outbound that cites real company data
  • Generic AI email drafts are not specific enough to ship
  • Your team wants enrichment, prompting, and review in one sheet
  • You need a repeatable workflow that can be reused across future lead lists

Integrations

LinkedIn data columns
Subproperty columns
Ahrefs domain overview enrichment
Sequence columns

What you can swap

This playbook follows the workflow shown in the video, but the exact source, enrichment, prompt, and handoff can be changed to match your team.

  • Source rows or import method
  • Domain or company enrichment provider
  • AI model and prompt wording
  • Review criteria and export destination
  • Sequence structure or handoff tool

Common questions

Do I need Ahrefs to use this workflow?

No. Ahrefs is the enrichment shown in the video, but the same pattern works with any provider that gives useful company-level signals the AI can cite in the message. The important part is not the vendor itself, but having a clean domain input and a few high-signal fields the AI can reference clearly.

Why use a sequence column instead of a plain AI column?

The walkthrough uses a Sequence column because the draft is meant to live inside an outbound message flow. That keeps the copy close to the later handoff, makes it easier to build multi-step outreach from the same rows, and gives the team a more realistic preview of how the message will be used downstream.

Can I improve weak outputs without rebuilding the workflow?

Yes. The video explicitly shows previewing a row, updating the prompt to mention important metrics, and rerunning so the draft becomes more concrete without changing the underlying sheet structure. In practice, this means you can treat the columns as your stable system and iterate mostly on prompting, attached fields, and review rules.

Who is this playbook best for?

It is a strong fit for agencies, SDR teams, founders doing founder-led sales, and growth operators who sell SEO, content, demand generation, or adjacent services where company-level proof points make outreach more credible.

What makes this different from normal AI cold email generation?

The difference is that the message is not generated from a standalone prompt alone. It is generated from structured sheet columns that include LinkedIn context, extracted domains, enrichment results, and review loops, which makes the workflow easier to inspect, scale, and reuse.

More AI playbooks

Write Personalized First Lines

Generate one opener per lead from title, company description, website notes, and a recent signal column.

Personalize cold emails from lead data

Use company description, ICP fit notes, and contact role to draft a tailored intro and value-prop paragraph for each row.