Automation of Legislative Outreach for Wyoming Realtors
Andres Sepulveda Morales
Verified
Like this project
What the client had to say
Andres Sepulveda Morales provides excellent services and work products. As a small non-profit organization, hiring Andres has worked out beautifully for our needs and our tight budget. We could not be more pleased!
Nicole Novotny Smith, Wyoming REALTORS
Jan 26, 2026, Client
Posted Feb 6, 2026
Automated Wyoming Realtors' data sync for legislative outreach using n8n between the National Association of Realtors and VoterVoice.
Likes
0
Views
0
Timeline
Dec 22, 2025 - Jan 26, 2026
Clients
Wyoming REALTORS
Bridging the Data Gap: Automating Wyoming Realtors’ Legislative Outreach
The Challenge: A "Wall" Between Two Vital Systems
Wyoming Realtors needed to mobilize their ~3,000 members for the upcoming legislative session. However, their tech stack was at a standstill. The National Association of Realtors (NAR) held the membership status, while VoterVoice was the engine for outreach.
The problem? The two systems didn’t talk. Both platforms essentially told the client they’d need a "third party" to bridge the gap. For a non-technical organization, this meant a staffer would have to manually audit, export, and re-upload 3,000 records—a process that would realistically take over 50 hours of tedious manual CRUD operations (assuming a conservative 1 minute per record for checking, updating, and verifying).
The "Aha" Moment: The Need for a Source of Truth
During discovery, we realized the core issue wasn't just a lack of an API connection; it was a lack of authority. Neither system was the "Source of Truth." To solve this, we introduced an intermediate data layer using Google Sheets (functioning as a nimble, centralized database) and n8n.
This allowed us to:
Pull data from the NAR official API.
Verify it against the Wyoming Realtors’ internal records.
Relay the clean, "Active vs. Inactive" status directly into VoterVoice.
An example portion of the flow to handle user records in VoterVoice
The Technical Solution
One-Way Synchronization: Built a robust push from our master database to VoterVoice via official APIs.
Sync Status Verification: I never want my clients to be dependent on me to check what they should have access to themselves! The existing database solution was extended to include sync status and error output to help diagnose things like missing addresses, incorrect emails, etc.
Fail-Safe Matching: Since email addresses can be inconsistent, we implemented logic to use the unique NAR ID as the primary identifier whenever an email was missing, ensuring zero duplicate or lost records.
Workflow Automation: Used n8n to handle the heavy lifting of mapping fields and sorting member statuses.
Parallelized Subworkflows: A little known benefit (at least not known to me until I started running into snags!) to using subworkflows in n8n is to ensure the system does not wait for the current task to finish before queuing up the next one. It would take around an hour to update the entire list on the first iteration of this flow, and changing that subworkflow setting cut it down to ~15 minutes.
If you're looking for where to set "parallel sub-workflows" on the n8n node, here it is!
The Result: 50 Hours Reduced to 15 Minutes
What used to be a multi-day administrative nightmare was transformed into a 15-minute background task.
~3,000 records updated in one sweep.
100% data integrity between NAR and VoterVoice.
Segmented Outreach: By separating active and inactive members, the organization could finally perform targeted outreach during critical legislative windows.
The Tech Stack
Automation: n8n
Database: Google Sheets (Centralized Contact Database)
Integrations: NAR API, VoterVoice API
Tired of being the 'middleman' between your own apps? If your team is wasting dozens of hours on manual data entry or CSV uploads, let’s automate it. I specialize in building the "missing link" between platforms that don't want to talk to each other.