AI Chatbot: Query Google Sheets with ChatGPT-5

This n8n workflow builds a conversational AI interface powered by OpenAI's GPT-5 Mini to query and analyze data in Google Sheets. Users can ask natural language questions about their spreadsheets, such as total spend, top campaigns, or month-over-month trends, and receive insightful responses. Key features include smart data analysis that understands column structures, maintains conversation context via a memory buffer, and automatically detects and describes data columns for accurate insights.

Benefits include time-saving automation for data interrogation without SQL or complex formulas, seamless integration between Google Sheets and AI, and scalability for marketing, sales, or any tabular data analysis. It's ideal for teams needing quick insights from spreadsheets, reducing manual reporting efforts.

Use cases: Marketing analytics (e.g., ad spend analysis), sales performance tracking, survey data summarization, or financial reporting. Setup requires OpenAI API key, OAuth-linked Google Sheet with headers in row 1 and data in rows 2-100. Once configured, activate the workflow for instant chat-based data exploration.