How to access automation add-ons If you want to browse add-ons for Google Sheets, Docs, Gmail, or Forms, you can find them in the Google web store.

This method of using Google Forms with Google Sheets was ostensibly designed to gather and analyze survey data, but with a few tweaks it works just as well to record your financial transactions ...

It has a nifty little formula which allows you to grab a web page’s list or table of data into your sheet of choice. It’s called importhtml, and it works as follows: ...

To obtain very specific bits of that HTML, Google Sheets uses a structured data format called XML and a related query language called XPath.