Dynamic Sales Pipeline Metrics: Airtable to Slack Weekly Report

This n8n workflow generates a dynamic weekly sales report by pulling deal data from Airtable, processing it to compute essential metrics such as total pipeline value, weighted pipeline based on deal stages, top deal value, closed revenue, and win rate. It uses a schedule trigger to run automatically (e.g., every Monday), splits data into open and closed deals, performs calculations via JavaScript nodes, and formats the results into a clean Markdown message for optimal readability in Slack.

Benefits include real-time visibility for sales teams without manual spreadsheet work, customizable weights for deal stages to reflect realistic forecasts, and easy integration into existing CRM processes. It saves hours weekly on reporting, enabling managers and founders to focus on strategy rather than data crunching.

Ideal use cases: Sales ops in startups or SMBs using Airtable as a lightweight CRM, revenue teams needing pipeline health checks, or any business wanting Slack notifications for key metrics. Easily adapt for other CRMs like HubSpot, add filters by rep/region, or include charts for enhanced visuals.