scraping data using Google App Script

Job ID: 33088023

Budget: $10 – $30 USD

See the more detail at url:https://docs.google.com/document/d/1oYiznRJsMv8sPfHCUOkGHpO2dn7bOHEwk3DDEhLRpDA/edit?usp=sharing

1.Clean and create tab:Clean and create the amount of blank stock tab at google sheet (input). The tab name is the cell at "input" _+A2-Ax,(x is the number isn’t blank), I assume it’s a variable called {{stock_no}}. For example _1101,_1102,_2232…

2.Download url table data:download the data at website to google sheet:
Here is the following url:
url1:http://5850web.moneydj.com/z/zc/zca/zca_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “A1” cell

url2:http://5850web.moneydj.com/z/zc/zcr/zcr_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “A34” cell

url3:http://5850web.moneydj.com/z/zc/zch/zch_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “A106” cell

url4:http://5850web.moneydj.com/z/zc/zcq/zcqa/zcqa_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at “K2” cell

url5:http://5850web.moneydj.com/z/zc/zcq/zcq_{{stock_no}}.djhtm
download the table data into the same {{stock_no}} tab at

url6:http://norway.twsthr.info/StockHolders.aspx?stock={{stock_no}}
download the table data into the same {{stock_no}} tab at

Here is the sample sheet I want:
https://docs.google.com/spreadsheets/d/1tbKI3oyXE3pKfXItkxQc3XJ7l9Thp-UrUqlr278RPi4/edit#gid=192230294

3.Set the formula:Go to the "input" tab and let B2 to CP2 drop down to the cell where the A column isn’t blank.
Related categories: Python Google Apps Scripts