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 
My contact info www.solutionlab.ai or https://www.linkedin.com/in/webbizdan/
āVersion 1ā
-
Bardeen Playbook V1: Shared Playbook | Bardeen
- Here is a video: Loom | Free Screen & Video Recording Software | Loom
- 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
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.
@Bill.French thanks for the info and Iāll make sure to check this out because this was driving me crazy when using Bardeen
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
i am trying to scrape an area (a city) on zillow and adjust what headers from Zillow show up on a google sheet-
Address
listing price
bed
bath
sq ft
rent estimate
days on market
url
