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 email
sheetforms@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.

sheetforms.co

Built with Gatsby and Vercel.