Vendor Compliance Alerting System
A JavaScript / Google Apps Script automation that reads live vendor data from Google Sheets, detects expired compliance documents, writes status updates back to the sheet, and automatically emails vendors to request renewals — covering 81 PCI ROC vendors that were previously tracked by hand.