Skip to main content

Fetch all sheets of data from Google Spreadsheet Excel without auth/ password.

Project description

Googlexcel_noPassword

_____________________________________________

The First package built to easily obtain the data within an entire shared Google Spreadsheet without passing Google username/ password, credentials.json or OTP authentication.


Instructions.

To install the package, perform:

pip install Googlexcel-noPassword

How to use the methods:

1. To obtain the list of sheetnames:

#Importing Library.
import Googlexcel-noPassword as ggx

#url_GoogleSheets = The shared url of Google Spreadsheet document. (Ensure that the privilege is set to 'Anyone with the link'.)
list_ofSheetnames = ggx.fetch_sheetnameslist(url_GoogleSheets)

2. To obtain the dictionary with 'Key' = Sheetname and 'Value' = DataFrame:

#Returns a dictionary with all the sheetnames and their respective data as dataframe.
dict_Dataframes = ggx.data_fromAllSheets(url_GoogleSheets)

3. To obtain a single dataframe from one sheet.

#Returns a dataframe for the data in one sheet.
df_sheetname = ggx.data_OneSheet(url_GoogleSheets, sheet_name)

Have fun with what is possibly the first library to bypass the credentials.json and the username/ password restrictions to fetch the entire Google Spreadsheet excel document.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

Googlexcel_noPassword-1.11.tar.gz (16.3 kB view hashes)

Uploaded Source

Built Distribution

Googlexcel_noPassword-1.11-py3-none-any.whl (16.1 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page