Hub
Pricing About
Collection

KNIME for Google Users

GoogleGoogle CloudGCPCloudBigquery
+10

Unlock the full potential of your Google footprint with KNIME. From basic storage and file management, scalable cloud databases, to advertisement and web analytics products, the KNIME Google extensions make it very easy to incorporate the power of Google by just adding a few nodes. Keep in mind that executing KNIME workflows connected to Google services may incur Google costs.

KNIME Google Cloud Integration Guide
This guide illustrates how to connect to Google Cloud and how to use the Google extensions.
Aug 26, 2024 1:47 PM
Like

Getting Started with Google Workflows

Utilizing Google product connections within KNIME will always start with user authentication. Once you have authenticated, you can use that output to power the Google connectors.
Node / Source
Google Authenticator

The item generates authentication tokens for accessing Google services. Learn more

Connecting to Data Stored in Google

KNIME supports importing different types of data from multiple different Google products. Depending on the Google product, you can incorporate KNIME frameworks for additional processing.
File Storage with KNIME File Handling
With the KNIME File Handling Framework, you can incorporate files stored in both Google Drive and Google Cloud Storage in your workflows.
KNIME File Handling Guide
Node / Source
Google Drive Connector

Allows downstream nodes to access files in Google Drive for reading, writing, and file system operations using UNIX-like path syntax. Learn more

Node / Source
Google Cloud Storage Connector

The item connects to Google Cloud Storage, allowing downstream nodes to access and manipulate data stored in the cloud as a file system. Learn more

Node / Manipulator
Google Sheets Connector

Connects to Google Sheets using a Google API connection. Learn more

Node / Manipulator
Google Sheets Reader

Reads a tab of a Google spreadsheet from Google Drive. Learn more

Node / Manipulator
Google Sheets Writer

Writes input data table to a new Google Sheets spreadsheet. Learn more

Node / Source
CSV Reader

Reads CSV files and auto-guesses file structure, with options to handle changing schemas and parallel reading. Learn more

Node / Sink
CSV Writer

Writes input data table to a file or remote location in string or numerical format, supporting various file systems. Learn more

Node / Source
Excel Reader

The item reads Excel files and outputs a table with auto-guessed structure and KNIME types. Learn more

Node / Sink
Excel Writer

Writes input data table to an Excel file, creating new or appending to existing spreadsheets in .xls or .xlsx format. Learn more

Node / Source
Table Reader

Reads files written by Table Writer, retains meta information, accesses different file systems. Learn more

Node / Sink
Table Writer

Writes a data table in KNIME's internal format to a file for later reading using the Table Reader node. Learn more

Node / Source
File Reader

Reads common text files, auto-guesses file structure, and supports changing file schemas. Learn more

Node / Source
List Files/Folders

Generates a list of files and/or folders within a selected folder. Learn more

Node / Source
Transfer Files

The item copies or moves files from a source to another folder, with options for single files, folders, and subfolders, including a move operation with source file deletion. Learn more

Node / Source
Transfer Files (Table)

Copies or moves files from a source to another folder based on specified criteria. Learn more

Go to item
Workflow
Read Data from Google Sheets and Google Drive
Google Drive ConnectorGoogle Sheets ReaderFile Reader
+5
This workflow demonstrates how to read data from Google Sheets and data files (Text, Excel and CSV) from Google Drive.
Beginners Space01_Read03_Read_Data_from_Google_Drive
13
knime
Go to item
Workflow
Incremental processing with Parquet files
ParquetIncremental loadingNYC taxi dataset
+3
Processes NYC taxi dataset incrementally, preprocessing and publishing event data as separate Parquet files based on week and yea…
Examples01_Data_Access01_Common_Type_Files12_Incremental_processing_Parquet_file
2
knime
Relational Databases with KNIME’s Database Framework
With KNIME’s Database Framework, you can incorporate database tables stored in Google into your KNIME Workflows. This includes Google database services like BigQuery and Cloud SQL
KNIME Database Extension
Node / Source
Google BigQuery Connector

Establishes a connection to a Google BigQuery server using its JDBC driver. Learn more

Node / Source
DB Connector

Establishes a connection to a JDBC database using driver selection and JDBC URL configuration. Learn more

Node / Source
DB Table Selector

Selects a table or view from a connected database and outputs database connection info and query. Learn more

Node / Manipulator
DB Row Filter

Filters rows from a DB Data table based on specified conditions. Learn more

Node / Source
DB Reader

Executes queries in a database and retrieves results into a KNIME data table, with adjustable fetch size to manage memory consumption. Learn more

Node / Source
DB Query Reader

Executes an entered SQL query and returns the result as KNIME data table. Learn more

Node / Manipulator
DB Joiner

This node joins two DB Data tables. The join is based on the joining columns of both tables. Learn more

Node / Manipulator
DB Concatenate

Concatenates two database tables based on matching column names, handling differing column types and optional handling of columns unique to one table. Learn more

