Googlesheets Spreadsheets Values Append

• rangestring

  Required
  A1 notation range used to locate a logical table. New rows are appended after the last row of that table within this range. First call GOOGLESHEETS_GET_SHEET_NAMES with this exact spreadsheet_id and use one of the returned sheet names; sheet names are case-sensitive and default…
• valuesarray

  Required
  2D array of values to append. Typically, each inner list is a ROW (majorDimension=ROWS). Use null/None for empty cells.
• spreadsheetIdstring

  Required
  The spreadsheet ID (typically 44 characters containing letters, numbers, hyphens, and underscores). Found in the URL between /d/ and /edit. NOT the sheet name (tab name) - that belongs in the 'range' parameter.
• majorDimensionstring
  How to interpret the 2D values array. Use ROWS for row-wise data (most common for appends). Use COLUMNS for column-wise data. Example: if A1=1,B1=2,A2=3,B2=4 then majorDimension=ROWS yields [[1,2],[3,4]] and majorDimension=COLUMNS yields [[1,3],[2,4]].
• insertDataOptionstring
  How the input data should be inserted.
• valueInputOptionstring

  Required
  How the input data should be interpreted.
• includeValuesInResponseboolean
  Determines if the update response should include the values of the cells that were appended. By default, responses do not include the updated values.
• responseValueRenderOptionstring
  Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE.
• responseDateTimeRenderOptionstring
  Determines how dates, times, and durations in the response should be rendered. This is ignored if responseValueRenderOption is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.

• data

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

  Required
  Whether or not the action execution was successful or not

No verified related use cases are linked yet.

No published Skills explicitly reference this Action yet.