Generate Dynamic Sales Pipeline Metrics for Slack
Every Monday, fetches deal data from Airtable to calculate pipeline value, win rate, and top deals.
What it does
Every Monday, you get a clear summary of your sales pipeline value, win rate, and top deals delivered straight to Slack. This automation pulls fresh data from Airtable and uses JavaScript logic to calculate these key metrics so your team stays informed without manual work.
Step by step
- Configure an Airtable scheduled trigger to fetch records from the Deals table at a fixed interval.
- Use JavaScript code to iterate through fetched records and calculate total pipeline value, weighted pipeline, closed revenue, and win rate based on deal stage and amount fields.
- Format the calculated metrics into a structured text block or Slack message payload.
Where the LLM does the work
- Generate the specific JavaScript logic for calculating weighted pipeline values by mapping Airtable stage names to their respective probability percentages.
- Draft the user-friendly Slack message template that highlights top deals and summarizes key performance indicators clearly.
- Define the conditional formatting rules for the Slack message, such as color-coding positive versus negative win rate changes.
Watch out for
Mismatched stage names in Airtable will cause incorrect probability calculations so ensure your code handles case sensitivity and typos gracefully.
Slack message length restrictions may truncate long deal lists so limit the number of top deals displayed to fit within character limits.
Empty or null values in the amount field can break arithmetic operations so add default zero checks before performing any math.
Tools that fit
The agent brief
Everything your agent needs, including the gotchas. Copy it and go.
You are helping me build the following AI agent workflow. ## Goal Generate Dynamic Sales Pipeline Metrics for Slack: Every Monday, fetches deal data from Airtable to calculate pipeline value, win rate, and top deals. ## Specification - What it does: Every Monday, you get a clear summary of your sales pipeline value, win rate, and top deals delivered straight to Slack. This automation pulls fresh data from Airtable and uses JavaScript logic to calculate these key metrics so your team stays informed without manual work. - Trigger: On a schedule (Scheduled · weekly) - Autonomy: Fully hands-off - Expected setup effort: under an hour - Tools/services involved: - Airtable: Fetch deal data and metrics - Code: Calculate sales metrics with JavaScript - Slack: Send formatted weekly report ## Known pitfalls, handle each one explicitly in your implementation 1. Mismatched stage names in Airtable will cause incorrect probability calculations so ensure your code handles case sensitivity and typos gracefully. 2. Slack message length restrictions may truncate long deal lists so limit the number of top deals displayed to fit within character limits. 3. Empty or null values in the amount field can break arithmetic operations so add default zero checks before performing any math. ## Reference implementation https://n8n.io/workflows/6463 (workflow template) Fetch and inspect this before building. If it matches my stack, adapt it; if not, rebuild the pattern with my tools. ## Process requirements 1. Before building: ask me which of the listed tools I actually use and what my platform is (n8n / Make / code / other). Do not assume. 2. Adapt the pattern to my answers; do not force the reference stack. 3. Address every pitfall above; tell me how you handled each. 4. Provide a test plan I can run before letting this touch real data. 5. Ask before any step that sends messages, modifies data, or spends money. Source: https://usecasesforagents.com/use-case/generate-dynamic-sales-pipeline-metrics-for-slack/ via usecasesforagents.com
Frequently asked questions
Can I use a different Spreadsheet than Airtable?
Yes. Airtable is only the example spreadsheet in this recipe. The same flow works with Baserow, Excel and Google Sheets. Swap the spreadsheet connection and keep the rest of the setup as written.
Want this running in your business?
This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.
Who it's for
Built for founders and execs who need sales handled without hiring for it.
Sales teams can plug this into their own CRM and call cadence just as easily.