Googlesheets Update Values Batch

Tool to set values in one or more ranges of a spreadsheet. Use when you need to update multiple ranges in a single operation for better performance.

料金

無料 Action

統合支払い

現在未対応

• dataarray

  必須
  The new values to apply to the spreadsheet. Each ValueRange specifies a range and the values to write to that range. Multiple ranges can be updated in a single request.
• spreadsheet_idstring

  必須
  The ID of the spreadsheet to update. This ID can be found in the URL of the spreadsheet (e.g., https://docs.google.com/spreadsheets/d/{spreadsheet_id}/edit). Must be a valid Google Sheets spreadsheet ID.
• valueInputOptionstring

  必須
  How the input data should be interpreted. RAW: Values are stored exactly as entered, without parsing. USER_ENTERED: Values are parsed as if typed by a user (numbers stay numbers, strings prefixed with '=' become formulas, etc.). INPUT_VALUE_OPTION_UNSPECIFIED: Default input valu…
• includeValuesInResponseboolean
  Determines if the update response should include the values of the cells that were updated. By default, responses do not include the updated values.
• responseValueRenderOptionstring
  Determines how values in the response should be rendered. Only used if includeValuesInResponse is true. FORMATTED_VALUE (default): Values are formatted as displayed in the UI. UNFORMATTED_VALUE: Values are unformatted. FORMULA: Formulas are not evaluated.
• responseDateTimeRenderOptionstring
  Determines how dates, times, and durations in the response should be rendered. Only used if includeValuesInResponse is true. SERIAL_NUMBER (default): Dates are returned as numbers. FORMATTED_STRING: Dates are returned as formatted strings.

• data

  必須
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  必須
  Whether or not the action execution was successful or not

• 

  AI 製品を条件に合うディレクトリへ登録する

  公式サイトから Product Kit とキャンペーンシートを作り、TinyFish で検証済みの 5 から 10 件の登録を進めます。