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
- OpenAI Chat Model
- AI Control Tower Agent
- Call Query Tool
- Query Database
- Trigger Executed by the AI Tool
- Sanitising the Query
- Chat Memory
- Chat with the User
- Error Handler for 53b36910
- Error Handler for bede0624
- Error Handler
Similar automations
AI Agents & AssistantsSupply Chain Control Tower Agent with BigQuery and GPT8 stepsData Sync & ETLRoute scored GTM signals from BigQuery to HubSpot with Telegram and Google Sheets14 stepsAI Agents & AssistantsChat with Your SEO Data in BigQuery Using OpenAI6 stepsReports, Analytics & DashboardsCreate Data-Driven SEO Reports from Articles with BigQuery23 steps