Method Run

internal/cmd/sheets_table.go:128–208

(ctx context.Context, flags *RootFlags)

}

func (c *SheetsTableCreateCmd) Run(ctx context.Context, flags *RootFlags) error {
	u := ui.FromContext(ctx)
	spreadsheetID := normalizeGoogleID(strings.TrimSpace(c.SpreadsheetID))
	rangeSpec := cleanRange(strings.TrimSpace(c.Range))
	name := strings.TrimSpace(c.Name)
	if spreadsheetID == "" {
		return usage("empty spreadsheetId")
	}
	if rangeSpec == "" {
		return usage("empty range")
	}
	if name == "" {
		return usage("empty name")
	}

	columns, err := parseSheetsTableColumnsJSON(c.ColumnsJSON, stdinReader(ctx))
	if err != nil {
		return err
	}

	if dryRunErr := dryRunExit(ctx, flags, "sheets.table.create", map[string]any{
		"spreadsheet_id": spreadsheetID,
		"range":          rangeSpec,
		"name":           name,
		"columns":        columns,
	}); dryRunErr != nil {
		return dryRunErr
	}

	account, err := requireAccount(flags)
	if err != nil {
		return err
	}

	svc, err := sheetsService(ctx, account)
	if err != nil {
		return err
	}

	catalog, err := fetchSpreadsheetRangeCatalog(ctx, svc, spreadsheetID)
	if err != nil {
		return err
	}
	gridRange, err := resolveGridRangeWithCatalog(rangeSpec, catalog, "table")
	if err != nil {
		return err
	}

	table := &sheets.Table{
		Name:             name,
		Range:            gridRange,
		ColumnProperties: columns,
	}
	req := &sheets.BatchUpdateSpreadsheetRequest{
		Requests: []*sheets.Request{
			{
				AddTable: &sheets.AddTableRequest{Table: table},
			},