Use Case Managing SSL certificates manually can be time-consuming and error-prone, often leading to unexpected downtime or security risks due to expired certificates. What This Workflow Does This workflow automatically monitors SSL certificates for a list of websites, checks their expiry status using SSL-Checker.io, and sends timely notifications if a certificate is about to expire. Setup Add your credentials for Google Sheets, Gmail, and SSL-Checker.io. Create a Google Sheet with a list of URLs for the websites you want to monitor. Configure the workflow to check the SSL status weekly. Set up email notifications to alert you when a certificate is close to expiry. Activate the workflow to automate monitoring and notification. How to Adjust It to Your Needs Customize the URL Source: Replace Google Sheets with another data source like Airtable or CSV files. Modify Notification Thresholds: Change the expiry threshold (e.g., notify for 14 days instead of 7). Add Additional Actions: Integrate with tools like Slack or Teams for team-wide notifications. Automate Renewal Requests: Add a step to send renewal requests directly to your SSL provider if a certificate is nearing expiry.
Tags
Gmail
Google SheetsWHTTP RequestRelated workflows
See all Gmail→WMonitor Server Uptime & Get Email Alerts with Google Sheets
🌐 Web Server Monitor & Alert System This automation pings web servers at regular intervals, logs their status, and sends email alerts if a server goes down. It’s perfect for maintaining visibility over server uptime — without complex monitoring tools. 🧠 How It Works This workflow performs minute-by-minute checks on all listed servers in a Google Sheet and: ✅ Logs all reachable servers in an “Alive” log. 🔻 Sends an email alert if a server is unreachable. 📄 Logs failed servers in a “Down” sheet with timestamps. 🧩 Key Components ⏰ 1. Schedule Trigger Runs the workflow every minute for real-time monitoring. 📄 2. Web Servers List (Google Sheets) Pulls server IPs or hostnames from a Google Sheet named Server_List. Each row = one server to monitor. This makes adding/removing servers effortless — just update the sheet. 🌐 3. Servers Alive Check (HTTP Request) Performs an HTTP GET request to each server (e.g., http://your-server.com). If the request fails, it automatically triggers the error path (handled via continueOnFail). ✅ 4. Web Server Alive Log (Google Sheets) Records successful pings in Server_Status_Alive with: Timestamp Server IP Status = Alive This log can be used for uptim
WMove data between JSON and spreadsheets
This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.
WSync HubSpot Contacts with LinkedIn URLs, Detect Changes & Send Gmail Alerts
Automate CSV imports into HubSpot without the mess. Powered by n8n. Supercharged by Pollup AI. Who’s this for? This workflow is perfect for Ops-minded folks in Customer Success, Marketing, and Sales – especially if you’re juggling CSV lists, CRM updates, and team-wide reporting. Whether you're a CS ops lead syncing product usage, or a RevOps manager updating contact records, this will save you hours. 🧠 Why it matters Manually importing CSVs into HubSpot is a headache: ❌ Copy-paste errors ❌ Mismatched fields ❌ Wasted time formatting every upload This workflow does the heavy lifting for you: ✅ Pulls fields dynamically from your HubSpot instance ✅ Preps and maps CSV data in minutes ✅ Syncs with Google Sheets to keep your source of truth aligned 🔄 What the workflow actually does Pulls live field names from HubSpot’s API (no guesswork) Indexes and organizes your CSV for import Processes & transforms raw data (optional filters, cleanup, etc.) Dynamically maps CSV fields to HubSpot fields Executes the upload and logs results ⚙️ How to get started Prerequisites: HubSpot private app token Google Sheets API credentials Access to an n8n instance (cloud or self-hosted) Setup in 3 steps: Impo