Back to integrations
Google BigQuery and Home Assistant connection
Save yourself the work of writing custom integrations for Google BigQuery and Home Assistant and use n8n instead. Build adaptable and scalable Data & Storage, Development, workflows that work with your technology stack. All within a building experience you will love.
Ways to connect Google BigQuery and Home Assistant
Create a new workflow and add the first step
In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Create your own Google BigQuery and Home Assistant connection
Create custom Google BigQuery + Home Assistant automations by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
Google BigQuery supported actions
Execute Query
Execute a SQL query
Insert
Insert rows in a table
Home Assistant supported actions
Get Screenshot
Get the camera screenshot
Get
Get the configuration
Check Configuration
Check the configuration
Create
Create an event
Get Many
Get many events
Get Error Logs
Get a log for a specific entity
Get Logbook Entries
Get all logs
Call
Call a service within a specific domain
Get Many
Get many services
Create or Update
Create a new record, or update the current one if it already exists (upsert)
Get
Get a state for a specific entity
Get Many
Get many states
Create
Create a template
Google BigQuery and Home Assistant connection details
Other integrations with Google BigQuery
Other integrations with Home Assistant
FAQs
FAQ
Can Google BigQuery work together with Home Assistant in n8n Lab?
Can I use Google BigQuery’s API with n8n Lab?
Can I use Home Assistant’s API with n8n Lab?
Is n8n Lab a secure option for connecting Google BigQuery with Home Assistant?
How do I start building Google BigQuery + Home Assistant automation in n8n Lab?
A widely adopted workflow orchestration workspace trusted by technical teams including
Why use n8n to connect Google BigQuery with Home Assistant
Build complex workflows, really fast
