New updates on Google sheet to create an event in Google calenar

How To
1

I have a prepopulated dates on google sheet - under Colm A. When updates are made in Colm B.
I want an event to be created on Google calendar.

What is the recommended trigger for Google sheet?
I can only see a step where, “A new row is added” but this is not really want i want. its more like when a cell is updated.

Thanks

1 Like
2

Hi @E12 ,
I think Watch Changes is what you are looking for.

Regards,

Screenshot 2025-07-13 at 12.14.53
Screenshot 2025-07-13 at 12.14.53882×220 20 KB

1 Like
3

Thanks @llirik! This could be the right trigger but it requires an Add-on to insert the webhook. And I am unable to find Make under Google Workspace

Screenshot 2025-07-16 at 8.49.01 AM
Screenshot 2025-07-16 at 8.49.01 AM2204×788 215 KB

4

Welcome to the Make community!

Have you seen these previous discussions?

It has been like this since the start of this year, and there are workarounds discussed —

For more information, also see these discussions on similar threads:

You can search this forum for existing answers, and also use the documentation in the Help Centre to get to a solution faster, and also help keep the forum organised. Thanks for your cooperation!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

5

Hi @E12
As of now, Make.com no longer provides an official Google Sheets extension, which means you cannot directly use triggers like “Watch Changes” from within Make anymore.

Instead, there is a way to achieve your use case (trigger Make when a specific cell like Column B is updated) is by using Google Apps Script + a Make Webhook.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

1 Like
6

Hi @E12
Here is the sample Apps Script to watch changes in column B:

function onEdit(e) {
  const sheet = e.source.getActiveSheet();
  const editedCell = e.range;
  if (editedCell.getColumn() === 2) {
    const row = editedCell.getRow();
    const date = sheet.getRange(row, 1).getValue();
    const info = editedCell.getValue();
    const payload = {
      row: row,
      date: date,
      details: info
    };
    const options = {
      method: "post",
      contentType: "application/json",
      payload: JSON.stringify(payload)
    };
    UrlFetchApp.fetch("https://hook.make.com/your-webhook-url", options);
  }
}

Just replace "https://hook.make.com/your-webhook-url" with your actual Make webhook URL.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

1 Like
7

Hi @E12,
The Make Google Sheets Add-on is currently not available.
You can check how to configure it here:

Hope it helps,