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

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

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

Regards,

1 Like

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

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!

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

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

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

Hope it helps,