Metadata-Version: 2.1
Name: gsheets-db-connector
Version: 0.4.0
Summary: Connects Google sheets to a database connector to transfer information to and fro.
Home-page: https://github.com/fylein/gsheets-db-connector
Author: Shwetabh Kumar
Author-email: shwetabh.kumar@fyle.in
License: MIT
Keywords: fyle,db,python,sdk,sqlite
Platform: UNKNOWN
Classifier: Topic :: Internet :: WWW/HTTP
Classifier: Intended Audience :: Developers
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Description-Content-Type: text/markdown
Requires-Dist: logger (==1.4)
Requires-Dist: pandas (==0.25.2)
Requires-Dist: typing (==3.7.4.1)
Requires-Dist: gspread (==3.1.0)
Requires-Dist: google-api-python-client (==1.6.7)

# Google Sheets Connector
Connects Google sheets to a database to transfer information to and fro. [Fyle](https://www.fylehq.com/) is an expense management system.

## Installation

This project requires [Python 3+](https://www.python.org/downloads/).

1. Download this project and use it (copy it in your project, etc).
2. Install it from [pip](https://pypi.org).

        $ pip install gsheets-db-connector

## Usage

This connector is very easy to use.

First you'll need to create a connection using the main class FyleSDK.
```python
from gsheets_db_connector import GoogleSheetsConnector

config = {
    'gsheets_credentials': '<Credentials>',
    'sheet_name': '<Sheet Name>'
}
gsheets_connector = GoogleSheetsConnector(config, database_connection)
```
After that you'll be able to extract/load data
```python
gsheets_connector.extract_data()
```

## Contribute

To contribute to this project follow the steps

* Fork and clone the repository.
* Run `pip install -r requirements.txt`
* Setup pylint precommit hook
    * Create a file `.git/hooks/pre-commit`
    * Copy and paste the following lines in the file - 
        ```bash
        #!/usr/bin/env bash 
        git-pylint-commit-hook
        ```
     * Run `chmod +x .git/hooks/pre-commit`
## License

This project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details


