@robinpath/google-sheets

@robinpath/google-sheets

Google Sheets module for RobinPath.

Why use this module?

The google-sheets module lets you:

• Read values from a spreadsheet range.
• Append a row of values to a spreadsheet.
• Clear all values in a spreadsheet range.
• Create a new Google Spreadsheet.
• List all sheets/tabs in a spreadsheet.

All functions are callable directly from RobinPath scripts with a simple, consistent API.

Installation

npm install @robinpath/google-sheets

Quick Start

1. Set up credentials

googleSheets.setCredentials "ya29.xxx"

2. Read values from a spreadsheet range.

googleSheets.getValues "spreadsheet_id" "Sheet1!A1:C10"

Available Functions

Function	Description
google-sheets.setCredentials	Set the OAuth2 access token for Google Sheets API.
google-sheets.getValues	Read values from a spreadsheet range.
google-sheets.setValues	Write values to a spreadsheet range.
google-sheets.appendRow	Append a row of values to a spreadsheet.
google-sheets.clearRange	Clear all values in a spreadsheet range.
google-sheets.create	Create a new Google Spreadsheet.
google-sheets.getSheets	List all sheets/tabs in a spreadsheet.
google-sheets.addSheet	Add a new sheet/tab to a spreadsheet.
google-sheets.deleteSheet	Delete a sheet/tab from a spreadsheet.
google-sheets.findRows	Find rows matching a value in a specific column.

Examples

Read values from a spreadsheet range.

googleSheets.getValues "spreadsheet_id" "Sheet1!A1:C10"

Write values to a spreadsheet range.

googleSheets.setValues "spreadsheet_id" "Sheet1!A1:B2" [[1,2],[3,4]]

Append a row of values to a spreadsheet.

googleSheets.appendRow "spreadsheet_id" "Sheet1!A:C" ["Alice", 25, "[e-mail]"]

Integration with RobinPath

import { RobinPath } from "@wiredwp/robinpath";
import Module from "@robinpath/google-sheets";

const rp = new RobinPath();
rp.registerModule(Module.name, Module.functions);
rp.registerModuleMeta(Module.name, Module.functionMetadata);

const result = await rp.executeScript(`
  googleSheets.setCredentials "ya29.xxx"
  googleSheets.getValues "spreadsheet_id" "Sheet1!A1:C10"
`);

Full API Reference

See MODULE.md for complete documentation including all parameters, return types, error handling, and advanced examples.

Related Modules

• @robinpath/google-calendar — Google Calendar module for complementary functionality
• @robinpath/google-contacts — Google Contacts module for complementary functionality
• @robinpath/google-forms — Google Forms module for complementary functionality
• @robinpath/gmail — Gmail module for complementary functionality
• @robinpath/outlook — Outlook module for complementary functionality

License

MIT