Auto-sync form submissions to Google Sheets
Want form submissions to appear in a Google Sheet automatically? LazyForms has native Google Sheets integration — every submission adds a new row to your spreadsheet. No Zapier, no code, no monthly fees. Set it up once and forget it.
Why Google Sheets?
Google Sheets is the de facto tool for:
- Collaboration — share with your team, everyone sees new submissions instantly
- Filtering and sorting — use Sheets' built-in tools to analyze data
- Charts and reports — visualize submission trends
- Exports — download as CSV, Excel, or PDF
- Formulas — calculate totals, counts, averages on your data
- Integrations — connect Sheets to 1000+ apps via Apps Script or Zapier
It's free, familiar, and powerful.
How to connect Google Sheets
- **Create a Google Sheet** — or use an existing one
- **Share it** — share the sheet with the LazyForms service account email (shown in your form settings)
- **Copy the Sheet URL** — paste it in your form settings under "Google Sheets URL"
- **Save** — that's it. New submissions will append rows automatically.
The first row of your sheet will be used as headers. LazyForms maps form field names to column headers.
How data is mapped
LazyForms uses your form field `name` attributes as column headers:
| Form field name | Sheet column |
|---|---|
| `name` | Name |
| `email` | |
| `message` | Message |
| `_submitted_at` | Submitted At |
If a column doesn't exist for a field, LazyForms adds it automatically. The `_submitted_at` timestamp column is always included.
Example setup
Your HTML form:
<form action="https://api.lazyforms.com/f/YOUR_KEY" method="POST">
<input name="name" placeholder="Name" required />
<input name="email" type="email" placeholder="Email" required />
<input name="company" placeholder="Company" />
<textarea name="message" placeholder="Message"></textarea>
<button type="submit">Send</button>
</form>Your Google Sheet will get columns: Name, Email, Company, Message, Submitted At.
Each submission = one new row.
Tips and limits
- Multiple forms, one sheet — you can point multiple forms at the same sheet. Each form's fields will create their own columns.
- One form, one sheet — recommended for clean data
- Sheets limit — Google Sheets supports up to 10 million cells. At ~5 columns, that's 2 million submissions per sheet.
- Real-time — submissions appear in the sheet within seconds
- No Zapier fees — this is a direct integration, no middleman
- Works with email + webhooks — all three notification methods can run simultaneously
Ready to get started?
Get your form endpoint in seconds. Free forever.
Enter your email to receive your form action URL · No password needed