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

​

Create Rows

googlesheets.createRows

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

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

Output: Returns batch update response with details about the inserted rows

---

​

Update Spreadsheet Rows

googlesheets.updateSpreadsheetRows

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 (MULTI_LINE_TEXT, Required): Values that should be inserted in the specific rows. Please use CSV Notation

Output: Returns update response with details about the modified rows

---

​

Append Rows to Spreadsheet

googlesheets.appendRowstoSpreadsheet

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. Default: Sheet1 (entire sheet)
  • valueInput (MULTI_LINE_TEXT, Required): Values that should be appended to the spreadsheet. Please use CSV Notation

Output: Returns append response with details about the added rows

---

​

List Spreadsheet Row

googlesheets.listSpreadsheetRow

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

• 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. Default: Sheet1
  • spreadsheetId (TEXT, Required): ID of the spreadsheet

Output: Returns the specified row data with all cell values

---

​

List Spreadsheet Row Range

googlesheets.listSpreadsheetRowRange

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

• sheetAndRange (TEXT, Optional): A1 / R1C1 notation of the referenced sheet and range. Default: Sheet1, entire sheet
  • spreadsheetId (TEXT, Required): The ID of the spreadsheet that should be edited

Output: Returns array of rows with cell values in the specified range

---

​

Clear Spreadsheet Rows

googlesheets.clearSpreadsheetRows

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. Default: Sheet1, entire sheet

Output: Returns clear response with details about the cleared range

---

​

Get Spreadsheet Metadata

googlesheets.getSpreadsheetMetadata

Retrieves essential spreadsheet metadata including title, locale, timezone, and sheet properties Requires Confirmation: No Parameters:

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

Output: Returns spreadsheet metadata including title, locale, timezone, and sheet properties (IDs, names, dimensions)

---

​

Delete Spreadsheet Rows

googlesheets.deleteSpreadsheetRows

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

• rowRangeEndIndex (NUMBER, Required): End index of row range that should be deleted. Row indexing starts at 0
  • 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

Output: Returns delete response with details about the removed rows

---

​

Common Use Cases

​

Best Practices

​

Troubleshooting

Issue	Solution
Authentication failed	Verify your OAuth credentials
Rate limit exceeded	Reduce request frequency
Data not found	Check permissions and data availability
Connection timeout	Verify network connectivity

​

Support

For additional help with the Google Sheets integration, contact support@langdock.com