Skip to content
Agent Tools

describeStructure

Analyzes the spreadsheet and returns a structured description of all data regions, headers, and labels. This helps you understand:

  • Where data tables are located (islands/regions)
  • Which rows are headers vs data
  • Column and row labels for each data region
  • Sheet names and their contents

Labels are limited to 50 per sheet. Use totalLabels to check if more exist, and labelOffset to paginate.

Use this information to write accurate formulas that reference the correct cells and ranges.

ParameterTypeDescription
sheetsstring[]optionalOptional: limit analysis to specific sheet names. If omitted, all sheets are analyzed.
labelOffsetnumberoptionalOptional: skip N labels before returning up to 50. Use for pagination when totalLabels > 50.