google-sheets-reporting（Google sheets reporting 开发）

Google Sheets Reporting

Automated reporting and alerting from any Google Sheets data. Get daily summaries, threshold-based alerts, and weekly digest emails without building dashboards.

Problem

Teams store operational data in Google Sheets but lack automated reporting. Checking sheets manually is tedious, and important changes (threshold violations, trends) go unnoticed until it's too late.

This skill turns any Google Sheet into an automated reporting system with zero code changes.

What It Does

1. Daily Summary — Auto-detects numeric columns, calculates sum/avg/min/max, emails formatted report
2. Threshold Alerts — Checks values against configurable min/max thresholds hourly, sends alert emails when violated
3. Weekly Digest — Multi-sheet summary every Monday with period-over-period comparison

Included Workflows

Architecture

Daily (once):
    |
    v
Workflow 01: Daily Summary
    +-> Read sheet data
    +-> Auto-detect numeric columns
    +-> Calculate sum, avg, min, max
    +-> Count categories in first text column
    +-> Email formatted report

Hourly:
    |
    v
Workflow 02: Threshold Alerts
    +-> Read sheet data
    +-> Check each value against thresholds
    +-> IF violations found -> email alert
    +-> Thresholds configurable via env variable

Weekly (Monday 9AM):
    |
    v
Workflow 03: Weekly Digest
    +-> Read primary + secondary sheets in parallel
    +-> Summarize both sheets
    +-> Email combined digest

Required n8n Credentials

Configuration Placeholders

Environment Variables

# Required
REPORT_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 configured via the ALERT_THRESHOLDS environment variable as JSON:

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

• min — Alert if value falls below this (set null to disable)
• max — Alert if value exceeds this (set null to disable)
• label — Human-readable name for alert emails

Quick Start

1. Prerequisites

• n8n v2.4+ (self-hosted)
• Google Sheets OAuth2 credentials
• SMTP email credentials
• A Google Sheet with data (any structure works)

2. Import & Configure

Import all 3 JSON files into n8n. Replace YOUR_REPORT_SHEET_ID with your sheet's ID and set credential placeholders.

3. Customize Sheet Names

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

4. Set Thresholds

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

5. Activate

Activate all 3 workflows. You'll receive your first daily summary within 24 hours.

Use Cases

1. Sales teams — Daily revenue summaries and low-sales alerts from order sheets
2. Support teams — Ticket count monitoring with escalation alerts
3. Marketing — Campaign performance digests from tracking sheets
4. Operations — Inventory level alerts and daily status reports
5. Finance — Expense monitoring with budget threshold alerts

Requirements

• n8n v2.4+ (self-hosted or cloud)
• Google Sheets OAuth2 credentials
• SMTP email credentials