Skip to content
Agent Tools

manageRowsAndColumns

Insert, delete, or auto-size rows and columns. Operations are executed in order: column insert → column delete → row insert → row delete → column autosize → row autosize.

ParameterTypeDescription
sheetstringrequiredSheet name to operate on
columnsobjectoptionalColumn operations
columns.insertobjectoptional
columns.deleteobjectoptional
columns.autoSizestring[]optionalArray of column letters to auto-size (e.g., [“A”, “B”, “C”])
rowsobjectoptionalRow operations
rows.insertobjectoptional
rows.deleteobjectoptional
rows.autoSizenumber[]optionalArray of 1-based row numbers to auto-size (e.g., [1, 2, 3])
notestringrequiredDescription of this operation for version history