sheetforms.co
An open API to save your forms data to a Google Spreadsheet.
How to use?
Make a POST
request to https://sheetforms.co/api
like this:
async function handleSubmit() {await fetch("https://sheetforms.co/api", {method: "POST",headers: { "Content-Type": "application/json" },body: JSON.stringify({spreadsheetId: "YOUR_SPREADSHEET_ID",values: ["ADD", "SOME", "DATA", "HERE"],}),});}
And remember to set sheetforms.co as Editor
in your spreadsheet sharing options.
# sheetforms.co client emailsheetforms@sheetforms.iam.gserviceaccount.com
🥳 That's it.
Example
Submit the following form and check this spreadsheet.
API
The API takes a POST
request with the following body
:
spreadsheetId
: The ID of the spreadsheet to save the data to.values
: An array of values to save to the spreadsheet.range
: (optional) The range to save the data to.