Data to AI™ / Copilot/Pipedrive

Pipedrive to Microsoft Copilot integration

Let sales leaders and finance ask a Teams agent about pipeline by stage, slipping close dates and won revenue, straight from current Pipedrive data.

Less tokens, better answers.

  • Lower AI costs for the same work
  • More accurate, reliable answers
  • Read-only
  • Uses the Pipedrive data you already sync
  • SOC 2 Type II certified
Microsoft 365 Copilot
Connected to Dataddo

Which reps carry the most weighted pipeline expected to close in September?

Copilot Answer · Pipedrive

Open deals expected to close in September add up to €412,000, or €171,500 weighted. Marta Novak holds €82,000 of the weighted value, almost half.

Owner NameValueWeighted Value
Marta Novak Deals €168,000€82,000
Tom Reyes Deals €141,000€54,500
Lena Brandt Deals €103,000€35,000

Deals pulls all current records on every run, so open deals reflect the last extraction rather than a date window.

source
Pipedrive · as of Mon 06:40 UTC
covers
Expected Close Date 1-30 Sep 2026
Example answer · fictional account and figures
Pipedrive in Copilot

Questions Copilot can answer from your Pipedrive data

Pipedrive is a CRM for sales teams that manages leads, deals and the sales pipeline. Dataddo extracts deals, stages, pipelines, activities, leads and deal subscriptions, so RevOps can ask about pipeline and forecast in plain language.

Pipeline in the sales channel

Ask Copilot

@Pipeline Desk How much open Value sits in each Stage of the main pipeline, and which open deals are past Rotten Days?

Sales managers ask the agent in their Teams channel, so the weekly sales sync starts from current pipeline numbers rather than last Friday's screenshot.

Won deals handed to finance

Ask Copilot

@Pipeline Desk List Deals won this month by Won time with Title, Value and Owner Name, so billing can check them.

At month end, the finance lead asks Microsoft 365 Copilot and compares the list with what billing expects before invoices go out.

Stage configuration as code

Ask Copilot

Use the dataddo tools to describe Pipelines and Stage and generate a stage-probability config from Deal Probability and Pipeline Name.

A RevOps engineer uses GitHub Copilot in Agent mode to keep the forecast service's stage probabilities in line with Pipedrive.

Pipedrive datasets you can use in Copilot →
Pricing

Free during private pre-release.

Data to AI™ is free while in private pre-release. We onboard teams in waves and shape the product with their feedback. At launch, it will be priced like the AI assistants your team already uses. Need tailored contracts or volume pricing? Talk to us about Enterprise.

Data to AITM

Serve governed business data to Claude, ChatGPT and other AI tools over MCP.

Private pre-release

Free during pre-release

Enterprise

Flexibly deploy Dataddo in any cloud or hybrid environment.

Custom

We have a payment model that works for you

See all plans and features →
With vs. without

Pipedrive in Copilot, with and without Dataddo

Without Dataddo With Dataddo Outcome for you
Pipeline in the weekly sync A manager screenshots the Pipedrive board before the weekly sync, and the picture is out of date by the afternoon. Sales managers ask the agent in Teams, and it reads Deals and Stage from the latest scheduled extraction. Sync starts from current numbers
Stalled deals Rotten deals are spotted one at a time on the board, and those in other reps' pipelines slip by. Stage carries Rotten Days and Rotten Flag and Deals carries Rotten Time, so the agent lists stalled deals across all owners. Stalled deals surfaced
Handover to finance Finance receives won deals by email at month end and re-keys them before invoicing. The finance lead asks Microsoft 365 Copilot for won Deals with Value and Owner Name and pastes the list into the billing check. Won deals handed over cleanly
Token consumption Copilot spends tokens exploring raw Pipedrive columns, sampling rows and retrying until it understands the data. Field definitions and relations are supplied up front, so the model skips the exploration and goes straight to the answer. Less tokens per answer
Answer quality Prone to wrong joins, invented fields and numbers that are hard to check. Answers grounded in defined fields. In the Dataddo benchmark, 78.5% of questions were answered correctly, against 65.5% with plain CSV files. Better answers
Datasets

Pipedrive datasets you can use in Copilot

The Pipedrive datasets finance and RevOps teams use most, with their real field names. Copilot queries them by name through the Dataddo semantic layer.

List of curated datasets

