Method Run

internal/cmd/sheets_conditional.go:33–108

(ctx context.Context, flags *RootFlags)

}

func (c *SheetsConditionalAddCmd) Run(ctx context.Context, flags *RootFlags) error {
	u := ui.FromContext(ctx)
	spreadsheetID := normalizeGoogleID(strings.TrimSpace(c.SpreadsheetID))
	rangeSpec := cleanRange(c.Range)
	if spreadsheetID == "" {
		return usage("empty spreadsheetId")
	}
	if strings.TrimSpace(rangeSpec) == "" {
		return usage("empty range")
	}
	if c.Index < 0 {
		return usage("--index must be zero or greater")
	}

	parsedRange, err := parseSheetRange(rangeSpec, "conditional-format")
	if err != nil {
		return err
	}
	format, formatFields, err := parseConditionalFormat(c.FormatJSON, c.FormatFields, stdinReader(ctx))
	if err != nil {
		return err
	}
	conditionType, values, err := sheetsconditional.BuildCondition(strings.TrimSpace(c.Type), strings.TrimSpace(c.Expr))
	if err != nil {
		return sheetsConditionalPlannerError(err)
	}

	if dryErr := dryRunExit(ctx, flags, "sheets.conditional-format.add", map[string]any{
		"spreadsheet_id": spreadsheetID,
		"range":          rangeSpec,
		"type":           conditionType,
		"values":         values,
		"format_fields":  formatFields,
		"index":          c.Index,
	}); dryErr != nil {
		return dryErr
	}

	account, err := requireAccount(flags)
	if err != nil {
		return err
	}
	svc, err := sheetsService(ctx, account)
	if err != nil {
		return err
	}
	sheetIDs, err := fetchSheetIDMap(ctx, svc, spreadsheetID)
	if err != nil {
		return err
	}
	gridRange, err := gridRangeFromMap(parsedRange, sheetIDs, "conditional-format")
	if err != nil {
		return err
	}

	req := &sheets.BatchUpdateSpreadsheetRequest{
		Requests: []*sheets.Request{
			sheetsconditional.BuildAddRequest(gridRange, conditionType, values, format, c.Index),