botsheets

Name	botsheets JSON
Version	0.1.1 JSON
	download
home_page	https://github.com/botlorien/botsheets
Summary	Class integrate with google sheets for RPA
upload_time	2025-01-22 16:41:23
maintainer	None
docs_url	None
author	Ben-Hur P. B. Santos
requires_python	>=3.10
license	None
keywords
VCS
bugtrack_url
requirements	No requirements were recorded.
Travis-CI	No Travis.
coveralls test coverage	No coveralls.

            # BotSheets

Pacote para integração de RPA com planilhas privadas do google sheets

## Instalação:
 ```bash
 pip install botsheets
 ```

## Exemplo de uso:
```python
from botsheets import Gsheets
url_sheet = 'https://docs.google.com/spreadsheets/d/<sheetid>/...'
gsh = Gsheets()
# Na variavel ambiente solicitada no terminal informe o caminho do arquivo json com as credenciais de acesso obtida no google console
gsh.login()
gsh.acess_spreadsheet(url_sheet)
gsh.set_sheet_name('Página1')
print(gsh.get_all_records())
gsh.set_sheet_name('Página2')
print(gsh.get_all_records())
gsh.clear_sheet()
```

            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/botlorien/botsheets",
    "name": "botsheets",
    "maintainer": null,
    "docs_url": null,
    "requires_python": ">=3.10",
    "maintainer_email": null,
    "keywords": null,
    "author": "Ben-Hur P. B. Santos",
    "author_email": "botlorien@gmail.com",
    "download_url": "https://files.pythonhosted.org/packages/d8/8c/2c87881b1e84b6f1783873eec704f551c15176329a636a6dce0b4969c2b6/botsheets-0.1.1.tar.gz",
    "platform": null,
    "description": "# BotSheets\r\n\r\nPacote para integra\u00e7\u00e3o de RPA com planilhas privadas do google sheets\r\n\r\n## Instala\u00e7\u00e3o:\r\n ```bash\r\n pip install botsheets\r\n ```\r\n\r\n## Exemplo de uso:\r\n```python\r\nfrom botsheets import Gsheets\r\nurl_sheet = 'https://docs.google.com/spreadsheets/d/<sheetid>/...'\r\ngsh = Gsheets()\r\n# Na variavel ambiente solicitada no terminal informe o caminho do arquivo json com as credenciais de acesso obtida no google console\r\ngsh.login()\r\ngsh.acess_spreadsheet(url_sheet)\r\ngsh.set_sheet_name('P\u00e1gina1')\r\nprint(gsh.get_all_records())\r\ngsh.set_sheet_name('P\u00e1gina2')\r\nprint(gsh.get_all_records())\r\ngsh.clear_sheet()\r\n```\r\n",
    "bugtrack_url": null,
    "license": null,
    "summary": "Class integrate with google sheets for RPA",
    "version": "0.1.1",
    "project_urls": {
        "Homepage": "https://github.com/botlorien/botsheets"
    },
    "split_keywords": [],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "d88c2c87881b1e84b6f1783873eec704f551c15176329a636a6dce0b4969c2b6",
                "md5": "489dc1d87cfb9b35f9e0946c37b63342",
                "sha256": "411751137ede87ca5a12fee02700ea2873bb75bcc974f5f44fef85306089d804"
            },
            "downloads": -1,
            "filename": "botsheets-0.1.1.tar.gz",
            "has_sig": false,
            "md5_digest": "489dc1d87cfb9b35f9e0946c37b63342",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.10",
            "size": 3934,
            "upload_time": "2025-01-22T16:41:23",
            "upload_time_iso_8601": "2025-01-22T16:41:23.080605Z",
            "url": "https://files.pythonhosted.org/packages/d8/8c/2c87881b1e84b6f1783873eec704f551c15176329a636a6dce0b4969c2b6/botsheets-0.1.1.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2025-01-22 16:41:23",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "botlorien",
    "github_project": "botsheets",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": false,
    "lcname": "botsheets"
}