Get RSS feed updates in a single email summarizing all posts that contain a specific keyword
Make (formerly Integromat) 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.
Greg Vonf
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.