I have a scenario here that searches for three RSS feeds in Google Sheets and then extracts the latest URL from each one and passes it through 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)