Metadata-Version: 2.1
Name: google-sheets-tools
Version: 0.0.2
Summary: The package is used for work with the Google Sheet spreadsheets using their URL.
Author: Bohdan Salamakha
Author-email: allen.avanheim@gmail.com
Requires-Python: >=3.10,<4.0
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.10
Requires-Dist: bs4 (>=0.0.1,<0.0.2)
Requires-Dist: requests (>=2.28.1,<3.0.0)
Description-Content-Type: text/markdown

A package for downloading data from Google Sheets with spreadsheet URL.

pip install google-sheets-tools - install the module

import google_sheets_tools - import the module to your project

--------------------------
class SheetsDownloader:
--------------------------
obj = SheetsDownloader(sheet_url, extension='csv') - create a constructor

- sheet_url - url of the Google sheet
- extension - extension of the downloaded file ('xlsx', 'ods', 'pdf', 'html', 'csv', 'tsv')

obj.download_file(folder_name='sheets') - download a sheet

- folder_name - to what folder download a spreadsheet; default value='sheets'

get_downloaded_file_name() - get a name of your downloaded spreadsheet

get_extension() - get the extension constructor works with

--------------------------
class CsvParser:
--------------------------
download_csv_sheet(path='csv_files') - download the spreadsheet as a csv file

- path - path to downloaded spreadsheet, can be structural '1\2\3'; default value='csv_files'

get_csv_data(sheet_type='list') - returns a data from the csv file

- sheet_type - type of the returned data, can be ('list', 'json'); default value='list'

