Table of Contents
Featured
Featured
Publish Date
Nov 13, 2022
Tags
Ingredients
To create your own RSS feed URL with crssnt you will need 2 things:
- a public Google Sheet ("The Baking Sheet") with your data
- a crssnt feed URL with your Sheet ID as a parameter: https://crssnt.com/preview?id=YOUR_SHEET_ID
The Baking Sheet
The easiest way to get some live data into your Baking Sheet is to import an existing RSS feed using the built-in Sheets formula
=IMPORTFEED. Depending on your data source you might also want to try out similar formulas like =IMPORTDATA, =IMPORTXML or even the community-driven open source extension =IMPORTJSON.After loading the feed you can arrange the data however you like using the familiar spreadsheet environment of Google Sheets. When you are ready to turn the data into your own custom RSS feed you just need to copy the Sheet ID from the Sheet URL and paste it into the below URL:
Here is a quick breakdown of how the data from your Baking Sheet will be transformed into the crssnt feed:
- data from the first column of the sheet will go into the
<title>tag of the feed
- data from any other columns will go into
<description>
- if there is a column containing an URL this will become the
<link>and<guid>tags
- if there is a column containing a date this will become the
<pubDate>tag, otherwise, the current date and time (when the feed URL was requested) will be the<pubDate>
Pro Tip: by default, crssnt looks for the feed data in a sheet called "Sheet1". This can be overwritten by passing an additional URL parameter with your sheet name:
https://crssnt.com/preview?id=YOUR_SHEET_ID&name=YOUR_SHEET_NAME
Your crssnt is ready
And that's it! The URL can now be used by any RSS reader like Feedly, Inoreader, Mailbrew etc. to start receiving your data there 👨🍳