IMPORTFEED for RSS in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the IMPORTFEED function do in Google Sheets?

It imports RSS or Atom feed data from a URL into your spreadsheet, showing items like titles, URLs, and dates.

beginner

What is the basic syntax of IMPORTFEED?

IMPORTFEED(url, [query], [headers], [num_items])<br><br>Where:<br>- url: The RSS feed URL<br>- query: What data to import (optional)<br>- headers: Whether to include headers (TRUE/FALSE)<br>- num_items: Number of items to import

beginner

Which query option in IMPORTFEED returns the titles of RSS feed items?

The query "items title" returns the titles of the feed items.

intermediate

How can you limit the number of RSS items imported using IMPORTFEED?

Use the fourth argument num_items to specify how many items to import, for example IMPORTFEED(url, "items title", TRUE, 5) imports only 5 items.

beginner

What happens if you set the headers argument in IMPORTFEED to FALSE?

The function will import the data without adding header labels in the first row.

What type of data does IMPORTFEED import into Google Sheets?

A RSS or Atom feed data

B CSV files only

C Images from URLs

D Excel formulas

IMPORTFEED is designed to import RSS or Atom feed data from a URL.

Which argument in IMPORTFEED controls how many feed items to import?

A url

B query

C headers

D num_items

The fourth argument, num_items, limits the number of feed items imported.

What does the query "items url" return in IMPORTFEED?

A The publication dates

B The titles of the feed items

C The URLs of the feed items

D The feed description

The query "items url" returns the URLs (links) of the feed items.

If you want to import feed data without headers, what should you set the headers argument to?

A TRUE

B FALSE

C 0

D 1

Setting headers to FALSE imports data without header labels.

Which of these is NOT a valid query for IMPORTFEED?

A "items color"

B "items title"

C "items date"

D "items url"

"items color" is not a valid query option for IMPORTFEED.

Explain how to use IMPORTFEED to import the latest 3 titles from an RSS feed URL.

Think about the four arguments of IMPORTFEED and how to limit items.

Describe what happens if you omit the query argument in IMPORTFEED.

Consider what IMPORTFEED does when query is not specified.