n8n

How to Automate Multi-Channel SSL Certificate Alerts with Sheets, Gmail, and Telegram?

Keep an eye on SSL certificate expiry across all your sites without manual checks. The workflow reads a list of domains, checks their SSL status, and alerts your team well before anything expires. It suits IT admins, web teams, and agencies that manage many websites.

A weekly schedule runs at the time you set and loads URLs from a Google Sheet. Each domain is sent to an SSL check API to pull the host, expiry date, and days left. Results are written back to the sheet so you have a simple view of current status. A switch groups each site into invalid, warning under 30 days, notice under 60 days, or info for healthy. Alerts go out by Gmail with clear subject lines, plus optional Telegram and Ntfy messages for fast response. This makes follow up easy and keeps everyone on the same page.

Create the sheet with a URL column, connect Google Sheets and Gmail in n8n Cloud, and add your Telegram bot and chat if you want chat alerts. Expect fewer outages and less panic work because the team sees risks weeks in advance. Good for company sites, client portfolios, and any service that cannot afford expired certificates.

What are the key features?

  • Weekly schedule trigger runs at a set day and hour
  • Google Sheets input list of URLs and output of expiry date and status
  • HTTP request to an SSL check API with domain cleanup to avoid bad URLs
  • Switch groups results into invalid, warning, notice, and info
  • Gmail sends alert emails with days left and host in the subject
  • Telegram posts alerts to a chat for real time response
  • Optional Ntfy push notifications for lightweight updates
  • Append or update rows so the sheet always stays current

What are the benefits?

  • Reduce manual work from hours to minutes each week
  • Automate 100 percent of SSL checks across all domains
  • Improve accuracy by removing copy and paste errors
  • Scale to hundreds of domains with a single sheet
  • Connect email, chat, and sheet for faster response
  • Cut downtime risk by warning at 30 and 60 days before expiry

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, Gmail, Telegram, SSL Checker and Ntfy. See the Tools Required section above for links to create accounts with these services.
  3. Create a Google Sheet. In cell A1 enter URL. Add one domain per row, for example example.com without http or https.
  4. In the n8n credentials manager, create a Google Sheets OAuth2 credential. Or double click the Fetch URLs node, click Create new credential, then follow the on screen steps to connect your account.
  5. Open the Fetch URLs node and select your spreadsheet and Sheet1. Save the node.
  6. Open the URLs to Monitor node and select the same spreadsheet and sheet. Keep the operation as append or update so expiry and status can be written back.
  7. For email alerts, open each Gmail node. In the Credential to connect with dropdown, click Create new credential and connect your Gmail account. Enter the To addresses for your team. Adjust subject and body text if needed.
  8. For chat alerts, open the Telegram node. Create a Telegram credential with your bot token. Add the bot to your chat and paste the chat ID into the node.
  9. If you want push notifications, open the Ntfy node and fill in your server URL and topic. Send a test message to confirm delivery.
  10. Open the Weekly Trigger node. Confirm the day and hour match your time zone and operations window.
  11. Run the workflow once manually. Check that the sheet now shows expiry dates and status. Verify that Gmail and Telegram send alerts for invalid, warning, and notice items.
  12. If you see errors, make sure URLs in the sheet do not include http or https and do not end with a slash. Check Gmail sending limits, confirm the Telegram chat ID is correct, and retry.
  13. Activate the workflow so it runs on schedule and monitors your domains every week.

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.

Gmail

Sign up

No cost: Personal Gmail (Gmail API has no usage-based pricing; quotas apply)

Google Sheets

Sign up

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

Free tier: $0 / mo, no signup on ntfy.sh; 250 messages/day limit

SSL Checker

Sign up

Pro: $25/year, includes API access

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.