Connect Google Sheets to Siftree.

Create Column

Create a new column in a spreadsheet.

Create Spreadsheet

Create a blank spreadsheet or duplicate an existing spreadsheet.

Create Worksheet

Create a blank worksheet with a title.

Delete Conditional Format Rule

Remove conditional formatting rule by index.

Delete Rows

Deletes the specified rows from a spreadsheet.

Delete Worksheet

Delete a specific worksheet.

Format Cells

Apply formatting to a range of cells in a Google Sheets worksheet: bold/italic/underline, font size and family, text and background color, alignment, text wrapping, number formats (currency, percent, date), borders,…

Includes making a header row stand out. To change cell values instead, use Update Multiple Rows ; to freeze rows or resize columns, use Format Worksheet ; to style cells based on their contents, use Add Conditional Formatting . Use Get Spreadsheet Info to discover worksheet names, and Read Rows to see which cells hold the data you want to format. Colors accept a hex code ( #1a73e8, #fff ) or a common name ( light gray, dark blue, yellow ). range is A1 notation WITHOUT the worksheet name — A1:F1 (a block), B:B (a whole column), 2:2 (a whole row), or A1 (one cell). Only the attributes you pass are changed; everything else in the range keeps its current formatting. Example: to make the header row of a 6-column sheet bold, white on dark blue, and centered, call with sheetName="Financials", range="A1:F1", bold=true, textColor="#ffffff", backgroundColor="#1155cc", horizontalAlignment="CENTER" → returns the applied attributes plus a link to the worksheet, and more

Format Worksheet

Change worksheet-level layout in Google Sheets: freeze header rows or columns, auto-resize columns to fit their contents, set explicit column widths or row heights, hide gridlines, color the sheet tab, or rename the…

Insert an Anchored Note

Insert a note on a spreadsheet cell.

Insert Comment

Insert a comment into a spreadsheet.

Insert Dimension

Insert a dimension into a spreadsheet.

Merge Cells

Merge a range of cells into a single cell.

Move Dimension

Move a dimension in a spreadsheet.

New Spreadsheet

Create a new Google Spreadsheet with an optional worksheet name and column headers. Returns the spreadsheet ID and URL. Use the spreadsheet ID with other tools to read/write data.

Set Data Validation

Add data validation rules to cells (dropdowns, checkboxes, date/number validation).

Update Cell

Update a cell in a spreadsheet.

Update Conditional Format Rule

Modify existing conditional formatting rule.

Update Formatting

Update the formatting of a cell in a spreadsheet.

Update Multiple Rows

Overwrite a contiguous block of cells in a Google Sheet, defined by an A1 range. Provide range WITHOUT the worksheet name — just the cells, e.g. A2:C3 (the tool prepends the worksheet automatically; passing…

Update Row

Overwrite cells in an existing row of a Google Sheet. Provide row (the 1-based row number — use Find Rows or Read Rows to get it from a row's _rowNumber ) and myColumnData , a positional array of values starting at…

Upsert Row

Upsert a row of data in a Google Sheet.