Triggering a Zap from existing items in an RSS feed

  • 21 October 2019
  • 1 reply

Userlevel 7
Badge +12

It's easy to trigger a Zap from new items in an RSS feed using the RSS by Zapier app, but did you know that it's also pretty simple to trigger a Zap from existing items?

This workaround uses a really useful function in Google Sheets called IMPORTFEED, which will import existing items from an RSS feed into your Google Sheet.

Here's how you can use it trigger a Zap:

Import get the RSS feed link. In this case, I grabbed the one for Zapier's blog:

Open a fresh sheet in Google Sheets and in the first cell type =IMPORTFEED("url-of-RSSfeed")

Untitled Image

Look at the information in from the feed to figure out what column headers you'll need for your Zap. In a new sheet, add the headers.

Set up your Zap using the Google Sheets New Row in Spreadsheet trigger, make sure that it's triggering from your new sheet with the header row. Add whatever action you'd like (eg sending the information to a social media scheduling app).

image.pngGo to your sheet with the RSS feed, make sure that it's all selected, then copy it.

Go to the sheet with the headers, click in the first cell (under the header row) and select Paste Special -> Paste Values only

Untitled ImageThis will add all of the information about the items in the feed as new rows in this sheet, which will then trigger your Zap.

If you'd like more info about using the IMPORTFEED function, check our Google's help guide.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +10

Great guide @Danvers