Searches for an specific exact value in an specific column of an worksheet and sheet and return the values for all of the columns in the matching row.
This action is one of the most common actions (if not the most common one) that is going to be used regarding this MCP.
Example
Document_ID | Nombre | Apellido |
101010 | Lionel | Messi |
070707 | Cristiano | Ronaldo |
Prompt / Instruction Example
💡 Using the Google Sheets tool, search for the value of the Document_ID mentioned by the human, in column A of the file {complete sheet url} and return the values for all other columns in the row found.
Required Parameters
sheet_id → Obtained automatically by the LLM from the sheet URL
worksheet_id → Obtained automatically by the LLM from the sheet URL
column_letter
value