Start here: crssnt 101 - how to get started

Tags
Publish Date
Nov 13, 2022
Reading time: 3 minutes
 
Changelog

version 1.1 - 08/07/2021
version 1.0 - 10/03/2021
 
 

 

🧑‍🍳 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
 

🥐 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:
 
 
notion image
 
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 👨‍🍳