IDid
string
Active Flagactive_flag
integer
Add Timeadd_time
datetime
Assigned To User IDassigned_to_user_id
float
Busy Flagbusy_flag
string
Calendar Sync Include Contextcalendar_sync_include_context
string
Company IDcompany_id
float
Conference Meeting Clientconference_meeting_client
string
Conference Meeting IDconference_meeting_id
string
Conference Meeting Urlconference_meeting_url
string
created_by_user_idcreated_by_user_id
float
Deal Dropbox Bccdeal_dropbox_bcc
string
deal_id
string
Deal Titledeal_title
string
Donedone
integer
Due Datedue_date
datetime
Due Timedue_time
string
Durationduration
string
Filefile
string
GGal Event IDgcal_event_id
string
Googlec Calendar ETaggoogle_calendar_etag
string
Googlec Calendar IDgoogle_calendar_id
string
Last Notification Timelast_notification_time
string
Last Notification User IDlast_notification_user_id
string
Lead IDlead_id
string
Lead Titlelead_title
string
Locationlocation
string
Location Admin Area Level 1location_admin_area_level_1
string
Location Admin Area Level 2location_admin_area_level_2
string
Location Countrylocation_country
string
Location Formatted Addresslocation_formatted_address
string
Location Localitylocation_locality
string
Location Postal Codelocation_postal_code
string
Location Routelocation_route
string
Location Street Numberlocation_street_number
string
Location Sublocalitylocation_sublocality
string
Location Subpremiselocation_subpremise
string
Marked As Done Timemarked_as_done_time
string
Notenote
string
Notification Language IDnotification_language_id
string
org_id
string
Org Nameorg_name
string
Owner Nameowner_name
sensitivestring
participants_person_id
string
Participants Primary Flagparticipants_primary_flag
integer
Person Dropbox Bccperson_dropbox_bcc
string
person_id
string
Person Nameperson_name
sensitivestring
Public Descriptionpublic_description
string
Rec Master Activity IDrec_master_activity_id
string
Rec Rulerec_rule
string
Rec Rule Extensionrec_rule_extension
string
Reference IDreference_id
string
Reference Typereference_type
string
Source Timezonesource_timezone
string
Subjectsubject
string
Yypetype
string
Type Nametype_name
string
Update User IDupdate_user_id
string
User IDuser_id
float
Update Timeupdate_time
datetime

Need a dataset, metric, or attribute you don't see?

Tell us what's missing and we'll add it to the connector.

Request it

Runs on your schedule, for example daily. Deals, Stage and Leads pull all current records each run, while Deals Timeline and Activities read a sliding date window, so older periods need a one-time full data re-sync.

Pipedrive connector →
Benchmark

More right answers. Half the confident mistakes.

We asked 43 pre-registered questions of three real datasets - Google Search Console, HubSpot deals and Google Ads - and delivered the same rows to the same model in four ways. Only the data layer changed.

78.5%

of questions answered correctly - the best of the four delivery methods tested

2x

fewer confidently wrong answers - 14.0% of runs against 24.0% and 26.3%

2.8x

more correct answers on messy CRM data - better on 8 questions, worse on none

Answered correctly All 43 questions - higher is better
Wrong, but stated as fact Share of runs - lower is better

Same model, prompts and rows in every condition; 759 graded runs, ground truth frozen before any run. On Google Search Console alone, documented CSV files did as well as Data to AI™ - the advantage comes from messier data such as HubSpot deals.

Read the benchmark →
FAQ

Pipedrive and Copilot: FAQ

How do I connect Pipedrive to Copilot?

Create a Pipedrive source in Dataddo with Deals, Stage and Pipelines and attach it to a Copilot destination or AI Model. In Copilot Studio, add a Model Context Protocol tool for https://headless.dataddo.com/mcp-data with OAuth 2.0 Dynamic discovery, then publish the agent to Teams and Microsoft 365 Copilot through Channels.

How do I connect Pipedrive to Microsoft 365 Copilot?

Through a Copilot Studio agent. Add Dataddo Data Access as a Model Context Protocol tool with OAuth 2.0 Dynamic discovery, then publish the agent via Channels > Teams and Microsoft Copilot.

How does the agent decide to query Pipedrive?

From the server description you enter in Copilot Studio. Say it holds Pipedrive deals, stages and pipelines, so pipeline and forecast questions trigger a Dataddo call.

Can sales leaders use the Pipedrive agent in Teams?

Yes. Once published to Teams, people type @ and pick the agent. The agent answers from the Pipedrive flows attached in Dataddo.

Is weighted pipeline available to Copilot?

Yes. Deals carries Weighted Value and Probability, and Stage carries Deal Probability, so the agent can report weighted and unweighted pipeline side by side.

Can GitHub Copilot read Pipedrive deals in VS Code?

Yes. Add the Dataddo server to .vscode/mcp.json, start it, sign in and use Copilot Chat in Agent mode. Business and Enterprise orgs must turn on the MCP servers in Copilot policy.