Data extraction and analysis from Google Sheets using AI agent

• Extract specific column values from customer data in Google Sheets.
• Retrieve detailed information about individual customers based on queries.
• List available columns in a Google Sheet to understand data structure.
• Facilitate AI-driven interactions for data analysis and reporting.

Triggers when a chat message is received, initiating the AI agent. Sets the Google Sheet URL for data extraction. Fetches the contents of the specified Google Sheet. Checks the operation type to determine the appropriate data retrieval method. Processes the data based on user queries and returns the results.

1. 1
   Import the workflow template into your n8n instance.
2. 2
   Set the Google Sheet URL in the 'Set Google Sheet URL' node.
3. 3
   Configure OpenAI credentials for the AI agent.
4. 4
   Test the workflow by sending a chat message to trigger data extraction.