63 businesses into spreadsheet, plus reviews, plus Google Earth KMZ

Freelancer MemCare Facilities King County


This job is in 2 parts.

Make a 63 item spreadsheet with certain fields
Make a text file for each facility that contains the full text of all of the reviews
Make a Google Earth KMZ file with all 63 facility addresses

Description -

Part 1

from this url:
https://www.caring.com/senior-living/memory-care-facilities/washington/king-county

Put all of these in a google sheet with the following fields:

A - facility name
B - address
C - city
D - state
E - zip
F - url from caring.com (ie https://www.caring.com/senior-living/washington/redmond/overlake-terrace)
G - number of reviews
H - Review score (# of stars)
I - Real phone number from google maps
J - link to review text file (see Part 2)

Part 2

Make a ‘reviews’ text file

Make a separate text file with all reviews, save each one to google drive, title it with “Facility name - City”, share each doc and add link to spreadsheet field

Part 3

In Google Earth:

Make a Google earth kml marker for each facility.

Add address to google earth, rt click and ‘save to my places, then edit placemark title to show ‘Facility Name - City’ ie The Gardens at Town Square - Bellevue.

Example:

URL is https://www.caring.com/senior-living/washington/bellevue/the-gardens-at-town-square-98004

Address is 933 111Th Avenue NE, Bellevue, WA 98004

Enter address in Google Earth, save marker to My Places

Rt click on this and edit the title - erase the address, and enter “The Gardens at Town Square - Bellevue”

Save all of these Google Earth placemarks in a folder within Google Earth then and save them all as a KMZ file

*****************************************

Deliverable will be:

Spreadsheet with 63 facilities
63 doc files of facility reviews
Google Earth KMZ file with 63 markers

Thank you!