Scrape Realtor.com for home addresses & separate it into multiple columns

šŸŒŸAutomation Experts Hub šŸ  Real Estate
1

I made a use case for a moving company that Iā€™m working with to scrape addresses from Realtor.com for new listings and then separate the data into manageable chunks. Itā€™s super simple but allows them to do more advanced scrapes later because the address is broken up into multiple columns instead of just one.

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 2ā€“

  1. Bardeen Playbook V2: Shared Playbook | Bardeen
  2. Video Tutorial: Loom | Free Screen & Video Recording Software | Loom
  3. Google Sheets Formula to remove duplicates: =UNIQUE(A2:D200)
  4. What improved? Added reg ex to the process so it will separate address, city, state, zip into multiple columns automatically in Google Sheets. shoutout to @Deyan_Petrov for the help.

ā€“Version 1ā€“

  1. Bardeen Playbook V1: Shared Playbook | Bardeen
  2. Here is a video: Loom | Free Screen & Video Recording Software | Loom
  3. Google Sheets Formulas: SolutionLab.ai formulas - Separate a Full Address Cell into Address, City, State, Zip from a Bardeen Scrape - Google Sheets (make a copy if you want the formulas)

What I want to improve (comment below if you have any other ideas) : Delete a row if there is a blank zip code. Iā€™ve tested the Bardeen delete row feature and it doesnā€™t seem to work with the reg ex and Iā€™m not able to make it work with a dynamically generated Google Sheet that was just created. For now you can easily remove them in the Google sheet (so itā€™s not an issue) but I want to get it done automatically within a Bardeen playbook. progress over perfection

1 Like
2

Awesome @danfernandez

1 Like
3

thanks @Krunald I just updated the post as well with a version 2 of the scraper :slight_smile:

1 Like