API Reference
Check out this live example to see how to use SpreadAPI from a browser application.
Get multiple rows
POST
https://script.google.com/macros/s/SCRIPT_ID/exec/
Return list of rows. Empty rows are skipped. Each row has an _id field which is equal to row number in Google Sheets.
Request Body
Get single row
POST
https://script.google.com/macros/s/SCRIPT_ID/exec/
Request Body
Insert row
POST
https://script.google.com/macros/s/SCRIPT_ID/exec/
Adds a row to the end of sheet. To add multiple rows pass an array of objects e.g.:
Request Body
Update row
POST
https://script.google.com/macros/s/SCRIPT_ID/exec/
Update content of a single row. To update multiple rows pass an array of objects e.g.:
Request Body
Remove row
POST
https://script.google.com/macros/s/SCRIPT_ID/exec/
Clear a single row. Notice, that the row is not physically removed so that ids of the following rows don't change.
To remove multiple rows pass an array of objects e.g.:
Request Body
Last updated