Class integrate with google sheets for RPA
Project description
BotSheets
Pacote para integração de RPA com planilhas privadas do google sheets
Instalação:
pip install botsheets
Exemplo de uso:
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()
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
botsheets-0.1.0.tar.gz
(3.9 kB
view details)
File details
Details for the file botsheets-0.1.0.tar.gz.
File metadata
- Download URL: botsheets-0.1.0.tar.gz
- Upload date:
- Size: 3.9 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.0.1 CPython/3.12.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
1586a8c2cee4d6428d3f0d38354886a6b6101b024d64f580dfea4e12a231933e
|
|
| MD5 |
582da64846dbc3771e99de159d33441d
|
|
| BLAKE2b-256 |
f355dc0f86b1ca70e2c25282376a9a36364f2689a466d6281700a9d20d06ba8b
|
