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:

https://crssnt.com/preview?id=YOUR_SHEET_ID

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