How to build a Notion meeting notes database with AI autofill
Build a Notion meeting notes database that auto-summarizes and extracts next steps with AI autofill, then surface the right meetings anywhere using linked views.
How a Small 401(k) Advisory Firm Automated Appointment Tracking and Caller Payroll with Airtable + Zapier
A 10-person 401(k) advisory firm used Airtable, Zapier, and Calendly to automate appointment tracking and caller payroll, cutting 3–4 hours of month-end work.
TABLE OF CONTENTS
TL;DR: A small retirement-plan advisory firm swapped six years of per-caller Google Sheets for an Airtable + Zapier + Calendly pipeline. Every booked appointment now logs itself, creates the CRM deal, and updates the caller's pay tally automatically, removing a 3–4 hour month-end payroll reconciliation and an estimated 20–25 manual handoffs a day.
The Situation
The firm is a small (~10-person) advisory practice that sets up and services 401(k) plans for small businesses. Two advisors run the sales side, splitting prospects by geography. A team of five long-tenured contract callers (two to seven years each) cold-calls business owners and books discovery calls onto the advisors' calendars. A few plan managers handle existing clients after a plan closes.
The callers are paid per qualified appointment. The pay plan is tiered: per-appointment values that step up as a caller books more in a month, a forgivable draw, and a quarterly bonus. That means every booked call is both a sales opportunity and a payroll line item.
The stack before Connex: Google Calendar and Outlook for scheduling, Pipedrive as the CRM, RingCentral for calls, Dropbox for files, and a Google Sheet per caller for leads, appointments, and the monthly pay tally. They were booking roughly 4–5 appointments a day.
The Problem
Each appointment set off a chain of manual steps. The caller booked the call, then emailed the advisors about it. An advisor sent the prospect a confirmation from Outlook, keyed the company and contact into Pipedrive, and emailed the caller back. The caller then opened a separate monthly pay sheet and added the appointment to their tally.
That held together day to day. It fell apart at month-end, when the advisors had to work out which appointments actually counted toward payroll. Calls that were rescheduled, pushed into the next month, marked not qualified, or that no-showed all changed what a caller was owed. Someone had to find them in the sheets and move them by hand.
"We find ourselves doing payroll because this will dictate our payroll. So this is where we spend like 3 to 4 hours on the 30th or the 31st to reconcile." — one of the firm's advisors, on the first call
The other advisor called the review process "kind of archaic" and pointed out a second cost: because history lived in years of sheets instead of the CRM, follow-ups with prospects they'd spoken to months earlier slipped through. The no-show column, in the first advisor's words, "is never perfect, because it requires us manually updating it."
Getting credit right was also a fairness issue. A call booked in October for a November meeting has to count toward November, so a cancellation or no-show doesn't leave a caller with a bonus they didn't earn. The sheets could only enforce that rule if everyone remembered it.
What They'd Already Tried
The team had already gone a long way with what they had. The Google Sheets system had run for about six years, and Pipedrive was in place. But the sheets were easier to scan than Pipedrive's stages, so the two systems drifted apart and the sheets stayed the real source of truth. They found Connex through the Zapier Experts directory, asking for help connecting Google, Microsoft, Pipedrive, and Dropbox. That's the classic "the tools are all here, they just don't talk to each other" situation.
What We Built: Airtable + Zapier Appointment Tracking
A Connex consultant rebuilt the operation around a central Airtable base, with Zapier moving data between the systems the team already used. The build happened over many short working sessions. That allowed the advisors to keep running the business while each piece went live, and it let the team change the design when real-world use exposed a gap.
1. Booking that logs itself
- Callers book through Calendly links unique to each caller, so every appointment is credited to the right person automatically.
- Bookings are routed to the right advisor's calendar based on the prospect's state, with a round-robin for everywhere else and a buffer after each meeting.
- Each booking creates the Airtable appointment record, sends the prospect a formatted confirmation from the advisor's corporate Outlook, and looks up or creates the organization, person, and deal in Pipedrive without duplicating anything.
The first version started the flow from an Airtable form. In practice, callers needed to see live availability before entering prospect details, so the trigger moved to Calendly. That one change took a lot of friction out of the callers' day.
2. Status codes instead of status chasing
Advisors don't open a database to mark an outcome. They type a short code into the calendar event (Q for qualified, NQ for not qualified, RS for rescheduled, RSA for rescheduled by the advisor), and automation updates the Airtable record, the tally, and the caller's notification. A reschedule that crosses into a new month moves the appointment's credit with it.
3. Payroll that calculates itself
- Monthly tallies recalculate every time an appointment is booked, rescheduled, or disqualified, applying the tiered per-appointment values, the forgivable draw versus bonus logic, and quarterly bonuses.
- Split credit between the two advisors is handled in a dedicated view, so neither side has to reconcile by hand.
- A "not coded" view lists any appointment that still has no outcome, so nothing reaches payroll unreviewed.
4. A portal for the callers
Each caller gets a magic-link portal that shows only their own appointments, statuses, and running tally by month and quarter. They no longer need to email the advisors to ask whether a call counted.
5. Follow-through after a call qualifies
- When an advisor marks a deal qualified, a request-for-information email goes out automatically, with a template based on the prospect's payroll provider.
- If an approval reply hasn't arrived within a week, a polite reminder goes out on its own. A standard subject-line tag means the automation reads only the relevant replies, not the whole inbox.
- RingCentral call recordings are transcribed and filed with the client's records, and call handle time is logged for reporting. Plan managers record annual plan reviews in a checklist form that syncs to the client's organization in Pipedrive.
Edge cases handled along the way
Most of the long-term value came from the unglamorous fixes, such as:
- Stopping duplicate confirmation emails when an event was moved between the two advisors' calendars
- Making sure records with a missing tax ID are no longer flagged as duplicates by mistake
- Keeping not-qualified events visible on the calendar instead of deleting them
- Raising the Zapier plan when monthly task usage outgrew it
The firm owns every account, and the advisors keep the final say on every status.
The Results
- Month-end payroll reconciliation: from 3–4 hours of manual sheet work to a tally that's already current. The firm's advisors reported 3–4 hours at each month-end. That's roughly 36–48 hours a year of advisor time, or about $1,600–$2,200 a year at a blended $45/hr. The real cost is higher, since this was the firm's two senior people doing clerical work.
- An estimated 20–25 manual handoffs a day removed. At 4–5 appointments a day, each one used to need a caller email, an Outlook confirmation, a Pipedrive entry, a reply to the caller, and a pay-sheet update. All five now happen automatically.
- Scale without adding headcount. By early 2026 the automations were running more than 6,500 Zapier tasks a month. That's work that would otherwise fall on the advisors or the callers.
- One source of truth. Appointments, outcomes, pay, and CRM deals now agree with each other, so following up with older prospects no longer depends on scrolling through years of spreadsheets.
*Estimated impact, based on the client's reported month-end reconciliation time, reported daily appointment volume, and a blended $45/hr labor rate. Zapier task volume is a real figure.*
Why the Engagement Kept Growing
The engagement grew from one problem ("automate our sales operations") into ongoing work. The firm kept bringing the next bottleneck: payroll splits, provider-specific follow-ups, plan-manager reviews, handle-time reporting. That pattern says more than any single quote. Once the first workflows proved reliable, the team trusted the system with the work that touches pay and client relationships.
FAQ
Will this work with the tools we already use?
Yes. This firm kept Pipedrive, Outlook, Google Calendar, RingCentral, and Dropbox. Airtable became the hub, Calendly handled booking, and Zapier connected everything. Nobody had to change CRMs.
How fast was the first measurable win?
Booking-to-Airtable-to-Pipedrive logging was working within the first few weeks. The payroll tally logic followed over the next few months, built in stages so the old sheets could run in parallel until the team trusted the new numbers.
Can automation handle a complicated commission plan?
Yes, if the rules are written down first. Tiered per-appointment values, draws, quarterly bonuses, split credit, and "credit the month the meeting happens" rules were all encoded and checked against past payroll before going live.
What happens when someone forgets to mark an outcome?
A dedicated view lists every appointment without a status, by month, so gaps get caught before payroll instead of after.
Ready to stop reconciling spreadsheets?
If your team's pay, pipeline, or reporting depends on someone cleaning up a spreadsheet at month-end, we can help. We build these systems alongside your team, one working session at a time, so the logic matches how you actually pay people and track deals. Book a free discovery call and we'll map out what your version of this looks like.
Related Posts
Reddit engagement workflow: from monitoring to content calendar
Build a repeatable reddit engagement strategy: monitor threads, route to Slack, draft ethical replies, and publish via an approval-based content calendar.
Embed Notion Views in Google Slides (Auto-Updating Decks)
Embed a Notion view in Google Slides for auto-updating decks: build a filtered view, then link it, screenshot it, add a live frame, or rebuild it with Zapier.
