2020年1月22日 | 4分钟阅读

如何使用 Google Sheets 监听变更模块

了解如何在 Google 表格更新时自动发送电子邮件。以下是由 Integromat 团队为您提供的分步指南！

![How to Use the Google Sheets Watch Changes Module](__CODE_BLOCK_0__ What this scenario does: Watches for changes on a Google Sheet, instantly retrieves the new information and emails the information to the intended recipient. Level of difficulty: Beginner Implementation Time: Approximately 20 mins Prerequisites: The following is needed to set up the scenario: A Google account for Google Sheets and Gmail If you like to learn more about these apps, check out our support articles on [Google Sheets](__CODE_BLOCK_1__ and [Gmail.](__CODE_BLOCK_2__ ‘Webhooks are Wonderful’ is an expression you will hear on Make , but what makes them wonderful? Well, a Webhook delivers [instant](__CODE_BLOCK_3__ notifications whenever a certain change occurs in the third party service. Keyword — _Instant._ As opposed to scheduling a scenario to execute every 15 minutes for example. Sometimes referred to as a ‘Reverse API’, it’s basically a ‘don’t call us, we’ll call you’ concept. This tutorial shows you how to create a simple scenario that receives information instantly using a Webhook. Let’s get to it.

Step 1: Add the Google Sheets app

Create a Google sheet and label it. We have labeled ours Time-sheet. Make sure to add column headers describing the data that you want to store in the sheet: * Go over to your Make dashboard. To create the scenario, click on the Create a new scenario button on the top right corner:

![create-a-scenario-button-make](__CODE_BLOCK_4__ * You will see an empty module with a plus sign. Click on the plus sign , search for the _Google Sheets_ app and select it:

![google-sheets-app-make](__CODE_BLOCK_5__ * Now click on the Watch changes trigger module since you want to watch for any changes on the Google Sheet. You will notice that it has an Instant tag:

![watch-changes-app-make](__CODE_BLOCK_6__ * Now you need to add a Webhook by clicking Add or select an existing one from the dropdown list:

![creating-a-webhook-make](__CODE_BLOCK_7__ * You can edit your Webhook name and click Save.

Step 2: Install the Integromat add-on

Next, you need to install the Integromat Add-on to the Google Sheet (_please note that the add-on is still labelled as Integromat, not Make_)。在 _Google Sheets_ 模块中点击 复制地址到剪贴板： !copy-address-button-make

* 现在再次回到您的表格。为了使用 _即时_ 触发器，必须安装 Integromat 加载项，并在 Make 模块与 _Google Sheets_ 模块之间建立连接。点击 加载项 选项卡，然后点击 获取加载项：

!add-ons-make-scenario

* 搜索 Integromat 并点击其缩略图：

* 点击安装，然后点击继续：

* 现在点击允许，授予 Integromat 访问权限：

* 安装完成后，再次点击 加载项 选项卡，选择 Integromat 并点击设置：

* 最后，将链接粘贴到 Webhook URL 字段中，并点击保存：

Webhook 已成功关联至该表格，_Google Sheets_ 模块现已完全配置完毕！