See llms.txt for all machine-readable content.

Google BigQuery and Samsung SmartThings integration

Save yourself the work of writing custom integrations for Google BigQuery and Samsung SmartThings 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.

How to connect Google BigQuery and Samsung SmartThings

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.

Google BigQuery and Samsung SmartThings integration: Create a new workflow and add the first step

Weekly ETL pipeline: QuickBooks financial data to Google BigQuery

Quick overview This template sets up a weekly ETL (Extract, Transform, Load) pipeline that pulls financial data from QuickBooks Online into Google BigQuery. It not only transfers data, but also cleans, classifies, and enriches each transaction using your own business logic. How it works Every Monday, the workflow automatically fetches all transactions from the previous week directly from your QuickBooks Online account. Custom business logic cleans up text fields, generates stable transaction IDs, and classifies each transaction as income, expense, or internal transfer. The cleaned and enriched data is prepared as a bulk-insert-ready SQL statement formatted for BigQuery compatibility. The structured SQL statement is executed and all transaction records are inserted into your designated Google BigQuery table. Setup Create a BigQuery dataset (e.g., quickbooks) and table (e.g., transactions) — ensure the table schema exactly matches the SQL query inside the Load Data to BigQuery node. Add your QuickBooks Online and Google BigQuery credentials in the n8n Credential Manager before configuring any other nodes. Open the Clean & Classify Transactions node and update the internalTransferAccounts, expenseCategories, and incomeCategories JavaScript arrays to match your QuickBooks Chart of Accounts exactly. Open the Load Data to BigQuery node, select the correct Google Cloud project, and verify the SQL query references the correct dataset and table name. Save and activate the workflow — it will now run automatically every Monday and load the previous week's transactions into BigQuery. Requirements A running n8n instance (Cloud or Self-Hosted) A QuickBooks Online account A Google Cloud Platform project with BigQuery enabled A BigQuery table with a matching schema Customization Change Schedule: Modify the schedule node to run daily, monthly, or at a different time Adjust Date Range: Change the date macro in the Get Last Week's Transactions node Refine Classification Rules: Add custom logic in the Clean & Classify Transactions node to handle specific edge cases Additional info Published by Fahmi Fahreza, Indonesia’s first official n8n Brand Ambassador and founder of WithMi Automation, built from real client implementations, not tutorials. → Let us build it for you: withmiautomation.com → Learn to build it yourself: academy.withmiautomation.com → Bring Fahmi to your team (training, workshop, talkshow): fahmiiireza.com

Popular ways to use the Google BigQuery and Samsung SmartThings integration

Build your own Google BigQuery and Samsung SmartThings integration

Create custom Google BigQuery and Samsung SmartThings workflows 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

Supported methods for Samsung SmartThings

Delete
Get
Head
Options
Patch
Post
Put

To set up Samsung SmartThings integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Samsung SmartThings to query the data you need using the API endpoint URLs you provide.

See the example here

Requires additional credentials set up

Use n8n's HTTP Request node with a predefined or generic credential type to make custom API calls.

Google BigQuery and Samsung SmartThings integration details

Google BigQuery

Google BigQuery

Many businesses use the Google Cloud service BigQuery for data reporting. BigQuery is categorized as an Advanced Data Connector. The amount of data that needs to be processed could be quite large (up to 10,000 columns and tens of millions of rows).

Samsung SmartThings

Samsung SmartThings

SmartThings is a versatile and intelligent platform that connects and automates various smart devices in your home or office. It enables users to conveniently control and monitor everything from lights and thermostats to security systems and appliances through a single interface.

Other integrations with Google BigQuery and Samsung SmartThings

Save engineering resources

Reduce time spent on customer integrations, engineer faster POCs, keep your customer-specific functionality separate from product all without having to code.

Learn more

FAQ about Google BigQuery integrations

Looking to integrate Slack and VirusTotal in your company?

Three colleagues talking around laptops at a shared desk

Trusted by teams building smarter workflows.

Why

Why use n8n to integrate Google BigQuery with Samsung SmartThings

Handle branching, merging and iteration easily. Pause your workflow to wait for external events.

Re-run single steps to test changes in no time. And pin your data to avoid generating trigger events every time you execute.

Your data is displayed alongside your settings, making edge cases easy to track down.

Use 1000+ workflow templates available from our core team and our community.

Copy and paste, easily import and export workflows.

Simple enough to 
understand + sophisticated 
enough to ship

Man in a brown jacket working at his desk by a window