API Reference

Append to a sheet data from another sheet

post
https://api.gigasheet.com/dataset//append/from-sheet//by-name

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.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Path Params
string
required

Handle of the target sheet

string
required

Handle of the source sheet

Body Params

Append options

boolean

Whether to add any unmatched source sheet columns as new columns in the target sheet.

boolean

Whether to ignore letter case in column names.

boolean

Whether to ignore leading and trailing spaces in column names.

Responses

Updated about 2 years ago

Language
Credentials
Header
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json

Updated about 2 years ago