airbytehq / airbytehq/PyAirbyte

# Issue: Google Sheets connector fails with "Could not load module `source_google_sheets.components.partition_routers`"

Open
#662 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
344
Forks
77
Avg merge
1d 11h
Merged PRs (30d)
35

Description

## Environment
- PyAirbyte version: 0.24.2
- Python version: 3.11.5
- OS: macOS
- Installation method: pip install

## Description
When trying to use the Google Sheets connector (`source-google-sheets`), it consistently fails with a module loading error. The connection check and all subsequent operations fail with the same error.

## Steps to Reproduce
1. Install PyAirbyte
2. Create a script to connect to Google Sheets:
```python
import airbyte as ab

source = ab.get_source(
name="source-google-sheets",
config={
"spreadsheet_id": "spreadhseet ID",
"credentials": {
"auth_type": "Client",
"client_id": "CLIENT_ID",
"client_secret": "CLIENT_SECRET",
"refresh_token": "REFRESH_TOKEN"
}
}
)

source.check() # Fails here
```
3. Run the script

## Error Message
```
ValueError: Could not load module `source_google_sheets.components.partition_routers`.
```

## Full Error Trace
```
Traceback (most recent call last):
File "[...]/airbyte_cdk/sources/declarative/parsers/model_to_component_factory.py", line 1503, in create_custom_component
custom_component_class = self._get_class_from_fully_qualified_class_name(model.class_name)
File "[...]/airbyte_cdk/sources/declarative/parsers/model_to_component_factory.py", line 1592, in _get_class_from_fully_qualified_class_name
raise ValueError(f"Could not load module `{module_name_full}`.")
ValueError: Could not load module `source_google_sheets.components.partition_routers`.
```

## Steps Already Taken
1. Tried using standard connector installation with no local path specified
2. Generated a new OAuth refresh token to ensure credentials were valid
3. Tried clearing the virtual environment (`.venv-source-google-sheets`)
4. Verified that `source-google-sheets` is listed in `ab.get_available_connectors()`

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.