Class: SheetsUtil

SheetsUtil()

Utilities for Google Sheets API

Constructor

new SheetsUtil()

Source:

Methods

(async, static) createClient(pathJwtFile, canWrite)

Create a client for the Google Sheets API

Parameters:
Name Type Default Description
pathJwtFile

Path to the JSON Web Token file for google service account credentials.

canWrite false

Whether to allow writing or not.

Source:

(async, static) findSheetId(client, spreadsheetId, title)

Find sheetId in a spreadsheet

Parameters:
Name Type Description
client

Google Sheets API client.

spreadsheetId

The spreadsheet to request.

title

The name of the sheet to search.

Source: