Skip to main content

Build an Email tracker and off-load your email data to a spreadsheet

Screenshot 2024-08-19 060227
www.make.com

Step 1: Create a New Scenario

  • Log in to your Make account and click on the “Create a new scenario” button.
  • Click on the “+” button to add a new module.
  • Search for “Email” and select the “Watch emails” trigger.

    Creating Scenario
    Creating Scenario

Step 2: Configure the Email Trigger

  • Select the email connection type (e.g., Gmail). Enter the connection name and select the folder you want to watch (e.g., All Mail).
  • Set the criteria for the emails you want to watch (e.g., all emails). Choose how many emails you want to process at a time (e.g., 5). Click “OK” to save the trigger.

    Configuring Mail
    Configuring Mail

Step 3: Add a Google Sheets Action

  • Search for “Google Sheets” and select the “Add a row” action. Select the Google Sheets connection type (e.g., Google Sheets API).
  • Enter the connection name and select the spreadsheet and sheet you want to write to. Map the email data to the corresponding columns in the Google Sheets (e.g., date, content, subject, sender, email address).
  • Connect the email trigger to the Google Sheets action by clicking on the arrow between the two modules.

    Configuring Sheets
    Configuring Sheets

Tips and Variations

  • As for the email trigger, you can select certain folders, labels, or keywords you want the program to watch.
  • You can extend the actions of that scenario; for instance, you can add an action of sending a notification or creating a new task.
  • You can specify other triggers such as watching an email address or domain.
  • Other actions can be used, for example, writing to a database or creating a new document and so on.

With these steps you can set up a simple flow in Make that listens to new unread emails and writes to Google Sheets. This scenario can be extended and tailored according to your requirement and organization’s workflow.

0
    0
    Your Cart
    Your cart is emptyReturn to Courses