Get sheet data

Get data from a specific sheet in a Google Spreadsheet.

Get sheet formulas

Get formulas from a specific sheet in a Google Spreadsheet.

Update cells

Update cells in a Google Spreadsheet with the values provided. Works for a single range.

Batch update cells

Batch update multiple ranges in a Google Spreadsheet.

Add rows

Add rows to a sheet in a Google Spreadsheet.

Add columns

Add columns to a sheet in a Google Spreadsheet.

List sheets

List all sheets in a Google Spreadsheet.

Copy sheet

Copy a sheet from one spreadsheet to another.

Rename sheet

Rename a sheet in a Google Spreadsheet.

Get multiple sheet data

Get data from multiple specific ranges in Google Spreadsheets.

Get multiple spreadsheet summary

Get a summary of multiple Google Spreadsheets, including sheet names, headers, and the first few rows of data for each sheet.

Get spreadsheet info

Get basic information about a Google Spreadsheet.

Create spreadsheet

Create a new Google Spreadsheet.

Create sheet

Create a new sheet tab in an existing Google Spreadsheet.

List spreadsheets

List all spreadsheets in the configured Google Drive folder. If no folder is configured, lists spreadsheets from 'My Drive'.

Share spreadsheet

Share a Google Spreadsheet with multiple users via email, assigning specific roles.