airbytehq / airbytehq/PyAirbyte
# Issue: Google Sheets connector fails with "Could not load module `source_google_sheets.components.partition_routers`"
- 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
Assessment
This issue has not been assessed yet.