From HTML to Google Spreadsheets. How to parse data on a page and import it into Google Spreadsheets?

Question

Google Sheets

Hello!
I need to display in a cell in Google Spreadsheets, the price of an iPhone that is shown on the page
www.apple.com/shop/buy-iphone/iphone6s
And repeat this action for the pages:
www.apple.com/shop/buy-iphone/ iphone6
​​www.apple.com/shop/buy-iphone/iphone5s
Why Google Spreadsheets?
Having received a table with prices for Apple products, I will use it in formulas (I will automatically convert dollars to rubles, add shipping costs and form a sales value based on this, as well as perform other mathematical operations)
In addition, for these needs it will be necessary to display in a cell Google Spreadsheets "dollar to ruble conversion rate", which can be found for example on this page:
https://www.google.ge/webhp?sourceid=chrome-instan...
Notes:
1. Prices for phones in dollars can be taken from any other places, as long as they reflect current prices
2. Information that may be needed you can first import into some "online parsers", and then from them already into Google Spreadsheets
The task has changed!
You just need to display in a cell in Google Spreadsheets the dollar to ruble conversion rates, which can be taken for example here: www.cbr.ru/scripts/RssCurrency.asp (RSS)
Everything is described in detail here:
www.cbr.ru/scripts/Root.asp ?PrtId=DWS
www.cbr.ru/scripts/Root.asp?PrtId=SXML

Answer 1

Use api and php to parse simplehtmldom.sourceforge.net
and work with spreadsheets https://github.com/asimlqt/php-google-spreadsheet-...

Answer 2

To import from sites in various formats (html, xml, csv), Google Spreadsheets has built-in functions, just insert into the formula in the IMPORTHTML cell and others:
https://support.google.com/docs/answer/3093339/?hl. ..
https://support.google.com/docs/answer/3093342?aut...