This release is a pre-release and may not be stable for production use.
Google-Sheets source connector
This is the repository for the Google-Sheets source connector, written in Python. For information about how to use this connector within Airbyte, see the documentation.
Local development
Prerequisites
- Python (~=3.9)
- Poetry (~=1.7) - installation instructions here
Installing the connector
From this connector directory, run:
poetry install --with dev
Create credentials
If you are a community contributor, follow the instructions in the documentation
to generate the necessary credentials. Then create a file secrets/config.json conforming to the source_google_sheets/spec.yaml file.
Note that any directory named secrets is gitignored across the entire Airbyte repo, so there is no danger of accidentally checking in sensitive information.
See sample_files/sample_config.json for a sample config file.
Locally running the connector
poetry run source-google-sheets spec
poetry run source-google-sheets check --config secrets/config.json
poetry run source-google-sheets discover --config secrets/config.json
poetry run source-google-sheets read --config secrets/config.json --catalog sample_files/configured_catalog.json
Running unit tests
To run unit tests locally, from the connector directory run:
poetry run pytest unit_tests
Building the docker image
- Install
airbyte-ci - Run the following command to build the docker image:
airbyte-ci connectors --name=source-google-sheets build
An image will be available on your host with the tag airbyte/source-google-sheets:dev.
Running as a docker container
Then run any of the connector commands as follows:
docker run --rm airbyte/source-google-sheets:dev spec
docker run --rm -v $(pwd)/secrets:/secrets airbyte/source-google-sheets:dev check --config /secrets/config.json
docker run --rm -v $(pwd)/secrets:/secrets airbyte/source-google-sheets:dev discover --config /secrets/config.json
docker run --rm -v $(pwd)/secrets:/secrets -v $(pwd)/integration_tests:/integration_tests airbyte/source-google-sheets:dev read --config /secrets/config.json --catalog /integration_tests/configured_catalog.json
Running our CI test suite
You can run our full test suite locally using airbyte-ci:
airbyte-ci connectors --name=source-google-sheets test
Customizing acceptance Tests
Customize acceptance-test-config.yml file to configure acceptance tests. See Connector Acceptance Tests for more information.
If your connector requires to create or destroy resources for use during acceptance tests create fixtures for it and place them inside integration_tests/acceptance.py.
Dependency Management
All of your dependencies should be managed via Poetry. To add a new dependency, run:
poetry add <package-name>
Please commit the changes to pyproject.toml and poetry.lock files.
Publishing a new version of the connector
You've checked out the repo, implemented a million dollar feature, and you're ready to share your changes with the world. Now what?
- Make sure your changes are passing our test suite:
airbyte-ci connectors --name=source-google-sheets test - Bump the connector version (please follow semantic versioning for connectors):
- bump the
dockerImageTagvalue in inmetadata.yaml - bump the
versionvalue inpyproject.toml
- bump the
- Make sure the
metadata.yamlcontent is up to date. - Make sure the connector documentation and its changelog is up to date (
docs/integrations/sources/google-sheets.md). - Create a Pull Request: use our PR naming conventions.
- Pat yourself on the back for being an awesome contributor.
- Someone from Airbyte will take a look at your PR and iterate with you to merge it into master.
- Once your PR is merged, the new version of the connector will be automatically published to Docker Hub and our connector registry.
1 maintainer
Release files for airbyte-source-google-sheets 0.10.0.dev202505231635
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| airbyte_source_google_sheets-0.10.0.dev202505231635.tar.gz | 14.1 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| airbyte_source_google_sheets-0.10.0.dev202505231635-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 31.3 kB
Release files / airbyte_source_google_sheets-0.10.0.dev202505231635.tar.gz
| Download URL | airbyte_source_google_sheets-0.10.0.dev202505231635.tar.gz |
|---|---|
| Size | 14.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
4e67e72a47e22238bdd49f4f1dc6d35770a3e78e0eb96a84e2d642bcffb4ae3d
|
|
BLAKE2b-256 checksum How to use checksums |
38d74a2e8010d9dfa16c5f73caf06c05ec3bf5edc7ce5a941a7951351906c566
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/2.1.3 CPython/3.11.12 Linux/6.11.0-1014-azure
|
Release files / airbyte_source_google_sheets-0.10.0.dev202505231635-py3-none-any.whl
| Download URL | airbyte_source_google_sheets-0.10.0.dev202505231635-py3-none-any.whl |
|---|---|
| Size | 17.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
e94a071460a7b447da429f0e6df9c5f883a2ddd5009d5c8b0b680a7e6da171fc
|
|
BLAKE2b-256 checksum How to use checksums |
a16b1003d6d0efaabaf2a9b756545baafbe01aa52b2db8a3dd0dc1b4d0a4dfb3
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/2.1.3 CPython/3.11.12 Linux/6.11.0-1014-azure
|
