I’m curious if anybody has an automation I can use that comes close to what I am after, so I don’t have to build from scratch.
I’d like to periodically scrape my site’s RSS feed, and any Posts (which each have a unique ID) that aren’t already in the spreadsheet, I’d like to add as a new row to the spreadsheet.
The use case is that I license posts on my site to a third-party, and I maintain a shared spreadsheet that they look through to decide which individual posts they want to license.
I’ve been updating the spreadsheet manually, but obviously that can be error-prone and time-consuming.