IMPORTFEED for RSS in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a content manager at a news website.

📋 Request: Your manager wants a live dashboard that shows the latest headlines from a popular news RSS feed.

📊 Data: You have access to the URL of the news RSS feed which contains the latest news headlines, publication dates, and links.

🎯 Deliverable: Create a Google Sheets dashboard that automatically imports the latest news headlines, their publication dates, and links using the IMPORTFEED function.

Sample Data

Title	Published Date	Link
Global Markets Rally	2024-06-01	https://news.example.com/global-markets-rally
New Tech Innovations	2024-06-01	https://news.example.com/new-tech-innovations
Climate Change Summit	2024-05-31	https://news.example.com/climate-change-summit
Sports Championship Highlights	2024-05-31	https://news.example.com/sports-championship
Health Tips for Summer	2024-05-30	https://news.example.com/health-tips-summer

1

Step 1: Open a new Google Sheets document and select cell A1.

No formula needed for this step.

Expected Result

You have a blank sheet ready to import data.

2

Step 2: First, enter headers in cells A1, B1, C1: 'Title', 'Published Date', 'Link'. Then enter the IMPORTFEED formula in cell A2 to import the latest news headlines, publication dates, and links from the RSS feed URL.

=IMPORTFEED("https://news.example.com/rss", "items title, items published, items link", TRUE, 5)

Expected Result

Cells A2 to C6 fill with the latest 5 news headlines, their published dates, and links.

3

Step 3: Format the header row (row 1) to bold text and freeze it for easy viewing.

Select row 1, click Bold button, then go to View > Freeze > 1 row.

Expected Result

Header row is bold and stays visible when scrolling.

4

Step 4: Adjust column widths to fit the content for better readability.

Double-click the right edge of each column header (A, B, C) to auto-fit.

Expected Result

Columns A, B, and C adjust width to show full headlines, dates, and links.

5

Step 5: Test the sheet by refreshing the page to confirm the news headlines update automatically.

No formula needed; just refresh the browser tab.

Expected Result

The sheet updates with the latest news from the RSS feed.

Final Result

--------------------------------------------------
| Title                  | Published Date | Link  |
--------------------------------------------------
| Global Markets Rally   | 2024-06-01     | https://news.example.com/global-markets-rally
| New Tech Innovations   | 2024-06-01     | https://news.example.com/new-tech-innovations
| Climate Change Summit  | 2024-05-31     | https://news.example.com/climate-change-summit
| Sports Championship    | 2024-05-31     | https://news.example.com/sports-championship
| Health Tips for Summer | 2024-05-30     | https://news.example.com/health-tips-summer
--------------------------------------------------

✓The sheet automatically shows the latest 5 news headlines from the RSS feed.

✓Publication dates help track how recent each news item is.

✓Links provide quick access to full news articles.

Bonus Challenge

Add a clickable hyperlink to the news titles so clicking a title opens the news article in a new tab.

Show Hint

Use the HYPERLINK function combined with IMPORTFEED data, for example: =ARRAYFORMULA(HYPERLINK(C2:C6, A2:A6))