CODEWITHSUNDEEP
google-apps-script
Vasim
Vasim

Reputation: 3143

Grab table from URL in Google App Script

In this link answer in line 6, how to identify how many getElement("div") and getElements("div")[number] should be captured from a URL.

This is the URL from where I am looking to capture the table.

Upvotes: 1

Views: 470

Answers (2)

Jan Krynauw
Jan Krynauw

Reputation: 1102

another example could be to pull the table into Sheets and the access the data from within the Sheets. For example: 

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

This pulls the first table on the particular webpage into the sheet.

Upvotes: 0

Eric Koleda
Eric Koleda

Reputation: 12673

You may want to look into using import.io, which is a tool specifically for extracting tabular data from web pages, and which has an Apps Script integration.

Upvotes: 6

Related Questions