IMPORTFEEDImports a RSS or ATOM feed.
IMPORTFEED(url, [query], [headers], [num_items])
url – The URL of the RSS or ATOM feed, including protocol (e.g. http://).
The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
query – [ OPTIONAL – “items” by default ] – Specifies what data to fetch from url.
“feed” returns a single row containing feed information including title, description, and url.
“items” returns a full table containing items from the feed. If num_items is not specified, all items currently published on the feed are returned.
headers – [ OPTIONAL – FALSE by default ] – Whether to include column headers as an extra row on top of the returned value.
num_items – [ OPTIONAL ] – For queries of items, the number of items to return, starting from the most recent.
If num_items is not specified, all items currently published on the feed are returned.
IMPORTXML: Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.
IMPORTRANGE: Imports a range of cells from a specified spreadsheet.
IMPORTHTML: Imports data from a table or list within an HTML page.
IMPORTDATA: Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.