AI Agents
Query BigQuery and publish insights to X with AI analysis
12 nodes
224
123
Automatic trigger
Workflow Description
An intelligent agent receives questions via chat or X, executes queries on BigQuery, analyzes results using OpenAI, and posts findings to Twitter. The agent maintains conversation context and memory across interactions.
How it works
- 1.Receive user question through chat trigger or Twitter mention
- 2.Execute SQL query against your BigQuery dataset
- 3.Process and analyze results with OpenAI language model
- 4.Post summary and insights to X/Twitter automatically
Use cases
- Publish automated daily data reports to Twitter
- Provide instant answers to analyst questions about your data
- Share business insights extracted from large datasets in real-time
Requirements
- Google Cloud account with BigQuery enabled and accessible datasets
- OpenAI API key for advanced data analysis and summarization
- X/Twitter account credentials for automated posting
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
OpenAI
AI Agent
Tool
Google Big Query
Twitter/X
Memory
Chat Trigger
Details
Trigger
Automatic trigger
Nodes
12
Apps
7
Views
224
Downloads
123
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (12)
/
OpenAI Chat Model
OpenAI
AI Control Tower Agent
Agent
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Call Query Tool
Tool Workflow
Sticky Note
Sticky Note
Query Database
Google Big Query
Trigger Executed by the AI Tool
Execute Workflow Trigger
Sanitising the Query
Code
Chat Memory
Memory Buffer Window
Chat with the User
Chat Trigger
Sticky Note3
Sticky Note