I have a scenario here that searches for three RSS feeds in a Google Sheets and then extracts the latest URL from each one and passes it trough some OpenAI modules to create article summaries and headlines.
The issue I’m having is that I want the scenario to only retrieve the URLs from the RSS Feeds that are newer than the date of the previously retrieved RSS Feeds. I have tried to add a Google Sheets module at the end which sequentially fills the “Time Updated” column with each date of each URL, however it only fills the first row of the column 3 times for each run. I also tried to bulk update the rows but that results in all three rows of the “Time Updated” column being filled with the last date retrieved.
How can I record the google sheets column with each date that is retrieved, one after the other?
I have uploaded the blueprint.
blueprint.json (50.9 KB)