Google Sheets

Active

Full Google Sheets integration. Read spreadsheet data, write to cells, create new sheets, and analyze tabular data. Connect your spreadsheets as scene assets for AI-driven data analysis.

Data & Databases OAuth 3 asset types 16 tools

What you can connect

Add these to your scene and AI gets access.

Account Accounts

A connected Google account for google_sheets

EmailName

Spreadsheet Spreadsheets

A Google Sheets spreadsheet

TitleSheets

Sheet Sheets

A sheet within a spreadsheet

TitleIndex

Tools

AI actions available through this integration.

sheets_get_spreadsheet Get metadata about a Google Spreadsheet including all sheet names and properties..

sheets_read Read data from a Google Sheet.

sheets_get_values Get raw cell values and formulas from a specific range in A1 notation (e.g., 'Sheet1!A1:D10').

sheets_update_values Update cell values in a specific range.

sheets_append_rows Append rows to the end of a sheet.

sheets_clear Clear all values in a range (keeps formatting)..

sheets_create Create a new Google Spreadsheet with optional initial data..

sheets_list List spreadsheets accessible to the connected Google account.

sheets_add_sheet Add a new sheet/tab to an existing spreadsheet..

sheets_get_cells Read cells with full data including values, formulas, formatting (colors, fonts, borders), and notes.

sheets_insert_rows Insert new blank rows at a specific position in a sheet, pushing existing rows down.

sheets_delete_rows Delete rows from a sheet, pulling remaining rows up.

sheets_format_cells Apply formatting to existing cells without changing their values.

sheets_batch_update Execute raw Google Sheets batchUpdate requests.

sheets_rename_spreadsheet Rename a Google Spreadsheet by updating its Drive file name..

sheets_delete_spreadsheet Delete a Google Spreadsheet from Drive..

Use cases

Analyze spreadsheet data with natural language queries
Update cells and ranges programmatically
Generate reports from spreadsheet data

Ready to try Google Sheets with Daslab?

Get started with CLI