Skip to main content

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()

Metadata

Release files for botsheets 0.1.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for botsheets 0.1.1
File Size Uploaded
botsheets-0.1.1.tar.gz 3.9 kB Details

Release files / botsheets-0.1.1.tar.gz

Download URL botsheets-0.1.1.tar.gz
Size 3.9 kB
Tags Source
SHA-256 checksum
How to use checksums
411751137ede87ca5a12fee02700ea2873bb75bcc974f5f44fef85306089d804
BLAKE2b-256 checksum
How to use checksums
d88c2c87881b1e84b6f1783873eec704f551c15176329a636a6dce0b4969c2b6
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.0.1 CPython/3.12.2

Release history Release notifications | RSS feed

This release

0.1.1 This release

1 release file

0.1.0

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page