Weekly outbound queue from hiring signals with LeadMagic and Google Sheets

Build me an agent workflow that runs every Monday at 8am and produces a fresh outbound queue from hiring signals using LeadMagic, Google Sheets, and Slack.

On each run, the agent should:

1. Use the LeadMagic Jobs Finder operation to surface new job postings from the last 7 days that match my ICP. Defaults: target titles include VP of Sales, Head of RevOps, and Director of Marketing; target industries are B2B SaaS and FinTech; company size 50 to 1,000 employees; country United States. Make all of these editable variables at the top of the workflow.

2. For each job posting, use the LeadMagic Role Finder operation to identify the likely budget holder one level above the open role at that company (for example, if the open role is Director of Sales, find the current VP of Sales or CRO). If the open role is already C-level, default to the CEO.

3. For each identified budget holder, use the LeadMagic Email Finder operation to get a verified work email, and the LeadMagic Mobile Finder operation to get a direct mobile number. Only keep prospects who have at least a verified email. The mobile is optional. Skip prospects already added to the Weekly Outbound Queue tab in the last 4 weeks (dedupe by email).

4. For every qualified prospect, draft a short 3-sentence personalized cold opener that references the specific open role they are hiring for and what that signal says about their company (for example: scaling the sales motion, building a new function, replacing a recent departure). Keep the tone conversational and consultative. Do not include a hard pitch in the opener.

5. Append each qualified prospect as a new row to the Weekly Outbound Queue tab in my Google Sheet using the Google Sheets Append Values operation. Columns in order: Date Added, Prospect Name, Title, Company, Verified Email, Mobile, Role They Are Hiring For, Job Posting URL, Drafted Opener, Fit Score (1 to 5).

6. After the queue is updated, post a digest to my SDR Slack channel using the Slack Send a Message operation. The digest should include: total number of new prospects added this week, breakdown by target title, and a list of the top 5 highest-fit prospects (name, title, company, role they are hiring for, and a one-line summary of why they scored highest). Format the message with bold section headers and bullet lists so it is easy to scan on mobile.

Editable variables I want at the top of the workflow: target job titles, target industries, company size range, country, Google Sheet ID, sheet tab name, Slack channel, fit-score rubric (how to weight seniority, company size, and recency of the posting), and opener tone instructions.

Error handling: if LeadMagic returns insufficient credits, post a warning to the same Slack channel and stop the run. If a job posting returns no role match or no verified email, skip it silently and move on. If the Google Sheet append fails, retry once then post the failure to Slack with the run details.

Additional information

What does this prompt do?

Surfaces brand-new job postings at companies that match your ICP industries, size range, and target titles so your reps work from real hiring intent, not stale lists.
Identifies the likely budget holder one level above each open role, then finds their verified work email and direct mobile number.
Drafts a short, three-sentence personalized cold opener for every prospect that references the open role and what it signals about the company.
Appends each qualified prospect as a row in your Weekly Outbound Queue tab and posts a Monday-morning digest to your SDR channel with the total count and the top five highest-fit prospects.

What do I need to use this?

A LeadMagic account with credits available for jobs, role, email, and mobile lookups.
A Google Sheet you want to use as the outbound queue, with a tab named Weekly Outbound Queue.
A Slack workspace and the name of the channel where the SDR team wants the Monday digest.
Your ICP defined in plain language: target industries, company size range, and the job titles you care about.

How can I customize it?

Change the schedule. Run it daily, twice a week, or only on the first Monday of the month.
Adjust the ICP filters. Swap industries, headcount bands, geographies, or the list of target job titles whenever your focus shifts.
Tune the opener. Tell the agent your tone, the product context to reference, or a call-to-action line you want included in every draft.
Change the destinations. Point the queue at a different spreadsheet, tab, or Slack channel, and decide how many prospects appear in the top-five preview.

Frequently asked questions

How does the agent decide who the budget holder is?

For every open role, the agent looks one level up the org chart (for example, the VP of Sales above an open Director of Sales) and finds the person currently in that seat at the hiring company. You can override the lookup rule, like always targeting the CRO or the CEO at sub-50 person companies.

What if LeadMagic cannot find a verified email or mobile for a prospect?

The agent only adds a prospect to the queue when it has at least a verified email. If the mobile is missing, the row is still added with the mobile column left blank so your reps can still reach out by email.

Will the same prospect show up week after week?

No. The agent checks the existing Weekly Outbound Queue tab and skips anyone already added in the last four weeks, so your reps are not pitching the same person twice in a month.

Can I change the personalized opener style?

Yes. Tell the agent how you want it to sound, casual and conversational, formal and consultative, or framed around a specific product angle, and it will redraft every opener in that style.

Do I need a HubSpot or Salesforce account to run this?

No. The queue lives in Google Sheets and the digest lives in Slack. You can connect a CRM later if you want, but it is not required for the core workflow.