Butter

Ad posting

Use this to fill an ad online using the data from a spreadsheet.

    Requirements

  1. Install Python 3.x ( Win, Mac )
  2. Chrome
  3. ChromeDriver
    Pick the appropriate version for your Chrome build.
  4. A file named private.slr, containing credentials, is needed for the script to work. If you do not have this file, contact me.

    Installation

  1. Extract this file in the desired folder.
  2. Put the ChromeDriver executable in the folder containing the script ("Butter-master" by default).
  3. Put the file named "private.slr" in the same folder.
  4. Using a terminal run those commands: pip install googlemaps pandas pip install phonenumbers selenium xlrd.

    Usage

  1. Download the spreadsheet containing the listing data to the running directory, renaming it "listing.xlsx".
  2. Using a terminal, from the directory where you installed the script, run this command: py main.py.
  3. The script will run, filling in as much ad details as possible. When done you'll be presented with a list of tasks that haven't been automated yet and need to be completed manually.

Listings scraping

Use this to generate a spreadsheet, highlighting post containing specified keywords, from a "Showing sheet" listing.

    Requirements

  1. Install Python 3.x ( Win Mac )

    Installation

  1. Extract this file in the desired folder.
  2. Using a terminal run this command: pip install lxml phonenumbers xlsxwriter.

    Usage

  1. Download the listings showing sheet's html to the running directory, renaming it "showing.html".
  2. Using a terminal, from the directory where you installed the script, run this command: py main.py.
  3. Optionally, you can specify keywords to highlight specific units in the spreadsheet. To do so edit the file named "keywords.json", using the colors defined in "colors.json".
  4. The script will run and create a file called "units.xlsx" containing condensed info from the listings, highlighting keywords if required.
Additional resources

Source code, installation instructions and requirements

Ad posting template

Last edit 6/30/2020 9:32 AM EST: fixed installation instructions for Ad Posting, googlemaps was missing from the module list.