Google Sheets

​

Overview

Manage and analyze data in Google’s spreadsheets solution. Through Langdock’s integration, you can access and manage Google Sheets directly from your conversations.

​

Available Actions

​

Search spreadsheets

google_sheets.search_spreadsheets

Searches for spreadsheets in Google Drive by name Requires Confirmation: No Parameters:

• query (TEXT, Optional): Search term to find spreadsheets by name. If empty, returns the most recent spreadsheets.
• folderId (TEXT, Optional): Optional Google Drive folder ID to search within.
• pageToken (TEXT, Optional): Token for pagination. Use the nextPageToken from a previous response to get the next page of results.

Output: Returns the operation result

---

​

Create rows

google_sheets.create_rows

Creates new rows in a specific spreadsheet. Requires Confirmation: Yes Parameters:

• spreadsheetId (TEXT, Required): ID of the spreadsheet.
• sheetId (NUMBER, Required): ID of the sheet (numeric). Default: 0 (first sheet).
• amount (NUMBER, Required): Amount of Rows to be inserted starting at index
• startIndex (TEXT, Optional): Default: 0

Output: Returns the operation result

---

​

Update spreadsheet rows

google_sheets.update_spreadsheet_rows

Updates rows in a specific spreadsheet Requires Confirmation: Yes Parameters:

• spreadsheetId (TEXT, Required): ID of the spreadsheet.
• range (TEXT, Optional): A1 Notation to define range and sheet in which values can be inserted into rows. Default = entire Sheet1.
• valueInput (OBJECT, Required): Values that should be inserted in the specific rows. Default: Empty Rows. An example for creating 4 rows with 5 values each is: [ [“Item”, “Cost”, “Stocked”, “Ship Date”], [“Wheel”, “$20.50", "4", "3/1/2016"], ["Door", "$15”, “2”, “3/15/2016”], [“Engine”, “$100”, “1”, “3/20/2016”], [“Totals”, “=S…

Output: Returns the operation result

---

​

Append rows to spreadsheet

google_sheets.append_rows

Appends new rows to the end of a spreadsheet, automatically finding the last row with data Requires Confirmation: Yes Parameters:

• spreadsheetId (TEXT, Required): ID of the spreadsheet.
• range (TEXT, Optional): A1 Notation to define the range to search for a table of data. Values will be appended after the last row of the table. Default: Sheet1 (entire sheet).
• valueInput (OBJECT, Required): Values that should be appended to the spreadsheet. An example for appending 3 rows with 4 values each is: [ [“Wheel”, “$20.50", "4", "3/1/2016"], ["Door", "$15”, “2”, “3/15/2016”], [“Engine”, “$100”, “1”, “3/20/2016”] ]

Output: Returns the operation result

---

​

List spreadsheet row

google_sheets.list_spreadsheet_row

Lists a specific spreadsheet row based on the row number Requires Confirmation: No Parameters:

• spreadsheetId (TEXT, Required): ID of the spreadsheet.
• rowNumber (NUMBER, Required): The row that should be returned. Indexing starts at 1.
• sheetName (TEXT, Optional): Name of the sheet (tab/page) in the spreadsheet that should be addressed. Default: Sheet1

Output: Returns the operation result

---

​

List spreadsheet row range

google_sheets.list_spreadsheet_row_range

Lists multiple spreadsheet rows based on a range Requires Confirmation: No Parameters:

• spreadsheetId (TEXT, Required): The ID of the spreadsheet that should be edited.
• sheetAndRange (TEXT, Optional): A1 / R1C1 notation of the referenced sheet and range to retrieve values from; Default: Sheet1, entire sheet, Row indexing starts at 1. If no input is provided, it will return all rows in the default sheet (Sheet1)

Output: Returns the operation result

---

​

Clear spreadsheet rows

google_sheets.clear_spreadsheet_rows

Clears the content of the selected rows while keeping the rows intact in the workspace Requires Confirmation: Yes Parameters:

• spreadsheetId (TEXT, Required): Id of the spreadsheet.
• sheetAndRange (TEXT, Optional): A1 / R1C1 notation of the referenced sheet and range to retrieve values from; Default: Sheet1, entire sheet, Row indexing starts at 1

Output: Returns the operation result

---

​

Get spreadsheet metadata

google_sheets.get_spreadsheet_metadata

Retrieves essential spreadsheet metadata including title, locale, timezone, and sheet properties (IDs, names, dimensions) Requires Confirmation: No Parameters:

• spreadsheetId (TEXT, Required): ID of the spreadsheet to get metadata for.

Output: Returns the operation result

---

​

Delete spreadsheet rows

google_sheets.delete_spreadsheet_rows

Deletes a range of rows in a specific spreadsheet Requires Confirmation: Yes Parameters:

• spreadsheetId (TEXT, Required): ID of the spreadsheet.
• sheetId (NUMBER, Required): ID of the sheet where the rows should be deleted.
• rowRangeStartIndex (NUMBER, Required): Start index of row range that should be deleted. Row indexing starts at 0. Including the row at this index.
• rowRangeEndIndex (NUMBER, Required): End index of row range that should be deleted. Row indexing starts at 0. Excluding the row at that index.

Output: Returns the operation result

---

​

Add sheet

google_sheets.add_sheet

Adds a new sheet to a spreadsheet. Requires Confirmation: Yes Parameters:

• spreadsheetId (TEXT, Required): ID of the spreadsheet
• title (TEXT, Required): Name of the new sheet

Output: Returns the operation result

---