Automated Data Analysis from Google Sheets via AI

This n8n workflow automates the process of extracting, transforming, and analyzing transaction data stored in Google Sheets using AI-powered tools. It begins by triggering when a chat message is received, allowing user prompts to define date ranges and status filters for data retrieval. The workflow then intelligently fetches relevant records from Google Sheets, filters transactions by status or date, and transforms complex JSONP data from visualization responses into usable JSON objects with a custom code node. It employs an AI agent equipped with various tools, including language models and calculators, to interpret data and answer analytical questions. The flow also supports nested workflows for advanced data processing. Practical scenarios include generating sales or refund reports, answering specific business inquiries, or maintaining real-time transaction dashboards through AI-assisted insights.