Connecting to Google Sheets

For information on the available WHL files for supported environments, and how to install the appropriate file for your Python distribution, see Package Installation.

For information on the module to import, and how to configure the necessary connection properties in a connection string, see Establishing a Connection.

Other available connection properties can be used to configure other aspects of the connector capabilities.

Python Version Support

The CData Python Connector for Google Sheets can be installed and used in Python 3.10 or newer.

Google Sheets Version Support

The connector leverages two APIs: the Google Sheets API v4 for reading and writing spreadsheet cell data, and the Google Drive API v3 for file-level operations such as listing, uploading, downloading, and deleting files, moving files to the trash, and managing sharing and visibility.

See Also

• Using the Connector: Establish connections and query Google Sheets through Python code.
• From SQLAlchemy: Use SQLAlchemy to establish a connection with dialect URL, and interact with Google Sheets data using mapped classes and Sessions.