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.

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.

Step by step instructions:

1. 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

1. In the “Watch rows” module, select your Google Sheet document and worksheet and enter the range of the cells you want to watch.
2. 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.
3. In the “Search for posts” module, select the RSS feeds you specified in the “RSS” column of your Google Sheet document.
4. In the “Send an email” module, enter the email address you wish to receive the summary at.
5. Select the “Body” field in the “Send an email” module and click the “Insert template” button.
6. Enter the following template and then click the “Insert” button:

{{count}} new posts

• {{post_title}}
• {{post_content}}

1. Save your scenario and click the “Run once now” button.

Example of use case:

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

1. You create a Google Sheet document with a list of RSS feeds to watch and the keywords you want to find.
2. 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

1. In the “Watch rows” module, you select your Google Sheet document and worksheet and enter the range of the cells you want to watch.
2. 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.
3. In the “Search for posts” module, you select the RSS feeds you specified in the “RSS” column of your Google Sheet document.
4. In the “Send an email” module, you enter the email address you wish to receive the summary at.
5. In the “Send an email” module, you select the “Body” field and click the “Insert template” button.
6. In the “Insert template” dialog, you enter the following template and then click the “Insert” button:

{{count}} new posts

• {{post_title}}
• {{post_content}}

1. You save your scenario and click the “Run once now” button.

Try out this ready to use workflow template:

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

Find more templates on our website:

Business workflow templates

Business Automated is an independent automation consultancy. You can visit us at www.business-automated.com if you would like to request custom automation for your business. Visit our YouTube Channel for more automation ideas to accelerate your business. If you like our work buy us a coffee or follow one of our affiliate links and try out Make (formerly Integromat).