I'm using dropdown button to update post from pending to accepted to activate a webhook but the webhook isn't receiving

How To
,
1

Hello I’m trying to create a scenario that allows me to approve of posts generated by ChatGpt before the post go to social media. I have a dropdown button on a google sheet that is labeled approved. I am trying to have that activate a scenario that pulls the information into a webhook and sends to social media using google scripts. My url webhook is working, I just tested it but the script is not. Anyone knows of a better way to do this please let me know. Here is the script. Also you can’t tell here but the url for the webhook module is underlined in scripts, I’m not sure if that makes a difference. The script also adds a date into another cell when the status is updated, that’s working fine.

function onEdit(e) {
const sheet = e.source.getActiveSheet();

// Sheet names
const postsSheetName = “Posts”; // The name of the sheet with the dropdown
const approvedPostsSheetName = “ApprovedPosts”; // The name of the sheet where the webhook triggers

// Column settings for the Posts sheet
const postsStatusColumn = 3; // Column C for Status in Posts sheet
const postsDateColumn = 4; // Column D for Date in Posts sheet

// Column settings for the ApprovedPosts sheet
const approvedPostsStatusColumn = 3; // Column C for Status in ApprovedPosts sheet
const approvedPostsContentColumn = 1; // Column A for Post Content in ApprovedPosts sheet
const webhookUrl = “https://hook.us1.make.com/jbat5c8f9dp7whnumsearfklhv7urfq1”; // Replace with your actual Make.com webhook URL

// Check if the edit was made in the “Posts” sheet
if (sheet.getName() === postsSheetName) {
// Check if the edited cell is in the “Status” column (Column C)
if (e.range.columnStart === postsStatusColumn) {
// Set the current date in the “Date” column (Column D) if Status was updated
const dateCell = sheet.getRange(e.range.rowStart, postsDateColumn);
dateCell.setValue(new Date());
}
}

// Check if the edit was made in the “ApprovedPosts” sheet
if (sheet.getName() === approvedPostsSheetName) {
// Check if the edited cell is in the “Status” column (Column C) and was set to “Approved”
if (e.range.columnStart === approvedPostsStatusColumn && e.value === “Approved”) {
// Retrieve the post content and other necessary data from the row
const row = e.range.rowStart;
const postContent = sheet.getRange(row, approvedPostsContentColumn).getValue(); // Post Content from Column A
const status = sheet.getRange(row, approvedPostsStatusColumn).getValue(); // Status from Column C
const approvalDate = new Date(); // Current date as approval date

  // Create a JSON object with the data
  const payload = {
    postContent: postContent,
    status: status,
    approvalDate: approvalDate.toISOString() // Convert date to ISO format
  };

  // Send the JSON payload to the Make.com webhook
  const options = {
    method: "post",
    contentType: "application/json",
    payload: JSON.stringify(payload) // Convert the data to JSON format
  };

  UrlFetchApp.fetch(webhookUrl, options);
}

}
}