🔔 THOAlerts Documentation

📖 Overview

THOAlerts is a powerful Google Sheets add-on that automatically sends notifications when your spreadsheet data meets specific conditions. Whether you’re tracking sales targets, monitoring inventory levels, managing tasks, or watching for form submissions, THOAlerts keeps you informed in real-time.

What Can THOAlerts Do?

🚀 Getting Started

Installation

📡 Notification Channels

THOAlerts supports 7 notification channels. Here’s how to set up each one:

1. 📧 Email (FREE)

How to use: Enter email address directly in the Recipient field.

Recipient: john@example.com

Multiple recipients: Separate with commas

Recipient: john@example.com, jane@example.com

2. 💬 Discord (FREE)

How to get webhook URL:

1. Open your Discord server
2. Go to Server Settings → Integrations → Webhooks
3. Click New Webhook
4. Choose channel and name (e.g., “THOAlerts”)
5. Click Copy Webhook URL

Recipient: https://discord.com/api/webhooks/123456789/ABCDEF...

📚 Official Guide: Discord Webhooks Documentation

3. 📱 Slack PRO

How to get webhook URL:

1. Go to api.slack.com/apps
2. Click Create New App → From scratch
3. Name it “THOAlerts” and select your workspace
4. Go to Incoming Webhooks → Toggle ON
5. Click Add New Webhook to Workspace
6. Select channel and click Allow
7. Copy the Webhook URL

Recipient: https://hooks.slack.com/services/T00000000/B00000000/XXXXXXXXXXXX

📚 Official Guide: Slack Incoming Webhooks

4. 🚀 Microsoft Teams PRO

How to get webhook URL:

1. Open Microsoft Teams
2. Go to your desired channel
3. Click ⋯ (More options) → Connectors
4. Search for Incoming Webhook → Click Configure
5. Name it “THOAlerts” and upload an icon (optional)
6. Click Create and copy the URL

Recipient: https://outlook.office.com/webhook/XXXXX...

📚 Official Guide: Teams Incoming Webhooks

5. 🗨️ Google Chat PRO

How to get webhook URL:

1. Open Google Chat
2. Go to the space where you want notifications
3. Click space name → Manage webhooks
4. Click Add webhook
5. Name it “THOAlerts” and optionally add avatar
6. Click Save and copy the Webhook URL

Recipient: https://chat.googleapis.com/v1/spaces/AAAA/messages?key=XXX...

📚 Official Guide: Google Chat Webhooks

6. ✈️ Telegram PRO

How to setup:

1. Open Telegram and search for @BotFather
2. Send command /newbot
3. Follow instructions to name your bot
4. Copy the Bot Token (looks like 123456:ABC-DEF...)
5. Add your bot to a channel/group or start a private chat
6. Get your Chat ID using @userinfobot or @RawDataBot
7. Format: BOT_TOKEN/CHAT_ID

Recipient: 123456789:AAHdqTcvCH1vGWJxfSeofSAs0K5PALDsaw/987654321

📚 Official Guide: Telegram Bot API

7. 🦜 Larksuite/Feishu PRO

How to get webhook URL:

1. Open Larksuite and go to your group chat
2. Click group settings → Bots
3. Click Add Bot → Custom Bot
4. Name it “THOAlerts” and add description
5. Copy the Webhook URL
6. Click Finished

Recipient: https://open.larksuite.com/open-apis/bot/v2/hook/XXXXXXXX

📚 Official Guide: Larksuite Custom Bots

8. ⚡ Zapier PRO

How to get webhook URL:

1. Go to zapier.com and create account
2. Create a new Zap
3. Set trigger to Webhooks by Zapier → Catch Hook
4. Copy the Webhook URL provided
5. Paste into THOAlerts Recipient field
6. Continue building your Zap workflow

Recipient: https://hooks.zapier.com/hooks/catch/123456/abcdef/

📚 Official Guide: Zapier Webhooks Documentation

9. 🔧 Make (Integromat) PRO

How to get webhook URL:

1. Go to make.com (formerly Integromat)
2. Create a new Scenario
3. Add Webhooks module → Custom webhook
4. Click Add to create new webhook
5. Copy the Webhook URL
6. Paste into THOAlerts and trigger once to register

Recipient: https://hook.us1.make.com/abc123xyz...

📚 Official Guide: Make Webhooks Documentation

10. 🤖 n8n PRO

How to get webhook URL (Cloud only):

1. Open your n8n Cloud instance at app.n8n.cloud
2. Create a new Workflow
3. Add Webhook node as trigger
4. Set HTTP Method to POST
5. Copy the Production URL (not Test URL)
6. Activate workflow before testing

Recipient: https://your-workflow.app.n8n.cloud/webhook/abc123...

📚 Official Guide: n8n Webhook Node Documentation

🎯 Available Conditions

FREE: 6 Basic Conditions

PRO: 25 Advanced Conditions PRO

Includes all FREE conditions plus 19 advanced operators:

📝 Advanced Text Operators

• text_not_contains – Does not contain text
• text_starts_with – Begins with text (e.g., “INV-“)
• text_ends_with – Ends with text (e.g., “.pdf”)

🔥 CSV List Matching (KILLER FEATURE)

• one_of – Value is in list: Done,Completed,Finished
• not_one_of – Value NOT in list: Pending,Draft,Review

🔢 Number Operators

• equals – Exactly matches number
• not_equals – Not equal to number
• greater_than – Larger than (>)
• greater_equal – Greater or equal (>=)
• less_than – Smaller than (<)
• less_equal – Less or equal (<=)
• between – In range (100-500)
• not_between – Outside range

📅 Date Operators

• date_is – Exactly matches date
• date_before – Date is earlier
• date_after – Date is later

Date keywords: TODAY, TOMORROW, YESTERDAY, TODAY+7, TODAY-30

🔥 Regex & Validators (KILLER FEATURES)

• matches_regex – Pattern matching (e.g., ^INV-d{6}$)
• is_valid_email – Email format validation
• is_valid_url – URL format validation

⚡ Advanced Features PRO

Dynamic Recipients NEW 2025

Send notifications to email addresses stored in cells – perfect for task assignments, client follow-ups, and team collaboration!

Method 1: Simple Cell Reference

Use {B} or {C2} in the Recipient field:

Recipient: {B}
# Sends to email in column B of the triggered row

Method 2: Excel-Style Formula

Use formulas like VLOOKUP or IF for complex logic:

Recipient: =IF(D2="High Priority",{B},{C})
# Send to manager (B) if high priority, else team lead (C)

Recipient: =VLOOKUP(A2,Contacts!A:B,2,FALSE)
# Lookup email from another sheet

⚠️ Troubleshooting Dynamic Recipients

• Not working? Make sure cell contains valid email format (name@domain.com)
• Empty cell? Notification will be skipped – no error message
• Formula error? Check syntax in Google Sheets first before using in THOAlerts

First-match vs Each-match Mode NEW 2025

Control notification frequency to prevent spam:

Row Data Variables NEW 2025

Access entire row data or specific columns in your message template:

📋 Task: {A}
👤 Assigned to: {B}
📅 Deadline: {D}
🔗 View: {URL}

HTML/Markdown Formatting NEW 2025

AND/OR Logic PRO

Combine multiple conditions with flexible logic:

• AND Logic: All conditions must be true (strict matching)
• OR Logic: At least one condition must be true (flexible matching)
• Unlimited conditions: Add as many rules as needed

💡 Real-World Examples

❓ Frequently Asked Questions