GPAL
  • Concepts
  • Tutorials
  • Library
  • Endpoints
  • API
  • OttoMagic
  • Services
v1.0.0
Library
  • AI
  • Application
  • Base64Helper
  • Browser
  • Converter
  • Credentials
  • Database
  • Excel
  • File
  • Form
  • Gherkin
  • GoogleDorking
  • GoogleDrive
  • GoogleSheets
  • Grid
  • ImageHelper
  • Launcher
  • Logger
  • Mail
  • PuppeteerClient
  • RESTClient
  • Selector
  • Url

GoogleSheets

  • Connection and Sheet Selection
  • Formatting Ranges
  • Google Apps Script Integration
  • Reading and Writing Data
  • Sheet and Spreadsheet Management

Library

Connection and Sheet Selection

Methods for authenticating with Google Sheets, selecting a spreadsheet and sheet, and obtaining the Sheets object.

Formatting Ranges

Methods for applying formatting to a range of cells - alignment, color, number format, and text rotation.

Google Apps Script Integration

Methods for uploading, deploying, and triggering Google Apps Script within a spreadsheet.

Reading and Writing Data

Methods for reading ranges, writing data, and appending or inserting values into Google Sheets.

Sheet and Spreadsheet Management

Methods for creating, deleting, and renaming sheets, setting the spreadsheet title, and performing calculations.

On this page


Library
Connection and Sheet Selection
Formatting Ranges
Google Apps Script Integration
Reading and Writing Data
Sheet and Spreadsheet Management

GPAL

Generally Positive Automation Library

Get Started Library Desktop Viewer

Learn More

Contact Us

GPAL License

About GPAL

FAQs


Bug Reports

Report a bug


Software Decisions Inc © 2026 Copyright
X