---
title: "Upload rows to Google Sheet"
method: POST
path: "/api/v1/gdrive/upload-gsheet-from-rows"
tags: ["Integrations"]
---

# Upload rows to Google Sheet

`POST /api/v1/gdrive/upload-gsheet-from-rows`

Upload client-supplied rows to a new Google Sheet (data apps).

## Request body

- UploadGsheetFromRows
  - `rows` GsheetRow[], required
  - `columns` GsheetColumn[], required
    - `type` 'string' | 'number' | 'date' | 'timestamp' | 'boolean'
    - `label` string
    - `key` string, required
  - `title` string, required
  - `projectUuid` string, required

## Response `200`

Success

- ApiJobScheduledResponse
  - `results` object, required
    - `jobId` string, required
  - `status` 'ok', required

## Other responses

- `default` — Error

---

[API](https://skmtc.net/lightdash/apis/lightdash-api.md) · [All operations](https://skmtc.net/lightdash/apis/lightdash-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/lightdash/lightdash-api/versions/40c933755c9a/schema)