2 Scrape projects from same website & create google sheets rows with certain data, email out extracted data
$30-250 AUD
Pagado a la entrega
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.
Project 2.
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.
Nº del proyecto: #16195140
Sobre el proyecto
19 freelancers están ofertando un promedio de $103 por este trabajo
Hello, I can do this job, i have scraped data from 40+ websites, please send me a message so we can discuss in detail. Thanks!
We are design agency with lot of experience, currently working on Freelancer.com. Design Stockers is team of professionals from wide range of digital services. Each member of our team have many years of experience in h Más
Hi, I can do this data entry job for you. My average type speed plain text 40wpm. I m dedicated and currently not engaged any services. I work from my home. So I can deliver my time for the job. I am very much new to F Más
I do my tasks efficiently and I do not procrastinate on certain projects that I do. You can contact me at you most preferred time.
Hello, My name is uzair a certified lead generation expert,got 6+ years of experience in lead generation. I have designed a tool that makes use of API technologies and i use that to generate leads. I am fully expert Más
I have professional experience of working on MS-Excel and got a 100% positive response from my customer. So, if you are looking for someone for data entry, data modeling, consolidation, pivot tables, charts and graphs Más