Kolton Dupey · 2025-07-02 · 4 min read

Automating Planswell Lead Capture: From API to CRM in Minutes

Automation

At our firm, staying responsive to new leads is critical—especially when they come from LeadGen sources such as

, a platform that connects individuals actively seeking financial advice with nearby advisors.

Instead of waiting for a notification of a new lead from Planswell and hoping we had someone on our staff to create them in our CRM and put on a marketing series, we decided to streamline the process with automation. Below is an inside look at how we used Planswell's API to automatically monitor, filter, and route new leads into our CRM or campaign tools based on ZIP code.

🧠 How Planswell Works (Quick Recap)

Planswell generates leads through their online platform, where users fill out detailed information about their financial lives. Once completed, those leads are distributed to financial advisors in their geographic area.

We wanted to:

Automatically check for new lead assignments
Route those leads to our closest physical office location
Send the leads and their data into our CRM to get them started on a marketing campaign ASAP

🛠️ The Automation Script: Key Features

Here's what our Python script does behind the scenes:

1. Authenticate via GraphQL API

We initiate a session by logging in with our credentials. This returns an access token, which is needed for every subsequent API call.

2. Query for Latest Assignments

Using a prewritten GraphQL query, we ask Planswell's API for the most recently assigned leads to our advisor account.

We grab the lead's name, email, phone, and ZIP code—everything we need to process the lead quickly.

3. ZIP Code Routing Logic

We maintain a large list of ZIP codes that determine which office our lead should be directed to. It's easy to find all ZIP codes in specific areas using

UnitedStatesZipCodes

. This list is hardcoded for now but could easily be made dynamic. If the ZIP code entered by the lead matches one within an office location pool of ZIP codes, they are assigned to that office. This could be bypassed if you had a dedicated Sales person to do that for you.

4. Submit Lead to Internal Endpoint

Once a lead is validated and categorized, we send their details to an endpoint. In our case, we send to Salesforce Marketing Cloud (Pardot/Account Engagement) to put the lead on a marketing series and inherently create the lead in our Salesforce Org. This could be done for any CRM or marketing platform such as WealthBox, Red Tail, ActiveCampaign, SendGrid, MailChimp, etc.

🕒 Automation Runs Continuously

The script runs in a loop every 2 minutes, checking for new leads. It avoids duplicates by storing emails already processed during that session.

If the access token expires or something goes wrong, it retries authentication automatically.

The script could be sped up but you'll want to respect Planswell's API limits.

💡 Why This Matters

In financial services, speed-to-lead often determines success. By automating the intake process from a trusted partner like Planswell, we're eliminating lag, improving our client experience, and maximizing our marketing ROI. In this scenario, we were getting 30 leads/month from Planswell. We estimate that the basics of this automation saved staff a few hours a week.

If you're receiving leads from Planswell—or any platform with an accessible API—consider automating your intake. The lift is small, but the payoff is big.

👋 Questions or Want the Code?

If you're a financial advisor or developer looking to integrate Planswell (or similar platforms) into your workflow, feel free to reach out.

– Kolton Dupey

Automation Developer | Salesforce & API Integrator

Want this built for your business?

This post comes from a real engagement. Dealing with something similar? Book a 15-minute call and I'll tell you what it would take.

Book a 15-min call Send a message →Browse projects →

Automation

Google Maps Lead Generation: Automate Business Discovery with n8n (Step-by-Step Guide)

This workflow searches Google Maps for businesses in your niche, resolves each listing to its website, scrapes the site with polite rate-limits, extracts valid emails + company info, de-duplicates, and appends the results to Google Sheets—perfect for outbound campaigns.

7 min read · 2025-08-31

Read post →

Automation

The Ultimate Guide to Enterprise Document Automation: A Deep Dive into Advanced DocuSign Integration

Explore a sophisticated Python-based DocuSign automation system with over 2,400 lines of production-ready code that transforms manual document workflows into highly efficient, scalable operations for enterprise environments.

15 min read · 2025-08-22

Read post →

Automation

Automating Earnings Call Intelligence with Python, GPT-4, and Twitter Integration

