Scrape for home addresses & separate it into multiple columns

I made a use case for a moving company that I’m working with to scrape addresses from 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 or

–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: 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

Awesome @danfernandez

1 Like

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

1 Like