I have a need for a custom RSS feed. Here’s my scenario: I want to create an email newsletter that every day sends out a headline, excerpt, and a link. Obviously I would like to automate this.
On the email side, I have Mailchimp which will take and RSS feed and send out an email consisting of new entries since the last check.
On the source side, I can create an AirTable database or Google Sheets with records that contain fields of Date, Headline, Excerpt, and Link.
The trick is setting it up so I can batch enter my headlines but only have them go out one per day, which means the RSS needs to be updated every day, adding the item for that day.
I have tried Zapier, but that just pulls whatever is in the Table or Sheet and fills the RSS with it. I could set up a web site (e.g. WordPress) with the entries postdated, but that seems like a lot of overhead for a simple RSS. Anyone have other ideas?