Automated Data Query and Summarization for Google Sheets

This n8n workflow automates data retrieval from a Google Sheets document, processes the data to generate various summaries, and uses a language model to generate a structured report or table. The workflow starts with a trigger that executes when invoked by another workflow. It retrieves data from a specified Google Sheets spreadsheet, then dynamically analyzes the columns and applies different aggregation functions such as sum, average, min, max, and count. Intelligent nodes use AI models, including Google Gemini, to interpret and format the summarized data into readable outputs, suitable for reporting or decision-making. Practical use cases include automated data reporting, KPI dashboards, or providing insights directly within WordPress or other platforms that integrate n8n workflows, reducing manual effort and providing real-time data analysis.