Bulk Create Notes on Pipedrive Deals From an Excel workbook

The Scenario

A sales rep switched dialers six months ago. Every call note from the old tool was exported as a CSV — 80 rows, each with a deal_id and a block of text from the call summary. The notes were supposed to be migrated into Pipedrive back in January. They weren't. Now the team is doing a CRM spring clean and someone handed the CSV to you.

The task seems simple: attach each note to its corresponding Pipedrive deal. In reality it means opening 80 deal records, clicking the notes worksheet, pasting the text, and saving. You have done similar work before. It takes longer than you expect and you make more mistakes than you'd like to admit, especially toward the end when you are tired and just want to be done.

The bad version:

• You start working through the workbook, opening Pipedrive deals by ID and pasting note content one by one
• On row 30 you accidentally paste the wrong note into the wrong deal and don't notice until row 45
• You have to go back and figure out which notes are in the wrong place, which means reading 15 deal records and comparing them to the workbook

An hour and a half for 80 notes. Three of them still in the wrong deal.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the deal IDs and note content from your sheet and creates the Pipedrive notes programmatically — no copy-paste, no worksheet-switching, no accidental mismatches.

For each row in the CallNotes sheet (columns: deal_id, note_content), create a Pipedrive note attached to the deal and write the returned note_id into column C.

What You Get

• A Pipedrive note created and attached to the correct deal for every row
• The returned note_id written into column C so you have a traceable record of what was created
• Any row where the deal_id is not found in Pipedrive surfaces ERROR in column C rather than silently skipping

What If the Data Is Not Quite Ready

The notes were exported with timestamps and you want those preserved as the note creation date

For each row in CallNotes (columns: deal_id, note_content, call_date), create a Pipedrive note attached to the deal with the content from column B. Use the date in column C as the note creation date. Write the note_id into column D.

Some deal IDs in the workbook are from the old system and need to be looked up by deal title instead

For each row in CallNotes where column A contains a text deal title instead of a numeric ID, search Pipedrive for a deal with that title, get its deal_id, and create the note. Write the resolved deal_id into column D and the note_id into column E. Flag any row where no matching deal was found.

You want to deduplicate before creating — check if a note with the same content already exists on the deal

For each row in CallNotes, check whether a Pipedrive note attached to the deal in column A already contains text matching column B. If a duplicate exists, write DUPLICATE in column C. If not, create the note and write the note_id into column C.

You need to create the notes and then schedule a follow-up review activity for each deal in one pass

For each row in CallNotes (columns: deal_id, note_content), create a Pipedrive note with the content in column B attached to the deal in column A. Then create a follow-up task activity on the same deal due in 5 business days with the subject Review imported call note. Write the note_id into column C and the activity_id into column D.

The pattern: create the note and trigger the follow-up in one prompt rather than running them as separate operations you have to manually reconcile.

Try It

If you have a batch of call notes sitting in a Excel workbook waiting to be migrated, Get the 7-day free trial of SheetXAI and let it handle the attachment in one operation. See the spoke on exporting all Pipedrive notes if you need to pull notes out of the CRM rather than push them in.