Google Sheets Connector

Read, write and update Google Sheets

Read, write and update Google Sheets through easy-to-use bi-directional drivers. Integrate with BI, Reporting, Analytics, ETL Tools and Custom Solutions. This one Qlik Google Spreadsheets Connector is part of CData ODBC Drivers. These connectors allow users to easily read and edit application, database and web API data. This connector is also suitable for both Qlik Sense like QlikView, but can also be used for other tools, such as our data warehouse solution TimeXtender and other BI tools, such as PowerBI In Excel.

Overview

The CData ODBC driver for Google Sheets is a standard ODBC driver with editions for Windows and Unix-based operating systems, such as Mac OS X and Linux. The driver models tables from Google Sheets in your Google account or in your Google Apps domain. The driver uses the Google Drive API to enable bi-directional access to Google Sheets. You must enable this API by creating a project in the Google Developers Console. For a guide to creating a project and using the OAuth standard to authenticate this API, see Using OAuth.