gs-update-utils 1.0.4

Utilities for working with Google Sheets: establishing a connection, reading data from a sheet, and uploading a DataFrame to Google Sheets with retry support.

English:

Google Sheets Utils Module

The module provides convenient utilities for working with Google Sheets. Features include establishing a connection to the Google Sheets API, reading data from a sheet, and uploading a DataFrame to Google Sheets with retry support.

Installation

bashCopy code
pip install gs-update-utils

Usage

Establishing a Connection

pythonCopy code
from gs-update-utils import setup_google_sheets
credentials_folder = "path/to/credentials"
credentials_file = "credentials.json"
google_credentials = setup_google_sheets(credentials_folder, credentials_file)

Reading Data from a Sheet

pythonCopy code
from gs-update-utils import read_gs_table
worksheet_id = "your_worksheet_id"
worksheet_name = "your_worksheet_name"
dataframe = read_gs_table(worksheet_id, worksheet_name, google_credentials)

Uploading DataFrame to Google Sheets

pythonCopy code
from gs-update-utils import upload_table_to_google_sheet

worksheet_id = "your_worksheet_id"
worksheet_name = "your_worksheet_name"
upload_table_to_google_sheet(dataframe, worksheet_id, worksheet_name, google_credentials)

Русский:

Модуль Google Sheets Utils

Модуль предоставляет удобные утилиты для работы с Google Sheets. Возможности включают установку соединения с API Google Sheets, чтение данных из листа и загрузку DataFrame в Google Sheets с поддержкой повторных попыток.

Установка

bashCopy code
pip install gs-update-utils

Использование

Установка соединения

pythonCopy code
from gs-update-utils import setup_google_sheets
credentials_folder = "path/to/credentials"
credentials_file = "credentials.json"
google_credentials = setup_google_sheets(credentials_folder, credentials_file)

Чтение данных из листа

pythonCopy code
from gs-update-utils import read_gs_table

worksheet_id = "your_worksheet_id"
worksheet_name = "your_worksheet_name"
dataframe = read_gs_table(worksheet_id, worksheet_name, google_credentials)

Загрузка DataFrame в Google Sheets

pythonCopy code
from gs-update-utils import upload_table_to_google_sheet

worksheet_id = "your_worksheet_id"
worksheet_name = "your_worksheet_name"
upload_table_to_google_sheet(dataframe, worksheet_id, worksheet_name, google_credentials)