PySheetsQL

pysheetsql is a simple Python library I made to automate logging data to Google Sheets. I have designed the library to perform basic CRUD operations and use it as a small-scale database for static side projects.

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.