Sales · USE CASE

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.

Data sources
Assistant
Destination
Try it with your data Free with up to 3 data sources · No credit card
A WORKED EXAMPLE

Which reps don’t have enough pipeline to reach quota this quarter?

RepRemaining quotaOpen this quarterCoverage
Ben Carter$57,000$96,0001.7×
Dev Patel$34,000$28,0000.8×
Whole team$148,000$306,0002.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
PipedriveGoogle Sheets
YOU

  1. 01
    $57,000 left to win · $96,000 open this quarter · $44,000 with passed close datesReview in pipeline meeting

    Next

  2. 02
    $34,000 left to win · $28,000 open this quarter · $22,000 with no close dateAdd close dates first

    Next

  3. 03
    3.4× coverage · Atlas Robotics is $40,000 of $64,000 · Custom probability 80%Confirm the probability

    Next

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
  1. Create your free workspace

    Sign up with your company email. Your first project opens on Data sources.

  2. Add the data sources

    Choose the accounts for this use case. Authorize access and select the property or site.

  3. Bring your question

    Connect your project to a supported AI assistant, or build your source reports.

Create a free account →
Setup steps & what you need

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.

03 · USE WHAT YOU FIND

Compare each rep with their quota, then review the gaps.

  1. 01

    Read the quotas your team keeps in Google Sheets.

  2. 02

    Read the deals inventory, stages and pipelines from Pipedrive.

  3. 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
  1. 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.

  2. 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.

  3. 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?
RepRemaining quotaOpen this quarterCoverage
Ben Carter$57,000$96,0001.7×
Dev Patel$34,000$28,0000.8×
Whole team$148,000$306,0002.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.

A FEW USEFUL ANSWERS

Before you start.

Why do I need both Pipedrive and a spreadsheet?

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.

Start free →