Google sheet to discord

Questions & Answers
1

I have a google sheet that has a colum (C) called staus. Its set to active but when expired it changes to EXPIRED. I’m wanting to watch my sheet so when the status changes to Expired it sends a mesaage to me in my discord channel. Is this possible as currently im getting a message for every single change on my sheet.

2

you could set an appscript on when column changes to expired then send a webhook from he googlesheet to a make webhook to send the msg to the discord

Set a date column and when set to expired and set a new column discordupdated column as empty.
Then when the change happens check to see if the column is expired and discordupdated not equal to Y

Then send to discord afterwards update the discordupdated to Y

1 Like
3

Hi. I did not test it now, but I think it’s working as script in Google Sheet appscript:

function onEdit(e) {
var sheet = e.source.getActiveSheet();
var row = e.range.getRow();
var url = “https://your-webhook-url.com/webhook”;

var payload = {
“sheetName”: sheet.getName(),
“row”: row
};

var options = {
“method”: “post”,
“payload”: JSON.stringify(payload)
};

UrlFetchApp.fetch(url, options);
}

Thanks, Helio!
Wemakefuture
If you have questions reach out :wink:

1 Like