Sales Pipeline Value Calculator

WHAT IT DOES

Sales Pipeline Value Calculator scans CRM pipeline and opportunity pages, extracting deal data including deal name, amount, stage, probability, close date, owner, account, product/service, forecast category, and expected revenue. The tool then calculates the weighted pipeline value — the sum of each deal's amount multiplied by its probability of closing — and displays the total pipeline value with a detailed summary table. It also provides stage-weighted totals and forecast category breakdowns, giving you an instant view of your sales pipeline health and expected revenue.

WHERE IT RUNS

This userscript runs inside major CRM platforms including Salesforce, HubSpot, Pipedrive, Zoho, and Freshworks in your browser, powered by the free BotGentz extension. It operates entirely on the page you are viewing — it does not send your sales data anywhere else. All data extraction and processing happens locally in your browser. The script works on all CRM pipeline pages including list views, kanban boards, and custom report builder views.

HOW TO USE

Install the BotGentz extension, then install this userscript from the BotGentz catalogue. Navigate to your CRM's pipeline or opportunity page. The tool will automatically scan the page and show the number of deals found. Use the "Scan Page" button to manually refresh the data. Toggle "Show breakdown by stage" and "Show forecast category" to customize the summary view. Click "Copy Results" to copy the deal data and calculations to your clipboard as tab-separated text for pasting into spreadsheets or reporting tools. The tool displays total pipeline value, weighted pipeline value, and deal count at a glance.

HOW IT WORKS UNDER THE HOOD

The script uses a multi-strategy extraction approach that adapts to each CRM's unique DOM structure. It first attempts to locate opportunity tables using selectors like table.opportunity-table, .deals-table, and .pipeline-table. If those fail, it scans for any table containing CRM-related keywords like opportunity, deal, pipeline, stage, amount, probability, or close date. The script intelligently identifies table headers and maps values to their appropriate fields. For probability detection, the script looks for explicit percentage values or infers probability from the deal stage using a built-in mapping (e.g., Prospecting = 10%, Qualification = 25%, Proposal = 70%, Negotiation = 85%, Closed Won = 100%). The weighted pipeline value is calculated as the sum of amount × probability for all deals, providing an accurate forecast of expected revenue.

THE PANEL

The tool runs in the BotGentz panel, a draggable floating interface that stays on top of the page. You can drag the panel by its header, collapse it to a small bubble, and resize it. The panel remembers its position per site, so it stays where you left it when you return to your CRM. Press Escape to close the panel when you are done. The panel includes status indicators showing how many deals were found, toggle controls for breakdown views, and a results display showing total and weighted pipeline values.

PLEASE NOTE

This tool requires the free BotGentz extension to run. CRM platforms frequently update their interfaces — if the tool stops working, check for an updated version or report the issue. All data stays in your browser and is never sent to any external server. The tool works only on the current page; to analyze data from multiple pages, scan each page individually. The tool extracts visible data only and cannot access data not loaded on the current page. Probability inference from stage names is an estimate — actual probabilities may vary. Always verify calculated values against your CRM's official reports for accuracy.