Data Entry - Search websites, add email address (if available)

General Instructions:

You will need to access each website available in the excel file attached (~2,700 rows) , search for the contact email link. And copy it to the file.  There is some additional information you also have to complete in the excel file (example: is the link valid?).


Note: Not all links will be valid and not all will belong to auto repair shops. I only want emails from auto repair shops that are easy to find.
Below are some detailed steps which may help you organize for this task.

Detail steps:
1. From the excel spreadsheet, copy the link (col B) search online each website.
2a.  If link does not work, add a "no" in column D and proceed to next row in excel (step 1)
2b.  If link works, check if web corresponds to an auto-repair shops.
If not, complete columns E and F and proceed to step 1.
3. If link works and belongs to an auto-repair shop, search for a contact email address and copy it in the excel file.
I do not want you to spend more than 30 seconds searching for email. So, if you cannot easily find it, just add a "no" in column and proceed to next link.

Notes:
Emails are usually:
          In the top of the website
          In the bottom of the website
        Or after clicking on the website link that says “Contact” or “Contact us”

If you find more than one email address, copy first the email for “customer services / or repairs”. You can add the other emails in the next column, or split them with a “/”.