Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Lead Generation & Enrichment

Lead Generation & Enrichment

Score and enrich target accounts from Google Sheets with Glasser and Claude

Runs each morning to read new accounts from a Google Sheet, pulls profile, tech stack, news and funding via Glasser, scores fit with Claude and drafts openers.

What it does

# Score and enrich target accounts from Google Sheets with Glasser, Claude, Slack and Gmail ## Who it's for Sales, SDR and RevOps teams who keep a list of target companies in a Google Sheet and want each one researched, scored against their ideal customer profile and turned into a ready-to-send opener, without a rep doing the digging. ## How it works 1. Every morning (or on demand) the workflow reads the rows in your Accounts sheet that have no Status yet. 2. For each domain, four Glasser calls run in parallel: company profile, technology stack, recent news and funding rounds. Glasser picks the data provider (Apollo, BuiltWith, PredictLeads) and reports which one answered. 3. Claude scores the account from 1 to 10 against the ideal customer profile you wrote in Describe your ideal customer, names the strongest buying signal and the job titles worth contacting. 4. Accounts that score 6 or more get decision makers from Glasser (People Data Labs), each work email is verified with Glasser's email finder (Hunter), and Claude drafts a three-sentence opener. 5. Every row is written back to the sheet with score, reason, signal, contacts and opener, so nothing is researched twice. 6. Scores of 8 to 10 post to your hot-leads Slack channel and become a Gmail draft addressed to the top contact; 6 to 7 go to a warm-leads channel; below 6 is only logged. A summary is posted when the run ends. ## How to set up 1. Install the verified Glasser community node from the nodes panel. Create a Key at app.glasser.ai/keys and add it as a Glasser API credential on the seven Glasser nodes. 2. Make a copy of the Accounts sheet template, add your target domains in column A, and paste its spreadsheet ID into the three Google Sheets nodes. 3. Add your Anthropic API key in Claude (or swap in another chat model). 4. Write your ideal customer profile in Describe your ideal customer. 5. Connect Slack and set the two channel names in Alert hot lead and Alert warm lead; connect Gmail in Draft the first email. 6. Run it once with Execute workflow, then activate it for the daily schedule. ## Requirements - A Glasser account with balance. Expect 10 to 20 cents per hot account and about half of that for a cold one, because people and email lookups only run for accounts that score 6 or more. - An Anthropic API key, Google Sheets, Slack and Gmail. ## How to customize the workflow - Change the thresh

The steps

  1. Every morning
  2. Run now
  3. Read the accounts sheet
  4. Only unresearched rows
  5. Describe your ideal customer
  6. Loop over accounts
  7. Company profile
  8. Technology stack
  9. Recent news
  10. Funding rounds
  11. Wait for all four
  12. Build the account brief
  13. Score the account
  14. Score format

37 steps in total.

Similar automations