Scraping Addresses From Zillow into Google Sheets & separating address, city, state, zip

🌟Automation Experts Hub 🏠 Real Estate
1

Here is a simple automation to gather addresses from Zillow, separating the address, city, state, and zip into individual columns in Google Sheets.

As I improve the playbook I’ll edit this first post so you can see the progress. Feel free to ask any questions or provide suggestions below :slight_smile:

My contact info www.solutionlab.ai or https://www.linkedin.com/in/webbizdan/

–Version 1–

  1. Bardeen Playbook V1: Shared Playbook | Bardeen
  2. Here is a video: Loom | Free Screen & Video Recording Software | Loom
  3. Reg Ex Formulas Used

Address: ^[^,]*
City: (?<=, )[^,]*(?=,)
State: (?<=, )\b\w{2}\b
Zip: (?<=,.+)(?=\d)\d+

What I want to improve (comment below if you have any other ideas) : I would love to automatically remove any duplicates. Once Bardeen fixes their bug we can add this into this playbook :slight_smile:

2

Novel approach… based on embeddings (more here).

The basic premise is that rows with “meaning” can be semantically identical, and AI embeddings make this almost effortless. And speaking of effortlessness - I stopped using RegEx for data cleansing recently and instead opted for AI.

CleanShot 2023-06-18 at 10.24.52@2x
CleanShot 2023-06-18 at 10.24.52@2x1614Ă—1210 229 KB

3

@Bill.French thanks for the info and I’ll make sure to check this out because this was driving me crazy when using Bardeen :slight_smile:

4

You can use this action. Select the table and than write the column name do not select a table and than a column just write the name.

This should than return a table that can be added to the desired output table e.g Gsheets, AirTable etc

image