04‐API

Import Library

from ggsheet import MicroGoogleSheet

Class Instance

MicroGoogleSheet(googleSheetURL, sheet_name, deploymentID)

Parameters

• googleSheetURL (str): The URL of the Google Sheet.
• sheet_name (str, optional): The name of the sheet within the Google Sheet. Default is "Sheet1".
• deploymentID (str, optional): The deployment ID of the Google Apps Script web app. The default is an empty string, which can be added later with set_DeploymentID().

# Google Sheet Credential 
google_sheet_url = "https://docs.google.com/spreadsheets/d/xxxxxxxxx/edit#gid=0"
google_sheet_name = "Sheet1"
google_app_deployment_id = "xxxxxxxx"

# Create Instance 
ggsheet = MicroGoogleSheet(google_sheet_url,google_sheet_name)

set_DeploymentID()

Python Code

set_SheetName()

Python Code

Update

Python Code

updateCell()

Python Code

updateRow()

Python Code

updateColumn()

Python Code

Get

Python Code

getCell()

Python Code

getRow()

Python Code

getColumn()

Python Code

Delete

Python Code

deleteCell()

Python Code

deleteRow()

Python Code

deleteColumn()

Python Code

Append

Python Code

appendCell()

Python Code

appendRow()

Python Code

appendColumn()

Python Code