pysheetsql 1.0.0

A package for managing Google Sheets data with gspread

PySheetsQL

pysheetsql is a Python package designed to simplify the management of Google Sheets data using the gspread library. With this package, you can effortlessly create, update, retrieve, delete, and export Google Sheets data.

Installation

To install pysheetsql, use pip:

pip install pysheetsql

Getting Started

Google API Credentials

To use pysheetsql, you need to obtain Google Sheets API credentials. Follow these steps to get your credentials.json file:

1. Create a Google Cloud Project:

   • Visit the Google Cloud Console.
   • Click on "Select a project" and then "New Project".
   • Enter a project name and click "Create".

2. Enable APIs:

   • Navigate to the API Library.
   • Search for and enable the Google Sheets API.
   • Also, enable the Google Docs API.

3. Create Credentials:

   • Go to the Credentials page.
   • Click on "Create Credentials" and select "Service account".
   • Follow the prompts to set up the service account.
   • After creating the service account, click "Create Key" and choose JSON format. This will download your credentials.json file.

Setup

To interact with Google Sheets using pysheetsql:

from pysheetsql.start import SheetClient

client = SheetClient(
    scopes=["https://www.googleapis.com/auth/spreadsheets"],
    credentials_file_path="path/to/credentials.json"
)

Replace path/to/credentials.json with the actual path to your downloaded credentials.json file.

For more usage information, visit the PySheetsQL Documentation.