Quick Overview
Quick Overview This workflow runs daily at 6 PM to pull trade breaks, failed trades, and exceptions from Google Sheets, calculate resolved vs pending counts with a severity/trend classification, generate an end-of-day summary with Google Gemini, optionally alert Slack for high pending volume, email the report via Gmail, and log results back to Google Sheets. How it works Runs every day at 6 PM on a schedule trigger. Reads rows from three Google Sheets tabs containing trade breaks, failed trades, and exceptions, then merges them into a single dataset. Filters to records with a non-empty Status field and calculates total issues plus resolved vs pending counts. Classifies overall severity (LOW–CRITICAL) and trend (IMPROVING/WORSENING/STABLE) based on pending and resolved counts. Sends the metrics to Google Gemini to generate a formatted Summary and Email body. Posts a high-priority Slack alert when pending issues exceed 5, and then extracts the generated email body. Sends the end-of-day summary via Gmail and appends the date, counts, severity, trend, and summary to a Google Sheets log tab. Setup Connect a Google Sheets OAuth2 account and update the spreadsheet ID and sheet/tab IDs for the three input tabs and the output log tab. Ensure each source sheet includes a Status column with values such as “resolved” so the workflow can compute resolved vs pending. Add a Google Gemini (PaLM) API credential for the AI-generated summary and email text. Add a Slack OAuth2 credential and select the destination channel for high-priority alerts. Add a Gmail OAuth2 credential and set the recipient(s) in the Gmail node so the end-of-day email goes to the right inbox. An n8n automation workflow template by WeblineIndia.
WeblineIndia
web
free
Others in the same category, ranked by how often they are opened.
