Google Sheets automatics with email alerts – Make.com Lessons

Imagine that you have a Google Sheets Blacks where new data is added – it can be responses, threads or inputs to which team members are added.

You want to know when new classes appear Without constantly verifying the paper. In this guide, we will create automation Watch Google Paper to get new rows and send you an e -mail notice immediately With details. This is very useful for tracking model introductions, sales threads, subscriptions, or any updates registered in a spreadsheet.

Why is it useful: Google Sheets is a common tool for collecting and storing data, but it does not do that Fasting actively You are a change. By adding an automatic mail an alert to new inputs, you guarantee that there is nothing sliding across cracks.

For example, if the customer fills the comments form (feeding in a sheet of paper), you will get an immediate email with their information, allowing a quick response.

The necessary tools:

• Google leaves (The spreadsheet that will lead to workflow).
• Gmail (To send an email alert, you can use any built -in email service with Make, but we will usefeatherExample).
• A Make.com account With access to Google Leaves and Gmail (Make Free Plan).
• Access or create a Google sheet that you will use to test the trigger (with a adjustment of connection via Make).

How to build it:

1. Prepare the operator – “Watch new ranks” in Google Leaves: In Make, start a new scenario and add Google leaves as a first unit. Select the trigger event “Watch ranks”any It monitors a newly added spreadsheet.

   Choose the “Watch Rows” for Google Papers in Make. Connect your Google account if claimed, choose a selected spreadsheet and tab for viewing. You can also determine or allow it to discover new rows at the bottom of the paper. In this example, we will assume that every new model introduces a new row to the paper.

   • advice: The first time you prepare the connection, Make will order permissions to access your Google leaves. Approval of access, then you can reuse this connection to future stereotypes.
   • When creating the trigger, you may see an option for “Where do you start– You can find out if you want to think about the current or only new rows moving forward. Usually choose “from now on” to ignore historical data and operate only on new entries.
2. Add procedure – Send an email via Gmail: Next, add a second unit to the scenario: Choose Gmail (or the General Email Unit) as an application, and “Send an email” As a procedure. Connect your Gmail account. Now, the email for the notification will be composed Data map from Google trigger leaves In email fields:
   • In the “To” field, enter your email (or you should notify anyone).
   • Set the topic line, for example Enter the new model: {{name}} – You can insert the name or another field of the new row here by clicking in the field and setting data from the Google Sheets Unit (Make will display the names of the columns as the fields of applicable).
   • In the email, write a brief message and include related details of the row. For example: “A new response was added to the spreadsheet. Name: {{name}}, e -mail: {{email}}, message: {{FeedBand}}”Where the elements are assigned to the actual column values ​​of the paper.
   • You can add multiple fields or entire row data. this Mapping One of the fields is how to perform information transfers between applications. (At the Make interface, the specific variables of the previous units are often highlighted – for example, the subject of the subject line that was appointed from Gmail to the leaves was highlighted, indicating that it came from the operator’s data.)
3. Optional – Add a filter (if necessary): Make allows you to set the conditions so that the procedures occur only if certain criteria are met. In this simple case, you may not need a filter (every new row leads to an email). But for the presentation of the demonstration, let’s say that you only want email messages for the inputs in which the “urgency” column is high.

   You can click the line between Google Sheets and Gmail and set a filter a base: It only continues if the “urgency” is equal to “high”. In this way, low -mail priorities will not. (You can skip this if it is not the need; it is just an explanation that the filter is possible for more complex scenarios.)

4. Test the script: It’s time to test. In a script editor, click “Run once” button. Then go to Google and Add a new row A sample of data (or simulating any event that adds a row). Switching again to making – you should discover the new Google papers player and you will see the scenario flow. If everything is properly prepared, the Gmail unit will send an email.

   Check your inbox to get the notification. The Make’s CheckMark will be shown if it succeeds, or a mistake if a mistake occurs (you can explore and fix errors by reading the error message).

5. Stimulating the scenario: If the test looks good, run the scenario by switching the switch to “on me” Set the scheduling. Google Sheets “Watch Rows” usually come up with new rows in a specific time interval (for example, every 5 or 15 minutes on the free plan).

   You can adjust the table if necessary (in scenario settings). Now, your automation is alive! Whenever a new row is added to this Google sheet, you will automatically send Make a alert via email.

outcome: You have a job automation linking Google and Gmail leaves. When someone adds data to your paper (for example via Google or any integration), you will get an immediate email with details. No more continuous verification of the spreadsheet – Make.com Have you covered.

(This basic style – operator on new data in app, then send a notice via app – is very common. You can reuse it with different applications: for example, see a rhetoric and send a recession message instead of email, watch a database and send SMS, etc.

In fact, the Make’s Own assistance determines that Google leaves can be used either to provoke the workflow on new rows or to add data to papers from other applications. We will explore more differences in the upcoming evidence.)