Claude Cowork | Country portal
I don’t know about you, but many times when I receive a list of owner data, it is surprisingly incomplete.
You can download a county tax roll, pull MLS records, purchase a lead list, export from your CRM, or pull public records. At first glance, it may seem useful, but in reality, you’re usually looking at a spreadsheet full of missing context.
It may have a package number, the owner’s name, and perhaps a mailing address. What you don’t have is the information that really helps you make smart decisions, like whether a property has road access, if it’s in a flood zone, how many acres it has, or roughly what it’s worth before you contact someone.
That gap is exactly what data enrichment solves. In this blog post, I’ll show you how to take a basic property records spreadsheet and automatically transform it into something much more valuable using Claude Cowork together with him Country portal API.
How is this different from researching a property?
A while ago I made another video showing how to use Claude Cowork and Land Portal to conduct in-depth research on a single property and compile a detailed report. This is the next step.
Here we are dealing with hundreds, or even thousands, of properties at a time.
Doing this by hand is not impossible, but it would be time consuming. You would spend many hours going over it yourself or you would pay someone else to spend many hours doing the same thing. For most people, it’s just not worth it, and that’s exactly why this combination is so useful.
We take a listing that has information but not enough, give it to Claude Cowork, and let him use the Land Portal API to automatically pull in acreage, property details, flood zones, compositions, zoning, tax data, and more in a matter of minutes.
The two tools you will need
If you’ve read my other posts on this, you already know the players. Claude Cowork is the desktop app that can actually take control of your computer and do the clicking and typing for you, instead of just chatting like a normal AI assistant.
I will be completely honest with you about the startup costs. You need a Claude Pay account, and the cheapest plan costs around $20 a month (closer to $17 if you pay annually). When I was at that level, it wasn’t enough use for jobs like this, so I upgraded to the maximum $100/month plan. That’s been enough for most of what I’ve added to it.
Land Portal is the real estate data service that does the heavy lifting on the data side. For this type of work, you’ll want to start with the Pro plan, which by default allows you to nurture up to 5,000 leads per month. You can increase that and the more registrations you get, the cheaper you will be per lead.
A real example: my list of delinquent taxes
Let me show you the actual list that pushed me to figure this out.
This is a list of delinquent taxes I purchased from a county I know. I wanted it because people who are behind on their property taxes are usually a strong sign of a motivated seller. Sometimes they no longer care about the property and would be happy to sell it at a discount before the county seizes it.
The problem is that a county is not a clean data service. They want to do as little work as possible, so what I got was the bare minimum: parcel number, state, county, owners’ names, mailing addresses, and how much each person owes.
That’s useful, but it’s not enough. I’m specifically looking for vacant land in a certain area range, sometimes within certain zip codes, and this list doesn’t tell me any of that.
What I really need to know is how many acres each property is, how it is zoned, if it has road access, if it is in a wetland or flood zone, and how much it is worth. Land Portal has all that.
Try Land Portal!
If I had all the time in the world, I could open Land Portal and search all the properties at hand. I don’t have hundreds of hours for that. I need to do it line by line via API, fast.
Get the API key from your country portal
Within your Land Portal account, go to Profile, then the API section and click “generate API key”. Give it a name (I called all of mine Claude Cowork), confirm your email and password, and it will give you a long series of letters and numbers.
Try Land Portal!
Treat this key as a password. If someone else gets hold of it, it could result in a large charge to your account, because it’s essentially the key to everything you do in Land Portal.
In fact, if you try to paste it directly into the chat, Claude will often tell you to delete it and generate a new one. The safest measure is to place the key in a Word document or text file, save it inside a dedicated folder that Claude Cowork can access, and then point Claude to that file to retrieve the key from your computer instead of the conversation.
Develop enrichment skill
Next, I asked Claude Cowork to create a new skill that took an existing spreadsheet and enriched it with data from the Land Portal, using the API key from that folder.
What I like about this part is that Claude asks intelligent clarifying questions before building anything. He wanted to know what identifiers my spreadsheets would have for each row and I told him APN, state and county. Honestly, that’s the bottom line here. If you have those three things and the APNs are formatted correctly, you can extract almost anything else from Land Portal.
It also asked me what fields I wanted to add as new columns (I said everything available), how to handle API limits on large jobs (I told it to stop and let me know when it’s getting close), and roughly how big my spreadsheets typically are.
From there I put it on my list. You can connect Claude Cowork to your entire Google Drive and give it a Google Sheet link, which is what I did. If that causes you any problems, you can simply download the file as a CSV and drop it directly into the chat.
Then I sat back and let it work.
The reward
About thirty minutes later, he finished a list of approximately 900 records. Let me make it clear that thirty minutes is not instantaneous, but it is a rounding error compared to doing it by hand.
When I opened the result, all my original columns were still there and a wall of new data was shifted to the right.
Try Land Portal!
We are talking about square footage, whether the parcel is vacant, the assessed value, the Land Portal estimated value, the price per acre, the annual tax amount, if it is landlocked, how many feet of road frontage it has, if it is in a flood zone and what percentage, if it touches a wetland and what percentage, a buildability score, the slope report, the school district and coordinates.
Now I can do something I couldn’t before. I can filter only properties between 5 and 20 acres and send emails only to those owners, or send a different message to a different type of owner. Rich data makes that kind of targeting easy.
This is not just for land investors
Here’s the part that even surprised me. This exact process is not only useful for land investors like me.
Real estate agents, insurance companies, attorneys, surveyors, developers, utility companies, environmental consultants, and even county governments can put the same fortification workflow into practice. Anyone with incomplete property data can use it to make smarter decisions.
Honestly, I couldn’t have done this without both pieces working together. Land Portal provides the depth of data and Claude Cowork does the tedious work of incorporating it at scale.
If you spend hours looking at half-empty spreadsheets, this is worth a look. Grab Claude Cowork and take a look Country portalConnect the two and let them turn your bad property lists into something you can actually act on.
