DEV Community

Stackscale
Stackscale

Posted on

Find B2B Leads with Perplexity and Save to Google Sheets

Stop hunting for B2B leads by hand. Learn how to find b2b leads with perplexity — Perplexity finds the companies, Make logs them, and Google Sheets fills itself with new leads every morning.

This is the companion tutorial for the StackScale video above. No code, no scraping, and no real prospect data — the whole flow runs on dummy companies so you can test it safely.

What You Will Build

A Google Sheet that grows by itself every morning: company name, city, industry, and one sentence on why each company might need what you sell. You open the sheet and the leads are already there.

Prerequisites / Tools

  • A Make account (free plan is enough to start)
  • A Perplexity account
  • A free Google Sheet
  • One line describing your ideal customer — for example, independent bakeries in London that sell online

Disclosure: Some links below are affiliate links, meaning StackScale may earn a commission at no extra cost to you.

The Workflow

Perplexity searches the web for companies matching your ideal customer. Make runs that search on a schedule. Google Sheets logs every company with its hook and industry. Three tools, one row per company, zero typing.

Step 1: Write the Perplexity Search Prompt

In Make, add a Perplexity module and ask it to find companies that match your ideal customer, returning the exact fields you want. Copy this prompt as-is and change the customer line to yours:

Find 10 independent bakeries in London that sell online. Return company name, city, industry, and one sentence on why they might need a new website.
Enter fullscreen mode Exit fullscreen mode

One prompt is the targeting — be specific about who you want and what fields come back.

Step 2: Schedule the Make Scenario

In Make, set the scenario to run every morning at nine. Perplexity runs the same prompt, and every new company it finds flows into the next module. Same prompt, fresh leads daily.

Step 3: Let Perplexity Find the Companies

Perplexity reads the web and returns named businesses, each with a hook. For testing, use two fictional demo companies — Northwind Bakery in London and Acme Studio in Manchester — each with a hook like a new online shop or a rebrand. Both names are fictional demos, only to show the flow.

Step 4: Map the Results into Google Sheets

Map each field Perplexity returns into a column:

{
  "Company": "company name",
  "City": "city",
  "Industry": "industry",
  "Why Now": "one-sentence hook"
}
Enter fullscreen mode Exit fullscreen mode

One row per company. Make only adds companies not already in the sheet, so there are no duplicates.

Step 5: Test with Dummy Data

Run the scenario once by hand and watch Northwind Bakery and Acme Studio land in the sheet — company, city, industry, hook, all in the right columns. Two rows, zero typing. Once the test rows look right, leave the schedule on and let it run every morning.

The Finished Result

A Google Sheet that fills itself with companies matching your ideal customer, each with a hook saying why to reach out. Open it each morning and you know who to contact today.

One Honest Limit

Perplexity is not a contact database. It finds companies and hooks, not verified email addresses — emails are often outdated or missing entirely. Use this sheet to pick who to approach, then find the right contact yourself. Companies and hooks, not promised inboxes.

Watch the Full Tutorial

The video at the top walks through the same five steps with the live mockups. All mockups in the video are synthetic, created for this tutorial, with dummy data only — no real prospect is shown, and no real email address appears anywhere.

New automation tutorials every day on StackScale — subscribe on YouTube at https://www.youtube.com/@StackScaleHQ.

Top comments (0)