Daily lead source attribution from Follow Up Boss
Every morning at 7am ET, log yesterday's new Follow Up Boss leads to Google Sheets and post a top-sources summary to Slack.
Follow Up Boss
Google Sheets
SlackSalesOperationsDaily DigestsData SyncBuild a deterministic code workflow that runs every weekday at 7am ET and produces yesterday's lead source attribution report from Follow Up Boss. No AI rewriting or judgment calls. Same fixed pipeline every morning.
Trigger: cron, weekdays at 7am ET.
Step 1: Call Follow Up Boss List People filtered to people created in the previous 24 hours (createdAfter = yesterday 00:00 ET, createdBefore = today 00:00 ET). Paginate through all results.
Step 2: In code, group the returned people by their source field and count rows per source. For each source also collect the names of the new leads as a comma-joined string.
Step 3: Call Google Sheets Append Values on a tracking tab the user picks. Append one row per source with these columns in order: date (yesterday, YYYY-MM-DD), source, count, comma-joined names of the new leads from that source.
Step 4: After the sheet write succeeds, call Slack Send a Message to a channel the user picks. Post a single summary line that includes the total new leads, the top three sources by count (with their counts), and a link to the spreadsheet.
Keep this strictly code and CRUD. No model calls. If Follow Up Boss returns zero people for the window, still post the Slack summary saying zero new leads and skip the sheet append. Surface a clear error if the Follow Up Boss, Google Sheets, or Slack call fails.
What does this prompt do?
- Pulls every lead created in Follow Up Boss in the last 24 hours and groups them by lead source.
- Appends one row per source to a Google Sheets tracking tab with the date, source, lead count, and the names of the new leads.
- Posts a single summary line to Slack with the total new leads, the top three sources, and a link to the spreadsheet.
- Runs the exact same way every weekday so dead sources stand out and ROI per source is one tab away.
What do I need to use this?
- A Follow Up Boss account with API access (Admin > API).
- A Google account with edit access to the spreadsheet you want to log into.
- A Slack workspace and a channel where the morning summary should post.
How can I customize it?
- Change the schedule from 7am ET to whatever time fits your team's morning huddle.
- Point it at a different Google Sheets tab, or add extra columns like assigned agent or stage.
- Swap the Slack channel, or tweak the summary copy to highlight more than the top three sources.
FAQs
Does this work with any Follow Up Boss plan?
What if a lead source has zero new leads yesterday?
Can I change which Slack channel the summary posts to?
Will this overwrite my existing Google Sheets data?
What time zone does the 24-hour window use?
Related templates
Stage a batch of filings overnight, then approve each completed form from a screenshot before anything is ever submitted.
Work every partner tier decision from one board, with the revenue and commission numbers, clear promotion thresholds, and AI review briefs.
Open one board at month end to find every closed deal missing a commission, every commission with no deal behind it, and every amount that does not add up.
Review every conversation Fin closed as resolved, judge which ones actually stuck, and see what the gap is worth against your bill.
Work every return, damage and warranty claim in one queue, with the order, the delivery date and a policy-backed recommendation already on screen.
See warmup status, daily send volume, and bounce risk for every sending account in one grid, with the riskiest mailboxes floating to the top.
Stop guessing which lead sources are actually working.
Connect Follow Up Boss, Google Sheets, and Slack once, and Geni delivers the same source attribution report every weekday morning.