> ## Documentation Index
> Fetch the complete documentation index at: https://docs.useparagon.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Update Row



## OpenAPI

````yaml /actionkit/openapi.json POST /projects/{project_id}/tools/#GOOGLE_SHEETS_UPDATE_ROW
openapi: 3.0.0
info:
  title: ActionKit Tools API
  version: 1.0.0
servers:
  - url: https://actionkit.useparagon.com
    description: US Cloud
security: []
paths:
  /projects/{project_id}/tools/#GOOGLE_SHEETS_UPDATE_ROW:
    post:
      summary: Update Row
      parameters:
        - name: project_id
          in: path
          required: true
          schema:
            type: string
            description: >-
              Your Paragon Project ID. You can copy your Project ID from your
              dashboard URL or by clicking Copy Project ID under the Environment
              switcher.
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                tool:
                  type: string
                  default: GOOGLE_SHEETS_UPDATE_ROW
                parameters:
                  type: object
                  properties:
                    spreadsheetId:
                      type: string
                      description: >-
                        The spreadsheet to update a row in. Defaults to using
                        the first worksheet in the selected spreadsheet
                    worksheet:
                      type: string
                      description: 'Worksheet : Your worksheet must have column headers.'
                    filterFormula:
                      type: object
                      description: >-
                        A filter in disjunctive normal form: OR of AND groups of
                        single conditions
                      properties:
                        operator:
                          type: string
                          description: Top-level operator must be OR (DNF enforced)
                          enum:
                            - OR
                        conditions:
                          type: array
                          description: >-
                            Each item is an AND group (a conjunction of single
                            conditions)
                          items:
                            type: object
                            properties:
                              operator:
                                type: string
                                description: Each group is an AND of single conditions
                                enum:
                                  - AND
                              conditions:
                                type: array
                                description: List of single conditions (AND together)
                                items:
                                  type: object
                                  properties:
                                    field:
                                      type: string
                                    operator:
                                      type: string
                                      enum:
                                        - $stringContains
                                        - $stringDoesNotContain
                                        - $stringExactlyMatches
                                        - $stringDoesNotExactlyMatch
                                        - $stringStartsWith
                                        - $stringDoesNotStartWith
                                        - $stringEndsWith
                                        - $stringDoesNotEndWith
                                        - $numberGreaterThan
                                        - $numberLessThan
                                        - $numberEquals
                                        - $numberDoesNotEqual
                                        - $dateTimeAfter
                                        - $dateTimeBefore
                                        - $dateTimeEquals
                                        - $booleanTrue
                                        - $booleanFalse
                                        - $exists
                                        - $doesNotExist
                                    value:
                                      type: string
                                      description: Value to compare against
                                  required:
                                    - field
                                    - operator
                                    - value
                            required:
                              - operator
                              - conditions
                      required:
                        - operator
                        - conditions
                    additionalFields:
                      type: object
                      description: >-
                        Specify fields to update, as an object with keys of
                        Column Names. (example: {
                            columnName1: "columnValue1",
                            columnName2: "columnValue2",
                            columnName3: "columnValue3",
                            columnName4: "columnValue4",
                          })
                      properties: {}
                  required:
                    - spreadsheetId
                    - worksheet
                    - additionalFields
                  x-integration: googlesheets
              required:
                - tool
                - parameters
      responses:
        '200':
          description: Success
      security:
        - BearerAuth: []
components:
  securitySchemes:
    BearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: >-
        Your [Paragon User
        Token](/getting-started/installing-the-connect-sdk#setup) (JWT), which
        you can generate using your project's signing keys.

````