Learn how to build an end-to-end automation pipeline that scrapes earnings call transcripts, summarizes them using GPT-4, extracts sentiment and strategic insights, and posts results to Twitter for scalable financial content production.

10 min read · 2025-07-23

Read post →

Kolton Dupey · 2025-07-02 · 4 min read

Automating Planswell Lead Capture: From API to CRM in Minutes

Automation

At our firm, staying responsive to new leads is critical—especially when they come from LeadGen sources such as

Planswell

, a platform that connects individuals actively seeking financial advice with nearby advisors.

🧠 How Planswell Works (Quick Recap)

We wanted to:

Automatically check for new lead assignments
Route those leads to our closest physical office location
Send the leads and their data into our CRM to get them started on a marketing campaign ASAP

🛠️ The Automation Script: Key Features

Here's what our Python script does behind the scenes:

1. Authenticate via GraphQL API

We initiate a session by logging in with our credentials. This returns an access token, which is needed for every subsequent API call.

2. Query for Latest Assignments

Using a prewritten GraphQL query, we ask Planswell's API for the most recently assigned leads to our advisor account.

We grab the lead's name, email, phone, and ZIP code—everything we need to process the lead quickly.

3. ZIP Code Routing Logic

We maintain a large list of ZIP codes that determine which office our lead should be directed to. It's easy to find all ZIP codes in specific areas using

UnitedStatesZipCodes

4. Submit Lead to Internal Endpoint

🕒 Automation Runs Continuously

The script runs in a loop every 2 minutes, checking for new leads. It avoids duplicates by storing emails already processed during that session.

If the access token expires or something goes wrong, it retries authentication automatically.

The script could be sped up but you'll want to respect Planswell's API limits.

💡 Why This Matters

If you're receiving leads from Planswell—or any platform with an accessible API—consider automating your intake. The lift is small, but the payoff is big.

👋 Questions or Want the Code?

If you're a financial advisor or developer looking to integrate Planswell (or similar platforms) into your workflow, feel free to reach out.

– Kolton Dupey

Automation Developer | Salesforce & API Integrator

Want this built for your business?

This post comes from a real engagement. Dealing with something similar? Book a 15-minute call and I'll tell you what it would take.

Book a 15-min call Send a message →Browse projects →

Automation

Google Maps Lead Generation: Automate Business Discovery with n8n (Step-by-Step Guide)

7 min read · 2025-08-31

Read post →

Automation

The Ultimate Guide to Enterprise Document Automation: A Deep Dive into Advanced DocuSign Integration

15 min read · 2025-08-22

Read post →

Automation

Automating Earnings Call Intelligence with Python, GPT-4, and Twitter Integration

10 min read · 2025-07-23

Read post →

Automating Planswell Lead Capture: From API to CRM in Minutes

🧠 How Planswell Works (Quick Recap)

🛠️ The Automation Script: Key Features

1. Authenticate via GraphQL API

2. Query for Latest Assignments

3. ZIP Code Routing Logic

4. Submit Lead to Internal Endpoint

🕒 Automation Runs Continuously

💡 Why This Matters

👋 Questions or Want the Code?

Related posts

Google Maps Lead Generation: Automate Business Discovery with n8n (Step-by-Step Guide)

The Ultimate Guide to Enterprise Document Automation: A Deep Dive into Advanced DocuSign Integration

Automating Earnings Call Intelligence with Python, GPT-4, and Twitter Integration

Automating Planswell Lead Capture: From API to CRM in Minutes

🧠 How Planswell Works (Quick Recap)

🛠️ The Automation Script: Key Features

1. Authenticate via GraphQL API

2. Query for Latest Assignments

3. ZIP Code Routing Logic

4. Submit Lead to Internal Endpoint

🕒 Automation Runs Continuously

💡 Why This Matters

👋 Questions or Want the Code?

Related posts

Google Maps Lead Generation: Automate Business Discovery with n8n (Step-by-Step Guide)

The Ultimate Guide to Enterprise Document Automation: A Deep Dive into Advanced DocuSign Integration

Automating Earnings Call Intelligence with Python, GPT-4, and Twitter Integration