
Finds the next available empty row numbers in columns A, B, and C of a Google Sheet to help you identify where to add new data.
This integration analyzes a Goog... Read More
Finds the next available empty row numbers in columns A, B, and C of a Google Sheet to help you identify where to add new data.
This integration analyzes a Google Sheet tab and identifies the first empty row number in columns A, B, and C. This is particularly useful when you need to know exactly where to insert new data in a spreadsheet that’s continuously growing, such as tracking sheets, logs, or data collection forms.
Returns an object containing the row numbers of the first empty cells found in each of the first three columns. Each property shows the specific row number where you can safely add new data without overwriting existing content.
{
"last_empty_row_in_column_a": 2847,
"last_empty_row_in_column_b": 2847,
"last_empty_row_in_column_c": 2848
} Read LessSearches for rows in a Google Sheet by matching a value in a specific column and returns all matching row data.
This integration searches through a specific tab... Read More
Searches for rows in a Google Sheet by matching a value in a specific column and returns all matching row data.
This integration searches through a specific tab in your Google Sheets spreadsheet to find rows where a particular column matches your search value. It’s useful for looking up customer records, order information, or any data stored in your sheets where you need to find specific entries and retrieve the complete row details.
Returns a search results object containing matched_count (number of matching rows found), search_column and search_value (your search criteria), searched_column_name (the header name of the searched column), and matched_rows (array of matching row data). Each matched row includes all column values from that row plus a line_number indicating its position in the spreadsheet.
{
"matched_count": 1,
"search_column": "A",
"search_value": "sarah.johnson@example.com",
"searched_column_name": "Email",
"cleaned_sheet_tab_name": "Customer%20Data",
"matched_rows": [
{
"Email": "sarah.johnson@example.com",
"Look up date": "2024-01-15",
"Voucher code": "SAVE20",
"conversation_id": "conv_789xyz",
"line_number": 3
}
]
} Read LessUpdates three specific column values in a single row of a Google Sheet with new data in one batch operation.
This integration allows you to update exactly three... Read More
Updates three specific column values in a single row of a Google Sheet with new data in one batch operation.
This integration allows you to update exactly three cells in a Google Sheet by specifying the row number and three column letters, then providing the new values for each cell. It’s perfect for updating customer records, inventory data, or any structured information where you need to modify multiple related fields at once across three columns.
Returns a batch update response containing details about each cell update, including responses (array of individual update results), spreadsheetId, and summary totals like totalUpdatedRows, totalUpdatedCells, totalUpdatedSheets, and totalUpdatedColumns. Each response includes the specific range updated and count of affected cells.
{
"responses": [
{
"updatedRows": 1,
"updatedCells": 1,
"updatedRange": "'Customer Database'!A2548",
"spreadsheetId": "1AbCdEfGhIjKlMnOpQrStUvWxYz123456789",
"updatedColumns": 1
},
{
"updatedRows": 1,
"updatedCells": 1,
"updatedRange": "'Customer Database'!B2548",
"spreadsheetId": "1AbCdEfGhIjKlMnOpQrStUvWxYz123456789",
"updatedColumns": 1
},
{
"updatedRows": 1,
"updatedCells": 1,
"updatedRange": "'Customer Database'!C2548",
"spreadsheetId": "1AbCdEfGhIjKlMnOpQrStUvWxYz123456789",
"updatedColumns": 1
}
],
"spreadsheetId": "1AbCdEfGhIjKlMnOpQrStUvWxYz123456789",
"totalUpdatedRows": 1,
"totalUpdatedCells": 3,
"totalUpdatedSheets": 1,
"totalUpdatedColumns": 3
} Read Less