The Scenario
Your sales manager designed a structured follow-up plan for 60 open deals after last week's pipeline review. She has a Google Sheet with a row per deal: deal_id, activity type (call, email, or meeting), subject line, due date, and due time. She wants all of those activities created in Pipedrive before the team starts their day tomorrow — so when reps log in, their queues already reflect the plan.
She has done this kind of activity loading manually before. The last time there were only 20 deals and it took her an hour, because creating an activity in Pipedrive means navigating to the deal, clicking Schedule Activity, filling in type, subject, date, time, and saving. That is six to eight interactions per activity. For 60 deals it's the better part of a morning.
The bad version:
- She starts clicking through deals and creating activities at 7 PM after a full day
- On deal 30 she accidentally sets the wrong date — she was looking at two deals simultaneously and the date from one leaked into the other
- She doesn't catch the error until a rep calls the next morning to ask why their activity is dated three weeks from now
Twenty activities need to be corrected. Three of them already got marked done by reps who thought it was a mistake and improvised.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the follow-up plan from the sheet and creates every Pipedrive activity in one operation — no per-deal navigation, no date fields entered by hand.
For each row in the FollowUpPlan sheet (columns: deal_id, activity_type, subject, due_date, due_time), create a Pipedrive activity linked to the deal and write the activity_id into column F.
What You Get
- A Pipedrive activity created for every row in the plan, linked to the correct deal
- Activity type, subject, due date, and due time populated from the sheet exactly as written
- The returned activity_id written into column F for each successful row
- Any row where the deal_id is not found or the activity type is invalid surfaces ERROR in column F
What If the Data Is Not Quite Ready
The activity type column has inconsistencies — some rows say Phone Call, others say call
Normalize the activity type in column B to Pipedrive's accepted values (call, meeting, email, task) before creating each activity. Map Phone Call to call, Zoom to meeting, and so on. Write the normalized type into column G and the activity_id into column F.
Some rows should be assigned to a specific rep, not the deal owner
For each row in FollowUpPlan where column G contains a user email, create the Pipedrive activity and assign it to that user instead of the deal owner. Where column G is blank, assign to the deal owner. Write the activity_id into column F.
You want to create activities for persons, not deals — the sheet has person_id instead of deal_id
For each row in CallSchedule (columns: person_id, subject, due_date, activity_type), create a Pipedrive activity linked to the person in column A. Write the activity_id into column E.
You need all activities created, each with a note attached, and a confirmation summary per rep
For each row in FollowUpPlan (columns: deal_id, activity_type, subject, due_date, due_time, rep_email, briefing_notes): create a Pipedrive activity linked to the deal, assigned to the rep. Attach a note to the deal with the briefing notes from column G. Write the activity_id into column H and note_id into column I. Below the data, write a summary showing each rep and the number of activities created for them.
The pattern: create the activity, attach the context, and report the summary in one prompt so the manager has a complete picture before the team starts their day.
Try It
Before your next pipeline review produces a follow-up plan, Get the 7-day free trial of SheetXAI and ask it to load the activities into Pipedrive in one operation. See the spoke on pulling overdue activities if you want to audit what got completed versus what got skipped afterward.