Method Run

internal/cmd/sheets.go:469–562

(ctx context.Context, flags *RootFlags)

}

func (c *SheetsAppendCmd) 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")
	}

	var values [][]interface{}

	switch {
	case strings.TrimSpace(c.ValuesJSON) != "":
		b, err := resolveInlineOrFileBytes(c.ValuesJSON, stdinReader(ctx))
		if err != nil {
			return usagef("read --values-json: %v", err)
		}

		values, err = sheetsvalues.Decode(b)
		if err != nil {
			return sheetsValuesPlannerError(err)
		}
	case len(c.Values) > 0:
		values = sheetsvalues.ParseArgs(c.Values)
	default:
		return usage("provide values as args or via --values-json")
	}

	valueInputOption := strings.TrimSpace(c.ValueInput)
	if valueInputOption == "" {
		valueInputOption = sheetsDefaultValueInputOption
	}
	insertDataOption := strings.TrimSpace(c.Insert)

	if err := dryRunExit(ctx, flags, "sheets.append", map[string]any{
		"spreadsheet_id":       spreadsheetID,
		"range":                rangeSpec,
		"values":               values,
		"value_input_option":   valueInputOption,
		"insert_data_option":   insertDataOption,
		"copy_validation_from": strings.TrimSpace(c.CopyValidationFrom),
	}); err != nil {
		return err
	}

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

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