SIMPLE IMACROS SCRIPT TO INSERT ZILLOW INFO IN GOOGLE DOCS SPREADSHEET

I want to use an imacros script that runs in the browser or something very similar (reason being is I want to be able to use the built in browser ip changing tool if I get banned.) It will advance through a google docs spreadsheet looking up addresses in zillow and then scraping information from zillow and inserting into the spreadsheet.

## Deliverables

Here is how the tool will be used

1) address field will be selected in a google docs spreadsheet manually (field will have something like "6406 Longridge Rd.")

2) script would be invoked and it will pop up a dialogue box asking how many of the rows below in the sheet to operate on. The default value will be "1" for the dialogue box so that if that is ok I can just press enter.

3) once the script will capture the address from the field it starts on and save to a string variable.

4) it will advance to the next field which is holds information for city state and zip (this field will have contents looking like "Mayfield Hts., Oh 44124") . It will capture this information and concatenate to the string that allready has the address.

5) the script will then remove any charactors and spaces and other unnecesary characters and replace them with one dash between each word or number of the address. (i.e. so "6406 Longridge Rd. Mayfield Hts., Oh 44124" becomes "6406-Longridge-Rd-Mayfield-Hts-Oh-44124")

6) the script will then follow put the new string at the end of this url, [url removed, login to view] thus making a url that would look like this:

[url removed, login to view]

7) I have included some screen shots for essentially explain the information to copy and how to do it when:

[url removed, login to view] - this url shows the information to scrape and how to do it if an address is currently for sale

[url removed, login to view] - this url shows the information to scrape and how to do it if an address is not for sale

[url removed, login to view] - this URL shows the information to scrape if address is not found in the database.

[url removed, login to view] - here is what the google docs spreadsheet looks like with notes here.

Just in case the screen shots don't work for you i do a video but it is probably unnecesary.

[url removed, login to view]

8) after going to the first row script will advance to the next row and do it all again depending on how many rows the script has been instructed to do.

工程 微软 项目管理 脚本安装 shell脚本 软件构架 软件测试 视窗桌面

项目ID： #3797536

关于项目