The below Google specific spreadsheet functions make it easy to translate and import data from web pages.

Helpful Resources

To get the language codes for GOOGLETRANSLATE function check out:

https://developers.google.com/admin-sdk/directory/v1/languages

More information about QR code:

https://developers.google.com/chart/infographics/docs/qr_codes

IMPORTXML function and XPATH:

https://www.w3schools.com/xml/xpath_intro.asp

More info about GOOGLEFINANCE:

https://support.google.com/docs/answer/3093281?hl=en

* Note - This is also available in your course notes.