Google Sheets Reporting — Google Sheets 报告ing

Google Sheets 报告ing

Automated 报告ing and 告警 from any Google Sheets data. 获取 dAIly summaries, threshold-based alerts, and weekly digest emAIls without building 仪表盘s.

Problem

Teams store operational data in Google Sheets but lack automated 报告ing. 检查ing sheets manually is tedious, and 导入ant changes (threshold violations, trends) go unnoticed until it's too late.

This 技能 turns any Google Sheet into an automated 报告ing 系统 with zero code changes.

What It Does DAIly Summary — Auto-检测s numeric columns, calculates sum/avg/min/max, emAIls 格式化ted 报告 Threshold Alerts — 检查s values agAInst configurable min/max thresholds hourly, 发送s alert emAIls when violated Weekly Digest — Multi-sheet summary every Monday with period-over-period comparison Included 工作流s # File Purpose 01 01-dAIly-summary.json DAIly 聚合 statistics emAIl for any sheet 02 02-threshold-alerts.json Hourly threshold 监控ing with alert emAIls 03 03-weekly-digest.json Weekly multi-sheet digest emAIl (Monday 9AM) Architecture DAIly (once): | v 工作流 01: DAIly Summary +-> Read sheet data +-> Auto-检测 numeric columns +-> Calculate sum, avg, min, max +-> Count categories in first text column +-> EmAIl 格式化ted 报告

Hourly: | v 工作流 02: Threshold Alerts +-> Read sheet data +-> 检查 each value agAInst thresholds +-> IF violations found -> emAIl alert +-> Thresholds configurable via env variable

Weekly (Monday 9AM): | v 工作流 03: Weekly Digest +-> Read primary + secondary sheets in parallel +-> Summarize 机器人h sheets +-> EmAIl combined digest

Required n8n 凭证s 凭证 Type Used For Placeholder in JSON Google Sheets OAuth2 Reading sheet data YOUR_GOOGLE_SHEETS_凭证_ID SMTP 发送ing 报告s and alerts YOUR_SMTP_凭证_ID Configuration Placeholders Placeholder Description YOUR_报告_SHEET_ID Google Sheet ID to 监控 YOUR_GOOGLE_SHEETS_凭证_ID n8n Google Sheets 凭证 ID YOUR_SMTP_凭证_ID n8n SMTP 凭证 ID YOUR_NOTIFICATION_EMAIL EmAIl for 报告s and alerts 环境 Variables # Required 报告_EMAIL=your-emAIl@example.com

# Optional: Threshold configuration (JSON) ALERT_THRESHOLDS='{"revenue":{"min":100,"max":null,"label":"Revenue"},"error_count":{"min":null,"max":10,"label":"Errors"}}'

Threshold Configuration

Thresholds are 配置d via the ALERT_THRESHOLDS 环境 variable as JSON:

{ "column_name": { "min": 100, "max": null, "label": "Display Name" } }

min — Alert if value falls below this (设置 null to disable) max — Alert if value exceeds this (设置 null to disable) label — Human-readable name for alert emAIls Quick 启动

• Prerequisites

• 导入 & 配置

导入 all 3 JSON files into n8n. Replace YOUR_报告_SHEET_ID with your sheet's ID and 设置 凭证 placeholders.

• Customize Sheet Names

Edit the Google Sheets nodes to match your tab names (default: "Data" and "Sheet2").

• 设置 Thresholds

配置 ALERT_THRESHOLDS env var for your columns, or edit the Code node defaults directly.

• Activate

Activate all 3 工作流s. You'll 接收 your first dAIly summary within 24 hours.

Use Cases Sales teams — DAIly revenue summaries and low-sales alerts from order sheets Support teams — Ticket count 监控ing with escalation alerts Marketing — CampAIgn performance digests from 追踪ing sheets Operations — Inventory level alerts and dAIly 状态 报告s Finance — Expense 监控ing with bud获取 threshold alerts Requirements n8n v2.4+ (self-hosted or cloud) Google Sheets OAuth2 凭证s SMTP emAIl 凭证s