> ## 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.

# Get Row



## OpenAPI

````yaml /actionkit/openapi.json POST /projects/{project_id}/tools/#GOOGLE_SHEETS_GET_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_GET_ROW:
    post:
      summary: Get 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_GET_ROW
                parameters:
                  type: object
                  properties:
                    spreadsheetId:
                      type: string
                      description: >-
                        The spreadsheet ID to get rows from. Defaults to using
                        the first worksheet in the selected spreadsheet
                    limit:
                      type: string
                      description: 'Limit rows : Limit the maximum number of rows to return.'
                    worksheet:
                      type: string
                      description: >-
                        The worksheet to get rows from. Defaults to using the
                        first worksheet in the selected spreadsheet
                    dateTimeRenderOption:
                      type: string
                      description: >-
                        How dates, times, and durations should be represented in
                        the output. This is ignored if value_render_option is
                        FORMATTED_VALUE. The default dateTime render option is
                        SERIAL_NUMBER.
                    majorDimension:
                      type: string
                      description: >-
                        The major dimension that results should use. For
                        example, if the spreadsheet data in Sheet1 is:
                        `A1=1,B1=2,A2=3,B2=4`, then requesting
                        `range=Sheet1!A1:B2?majorDimension=ROWS` returns
                        `[[1,2],[3,4]]`, whereas requesting
                        `range=Sheet1!A1:B2?majorDimension=COLUMNS` returns
                        `[[1,3],[2,4]]`.
                    range:
                      type: string
                      description: >-
                        The [A1 notation or R1C1
                        notation](/sheets/api/guides/concepts#cell) of the range
                        to retrieve values from.
                    valueRenderOption:
                      type: string
                      description: >-
                        How values should be represented in the output. The
                        default render option is FORMATTED_VALUE.
                  required:
                    - spreadsheetId
                  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.

````