Formstar is a serverless form backend library for Google Apps Script that makes handling form submissions from static websites easy. Formstar is a fork of the FormEasy project with support for Cloudflare Turnstile CAPTCHAs, enhanced support for reCAPTCHA v3, TypeScript source code, and various other optimizations.
Google Apps Script ID: 1-0U5H6zqVyAnYjBekxDYvx8PoWdSHjf6L6m_GKMK4wE96-Z-9PVtyemi
- Create a new Google Sheets file within Google Drive - this is where your form data gets stored
- In the Sheets menu bar, click Extensions > Apps Script
- In the left sidebar of the Apps Script project, click on the
Libraries - Add the above
Google Apps Script IDabove, click on theLook upbutton, and select the latest version (either the latest numeric version for a stable release orHEAD (Development mode)to always receive the latest changes as soon as possible), then click on theAddbutton.
Your new Apps Script project can now use the Formstar JavaScript object.
Clear the contents of the Apps Script editor, and add the below function, replacing <SETTINGS>
with any combination of the options specified below.
const doPost = req =>
Formstar.action(req, {
<SETTINGS>
});| Setting | Description | Default Value |
|---|---|---|
sheetName |
The name of the sheet within the target spreadsheet to which form submissions should be written. If empty, uses the default sheet within the target spreadsheet. | '' |
emailSubject |
The subject line of emails sent to the address specified by the email setting. Has no effect if email is not configured or set to an empty string. |
'New Form Submission' |
fields |
The header fields of the target sheet that records form submissions. If not already present in the sheet, Formstar will write them to the first row of the sheet. | ['name', 'email', 'message'] |
captcha |
Settings for configuring recommended spam protection. reCAPTCHA v2, reCAPTCHA v3, and Cloudflare Turnstile (types recaptcha for either v2 or v3, and cloudflare_turnstile) are supported. For reCAPTCHA v3, you may set the numeric data.reCaptchaV3MinScore attribute to the minimum reCAPTCHA v3 score for which submissions should be accepted. Note that you must configure a reCAPTCHA or Turnstile project that supplies site and secret keys to use this capability. |
<NONE> |
Example
const doPost = req =>
Formstar.action(req, {
emailSubject: 'New Form Submission from My Site',
email: '[email protected]',
fields: ['name', 'email', 'phone', 'birthday', 'message'],
captcha: {
type: 'cloudflare_turnstile',
data: {
secretKey: '<TURNSTILE_SECRET_KEY_HERE>'
}
}
});After adding the above function click the Deploy button at top right corner and select New deployment and select type to Web app from the gear icon.
Select the below options:
- Description (optional),
- Execute as
Me (<YOUR EMAIL>) - Who has access
Anyone
Click on the Deploy button (authorize the script if you haven't already), and you will get a URL under Web app.
Copy that URL and use it as the endpoint for submitting POST requests from your frontend form(s).
Note: You don't need to repeat this process every time you make changes if you want to use the same web app URL. Select Manage deployments and update the version to keep the same URL.