Data extraction and analysis from Google Sheets using AI agents

• Retrieve specific customer data from Google Sheets using AI queries.
• List available columns in a Google Sheet for better data understanding.
• Fetch values from specific columns to analyze customer trends.

Triggers an AI agent to process user queries. Sets the Google Sheet URL for data retrieval. Fetches the contents of the specified Google Sheet. Checks the type of operation requested (e.g., row, column names, or values). Prepares and formats the output data for user interaction.

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
   Test the workflow by triggering the 'Chat Trigger' node.