Project 1 - monthly scrape
Scape#1 public database (no login required) with set search fields to store in google sheet rows.
Prefer to use Google docs if you can.
Extract Customer Data #1 into a separate worksheet - Scrape only 4 fields from each customer record - (1) owner name, (2) their address, (3) representative name, & (4) brand (word or logo image).
Extract Exclusion Data #2, to Build Exclusion List and build an Exclusion database list in google sheets.
Exclude#1 - if the same customer name appears in a new month search, then exclude from putting into Customer Google Sheet (Item 2, below). This leads to duplications otherwise.
Exclude#2 - exclude all records which contain certain words, I will manually build this list up.
Exclude#3 - exclude all records where the owner and representative names are different. We only want them if they are the same names in both fields.
Scape#2 the same public database using each Customer Owner Name (1), to see how many Trademarks they own, and put the number in a 5th column in google Sheets. So if they have 2 Trademarks, then to each customer’s google sheets row will appear - 2.
Scrap #3 - scan the internet and find the Customer phone number and put into 6th column (use either owner and/or Brand.
System uses rows in Google Sheets, to routinely search (each 2 months) public database.
The results (trademark, owner, class, goods&services) are extracted and emailed to the recipient listed in the same Google Sheets Row. There are 3 columns in my Google Sheet being Brand word(s), Recipient Name, Recipient EMail.
As time goes on, we will add new rows with words, name and email. Your search will p
Multiple different monthly automated search using 2 fields:
Field#1: word(s) - inserted from a data row in my google sheets doc, and searched separately. Each row defines a separate word search, and different result to collect and email to the email in the same data row, which will be different from row to row.
Field#2: Status - Pending. We only want pending records.
36 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi, I have developed similar scraper/crawler and data/web automation projects. Please let me know if you are interested and I am available to start right away.
Hi, first point : We can't code such things in google sheets, it can be done in Excel. Second, a script to find phone number, there is no such thing. If you want we can discuss. Thanks
Dear Sir/Ma'am, I can Scrape 2 projects/websites & get into google sheets. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
sir i have a lot of experience about scraping ,i can create script of any kind of website so please contact me ,i hope i can help you in this [login to view URL]