---
title: "Append to a sheet data from another sheet"
method: POST
path: "/dataset/{handle}/append/from-sheet/{from-handle}/by-name"
tags: ["data"]
---

# Append to a sheet data from another sheet

`POST /dataset/{handle}/append/from-sheet/{from-handle}/by-name`

## Request

- Base URL: `//api.gigasheet.com` (relative, and the document’s source URL is not known)
- URL: `//api.gigasheet.com/dataset/{handle}/append/from-sheet/{from-handle}/by-name`
- Auth: API key in header `X-GIGASHEET-TOKEN`
- TypeScript: <https://skmtc.dev/freshdesk/apis/gigasheet-api/docs/dataset/:handle/append/from-sheet/:from-handle/by-name/post.ts> (a function with typed inputs; its response is checked against the schema)

Append data from a source sheet to the target sheet. Uses column names rather than ids.
Matches columns from the source sheet to the target sheet based on column names.

## Path parameters

- `handle` string, required
- `from-handle` string, required

## Request body

- AppendrowsAppendFromSheetRequest
  - `add_unmatched_columns` boolean: Whether to add any unmatched source sheet columns as new columns in the target sheet.
  - `case_insensitive` boolean: Whether to ignore letter case in column names.
  - `trim_column_names` boolean: Whether to ignore leading and trailing spaces in column names.

## Response `200`

OK

- StructsResponse
  - `Message` string
  - `Success` boolean

## Other responses

- `400`: Bad Request
- `401`: Unauthorized
- `403`: Forbidden
- `500`: Internal Server Error

---

[API](https://skmtc.dev/freshdesk/apis/gigasheet-api.md) - [All operations](https://skmtc.dev/freshdesk/apis/gigasheet-api/llms.txt) - [OpenAPI document](https://skmtc.dev/freshdesk/apis/gigasheet-api/revisions/d1e5cbb24557?raw)