2026
Grok Bot Consulting
How Grok Bot Helped a Texas Political Firm Collect Early Voting Rosters
Overview
We worked with the principal of a Texas political consulting firm to set up Grok Bot. The firm runs voter contact and turnout programs in counties across the state. During early voting, its campaigns rely on knowing who has already voted, so field teams, mail, and digital outreach can stop spending money on voters who have already cast a ballot and focus on the ones who have not.
The firm set up Grok Bot to own the roster workflow, working under a written set of rules from the principal. This is the Grok Bot consulting engagement.
The Challenge
Texas does not publish early voting rosters in one place or one format. For the November 3, 2026 general election, the firm needed daily rosters from 12 counties: Collin, Dallas, Denton, Harris, Hays, Jones, Kaufman, Lubbock, Tarrant, Taylor, Wichita, and Wilbarger. Each county had its own source and its own quirks.
Five counties came from the Texas Secretary of State's early voting site. The others had to be pulled from each county's own elections page. Some counties posted cumulative rosters and others posted one file per day. One posted a zip of every day's file. One published only PDFs. One sent its rosters by daily email.
Files arrived at unpredictable times, and counties often reposted corrected versions of days they had already published. The firm's database expected clean, consistent CSVs with standard voter IDs and voting-method codes, and each new file had to be pushed to the firm's roster ingest system.
Done by hand, this meant someone checking a dozen websites several times a day, then downloading, renaming, converting, de-duplicating, and uploading files, for weeks, with no room for mistakes.
Services
- Grok Bot setup with the firm's principal
- Daily early voting roster collection
- Roster version history
- Controlled uploads to the roster ingest system
- Tarrant County voter file
- 12 counties
- Daily early voting rosters, collected and normalized across the full early voting period.
- Two kinds of sources
- Five counties came from the Texas Secretary of State's early voting site. The others came from each county's own elections page.
- 721,000+
- Tarrant County voters in one file, coded the way the firm's database expects.
- Held for a decision
- Corrected versions, files outside the election window, and sensitive datasets stayed back unless the principal approved them.
- 12
- Counties of early voting rosters, collected daily
- 721,000+
- Tarrant County voters in one file, coded the way the firm's database expects.
Daily rosters
Daily rosters from 12 counties, on a schedule
Routines checked each county's source on a set schedule throughout early voting. They pulled only new or changed files, and spaced out downloads so no site ever saw a burst of requests. For Secretary of State counties, Grok Bot tracked each county's in-person count from hour to hour. Once a held county's count stopped changing for three hourly checks, it pulled the file, so the firm got complete data without wasting downloads on partial updates. Routine handoffs and anything that needed a decision went to the principal as short chat messages. When nothing had changed, Grok Bot stayed quiet. It never contacted anyone else on the firm's behalf.
The rules
Every file kept, and only new first versions uploaded
No file was ever overwritten. Every re-download was saved as a new version (v1, v2, and so on) with a changelog, so the firm always had a complete record of what each county published and when. PDFs became CSVs, line endings were cleaned up, county ID fields such as Certificate Number were mapped to the statewide VUID, and counties that shared a source were split into separate files. Only new first-version files went to the firm's roster ingest webhook. Corrected versions, files outside the election window, and sensitive datasets were held back unless the principal approved them. Grok Bot did not replace the firm's judgment. It carried out that judgment consistently. The principal set the rules once: which sources to trust, how to name and store files, what was allowed to reach the database, and when to ask. Grok Bot followed those rules every hour of every day of early voting. That freed the firm's team to spend election season on strategy instead of downloads.
Tarrant County
A Tarrant County file of more than 721,000 voters
After Election Day, the firm asked for a single file listing everyone who voted in Tarrant County, the state's third-largest county. Grok Bot merged 12 days of Secretary of State early voting rosters with the state's unofficial Election Day turnout list. It coded every voter with the firm's three database values: AV for mail ballots, EV for early in-person voters, and ED for Election Day voters. Mail ballots were always coded AV, even when they appeared in the Election Day download. It filled in a voted date for every early voter, based on the roster day the voter first appeared. It de-duplicated by voter ID, producing a file of more than 721,000 unique voters.
The mail gap
The mail-ballot gap, explained before anything changed
When the principal noticed that the state's public mail total (21,013) did not match the file's AV count (15,231), Grok Bot reconciled the gap. Every day from October 15 through October 30 matched exactly. The difference came from ballots returned before early voting began and after the last early voting roster. Grok Bot then found Tarrant County's own mail ballot roster and compared it voter by voter. It flagged voters who also appeared as in-person voters, records with mismatched IDs, and redacted rows. Before changing anything, it gave the principal clear options and laid out the trade-off of each one.
What we used
Grok Bot, the Texas Secretary of State early voting site, each county's elections page, daily email, and the firm's roster ingest system.
- County elections pages
- Daily email
- Firm roster ingest system
- Grok Bot
- PDFs and CSVs
- Texas Secretary of State early voting site
This work in service form
Services
Grok Bot Consulting
A CFO at a local firm
Month-end reporting, payroll journal entries, and a report her vendor could not change. See how one CFO handed all three to Grok Bot and got hours back every week.
Publishing Platform
Dave Campbell's Texas Football
20M+ annual visits. Custom publishing workflow, live scoring, podcasts, user personalization, and e-commerce.