AI-powered SQL query execution in BigQuery from user chat input

• Execute SQL queries based on user requests in a chat interface.
• Retrieve and present structured data from BigQuery for supply chain analysis.
• Automate data insights generation for operational decision-making.

User initiates a chat with the AI agent. AI agent interprets the user's request and formulates an SQL query. Query is sanitized to ensure accuracy and security. The sanitized query is executed in BigQuery to fetch results. Results are returned to the user in a structured format.

1. 1
   Import the workflow template into n8n.
2. 2
   Configure the OpenAI chat model with necessary credentials.
3. 3
   Set up the BigQuery integration with your project details.
4. 4
   Test the chat interface to ensure proper interaction with the AI agent.