Get quick answers from your customer sheet using a chat interface. Sales and account teams can ask simple questions like which customer is the largest and get instant replies without opening spreadsheets.

A chat message starts the flow. An AI agent powered by OpenAI reads your request and uses three custom tools to pull only the data it needs from Google Sheets. One tool lists all column names, one gets values for a specific column across all customers, and one returns the full record for a single customer. A sub workflow handles the sheet read, routes by the requested operation, prepares clean output, and keeps the model from loading the entire sheet. Memory keeps context across messages so follow up questions make sense.

To set it up, connect your OpenAI account and a Google Sheets account that can access your data. Paste your sheet link into the configuration and verify the sheet has clear headers. Expect faster responses, less manual digging, and fewer copy paste mistakes. Great for account reviews, quick pipeline checks, and daily standups where you need fast facts from your customer data.

• Chat trigger starts a conversation and captures each user question
• OpenAI Chat Model with simple memory for context across follow up messages
• AI agent uses three custom tools to explore the sheet safely
• List columns tool reveals all available fields before running a query
• Get column values tool returns one column for all customers with a row number for reference
• Get customer tool fetches a full record by row number for deep dives
• Sub workflow reads Google Sheets, routes by operation, filters, and formats output
• Set and Code nodes shape the final response so results are clean and easy to read

• Reduce manual lookups from 30 minutes to 2 minutes for common customer questions
• Automate up to 80 percent of routine data checks for sales and account teams
• Improve accuracy by cutting copy paste errors across reports
• Handle large sheets by fetching only the fields needed for each question
• Unify chat and data so teams get answers without switching tools

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create an OpenAI API Key credential. Copy your API key from your OpenAI account and paste it into the key field. Name the credential clearly, such as OpenAI Prod.
4. In the n8n credentials manager, create a Google Sheets OAuth2 credential. Follow the on screen steps to grant access to the Google account that owns or can view the target sheet. Name it clearly, such as Google Sheets Sales.
5. Open the OpenAI Chat Model node. Select your OpenAI credential and confirm the model is set to gpt 4o mini. Adjust temperature only if you want more or less creative answers.
6. Open the Set Google Sheet URL node. Replace the sheetUrl value with the link to your spreadsheet. Make sure the first row has clear column headers and the Google account you connected can access the file.
7. Open the Get Google sheet contents node. Select your Google Sheets credential. Choose the spreadsheet and sheet tab to read. Use read only mode and confirm the range includes your header row.
8. Test the sub workflow. Manually execute the When Executed by Another Workflow node with operation set to column_names and query set to none. Confirm you see a list of headers in the output.
9. Start the chat interface from the When chat message received trigger. Click Chat and ask a question such as Which is our biggest customer. Watch the execution to see which tools are called and review the result.
10. Troubleshoot common issues. If results are empty, check header names and that the sheet is shared with the connected Google account. If the agent cannot answer, verify tool names and that the operation values match column_names, column_values, or row. If responses are slow, reduce sheet size or limit ranges in the Google Sheets node.