Generate SSL/TLS certificate expiry reports with AWS ACM and AI for Slack & email
Ready for 3.0What this workflow does
This AI workflow has 13 nodes and runs on a schedule (every week). Along the way it connects AWS Certificate Manager, OpenAI Chat Model, Google Drive and Slack and 1 more. It also calls googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every week).
- Get many certificates (AWS Certificate Manager): get many
- Parse ACM Data (Code): runs custom JavaScript code
- Certificate Summary HTML Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Certificate Summary Markdown Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Set Workflow Data (Edit Fields (Set)): sets 3 fields: SenderEmail, SenderName, RecepientEmail
- Configure metadata (Edit Fields (Set)): sets 2 fields: Drive Folder ID, Document Content
- Send Weekly ACM Report Email (SendGrid): work with mail
- Create document file (HTTP Request): calls googleapis.com (POST)
- Convert to PDF (Google Drive): download
- Send Weekly ACM Report PDF (Slack): work with file
Services it uses
HTTP calls to: googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Rarely used nodes in this template: n8n-nodes-base.awsCertificateManager
Nodes used (10)
- AWS Certificate Manager
n8n-nodes-base.awsCertificateManager - Schedule Trigger
n8n-nodes-base.scheduleTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Google Drive
n8n-nodes-base.googleDrive - Slack
n8n-nodes-base.slack - SendGrid
n8n-nodes-base.sendGrid - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
Automated SSL/TLS Certificate Expiry Report for AWS > Automatically generates a weekly report of all AWS ACM certificates, including status, expiry dates, and renewal eligibility. The workflow formats the data into both Markdown (for PDF export to Slack)…