v1

latestOpenAPI 3.0.12026-07-1711094.7 KB

Sanitizes sheet data by removing whitespace padding from string cells in a specified range.

This function removes whitespace padding from all string cells within a given range in a Google Sheet and updates the sheet with the cleaned data. It takes an input object containing the range and values to be sanitized, processes the data, and then updates the sheet using the Google Sheets API.

post/sanitizeSheetData

Request body

Response

Successfully sanitized and updated the sheet data.

spreadsheetIdstring

The ID of the spreadsheet that was updated.

updatedRangestring

The range that was updated in A1 notation.

updatedRowsinteger

The number of rows that were updated.

updatedColumnsinteger

The number of columns that were updated.

updatedCellsinteger

The number of cells that were updated.