n8n

How to Monitor Google Sheets Sites with Telegram Alerts?

Keep your website links healthy with a simple scheduled check. A Google Sheet holds the list of URLs and Telegram delivers instant alerts. Great for teams that need quick eyes on broken pages or downtime without manual checking.

A schedule trigger starts runs at set minute intervals. The Google Sheets node reads each link from column A under the header URLS. The HTTP Request node pings every link and captures the status and any error code. The Telegram node sends a message with the URL and the error code so your team sees issues fast. Managing the list in a sheet means you can add or remove links by editing rows, not the flow.

You need access to a Google Sheet and a Telegram bot with the correct chat ID. Expect to cut manual link checks from an hour of clicking to only a few minutes of review, while getting near real time alerts when something fails. Use this for landing pages, blog posts, promo pages, internal tools, and API endpoints that must stay live.

What are the key features?

  • Scheduled checks run every few minutes using a schedule trigger.
  • Reads URLs from a Google Sheet using the URLS header in column A.
  • HTTP Request tests each link and captures status and error details.
  • Sends a Telegram message that includes the URL and any error code.
  • Simple to add or remove links by editing the sheet, not the automation.
  • Notification channel can be swapped if you prefer another app.

What are the benefits?

  • Reduce manual link checks from 60 minutes to 2 minutes per day
  • Receive alerts within minutes when a URL fails or times out
  • Manage the entire URL list in Google Sheets without editing the flow
  • Connect Google Sheets and Telegram with no code changes
  • Scale from a few links to hundreds by adding rows

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Sheets and Telegram. See the Tools Required section above for links to create accounts with these services.
  3. In Google Sheets, create a sheet with column A header named URLS, then list one URL per row under it.
  4. In the n8n credentials manager, open the Google Sheets node, click Credential to connect with, choose Create new credential, and follow the on screen steps to connect your Google Sheets account using OAuth2.
  5. Open the Google Sheets node settings and select your Document ID and Sheet. Confirm the column header is exactly URLS so the URLs map to the field used later.
  6. Create a Telegram bot using BotFather to get a bot token. In the Telegram node, click Credential to connect with, choose Create new credential, and paste the bot token to connect Telegram.
  7. Enter your Telegram chat ID in the Telegram node. Send a test message to confirm the bot can post to that chat.
  8. Open the HTTP Request node and make sure the URL field uses the expression {{$json.URLS}}. Enable Continue On Fail so failed checks still pass error info to Telegram.
  9. Open the Schedule Trigger node and set the interval in minutes. Start with every 5 minutes, then adjust to your needs.
  10. Run a test: put one valid URL and one broken URL in the sheet. Execute the workflow once and verify Telegram messages show the URL and any error code for the broken link.
  11. Troubleshooting: if no messages arrive, confirm the sheet header is URLS, recheck Google Sheets and Telegram credentials, and verify the chat ID is correct.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Telegram

Sign up

Free: $0, Telegram Bot API usage is free for developers

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.