Documentation Index Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
Use this file to discover all available pages before exploring further.
Server path: /google-sheets | Type: Application | PCID required: YesTool Description google-sheets_create_spreadsheetCreate a new Google Spreadsheet with customizable title google-sheets_list_sheetsList all sheets/tabs within a Google Spreadsheet google-sheets_create_sheetCreate a new sheet/tab within an existing Google Spreadsheet google-sheets_read_all_from_sheetRead all data from a specified sheet in a Google Spreadsheet with pagination support google-sheets_read_col_headingsRead column headers/names from the first row of a Google Sheet google-sheets_read_rowsRead specific rows from a Google Spreadsheet google-sheets_read_columnsRead specific columns from a Google Spreadsheet google-sheets_edit_cellEdit a single cell in a Google Spreadsheet google-sheets_edit_rowEdit an entire row in a Google Spreadsheet google-sheets_edit_columnEdit an entire column in a Google Spreadsheet google-sheets_insert_rowInsert a new row at a specified position in a Google Spreadsheet google-sheets_insert_columnInsert a new column at a specified position in a Google Spreadsheet google-sheets_rename_sheetRename a sheet/tab within a Google Spreadsheet google-sheets_rename_spreadsheetRename the entire Google Spreadsheet file google-sheets_get_sheet_row_column_countGet the total dimensions of a Google Sheet including maximum rows and columns google-sheets_delete_sheetDelete a sheet/tab from a Google Spreadsheet google-sheets_delete_spreadsheetDelete an entire Google Spreadsheet file google-sheets_add_columnAdd a new column to a Google Sheets worksheet google-sheets_clear_cellClear the content of a specific cell in a spreadsheet google-sheets_clear_rowsClear content from multiple rows in a spreadsheet google-sheets_find_rowFind rows by searching for a value in a specific column google-sheets_copy_worksheetCopy a worksheet within the same spreadsheet or to another spreadsheet google-sheets_insert_commentInsert a comment on a specific cell in a spreadsheet google-sheets_update_formattingUpdate cell formatting (bold, italic, background color, etc.)
google-sheets_create_spreadsheet Create a new Google Spreadsheet with customizable title
Parameters: Parameter Type Required Default Description titlestring Yes — Title/name for the new spreadsheet
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "title" : { "type" : "string" , "description" : "Title/name for the new spreadsheet" } }, "required" : [ "PCID" , "title" ] }
google-sheets_list_sheets List all sheets/tabs within a Google Spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to list sheets from
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to list sheets from" } }, "required" : [ "PCID" , "spreadsheetId" ] }
google-sheets_create_sheet Create a new sheet/tab within an existing Google Spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to create a new sheet in titlestring Yes — Name for the new sheet/tab
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to create a new sheet in" }, "title" : { "type" : "string" , "description" : "Name for the new sheet/tab" } }, "required" : [ "PCID" , "spreadsheetId" , "title" ] }
google-sheets_read_all_from_sheet Read all data from a specified sheet in a Google Spreadsheet with pagination support
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to read from sheetNamestring No — Name of specific sheet to read from (defaults to first sheet) pageSizenumber No — Number of rows to return per page (default: 1000, max: 10000) startRownumber No — Row number to start reading from (1-based indexing, default: 1)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to read from" }, "sheetName" : { "type" : "string" , "description" : "Name of specific sheet to read from (defaults to first sheet)" }, "pageSize" : { "type" : "number" , "description" : "Number of rows to return per page (default: 1000, max: 10000)" }, "startRow" : { "type" : "number" , "description" : "Row number to start reading from (1-based indexing, default: 1)" } }, "required" : [ "PCID" , "spreadsheetId" ] }
google-sheets_read_col_headings Read column headers/names from the first row of a Google Sheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to read from sheetNamestring No — Name of sheet to read headers from (defaults to first sheet)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to read from" }, "sheetName" : { "type" : "string" , "description" : "Name of sheet to read headers from (defaults to first sheet)" } }, "required" : [ "PCID" , "spreadsheetId" ] }
google-sheets_read_rows Read specific rows from a Google Spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to read from sheetNamestring No — Name of sheet to read from (defaults to first sheet) startRownumber No — Starting row index to read from (1-based, defaults to first row after header) endRownumber No — Ending row index to read to (1-based, defaults to last row with data) pageSizenumber No — Number of rows to return per page (default: 1000) pageStartRownumber No — Row number to start the current page from (for pagination)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to read from" }, "sheetName" : { "type" : "string" , "description" : "Name of sheet to read from (defaults to first sheet)" }, "startRow" : { "type" : "number" , "description" : "Starting row index to read from (1-based, defaults to first row after header)" }, "endRow" : { "type" : "number" , "description" : "Ending row index to read to (1-based, defaults to last row with data)" }, "pageSize" : { "type" : "number" , "description" : "Number of rows to return per page (default: 1000)" }, "pageStartRow" : { "type" : "number" , "description" : "Row number to start the current page from (for pagination)" } }, "required" : [ "PCID" , "spreadsheetId" ] }
google-sheets_read_columns Read specific columns from a Google Spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to read from sheetNamestring No — Name of sheet to read from (defaults to first sheet) columnsnumber[] No — Column indices to read (1-based, e.g., [1, 3, 5] for columns A, C, E. Defaults to all columns with data) pageSizenumber No — Number of rows to return per page (default: 1000) startRownumber No — Row number to start reading from (1-based, default: 1)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to read from" }, "sheetName" : { "type" : "string" , "description" : "Name of sheet to read from (defaults to first sheet)" }, "columns" : { "type" : "array" , "items" : { "type" : "number" }, "description" : "Column indices to read (1-based, e.g., [1, 3, 5] for columns A, C, E. Defaults to all columns with data)" }, "pageSize" : { "type" : "number" , "description" : "Number of rows to return per page (default: 1000)" }, "startRow" : { "type" : "number" , "description" : "Row number to start reading from (1-based, default: 1)" } }, "required" : [ "PCID" , "spreadsheetId" ] }
google-sheets_edit_cell Edit a single cell in a Google Spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to edit sheetNamestring No — Name of sheet to edit (defaults to first sheet) cellAddressstring Yes — Cell address in A1 notation (e.g., “A1”, “B5”, “Z100”) valuestring Yes — New value to set in the cell (text, number, or formula)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to edit" }, "sheetName" : { "type" : "string" , "description" : "Name of sheet to edit (defaults to first sheet)" }, "cellAddress" : { "type" : "string" , "description" : "Cell address in A1 notation (e.g., \" A1 \" , \" B5 \" , \" Z100 \" )" }, "value" : { "type" : "string" , "description" : "New value to set in the cell (text, number, or formula)" } }, "required" : [ "PCID" , "spreadsheetId" , "cellAddress" , "value" ] }
google-sheets_edit_row Edit an entire row in a Google Spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to edit sheetNamestring No — Name of sheet to edit (defaults to first sheet) rowIndexnumber Yes — Row number to edit (1-based indexing) valuesstring[] Yes — Array of values to set in the row (one value per column)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to edit" }, "sheetName" : { "type" : "string" , "description" : "Name of sheet to edit (defaults to first sheet)" }, "rowIndex" : { "type" : "number" , "description" : "Row number to edit (1-based indexing)" }, "values" : { "type" : "array" , "items" : { "type" : "string" }, "description" : "Array of values to set in the row (one value per column)" } }, "required" : [ "PCID" , "spreadsheetId" , "rowIndex" , "values" ] }
google-sheets_edit_column Edit an entire column in a Google Spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to edit sheetNamestring No — Name of sheet to edit (defaults to first sheet) columnLetterstring Yes — Column letter to edit (e.g., “A”, “B”, “C”, “AA”, “AB”) valuesstring[] Yes — Array of values to set in the column (one value per row) startRownumber Yes — Row number to start writing values from (1-based)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to edit" }, "sheetName" : { "type" : "string" , "description" : "Name of sheet to edit (defaults to first sheet)" }, "columnLetter" : { "type" : "string" , "description" : "Column letter to edit (e.g., \" A \" , \" B \" , \" C \" , \" AA \" , \" AB \" )" }, "values" : { "type" : "array" , "items" : { "type" : "string" }, "description" : "Array of values to set in the column (one value per row)" }, "startRow" : { "type" : "number" , "description" : "Row number to start writing values from (1-based)" } }, "required" : [ "PCID" , "spreadsheetId" , "columnLetter" , "values" , "startRow" ] }
google-sheets_insert_row Insert a new row at a specified position in a Google Spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to edit sheetNamestring No — Name of sheet to edit (defaults to first sheet) rowIndexnumber No — Position to insert the new row (1-based, defaults to end of sheet) valuesstring[] No — Optional initial values for the new row
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to edit" }, "sheetName" : { "type" : "string" , "description" : "Name of sheet to edit (defaults to first sheet)" }, "rowIndex" : { "type" : "number" , "description" : "Position to insert the new row (1-based, defaults to end of sheet)" }, "values" : { "type" : "array" , "items" : { "type" : "string" }, "description" : "Optional initial values for the new row" } }, "required" : [ "PCID" , "spreadsheetId" ] }
google-sheets_insert_column Insert a new column at a specified position in a Google Spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to edit sheetNamestring No — Name of sheet to edit (defaults to first sheet) columnLetterstring No — Position to insert the new column (e.g., “A”, “B”, “C”, defaults to end of sheet) valuesstring[] No — Optional initial values for the new column
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to edit" }, "sheetName" : { "type" : "string" , "description" : "Name of sheet to edit (defaults to first sheet)" }, "columnLetter" : { "type" : "string" , "description" : "Position to insert the new column (e.g., \" A \" , \" B \" , \" C \" , defaults to end of sheet)" }, "values" : { "type" : "array" , "items" : { "type" : "string" }, "description" : "Optional initial values for the new column" } }, "required" : [ "PCID" , "spreadsheetId" ] }
google-sheets_rename_sheet Rename a sheet/tab within a Google Spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to edit sheetNamestring No — Current name of sheet to rename (defaults to first sheet) newNamestring Yes — New name for the sheet/tab
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to edit" }, "sheetName" : { "type" : "string" , "description" : "Current name of sheet to rename (defaults to first sheet)" }, "newName" : { "type" : "string" , "description" : "New name for the sheet/tab" } }, "required" : [ "PCID" , "spreadsheetId" , "newName" ] }
google-sheets_rename_spreadsheet Rename the entire Google Spreadsheet file
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to rename newNamestring Yes — New name for the spreadsheet file
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to rename" }, "newName" : { "type" : "string" , "description" : "New name for the spreadsheet file" } }, "required" : [ "PCID" , "spreadsheetId" , "newName" ] }
google-sheets_get_sheet_row_column_count Get the total dimensions of a Google Sheet including maximum rows and columns
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to get dimensions from sheetNamestring No — Name of sheet to get row and column count from (defaults to first sheet)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to get dimensions from" }, "sheetName" : { "type" : "string" , "description" : "Name of sheet to get row and column count from (defaults to first sheet)" } }, "required" : [ "PCID" , "spreadsheetId" ] }
google-sheets_delete_sheet Delete a sheet/tab from a Google Spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to delete sheet from sheetNamestring Yes — Name of sheet/tab to delete
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to delete sheet from" }, "sheetName" : { "type" : "string" , "description" : "Name of sheet/tab to delete" } }, "required" : [ "PCID" , "spreadsheetId" , "sheetName" ] }
google-sheets_delete_spreadsheet Delete an entire Google Spreadsheet file
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID to delete
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID to delete" } }, "required" : [ "PCID" , "spreadsheetId" ] }
google-sheets_add_column Add a new column to a Google Sheets worksheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID sheetNamestring Yes — Name of the worksheet to add column to columnIndexnumber No — Index where to insert column (0-based). If not provided, adds at the end
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID" }, "sheetName" : { "type" : "string" , "description" : "Name of the worksheet to add column to" }, "columnIndex" : { "type" : "number" , "description" : "Index where to insert column (0-based). If not provided, adds at the end" } }, "required" : [ "PCID" , "spreadsheetId" , "sheetName" ] }
google-sheets_clear_cell Clear the content of a specific cell in a spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID sheetNamestring Yes — Name of the worksheet cellstring Yes — Cell reference in A1 notation (e.g., “A1”, “B5”)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID" }, "sheetName" : { "type" : "string" , "description" : "Name of the worksheet" }, "cell" : { "type" : "string" , "description" : "Cell reference in A1 notation (e.g., \" A1 \" , \" B5 \" )" } }, "required" : [ "PCID" , "spreadsheetId" , "sheetName" , "cell" ] }
google-sheets_clear_rows Clear content from multiple rows in a spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID sheetNamestring Yes — Name of the worksheet startRownumber Yes — Starting row number (1-based) endRownumber Yes — Ending row number (1-based)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID" }, "sheetName" : { "type" : "string" , "description" : "Name of the worksheet" }, "startRow" : { "type" : "number" , "description" : "Starting row number (1-based)" }, "endRow" : { "type" : "number" , "description" : "Ending row number (1-based)" } }, "required" : [ "PCID" , "spreadsheetId" , "sheetName" , "startRow" , "endRow" ] }
google-sheets_find_row Find rows by searching for a value in a specific column
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID sheetNamestring Yes — Name of the worksheet columnstring Yes — Column to search in (A1 notation, e.g., “A”, “B”) valuestring Yes — Value to search for exportRowboolean No falseReturn full row data for matches
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID" }, "sheetName" : { "type" : "string" , "description" : "Name of the worksheet" }, "column" : { "type" : "string" , "description" : "Column to search in (A1 notation, e.g., \" A \" , \" B \" )" }, "value" : { "type" : "string" , "description" : "Value to search for" }, "exportRow" : { "type" : "boolean" , "default" : false , "description" : "Return full row data for matches" } }, "required" : [ "PCID" , "spreadsheetId" , "sheetName" , "column" , "value" ] }
google-sheets_copy_worksheet Copy a worksheet within the same spreadsheet or to another spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Source Google Spreadsheet ID sheetNamestring Yes — Name of the worksheet to copy newSheetNamestring Yes — Name for the copied worksheet destinationSpreadsheetIdstring No — Destination spreadsheet ID (if copying to different spreadsheet)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Source Google Spreadsheet ID" }, "sheetName" : { "type" : "string" , "description" : "Name of the worksheet to copy" }, "newSheetName" : { "type" : "string" , "description" : "Name for the copied worksheet" }, "destinationSpreadsheetId" : { "type" : "string" , "description" : "Destination spreadsheet ID (if copying to different spreadsheet)" } }, "required" : [ "PCID" , "spreadsheetId" , "sheetName" , "newSheetName" ] }
Insert a comment on a specific cell in a spreadsheet
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID sheetNamestring Yes — Name of the worksheet cellstring Yes — Cell reference in A1 notation (e.g., “A1”, “B5”) commentstring Yes — Comment text to add
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID" }, "sheetName" : { "type" : "string" , "description" : "Name of the worksheet" }, "cell" : { "type" : "string" , "description" : "Cell reference in A1 notation (e.g., \" A1 \" , \" B5 \" )" }, "comment" : { "type" : "string" , "description" : "Comment text to add" } }, "required" : [ "PCID" , "spreadsheetId" , "sheetName" , "cell" , "comment" ] }
Update cell formatting (bold, italic, background color, etc.)
Parameters: Parameter Type Required Default Description spreadsheetIdstring Yes — Google Spreadsheet ID sheetNamestring Yes — Name of the worksheet rangestring Yes — Range to format in A1 notation (e.g., “A1:B5”) boldboolean No — Make text bold italicboolean No — Make text italic backgroundColorstring No — Background color (hex format, e.g., “#FF0000”) textColorstring No — Text color (hex format, e.g., “#000000”)
{ "type" : "object" , "properties" : { "PCID" : { "type" : "string" , "description" : "Pink Connect ID" }, "spreadsheetId" : { "type" : "string" , "description" : "Google Spreadsheet ID" }, "sheetName" : { "type" : "string" , "description" : "Name of the worksheet" }, "range" : { "type" : "string" , "description" : "Range to format in A1 notation (e.g., \" A1:B5 \" )" }, "bold" : { "type" : "boolean" , "description" : "Make text bold" }, "italic" : { "type" : "boolean" , "description" : "Make text italic" }, "backgroundColor" : { "type" : "string" , "description" : "Background color (hex format, e.g., \" #FF0000 \" )" }, "textColor" : { "type" : "string" , "description" : "Text color (hex format, e.g., \" #000000 \" )" } }, "required" : [ "PCID" , "spreadsheetId" , "sheetName" , "range" ] }
