Keep your websites safe without busywork. This setup checks the SSL expiry date for each URL in a Google Sheet and sends a clear Gmail alert when a certificate is close to expiring. It suits IT and DevOps teams that manage many domains and want a simple weekly check.

A weekly trigger starts the run at a set day and hour. The flow reads URLs from a Google Sheet, checks each site with an SSL check API, and returns the host, the valid until date, and the days left. Results are written back to the same Google Sheet so you always have an updated list. An if step looks for any site with seven days or fewer remaining. If found, Gmail sends an alert that includes the host and the days left so your team can act fast. This gives one source of truth and reduces surprise outages.

You need a Google Sheet to store the URL list and a Gmail account to send alerts. Connect both services in n8n Cloud, paste your sheet link into the nodes, and set the email address that should receive alerts. Expect a big time save and fewer missed renewals. This is helpful for agencies, IT operations teams, and anyone who maintains many websites.

• Weekly schedule runs at a chosen day and hour
• Reads the URL list from a Google Sheet tab
• Cleans each URL before the API call to avoid format issues
• Checks SSL status and returns host, valid until date, and days left
• Writes the latest SSL details back to the Google Sheet
• Flags any certificate with 7 days or fewer remaining
• Sends a Gmail alert with host and days left in the subject
• Visual notes describe each step for easier handoff

• Reduce manual checks from 2 hours to 5 minutes each week
• Automate 90 percent of repetitive monitoring work
• Improve accuracy by removing copy and paste errors
• Get early warnings 7 days before expiry to plan renewals
• Connect Google Sheets and Gmail without custom code
• Scale to hundreds of domains with the same workflow

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 Gmail. See the Tools Required section above for links to create accounts with these services.
3. Create a Google Sheet with a tab for your URLs. Add a column named URL and optional columns for KnownExpiryDate and Status.
4. In the n8n credentials manager, open the Google Sheets nodes and create a new Google Sheets OAuth2 credential. Follow the on screen steps in n8n Cloud and name it clearly, for example Sheets Prod.
5. Open the Fetch URLs node and paste your Google Sheet link into the document and sheet fields. Select the correct tab or gid.
6. Open the Weekly Trigger node and set the day and hour that fits your team schedule. Save the node.
7. Review the HTTP Request node. It calls an SSL check endpoint and expects cleaned host names. Keep the existing expression that removes http and https and trailing slashes.
8. Open the URLs to Monitor node and confirm the update operation maps host and valid until fields to your sheet columns. Adjust column names if your sheet uses different headers.
9. Open the If node and confirm the condition checks days left less than or equal to 7. Make sure it reads from result.days_left in the incoming data.
10. In the n8n credentials manager, open the Gmail node and create a new Gmail OAuth2 credential. Follow the on screen steps and give it a clear name, for example Gmail Alerts.
11. Set the Send Alert Email node to use your Gmail credential. Edit the send to address to the mailbox that should receive alerts and keep the subject and message placeholders.
12. Run the workflow once manually. Check the Google Sheet for updated expiry data and confirm a test alert arrives when a site has 7 or fewer days left.
13. If you see errors, confirm the sheet link is correct, the URL column has valid sites, and that Gmail has permission to send. If rate limits occur, try a smaller test list first.
14. Activate the workflow so it runs on the weekly schedule.