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

# Add Row

> Appends one or more rows to the bottom of the worksheet. Supports both a single object or an array of objects for bulk addition.



## OpenAPI

````yaml POST /{endpointNamespace}/{projectName}/{tabSlug}
openapi: 3.0.3
info:
  title: Sheet Ninja API
  description: >-
    The official API for Sheet Ninja, turning Google Sheets into RESTful
    endpoints. Supports hierarchical routing, bulk operations, and camelCase
    header mapping.
  version: 1.0.0
  contact:
    name: Sheet Ninja Support
    url: https://sheetninja.io
servers:
  - url: https://api.sheetninja.io
    description: Production Server
security: []
paths:
  /{endpointNamespace}/{projectName}/{tabSlug}:
    parameters:
      - name: endpointNamespace
        in: path
        required: true
        description: Your unique user namespace (e.g., c01c052...)
        schema:
          type: string
      - name: projectName
        in: path
        required: true
        description: The slugified name of your project
        schema:
          type: string
      - name: tabSlug
        in: path
        required: true
        description: The slugified name of the specific worksheet (tab)
        schema:
          type: string
    post:
      tags:
        - Rows
      summary: Add Row(s)
      description: >-
        Appends one or more rows to the bottom of the worksheet. Supports both a
        single object or an array of objects for bulk addition.
      requestBody:
        required: true
        content:
          application/json:
            schema:
              oneOf:
                - type: object
                  additionalProperties: true
                  description: A single row object representing the columns in your sheet
                - type: array
                  items:
                    type: object
                    additionalProperties: true
                  description: An array of row objects for bulk append operations
      responses:
        '201':
          description: Rows successfully added
          content:
            application/json:
              schema:
                type: object
                properties:
                  added:
                    type: integer
                    description: >-
                      The total number of rows successfully appended to the
                      sheet
                  warning:
                    type: string
                    description: >-
                      Any non-critical issues encountered during the append
                      operation
                  ignored_keys:
                    type: array
                    items:
                      type: string
                    description: >-
                      A list of keys provided in the request that did not match
                      any header in the worksheet
        '400':
          $ref: '#/components/responses/BadRequestError'
        '401':
          $ref: '#/components/responses/UnauthorizedError'
        '402':
          $ref: '#/components/responses/PaymentRequiredError'
        '403':
          $ref: '#/components/responses/ForbiddenError'
        '404':
          $ref: '#/components/responses/NotFoundError'
        '429':
          $ref: '#/components/responses/RateLimitError'
        '500':
          $ref: '#/components/responses/ServerError'
      security:
        - bearerAuth: []
        - {}
components:
  responses:
    BadRequestError:
      description: >-
        The request was invalid (malformed JSON, invalid rowId, or system limits
        reached).
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    UnauthorizedError:
      description: Authentication failed, token is missing.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    PaymentRequiredError:
      description: Row quota exceeded (Subscription or Credits).
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    ForbiddenError:
      description: >-
        Invalid token, insufficient permissions, or the project/operation is
        disabled.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    NotFoundError:
      description: The requested namespace, project, tab, or row was not found.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    RateLimitError:
      description: Google Sheets API rate limits exceeded.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    ServerError:
      description: An unexpected internal server error occurred.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
  schemas:
    ErrorResponse:
      type: object
      description: Standardized error structure returned for non-2xx responses
      properties:
        error:
          type: string
          description: The machine-readable error code
          enum:
            - not_found
            - unauthorized
            - forbidden
            - disabled
            - invalid
            - conflict
            - quota_exceeded
            - google_token_invalid
            - google_unsupported_document
            - google_rate_limit_exceeded
            - google_permission_denied
            - google_sheet_not_found
            - google_timeout
            - internal_server_error
            - encoding_failed
        message:
          type: string
          description: A human-readable explanation of what went wrong
        data:
          type: object
          nullable: true
          description: Optional additional context or metadata regarding the error
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: API Token
      description: >-
        The Bearer Token associated with your endpoint. This is only required if
        you have enabled protection for this endpoint.

````