How to grab web data into Numbers sheet

If you want just that one value then you can do something like this:

-- change values between "" in first three lines to match your setup
set mySheetName to "MySheetName"
set myTableName to "MyTableName"
set tgtCell to "B2"

set theHtml to do shell script "curl -s " & quoted form of "https://www.bolsasymercados.es/MTF_Equity/esp/SICAV/Ficha/ACATES_SISAPON__SICAV__S_A__ES0176200030.aspx"
set text item delimiters to {"<div class=\"row fechaPreciosSup\">", "<div class=\"row fechaPrecio\">"}
set the extractedDivs to theHtml's text item 2 -- item 2 is the relevant section of the html
set text item delimiters to {"<p>", "</p>"} -- remove the p tags
set tempLst to text items of extractedDivs
set text item delimiters to ""
set tempStr to tempLst as text
set text item delimiters to {"<div class=\"col-md-6 col-sm-6 col-xs-6\">"}
set theValue to first word of text item 3 of tempStr
set the clipboard to theValue
-- return theValue -- uncomment this line for testing -- will appear in Result pane

tell application "Numbers"
	tell front document
		tell active sheet to set currSheet to its name # save current location
		tell sheetmySheetName to tell tablemyTableName
			activate
			set selection range to rangetgtCell
			delay 0.3
			tell application "System Events" to keystroke "v" using {option down, shift down, command down}
		end tell
		
		activate
		set active sheet to sheetcurrSheet # go back to original location
	end tell
end tell

This assumes you have changed the first three lines of the script to match your setup. Note that the value is not placed in a Numbers "sheet" but in a table. A sheet in Numbers has a blank canvas on which you place tables, charts and other objects.

SG

The general approach is to look at the source html for the page. In Safari enable the Develop menu (Safari > Preferences > Advanced and check 'Show Develop menu bar'). Then to see the source for a webpage go in the menu to Develop > Show Page Source.

For many (but not all) pages you can locate in the html the value that you are looking for. Then you study the text around the value and figure out how to use text item delimiters to chunk the html to get what you want.

This is a very basic form of web scraping. There are many other more sophisticated tools, such as Beautiful Soup under Python.

But good old humble AppleScript can get the job done in many situations.

Many thanks for the green tick!

SG

SG

Unfortunately this kind of "web scraping" is very much dependent on the source html of each web page. What will work on one page will not necessarily work on another page. And it is easily broken when the design of the page is changed, something that happens quite frequently.

SG