Skip to content

Example Flow: Save new Blog Posts in Google Sheets and send an e-mail

Flow Description:

A new Blog post will be saved automatically in a Google Sheet and a notification e-mail will be sent.

Goal:

New Blog posts from a RSS feed will be saved in a Google Sheet for a comfortable comprehensive overview and then a notification e-mail will be sent to a specified e-mail account.

Prerequisites

  1. This guide assumes you have already connected the Google Sheets and SMTP apps.
  2. For this example flow a new Blog post needs to have been posted in a RSS feed.
  3. For this example flow a Google Sheet has been set up, named e.g. "New Blog Posts".

Steps:

  1. Go to the Flows page on Mation. Click the + button to create a flow. Example_Flow_RSS_Sheets_SMTP_01.jpg

  2. Name your flow with an appropriate name.

    NOTE

    You may edit your flow name at any time. You don't need to unpublish a flow to rename it.

    Example_Flow_RSS_Sheets_SMTP_02.jpg

  3. Choose RSS as application from the dropdown list. Example_Flow_RSS_Sheets_SMTP_03.jpg

  4. Choose New items in feed as the Trigger event from the dropdown list. Click the Continue button. Example_Flow_RSS_Sheets_SMTP_04.jpg

  5. Copy the RSS Feed URL you would like to connect, and paste it into the Feed URL field. Click the Continue button.Example_Flow_RSS_Sheets_SMTP_05.jpg

  6. Click the Test & Continue button to test the Trigger step.Example_Flow_RSS_Sheets_SMTP_06.jpg

  7. Click the Continue button. Example_Flow_RSS_Sheets_SMTP_07.jpg

  8. The Action step is now ready for configuration. Example_Flow_RSS_Sheets_SMTP_08.jpg

  9. Choose Google Sheets as application from the dropdown list.Example_Flow_RSS_Sheets_SMTP_09.jpg

  10. Choose Create spreadsheet row as the Action event from the dropdown list. Click the Continue button.Example_Flow_RSS_Sheets_SMTP_10.jpg

  11. Choose your connection from the dropdown list. Click the Continue button.Example_Flow_RSS_Sheets_SMTP_11.jpg

  12. Set up the action choosing your Drive, Spreadsheet, and Worksheet from the respective dropdown lists. Click the Continue button. Example_Flow_RSS_Sheets_SMTP_12.jpg

  13. Click the Test & Continue button to test the Action step.Example_Flow_RSS_Sheets_SMTP_13.jpg

  14. Click the Continue button. Example_Flow_RSS_Sheets_SMTP_14.jpg

  15. Set up the next Action step.Example_Flow_RSS_Sheets_SMTP_15.jpg

  16. Choose SMTP as application from the dropdown list. Example_Flow_RSS_Sheets_SMTP_16.jpg

  17. Choose Send an email as the Action event from the dropdown list. Click the Continue button.Example_Flow_RSS_Sheets_SMTP_17.jpg

  18. Choose your connection from the dropdown menu. Click the Continue button. Example_Flow_RSS_Sheets_SMTP_18.jpg

  19. To enable functionality fill in the From name, From email, To, Subject, and Body fields. Feel free to fill in the Reply to, Cc, and Bcc as you see fit. Click the Continue button. Example_Flow_RSS_Sheets_SMTP_19.jpg

  20. Click the Test & Continue button to test the Action step. Example_Flow_RSS_Sheets_SMTP_20.jpg

  21. Click the Continue button.Example_Flow_RSS_Sheets_SMTP_21.jpg

  22. Your flow is now configured. Click the Publish button.Example_Flow_RSS_Sheets_SMTP_22.jpg

  23. If you would like to edit your new flow, Click the Unpublish button. Alternatively click the < button in the top left corner of this page to navigate to the Flows page. Example_Flow_RSS_Sheets_SMTP_23.jpg

  24. Your new flow is ready and running! Example_Flow_RSS_Sheets_SMTP_24.jpg