Using Google Sheets to build an RSS index

A crude way but simple way to index an RSS page. You can also embed the sheet on your own pubwriter page.

Cell A1

URL of RSS Feed

Cell C1

Title of RSS feed (optional)

Cell A2

=ImportFeed(A1, "items title", FALSE, 10)

Cell B2

=ImportFeed(A1, "items url", FALSE, 10)

Cell C3

=HyperLink(B2, A2)

After I create the sheet, I hide columns A & B.

You can access the google sheet here.

Source Attribution: I found this out on Digital Inspiration (Amit Agarwal). His site is full of amazing tips!

Top