Go to item
Workflow
Database - Simple IO
DatabaseIoSqlite
Executes simple input/output operations on a database using DB Query Reader and DB Writer nodes in a KNIME workflow.
Examples01_Data_Access02_Databases01_Database_Simple_IO_Example
2
knime
Go to item
Workflow
Database - Advanced Usage
DatabaseSqlite
Executes database operations using various database nodes within a KNIME workflow.
Examples01_Data_Access02_Databases02_Database_Advanced_Example
0
knime
Go to item
Workflow
Austin Bike-sharing with Google BigQuery
Google BigQueryDB queryCloud
Blends Austin Bike-sharing data with weather data from Austin and visualizes it on Google BigQuery.
Examples10_Big_Data01_Big_Data_Connectors05_Austin bike sharing with Google BigQuery
0
knime
Go to item
Workflow
Google BigQuery and Amazon Athena
BigQueryAthenaGWAS
Combines data from Google BigQuery and Amazon Athena for Genome Wide Association studies.
Examples01_Data_Access02_Databases12_Google_BigQuery_and_Amazon_Athena_will_they_blend
1
knime

Connecting to Google Analytics

The KNIME Google Connectors extension provides nodes to connect and interact with Google Analytics. Google Analytics is a set of services provided by Google to investigate traffic and activity on a website of your property.
KNIME Google Connectors
Go to item
Workflow
Google Analytics 4 Filter Dimensions
GoogleGoogle AnalyticsFilter Dimension
+1
The workflow showcases Google Analytics 4 capabilities in KNIME for efficient data extraction and filtering.
Examples01_Data_Access05_REST_Web_ServicesGoogle Analytics 4 Filter Dimensions
1
knime
Go to item
Workflow
Google Analytics 4 Blends Local Files
GoogleGoogle AnalyticsData blending
+1
Generates a table from Google Analytics with appended Geo Target information.
Examples01_Data_Access05_REST_Web_ServicesGoogle Analytics 4 Blends Local Files
0
knime
Go to item
Workflow
Google Analytics 4 and Loops
GoogleGoogle AnalyticsLoop
+1
Extracts data from Google Analytics 4 using loops for sampling avoidance and data retrieval beyond row limits.
Examples01_Data_Access05_REST_Web_ServicesGoogle Analytics 4 and Loops
2
knime
Querying Google Analytics in KNIME

Connecting to Google Ads

Learn how to connect to Google Ads and gain customized insights on web advertisements.
Go to item
Extension
KNIME Nodes for Google Ads (Labs)Trusted extension
This feature contains the Google Ads (Labs) nodes.

KNIME AG, Zurich, Switzerland

0
knime
Go to item
Workflow
Google Ads Report
Release 5.3Google AdsQuery
+1
Generates Google Ads report data in Google Sheets for further analysis.
Examples01_Data_Access05_REST_Web_ServicesGoogle Ads Report
2
knime
Go to item
Workflow
Keyword Research with Google Ads Nodes
Release 5.3Google AdsKeyword Research
+1
Conduct keyword research in KNIME using the Google Ads Extension.
Examples01_Data_Access05_REST_Web_ServicesKeyword Research with Google Ads Nodes
1
knime
Go to item
Workflow
Google Ads Assets Creation with Generative AI
Release 5.3Google AdsKeyword Research
+2
Generates Google Ads Headlines using Generative AI.
AI Extension Example Workflows5) Use CasesGoogle Ads Assets Creation with Generative AI
1
knime
Go to item
Workflow
Google Ads Query Explorer
Release 5.3Google AdsGoogle
+1
Generates custom Google Ads queries and displays results in a table view.
Examples01_Data_Access05_REST_Web_ServicesGoogle Ads Query Explorer
0
knime

Leveraging Google Dataproc with KNIME’s Apache Spark Framework

With the KNIME Extension for Apache Spark, KNIME user’s can leverage data from spark clusters created using Google Dataproc into their workflows.
KNIME Google Cloud Integration User Guide
KNIME Extension for Apache Spark
Go to item
Workflow
Working with Google cloud services
GoogleBigqueryCloud storage
+2
Enables connection to Google Cloud Services like BigQuery, Dataproc, and Cloud Storage within KNIME Analytics Platform.
Examples10_Big_Data01_Big_Data_Connectors04_GoogleCloudExample
1
knime

Connecting to Google Cloud in KNIME Python Nodes

Learn how to connect to Google Cloud services using Python in KNIME
Go to item
Collection
Getting started with KNIME's Python integration
PythonPython ScriptPython Integration
+2
Provides an overview of Python script nodes and examples for the KNIME Python integration.
4
knime
Python Cloud Client Libraries (Google Cloud)

KNIME on Google Cloud Marketplace

KNIME provides Google Cloud Marketplace offerings for customer-managed instances of KNIME Business Hub. If you are interested in deployment of KNIME Business Hub via the Google Cloud Marketplace, refer to the following links and documentation. If you need assistance on evaluation of this deployment, please contact KNIME Customer Care using the link below.
KNIME on Google Cloud Marketplace
Contact KNIME Customer Care

Additional Material

A collection of additional resources and materials
Docs: KNIME Google Cloud Integration Guide
Docs: KNIME File Handling Guide
Docs: KNIME Database Extension Guide
Docs: KNIME Big Data Extensions User Guide

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits