Hi, I visit the link above and view the google sheet below.
I find that the web page has 3 tables, also, the google sheets have 4 tabs,
but I visit the other tabs of the google sheets, it seems only the first tab is used in this project, correct?
OK, let me explain my plan for this job.
I will use C# programming language to create a program, could you accept this? it may need run offline on your desktop, or you can hosted it on a Windows VPS, could you accept this?
To scrape the website and create a worksheet with the data listed on the page is fairly easy, but I am only good at C# language, but C# can only run on Windows OS.
Let me tell you the detail process about scraping.
1, Request the html code of the page, send HTTP request to the url. For this job, it's easy because it's an GET request
2, Parse HTML code, use XPath to find HTML elements, for example, I want to get this text "Last 10 payouts" - the title of the first table shown on the page, then I search it in the HTML code (you can right click on the browser, select view source to see the HTML code of the page), then I see this line "<div class="panel-heading">Last 10 payouts</div>", then I will create XPath: //div[@class='panel-heading'], this XPath is to find the div element whose class attribute is 'panel-heading'.
Create XPath for all necessary elements.
3, Save the InnerText value to the worksheets used to save data.
Could you accept such a program?