Publish a Form
Create a public form and track delivery to Google Sheets
Forms turn a connected Sheet into a hosted public intake flow. Each accepted submission is queued for delivery to the connected Google Sheet. If inbox storage is enabled, Sheetfront also keeps submission data available for review in the dashboard.
Create the Form
- Open a connected sheet in the dashboard.
- Go to Forms.
- Click Create First Form or New.
- Choose the fields that should appear publicly.
- Configure required fields, helper text, theme, and submission behavior.
- Click Publish when the preview is ready.
Published forms use /f/{slug} URLs.
Field Mapping
Form fields are based on visible sheet headers. A submission key should match the form field key generated from the sheet header.
| Sheet header | Submission field |
|---|---|
Full Name | full_name |
Email | email |
Company | company |
Notes | notes |
Hidden columns are not shown to public respondents. If you add, rename, hide, or delete columns in Google Sheets, refresh schema before editing the form.
Submit Data
Public form submissions do not require an API key.
export FORMS_BASE_URL="https://forms.sheetfront.com"
curl -X POST \
-H "Content-Type: application/json" \
-d '{"data": {"full_name": "Alex Lee", "email": "alex@example.com"}}' \
"$FORMS_BASE_URL/f/{slug}/submit"Delivery to Google Sheets
Accepted submissions are queued first, then delivered to Google Sheets. This keeps the public form responsive if Google Sheets is temporarily slow or unavailable.
| State | Meaning |
|---|---|
| Pending | Submission was accepted and is waiting for delivery |
| Delivered | A row was appended to Google Sheets |
| Failed | Delivery could not complete and needs attention |
If delivery fails, the submission stays visible in the dashboard so you can inspect the error, fix the sheet connection, or contact support.
Anti-Spam and Limits
Sheetfront applies public form rate limits and bot checks. Some protections and form features depend on the account plan.
| Feature | Availability |
|---|---|
| Classic form layout | Free and higher |
| Multi-step layouts | Starter and higher |
| reCAPTCHA or Turnstile | Starter and higher |
| File uploads | Starter and higher |
| Owner email notifications | Starter and higher |
| Respondent emails | Pro and higher |
| Custom CSS | Pro and higher |
Monthly form submissions count against the account plan. When the account reaches its monthly submission limit, public submissions return a limit error until usage resets or the plan changes.
Free Sandbox can publish a form and accept test submissions, but Google Sheet delivery requires available Google write operations. Starter plans and higher include monthly Google write operations.
Test Before Launch
- Publish the form.
- Submit one test response from the public URL.
- Check the form Submissions tab.
- Confirm the delivery status is Delivered.
- Confirm the row appears in the connected Google Sheet.
- Review analytics for submission errors.