ACTION_ID: google_sheet_add_data
NAME: Google Sheets: Add Data
CATEGORY: Integrations
CREDITS: 0

Add data to a Google Sheet.

PREREQUISITE: Google account connection — the user must create it in the Floqer UI
(Connections page); an agent cannot. Without it the action fails the row with
a connection / authentication error. Confirm it exists before configuring.

1. INPUTS

spreadsheets (spreadsheetsDropdown, required)
  Spreadsheets. Select the Spreadsheet to add data to. Values from
  google_spreadsheets.

select_sheet (inSheetDropdown, optional)
  Select sheet. Select the sheet to add data to. Values from
  google_spreadsheet_sheets.

value_input_option (dropdown, optional)
  Value Input Option. Type of data interpretation. Values:
    - { id: "USER_ENTERED", name: "User Entered" }
    - { id: "RAW", name: "Raw" } (default)

add_data_to_columns (jsonArrayCreateNew, required)
  Add Data To Columns. Select Columns from the object and add Values
  or Create a New Column.

2. OUTPUTS

(no response fields — this action writes to the sheet and returns nothing.)

3. HOW TO CONFIGURE

Resolve the dropdowns via Get Action Field Options:

  POST /api/v1/workflows/{workflow_id}/sheets/{sheet_id}/actions/{action_instance_id}/options/spreadsheets
       (body: {})
       → user's spreadsheets. `value` is the spreadsheet ID.

  POST .../options/select_sheet
       (body: { "context": { "spreadsheets": "<spreadsheet_id>" } })
       → tabs (sheets) inside the chosen spreadsheet. `value` is the
         sheet name.

Configure Action body:

{
  "inputs": {
    "spreadsheets": "<spreadsheet_id>",
    "select_sheet": "Sheet1",
    "value_input_option": "USER_ENTERED",
    "add_data_to_columns": [
      { "name": "First Name",  "value": "{{input.first_name}}" },
      { "name": "Email",       "value": "{{input.email}}" },
      { "name": "Company",     "value": "{{input.company_name}}" }
    ]
  }
}

Field-by-field:
  - spreadsheets         Google spreadsheet ID from the
                         `spreadsheets` options call.
  - select_sheet         Tab/sheet name from the `select_sheet`
                         options call. Optional; defaults to the
                         first sheet.
  - value_input_option   `RAW` (default — values inserted as-is) or
                         `USER_ENTERED` (Google Sheets parses values
                         like a user typing them, so `=A1+B1` becomes
                         a formula).
  - add_data_to_columns  `[{name, value}]` — `name` is the column
                         header on the destination sheet (created if
                         missing); `value` is what to write per row.

4. KEY NOTES

- Append-only — every run adds a new row at the bottom of the sheet.
  Use `google_sheet_upsert_row` if you need create-or-update by a
  key column.
- Column `name`s that don't exist on the sheet are created as new
  columns at the right edge.
- `value_input_option: "RAW"` is the safe default. Use `"USER_ENTERED"`
  only if you want Google Sheets to interpret formulas, dates, etc.
  from your written values.

5. WHERE IT FITS IN A WORKFLOW

Pattern: enrichment -> google_sheet_add_data (append output to a
sheet).

6. WHEN TO USE

Use google_sheet_add_data for append-only writes to a Google
Sheet.

7. WHEN NOT TO USE

Need upsert by a key column
  -> action-detail/google_sheet_upsert_row.txt

Need to read existing rows
  -> action-detail/google_sheets_lookup_rows.txt

Last updated: 2026-04-28.