Keep a fresh list of news without manual work. This setup pulls articles from many RSS links, stores them in Google Sheets, and cleans out old items on its own. It is ideal for marketing teams that plan social posts, newsletters, or trend reports.

A daily schedule reads a list of RSS URLs from a Google Sheet, then scans each feed one by one. Items older than a set number of days are filtered out with simple code, so only recent posts move forward. Content is formatted and saved to Google Sheets with a short wait after each write to prevent rate limits. After a short cool down, the system reads the saved data, finds rows older than your cutoff, and deletes them in small steps with longer waits. The result is a clean, up to date sheet that is safe for API limits.

Setup needs a Google Sheets account and two sheets or tabs, one for RSS links and one for saved entries. You can change the age limit in the code nodes if you want more or fewer days. Expect less copy and paste, faster research, and a single source of truth for the latest articles. Use it for content curation, PR monitoring, or daily news for your team.

• Daily schedule runs the update automatically
• Reads RSS feed URLs from a Google Sheet list
• Fetches each feed in batches to control load
• Filters items by age using a simple code cutoff set to 3 days
• Formats text with a Markdown step before saving
• Saves each item to Google Sheets with a 2.5 second wait to avoid rate limits
• Short cool down of 1 minute before cleanup to keep the API stable
• Deletes old rows with a 25 second delay between deletes
• Split in Batches loops ensure safe, paced processing
• Field mapping normalizes item data for consistent records

• Reduce manual curation from 2 hours to 10 minutes per day
• Keep content fresh by auto removing posts older than 3 days
• Prevent Google Sheets API blocks with paced writes and deletes
• Unify many RSS sources into one clean Google Sheet
• Scale to dozens of feeds with batch loops and timed steps
• Improve data quality by filtering out outdated items before saving

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. Open the Google Sheet you will use and create two tabs: one for RSS links and one for saved news items. In the links tab, add a column named Links and paste your RSS URLs there.
4. In n8n, double click the Read Links node. In the 'Credential to connect with' dropdown, click 'Create new credential', choose Google Sheets OAuth2, and follow the on screen steps to sign in and allow access.
5. Repeat the same credential step for Save News, Read News, and Delete News nodes so they all use the same Google Sheets connection.
6. Configure Read Links to point to your spreadsheet and the tab that holds the Links column. Make sure the column name matches Links because the RSS node reads url from {{$json.Links}}.
7. Open the Save News node and select your spreadsheet and the tab for saved entries. Map fields like id, title, link, and date to columns in the sheet.
8. Open the Code and Code1 nodes. If you want a different retention period, change the setdays value from 3 to your preferred number.
9. Check the Wait nodes. Keep the 2.5 second wait after each write, the 1 minute cool down, and the 25 second delay for deletes. Increase these values if you see rate limit errors.
10. Run a test with a few RSS URLs. Confirm new rows appear in the saved entries tab, then verify that items older than your set days are removed after the cleanup phase.
11. If the RSS node returns no items, confirm each URL is a valid feed. If Google Sheets errors, recheck the selected spreadsheet, tab names, and that your Google account has edit access.
12. Turn the workflow on. It will run on the set schedule and keep your sheet current every day.