Skip to content
NEWError doctor and Watchtower: failed n8n runs explained in plain words, and emailed to you. See what is new

Library / AI Agents & Assistants

AI Agents & Assistants

Query BigQuery with an OpenAI Control Tower Agent

When called by another workflow, an OpenAI agent sanitizes questions and runs read-only queries on BigQuery to answer data requests.

What it does

# Lmchatopenai Workflow ## Overview Automated workflow: Lmchatopenai Workflow. This workflow integrates 10 different services: stickyNote, code, agent, stopAndError, lmChatOpenAi. It contains 14 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 14 - Node Types: 10 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - OpenAI Chat Model: lmChatOpenAi - AI Control Tower Agent: agent - Sticky Note1: stickyNote - Sticky Note2: stickyNote - Call Query Tool: toolWorkflow - Sticky Note: stickyNote - Query Database: googleBigQuery - Trigger Executed by the AI Tool: executeWorkflowTrigger - Sanitising the Query: code - Chat Memory: memoryBufferWindow - ... and 4 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible

The steps

  1. OpenAI Chat Model
  2. AI Control Tower Agent
  3. Call Query Tool
  4. Query Database
  5. Trigger Executed by the AI Tool
  6. Sanitising the Query
  7. Chat Memory
  8. Chat with the User
  9. Error Handler for 53b36910
  10. Error Handler for bede0624
  11. Error Handler

Similar automations