Automated SQL Query Execution from User Input to BigQuery

• Automate SQL query execution for supply chain analytics.
• Enhance user interaction with AI-powered chat for data insights.
• Retrieve structured data from BigQuery based on user requests.

User initiates a chat to request data insights. AI agent processes the request and generates an SQL query. Query is sanitized to ensure proper formatting. The sanitized query is executed in BigQuery. Results are returned and presented to the user in a structured format.

1. 1
   Import the workflow template into n8n.
2. 2
   Configure the OpenAI chat model with your credentials.
3. 3
   Set up the BigQuery node with your project details.
4. 4
   Test the workflow by initiating a chat and requesting data.