I have a question regarding RSS feeds.
Currently, I am utilizing Zapier to have a Google News RSS feed add new rows to a sheet. Then I generate a report so that I can have widget in Sights with news from the past few days. I've found that there could be hundreds of news articles a week, which will use up the 5000 row maximum within a few months.
Are there any suggestions on how I can overcome this issue? It doesn't look like there's a way to automatically delete rows after it reaches a certain age.
I thought about doing Zapier -> Google Sheet -> Smartsheet since a Google Sheet can have 400,000 rows, but it still doesn't solve the 5000 row maximum in Smartsheet since there isn't a zap to delete or replace rows in Smartsheet.
Another method would be manually deleting rows once a month to get around the 5000 max cap. This would be pretty time intensive though since I have about 20-30 sheets that would need to undergo this maintenance.
Would appreciate any workarounds or feedback! Thank you for your time.