Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

RSS Feed

edited 12/09/19 in Archived 2017 Posts

Hi All,

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. 


  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    How many rows are of interest?

    You mention "past few days". Do you care about history? Archiving?

    If the system allowed X rows and after that would delete the oldest one each time a new one was added, what would X be?

    You also said you have 20-30 sheets that would need such maintenance. Does that imply you have 20-30 Zaps already in use?

    If the solution involved Zapier, you would double the number of Zaps in use now. Do you have that many available?



  • Hi Craig, 

    Thank you for your response.  The history is not important.  The RSS is intended to just see the current news over a few days.  So far, I've found that one day of google news articles yields about 50-100 rows.  Ideally, a great solution would be being able to automatically deleting rows once they reach a certain age (i.e. older than one week). 

    I've only tested Zapier for one sheet so far.  Eventually, I would have 20-30 since each sheet corresponds to a company that I'm following on Google News RSS.  The number of zaps shouldn't be an issue I have a premium account.  Is there a zap for deleting Smartsheet rows?  

    Thank you for your time. 

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Zapier does not have a delete row action. This is likely due to the chance for getting into a loop of trigger-action when using the Updated Row trigger (deletion will trigger all rows below it has changed).

    Your best bet is likely the API. 


This discussion has been closed.