Get RSS feed updates in a single email summarizing all posts that contain a specific keyword

Software used in this automated workflow example

Google Sheets

Integromat

Make

RSS

Summary

Make will watch RSS feeds you specify in a Google Sheets spreadsheet for new posts that contain a specific keyword. It will merge all these posts into a single email summary and send it to a specific email address. If you wish to use this template without further settings, you need to create a spreadsheet according to this example. In the RSS column, you specify the RSS feeds you want to watch and in the KEYWORD column the keyword to find.

Detailed explanations

Step by step instructions

Create a new scenario in Make with the following modules:

Google Sheets > Watch rows

Google Sheets > For each row

RSS > Search for posts

Email > Send an email

In the "Watch rows" module, select your Google Sheet document and worksheet and enter the range of the cells you want to watch.
In the "For each row" module, select the RSS column (A in our example) as the "Key" field and the KEYWORD column (B in our example) as the "Value" field.
In the "Search for posts" module, select the RSS feeds you specified in the "RSS" column of your Google Sheet document.
In the "Send an email" module, enter the email address you wish to receive the summary at.
Select the "Body" field in the "Send an email" module and click the "Insert template" button.
Enter the following template and then click the "Insert" button:

<h1>{{count}} new posts</h1>
 <ul> 
{{#data}} 
<li>
<a href="{{post_url}}">{{post_title}}</a>
<p>{{post_content}}</p> 
</li>
 {{/data}}
 </ul>

Save your scenario and click the "Run once now" button.

Business use case example

You are a blogger and you want to be notified whenever a new post is published on a specific topic.

You create a Google Sheet document with a list of RSS feeds to watch and the keywords you want to find.
You create a Make scenario with the following modules:

Google Sheets > Watch rows

Google Sheets > For each row

RSS > Search for posts

Email > Send an email

In the "Watch rows" module, you select your Google Sheet document and worksheet and enter the range of the cells you want to watch.
In the "For each row" module, you select the RSS column (A in our example) as the "Key" field and the KEYWORD column (B in our example) as the "Value" field.
In the "Search for posts" module, you select the RSS feeds you specified in the "RSS" column of your Google Sheet document.
In the "Send an email" module, you enter the email address you wish to receive the summary at.
In the "Send an email" module, you select the "Body" field and click the "Insert template" button.
In the "Insert template" dialog, you enter the following template and then click the "Insert" button:

<h1>{{count}} new posts</h1>
 <ul> 
{{#data}} 
<li>
<a href="{{post_url}}">{{post_title}}</a> 
<p>{{post_content}}</p> 
</li> 
{{/data}} 
</ul>

You save your scenario and click the "Run once now" button.

Try ready to use workflow template

Get RSS feed updates in a single email summarizing all posts that contain a specific keyword with Make.com (formerly Integromat)