From SQLAlchemy
The CData Python Connector for Google Sheets includes a Dialect class that enables integration with SQLAlchemy. Bear in mind that several aspects of connector functionality are not currently supported in SQLAlchemy 2.0 or above. If necessary, downgrade SQLAlchemy to version 1.4 or 1.3 before using this connector.
The following sections detail various aspects of this integration:
Connecting From SQLAlchemy
To construct a URL with which SQLAlchemy loads and uses the appropriate connector automatically, see Connecting
Reflecting Metadata With SQLAlchemy
To learn how to model Google Sheets tables with mapped classes, see Reflecting Metadata.
Querying Data From SQLAlchemy
To learn how to use mapped classes to query the associated tables, see Querying Data.