2 Scrape projects from same website & create google sheets rows with certain data, email out extracted data

Cerrado Publicado hace 6 años Pagado a la entrega
Cerrado 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.

Entrada de datos Extracción de datos Excel PHP Extracción de datos web

Nº del proyecto: #16195140

Sobre el proyecto

19 propuestas Proyecto remoto Activo hace 6 años

19 freelancers están ofertando un promedio de $103 por este trabajo

bhavesh1508

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!

$155 AUD en 3 días
(21 comentarios)
6.6
svsinfopro

A proposal has not yet been provided

$110 AUD en 5 días
(8 comentarios)
4.8
abhilashrana01

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

$155 AUD en 3 días
(25 comentarios)
4.3
urbitco

Hello dear, I hope this proposal find you well, I saw your job posting online, I would like to request you please have a look into my previous works. I am a full-time freelancer with over 5 years of vast experience i Más

$30 AUD en 3 días
(0 comentarios)
0.0
paulpurnima84

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

$155 AUD en 3 días
(0 comentarios)
0.0
brigittegml

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.

$111 AUD en 3 días
(0 comentarios)
0.0
jalbag

A proposal has not yet been provided

$30 AUD en 3 días
(1 comentario)
0.2
leadsexport

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

$30 AUD en 3 días
(0 comentarios)
0.0
Asanandsingh315

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

$35 AUD en 1 día
(1 comentario)
0.0