Insert

Inserts row(s) in the spreadsheet. The keys inside the object should be the column names, and the values will be filled in the spreadsheet. The rows will be added at the end of the sheet.

POST https://api.sheet2db.com/v1/{connection-id}

Request Body

Content type: application/json or application/x-www-form-urlencoded

The body should consist of either a single object or an array of objects, designed for insertion into a spreadsheet. Each object should contain keys corresponding to the column names of the spreadsheet.

Query Parameters

sheet string (Optional)

Specify the name of the sheet (tab) you wish to select within your Google Spreadsheet.

Example Request

curl -X POST https://api.sheet2db.com/v1/{connection-id} \
     -H "Content-Type:application/json" \
     -d '{"id":"10","name":"Mark","age":10}'

Example Response

 
{inserted:1}