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.

• Authentication: OAuth

• Category: Google Workspace

• Availability: All workspace plans

---

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

• Data Management: Manage and organize your Google Sheets data

• Automation: Automate workflows with Google Sheets

• Reporting: Generate insights and reports

• Integration: Connect Google Sheets with other tools

---

Best Practices

1

Getting Started

• Enable the Google Sheets integration in your workspace settings

• Authenticate using OAuth

• Test the connection with a simple read operation

• Explore available actions for your use case

2

Important Considerations

• Ensure proper authentication credentials

• Respect rate limits and API quotas

• Review data privacy settings

• Test operations in a safe environment first

---

Troubleshooting

Common Issues & Solutions

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 [email protected]

---