Check whether each rep’s Pipedrive pipeline can cover the rest of their quota.
Put the quotas your team keeps in Google Sheets next to the deals each rep owns in Pipedrive. See who has enough open pipeline closing this quarter, whose pipeline depends on close dates that have already passed or are missing, and which forecast rests on one deal’s custom probability.
Which reps don’t have enough pipeline to reach quota this quarter?
Rep
Remaining quota
Open this quarter
Coverage
Ben Carter
$57,000
$96,000
1.7×
Dev Patel
$34,000
$28,000
0.8×
Whole team
$148,000
$306,000
2.1×
Quarter Oct 1–Dec 31, 2026 · Pipedrive read Nov 16, 12:00 UTC
The team has won $117,000 of its $265,000 quarterly quota, leaving $148,000. Open deals expected to close by Dec 31 add up to $306,000, which is 2.1× the remaining quota against a 3.0× target. Ana Ruiz and Chloe Park are above target. Ben Carter is at 1.7× with $44,000 of deals whose close dates have already passed, and Dev Patel is at 0.8× with $22,000 of deals that have no close date.
WHERE THE RESULT GOES
Google Sheets
Export each data source report to Google Sheets, then add your analysis or checklist to the review Sheet.
Example use case
Ask. Follow up. Take the next step.
✦ AI assistantSample use case
YOU
Which reps don’t have enough pipeline to reach quota this quarter?
✦
The team has won $117,000 of its $265,000 quarterly quota, leaving $148,000. Open deals expected to close by Dec 31 add up to $306,000, which is 2.1× the remaining quota against a 3.0× target. Ana Ruiz and Chloe Park are above target. Ben Carter is at 1.7× with $44,000 of deals whose close dates have already passed, and Dev Patel is at 0.8× with $22,000 of deals that have no close date.
01
Ben Carter · 1.7× coverage$57,000 left to win · $96,000 open this quarter · $44,000 with passed close datesReview in pipeline meeting
Ben Carter has won $18,000 of a $75,000 quota. To reach the 3.0× target, $171,000 of open deals should be expected to close by Dec 31, so $75,000 is missing. Three more open deals worth $44,000 (Kinsale Foods, Redwood Clinics and Mosaic Travel) have expected close dates between Oct 31 and Nov 13 and are not counted. Even if all three were moved into this quarter, coverage would be 2.5×.
NextIn the pipeline meeting, Ben Carter gives each of the three deals a new close date or marks it lost in Pipedrive. The sales manager then decides with Ben Carter where the rest of the missing pipeline comes from, for example new outreach or deals that can be pulled in from January.
02
Dev Patel · 0.8× coverage$34,000 left to win · $28,000 open this quarter · $22,000 with no close dateAdd close dates first
Dev Patel has won $6,000 of a $40,000 quota, and the open deals expected this quarter cover less than the remaining $34,000. Juniper Health ($15,000) and Brightline Media ($7,000) have no expected close date, so they cannot be placed in any quarter. With both dated before Dec 31, coverage would still only be 1.5×.
NextDev Patel adds realistic close dates to the two undated deals this week. The sales manager decides whether to route more new leads to Dev Patel or lower expectations for this quarter, and records that decision in the quota Sheet.
03
Chloe Park · Forecast rests on one deal3.4× coverage · Atlas Robotics is $40,000 of $64,000 · Custom probability 80%Confirm the probability
Chloe Park’s coverage is above target, and the weighted forecast is $81,000 against a $60,000 quota. But Atlas Robotics is in the Demo done stage, where the stage probability is 25%, and the deal has a custom probability of 80%. At the stage probability the forecast would be $59,000, just under quota. Without Atlas, the open pipeline this quarter is $24,000.
NextIn the deal review, Chloe Park explains what supports 80% on Atlas Robotics. The manager decides whether to keep it, and whether Chloe Park needs another deal for this quarter in case Atlas slips. Kestrel Tours (€12,000) is listed separately because the quota is in USD.
Quarter Oct 1–Dec 31, 2026 · Pipedrive read Nov 16, 12:00 UTC
01 · CONNECT YOUR DATA
Your tools. One place to ask.
2 of 3 Free data sources No credit card · Daily refresh
DatapipeYour project
✦Your AI assistantor a report in Sheets / Data Studio
Create your free workspace
Sign up with your company email. Your first project opens on Data sources.
Add the data sources
Choose the accounts for this use case. Authorize access and select the property or site.
Bring your question
Connect your project to a supported AI assistant, or build your source reports.
Email/password signups confirm their email first. Use Google signup with a company account if you prefer.
Pipedrive: Add the intended Pipedrive company using its supported sign-in or your personal API token. You see the people and deals your Pipedrive permissions allow. Setup guide ↗
Google Sheets: Authorize Google Sheets with an account that can open the file, then paste the spreadsheet link and select the intended tab and columns. Setup guide ↗
Free includes 3 data sources across the workspace. One account/property added to one project counts as one. Extra properties or the same account in another project use another slot.
02 · ASK A USEFUL QUESTION
Start with a prompt. Follow the evidence.
Copy these in order into your connected assistant. Each builds on the answer before it.
01
Read our quotas and find the matching Pipedrive owners
Read the full prompt
Use only this Datapipe project’s authorized data. Discover the connected accounts, datasets and compatible fields first. Confirm dates, timezones, currencies and data coverage. Keep missing or unmatched rows visible; never substitute sample data. Compare the sources explicitly and explain every match. Do not change source records or send messages.
From the connected Google Sheet, find the tab that holds our quarterly quotas and show me its headers. Return each row’s owner_id, rep_name, quarter_start, quarter_end, quota, currency and coverage_target. Then, from the connected Pipedrive company, check which datasets and fields are available for deals, pipeline stages and pipelines, and confirm that every owner_id in the Sheet appears as an Owner ID on at least one deal. List Sheet rows with no matching deals and Owner IDs on deals that are not in the Sheet. If a header differs from what you expect, ask me how to map it rather than guessing. This Sheet is the plan our sales team maintains, not an export.
02
Read the deals and stages for this quarter
Read the full prompt
From Pipedrive, read Deals inventory with Deal ID, Deal title, Owner ID, Pipeline ID, Stage ID, Deal value, Currency, Deal status, Win probability, Expected close date and Won at. As separate reads, return Pipeline stages with Stage ID, Stage name, Pipeline ID and Stage probability, and Pipelines with Pipeline ID, Pipeline name and Deal probabilities enabled. Use the quarter dates from the Sheet. Tell me how many deals are won, open and lost, how many open deals have no expected close date, and how many have an expected close date before today. Treat Won at as UTC. Do not add values across currencies, and tell me if any won deals this quarter may be archived and therefore missing from this read.
03
Prepare the coverage table for our pipeline meeting
Read the full prompt
Using the Sheet’s quotas and targets, build a table with one row per rep: quota, won this quarter, remaining quota, open deals expected to close between today and quarter end, coverage (open ÷ remaining), the coverage target and the shortfall to reach it. Add a weighted forecast: won plus each open deal’s value multiplied by its own Win probability when set, otherwise its Stage probability, divided by 100. Under each rep, list separately and leave out of coverage: open deals whose expected close date has passed, open deals with no expected close date, deals expected after quarter end, and deals in a currency other than the quota’s. Flag any deal whose own probability is higher than its stage probability, and show the rep’s forecast using the stage probability instead. Draft this in our conversation; do not change deals in Pipedrive or edit the Sheet.
Compare each rep with their quota, then review the gaps.
01
Read the quotas your team keeps in Google Sheets.
02
Read the deals inventory, stages and pipelines from Pipedrive.
03
Compare each rep with their quota, then review the gaps.
↗
Check the result at your next review.
After the pipeline meeting, read both sources again. Check that the three passed close dates on Ben Carter’s deals and the two missing dates on Dev Patel’s deals have been updated, and compare each rep’s new coverage with this week’s 1.7× and 0.8×. Repeat every week until quarter end, and watch whether Atlas Robotics moves to a later stage.
Implementation tips for this use case
Match deals to Sheet rows by Owner ID. Count won deals whose Won at date falls inside the quarter. Count open deals in the quota currency whose expected close date is between today and quarter end. Divide that open total by the remaining quota to get coverage, and compare it with coverage_target. Weight each open deal by its own probability when set, otherwise by its stage probability. List deals with passed or missing close dates, later quarters and other currencies separately. Take the list to the weekly pipeline meeting, where each rep updates their own deals and the sales manager decides on next steps.
WHEN YOU NEED MORE CONTEXT
Go a little deeper.
The method and reporting checks behind this example.
How to check each rep’s Pipedrive pipeline against the quotas in Google Sheets
Read the quotas your team keeps in Google Sheets.
Add the Pipedrive company and the Google Sheet with your quotas to one project. Discover the actual tab and headers. The example tab has one row per rep with owner_id, rep_name, quarter_start, quarter_end, quota, currency and coverage_target. owner_id is the rep’s Pipedrive user ID, which is how the two sources are matched; names are not used for matching. Quotas and targets are decisions your team owns, so they live in the Sheet rather than Pipedrive.
Read the deals inventory, stages and pipelines from Pipedrive.
Read Deals inventory with Deal ID, Deal title, Owner ID, Pipeline ID, Stage ID, Deal value, Currency, Deal status, Win probability, Expected close date and Won at. Then read Pipeline stages with Stage ID, Stage name, Pipeline ID and Stage probability, and Pipelines with Pipeline ID, Pipeline name and Deal probabilities enabled. Deals inventory is the current, non-archived list, and report dates do not filter it. Won at is a UTC timestamp; Expected close date is a plain date. If your team archives won deals, read Archived deals as well.
Compare each rep with their quota, then review the gaps.
Match deals to Sheet rows by Owner ID. Count won deals whose Won at date falls inside the quarter. Count open deals in the quota currency whose expected close date is between today and quarter end. Divide that open total by the remaining quota to get coverage, and compare it with coverage_target. Weight each open deal by its own probability when set, otherwise by its stage probability. List deals with passed or missing close dates, later quarters and other currencies separately. Take the list to the weekly pipeline meeting, where each rep updates their own deals and the sales manager decides on next steps.
See the complete example report
EXAMPLE REPORT
Which reps don’t have enough pipeline to reach quota this quarter?
Quarter Oct 1–Dec 31, 2026 · Pipedrive read Nov 16, 12:00 UTC
Which reps don’t have enough pipeline to reach quota this quarter?
Rep
Remaining quota
Open this quarter
Coverage
Ben Carter
$57,000
$96,000
1.7×
Dev Patel
$34,000
$28,000
0.8×
Whole team
$148,000
$306,000
2.1×
WHAT TO LOOK ATThe team has won $117,000 of its $265,000 quarterly quota, leaving $148,000. Open deals expected to close by Dec 31 add up to $306,000, which is 2.1× the remaining quota against a 3.0× target. Ana Ruiz and Chloe Park are above target. Ben Carter is at 1.7× with $44,000 of deals whose close dates have already passed, and Dev Patel is at 0.8× with $22,000 of deals that have no close date.
Compare each rep with their quota, then review the gaps.
Ben Carter has won $18,000 of a $75,000 quota. To reach the 3.0× target, $171,000 of open deals should be expected to close by Dec 31, so $75,000 is missing. Three more open deals worth $44,000 (Kinsale Foods, Redwood Clinics and Mosaic Travel) have expected close dates between Oct 31 and Nov 13 and are not counted. Even if all three were moved into this quarter, coverage would be 2.5×. Dev Patel has won $6,000 of a $40,000 quota, and the open deals expected this quarter cover less than the remaining $34,000. Juniper Health ($15,000) and Brightline Media ($7,000) have no expected close date, so they cannot be placed in any quarter. With both dated before Dec 31, coverage would still only be 1.5×. Chloe Park’s coverage is above target, and the weighted forecast is $81,000 against a $60,000 quota. But Atlas Robotics is in the Demo done stage, where the stage probability is 25%, and the deal has a custom probability of 80%. At the stage probability the forecast would be $59,000, just under quota. Without Atlas, the open pipeline this quarter is $24,000.
Try the example with sample CSVs
Fictional rows matching the example above. Attach these files to your assistant for a sample analysis.
Data method, reporting checks & sources
Add the Pipedrive company and the Google Sheet with your quotas to one project. Discover the actual tab and headers. The example tab has one row per rep with owner_id, rep_name, quarter_start, quarter_end, quota, currency and coverage_target. owner_id is the rep’s Pipedrive user ID, which is how the two sources are matched; names are not used for matching. Quotas and targets are decisions your team owns, so they live in the Sheet rather than Pipedrive. Read Deals inventory with Deal ID, Deal title, Owner ID, Pipeline ID, Stage ID, Deal value, Currency, Deal status, Win probability, Expected close date and Won at. Then read Pipeline stages with Stage ID, Stage name, Pipeline ID and Stage probability, and Pipelines with Pipeline ID, Pipeline name and Deal probabilities enabled. Deals inventory is the current, non-archived list, and report dates do not filter it. Won at is a UTC timestamp; Expected close date is a plain date. If your team archives won deals, read Archived deals as well. Match deals to Sheet rows by Owner ID. Count won deals whose Won at date falls inside the quarter. Count open deals in the quota currency whose expected close date is between today and quarter end. Divide that open total by the remaining quota to get coverage, and compare it with coverage_target. Weight each open deal by its own probability when set, otherwise by its stage probability. List deals with passed or missing close dates, later quarters and other currencies separately. Take the list to the weekly pipeline meeting, where each rep updates their own deals and the sales manager decides on next steps.
Deals are matched to quota rows by Pipedrive Owner ID, not by rep name. Won deals count only when the UTC date of Won at falls inside the quarter in the Sheet. Open deals with passed or missing expected close dates, later quarters or another currency are listed but kept out of coverage. Weighted value uses the deal’s own probability when set and the stage probability otherwise, and a raised custom probability is shown both ways.
Deals are matched to quota rows by Pipedrive Owner ID, not by rep name.
Won deals count only when the UTC date of Won at falls inside the quarter in the Sheet.
Open deals with passed or missing expected close dates, later quarters or another currency are listed but kept out of coverage.
Weighted value uses the deal’s own probability when set and the stage probability otherwise, and a raised custom probability is shown both ways.
Access to the intended Pipedrive account or property.
Access to the intended Google Sheets account or property.
Deals are matched to quota rows by Pipedrive Owner ID, not by rep name.
For blended reports, align dates, normalized URLs, and reporting grain. Query-level search rows must not duplicate page-level sessions.
Pipedrive holds the deals: values, stages, owners, close dates and wins. The quota for each rep and the coverage target are decisions your sales manager makes, and many teams keep them in a spreadsheet. Only together do they show whether each rep has enough pipeline left for the quarter.
What is pipeline coverage?
Coverage here is the value of open deals expected to close by quarter end divided by the quota a rep still has to win. A target of 3× means the team expects to need about three dollars of open pipeline for every dollar still to win. Set the target in your Sheet from your own win rates.
Why are deals with passed close dates left out?
A deal that was expected to close on Oct 31 and is still open may now close in December, next year or never. Until the rep updates the date, there is no reliable way to put it in this quarter. The deals are listed under each rep so they can be updated in the pipeline meeting.
How is the weighted forecast calculated?
Each open deal’s value is multiplied by its probability and divided by 100. Pipedrive uses the deal’s own probability when one is set and the stage probability otherwise, and this use case follows the same rule. If a pipeline has deal probabilities turned off, use the coverage figures and leave out the weighted forecast.
Can it read the goals we set in Pipedrive?
Pipedrive goals are not read here. Keep the quotas in a Google Sheet with each rep’s Pipedrive Owner ID so the two can be matched exactly.
Does the assistant update deals or close dates?
No. It prepares the coverage table and the lists of deals to review in your conversation. Each rep updates their own deals in Pipedrive, and the sales manager decides on quotas and lead routing.
YOUR NEXT STEP
Try it with your own data.
Start free with up to 3 data sources. No credit card.