Lukket

Google App Script to Scrape Data - Minderlaw 20210221Y

For this Google App Script project, please see spreadsheet [login to view URL] and the attached PDFs. In Worksheet Trademarks, Column E (Application) are a list of Application Numbers. The script logic is listed below.

1. For each Row, go to the URL https://tsdr.uspto.gov/#caseNumber=[Application Number]&caseSearchType=US_APPLICATION&caseType=DEFAULT&searchType=statusSearch . For example, the URL for Row 2 would be https://tsdr.uspto.gov/#caseNumber=4469429&caseSearchType=US_APPLICATION&caseType=DEFAULT&searchType=statusSearch . The attached PDFs show the resulting webpage at https://tsdr.uspto.gov/#caseNumber=4469429&caseSearchType=US_APPLICATION&caseType=DEFAULT&searchType=statusSearch

2. If Worksheet Trademarks Column F (Registration) is blank, fill in the Registration Number. Note that some Applications do not have Registration Numbers.

3. If Worksheet Trademarks Column G (Registration Date) is blank, fill in the Registration Date in the format yyyy-MM-dd. Note that some Applications do not have Registration Dates.

4. If Worksheet Trademarks Column H (Mark) is blank, fill in the Mark. Note that some Applications do not have Marks.

5. For Worksheet Trademarks Column I (TM5 Common Status Descriptor), overwrite the TM5 Common Status Descriptor. Even if Column I is not blank, overwrite the field with the current TM5 Common Status Descriptor.

6. For Worksheet Trademarks Column J (Status), overwrite the Status. Even if Column J is not blank, overwrite the field with the current Status.

7. For Worksheet Trademarks Column K (Next Filing), overwrite the Next Filing in the format yyyy-MM-dd. Even if Column K is not blank, overwrite the field with the current Next Filing date. Note that the Next Filing date is under the Maintenance tab.

8. For Worksheet Trademarks Column L (Filing Type), overwrite the Filing Type. Even if Column L is not blank, overwrite the field with the current Filing Type. Note that the Filing Type is under the Maintenance tab.

9. Note that the USPTO website throttles web traffic. So the script should include some time delay between the USPTO searches.

Candidates should confirm that they have Google Apps Script experience. Thank you.

Færdigheder: Google App Engine, Web Skrabning, Python, Google Sheets, Google Apps Scripts

Om klienten:
( 43 bedømmelser ) Los Angeles, United States

Projekt ID: #34691556

26 freelancere byder i gennemsnit $152 timen for dette job

gangabass

I have a huge Google Apps Script experience (with 1,000+ reviews) that's why I'm sure that you'll be impressed with my work. I can provide you a working script in less than a day for just $100. Could you show your spre Flere

$100 USD på 1 dag
(572 bedømmelser)
8.0
uumarkhalid31

Hi Python expert here with hands on experience in script development to do website scraping and data mining. I normally use requests, selenium or puppeteer to perform the scraping and my first priority always is to mak Flere

$100 USD in 2 dage
(246 bedømmelser)
7.2
mananraja

hi I understand the steps you listed, and can make a GOOGLE APPS SCRIPT, to do these steps. I'm interested to discuss more details with you in chat. Abdul H.

$100 USD på 1 dag
(270 bedømmelser)
7.0
(40 bedømmelser)
6.2
(119 bedømmelser)
6.4
kanwalrafique

Hi, I'm an experienced Google Apps Scripts developer. I have experience in integrating web APIs in Google Apps Scripts. The data on the Status tab of the USPTO website for patent and trademark applications are coming f Flere

$200 USD in 3 dage
(38 bedømmelser)
6.0
jeremytay

◆◆Web Scraping Expert is here◆◆ Hi, there!!! Thank you for your reading. As a highly skilled Scraping Expert, I can help you . I have vast experience in web scraping with python(Scrapy), C#, JavaScript(Node.js), Puppet Flere

$200 USD in 3 dage
(3 bedømmelser)
4.2
mehmetdemir58fr

Hello. PHP, Python based scraping artisan here! I am ready to work now...... Fast delivery, Best Quality........... Best!

$300 USD in 7 dage
(3 bedømmelser)
3.8
RomanRut

Hello I am Roman R, enthusiastic senior web developer now you are looking for. I am glade to take this task. I can help you perfectly in this field owing to I have robust experience in WordPress/Django/Laravel/MERN. I' Flere

$140 USD in 7 dage
(7 bedømmelser)
4.0
(3 bedømmelser)
3.6
sharikmp

Hello Dear, I have good expertise in Google script automation. I have experience of working with Google script for data scraping, telegram, slack bots development using Google script. Let connect to start. Thanks Flere

$140 USD in 7 dage
(12 bedømmelser)
3.2
(6 bedømmelser)
3.9
ayesharifatmed

Hello There! This is Ayesha Siddiqua. Nice to meet with you. I am an M.B.B.S doctor. I have completed my graduation from North Bengal Medical College under Rajshahi University. A versatile and professional Web & Mob Flere

$150 USD in 3 dage
(4 bedømmelser)
2.9
(1 bedømmelse)
3.1
rukshanlancer

Hi There, Hope you are doing well. I checked your description in "Google App Script to Scrape Data - Minderlaw 20210221Y". I'm a senior developer with 9 years of experience in PHP. I want to discuss with you for the pr Flere

$150 USD in 5 dage
(2 bedømmelser)
2.6
gajematthias

Hi! How are you? I'm a python expert with 8+ years experience and I'm very familiar with various libraries and packages including numpy, selenium ,pandas etc. I haver rich experience in Django and Flask. I'm specializ Flere

$120 USD in 7 dage
(4 bedømmelser)
2.7
scottwardell

Hi, there. I just went through your job post and it piqued my interest. Your description of the work responsibilities pertaining to this role closely matches my interest. As an experienced senior Python & Web Scraping Flere

$120 USD in 7 dage
(1 bedømmelse)
2.3
castillajoselui3

Hi, How are you? Very happy to bid your project because my skills are fitted in your project. I have 8 years experience in Python programming. I am very familiar with data analysis, portfolio optimization, Machine lear Flere

$100 USD in 4 dage
(1 bedømmelse)
1.0
ankurbora7

Hello? How are you? I have done many google app script project before. So, I can help you. Hope to work with you. Many thanks.

$140 USD in 3 dage
(0 bedømmelser)
0.0
AykhanABB

Hi, I understand your list. As a developer with more than 6 years of experience in Python, I am confident that your project will be great. If you give me a chance to win an order for your project, I would like to have Flere

$100 USD in 4 dage
(0 bedømmelser)
0.0