I built a Zap to send emails via Gmail when one status column in my Monday subitem is changed to a specific status. I tested the connections and the whole zap, and it worked great. I then clicked publish and got a confirmation that it was published. However, when I reloaded the page, the zap was turned off. I tried turning it on again in the Zaps page and encountered the same. It turned on, but when I reloaded the page, the zap was turned off.

I've tried deleting connections and reconnecting the apps, but it didn't work.

For reference, here are the apps I’m using and the configurations for each:

1. Trigger: monday.com - Specific Column Value Changed in Board
2. Delay For 5 Minutes
3. Filter conditions - only continue if status column text exactly matches Yes
4. monday.com - Get Items by Column Value
5. Format Text (uppercase)
6. Run Javascript (I will paste the code I used under this post)
7. Gmail - Send Email

Again, when I was testing this worked great. I  also don’t see any error anywhere.

Here’s the code I used:

let neededNotReceivedColumns = [];

for (let column in inputData) {

  if (inputData[column] === "Needed/Not Received") {

    neededNotReceivedColumns.push(column);

  }

}

if (neededNotReceivedColumns.length > 0) {

  const summary = `The following documents are missing: ${neededNotReceivedColumns.join(', ')}`;

  return { summary };

} else {

  return { summary: "No columns have the 'Needed/Not Received' status." };

}

To add more context:

I have a Monday board where I manage client projects. The board has several status columns in the suitem level for the documents I need for these projects (one document = one status column). If I need that specific document, I change the status to “Needed/Not Received”. There’s another column for “Missing Docs?”. I set up the zap so that when “Missing Docs?” is changed to Yes, it sends me an email containing the documents that have “Needed/Not Received” as status.

Could anyone please help me? I’ve tried everything.