Take the table from the URL of the Google Script application

Question

In this answer on line 6, how to determine how many getElement("div") and getElements("div")[number] should be written from the URL.

This is the URL where I want to grab the table from.

Answer 1

You might want to study import.io , which is a tool specifically for extracting tabular data from web pages and has Script integration applications .

Answer 2

Another example would be to pull a table into Tables and access data from Tables. For example:

 =importhtml("http://www.tradingeconomics.com/zambia/rating","table",1) 

This will pull the first table on a particular web page into a sheet.