A Google Sheet is the place a lot of people want form submissions to end up. Everyone on the team can open it, filter it and add a "called back?" column, and nobody has to log in to another tool.
Sheets can't take a form post by itself, though. Something has to receive the submission and write the row. This guide does it two ways: a free Google Apps Script web app you set up yourself, and a form backend that creates the sheet and fills it for you.
1. Option A: Google Apps Script
Set up the sheet
Create a new spreadsheet and type these headers in row 1, one per column:
| timestamp | name | message |
|---|
Each header has to match a field name in your form exactly, including case. That's how the script knows which value goes in which column. The script writes to the first tab.
Add the script
In the sheet, open Extensions → Apps Script, delete what's there and paste this:
function doPost(e) { const data = JSON.parse(e.postData.contents || "{}"); // Honeypot filled in: answer OK so the bot learns nothing. if (data._gotcha) return json({ ok: true }); const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0]; const row = headers.map((header) => { if (header === "timestamp") return new Date(); const value = String(data[header] || "").slice(0, 5000); // A value starting with = + - or @ would run as a formula. The ' keeps it as text. return /^[=+\-@]/.test(value) ? "'" + value : value; }); sheet.appendRow(row); return json({ ok: true }); } function json(data) { return ContentService.createTextOutput(JSON.stringify(data)) .setMimeType(ContentService.MimeType.JSON); } Deploy it as a web app
- Click Deploy → New deployment, then the gear icon and Web app.
- Set Execute as to Me and Who has access to Anyone.
- Click Deploy and allow access. Google shows "Google hasn't verified this app" because the script is yours and unreviewed. Click Advanced, then Go to (your project).
- Copy the Web app URL. It looks like
https://script.google.com/macros/s/AKfy…/exec.
The form
The web app answers on a Google domain, so a plain <form action> would leave your visitor on a page of JSON. Send it with fetch() instead and show the thank-you message on your own page:
<form id="contact"> <input name="name" placeholder="Name" required> <input name="email" type="email" placeholder="Email" required> <textarea name="message" placeholder="Message" required></textarea> <!-- Honeypot: hidden from people, bots fill it in --> <div aria-hidden="true" style="position:absolute; left:-9999px"> <input type="text" name="_gotcha" tabindex="-1" autocomplete="off"> </div> <button type="submit">Send</button> </form> <script> const form = document.getElementById("contact"); form.addEventListener("submit", async (event) => { event.preventDefault(); // No Content-Type header, so the browser sends it as text/plain and skips the CORS preflight. const res = await fetch("https://script.google.com/macros/s/YOUR_DEPLOYMENT_ID/exec", { method: "POST", body: JSON.stringify(Object.fromEntries(new FormData(form))), }); form.replaceWith(res.ok ? "Thanks, we got your message." : "Something went wrong. Please try again."); }); </script> Submit it once and a row should show up in the sheet.
The traps
Most "it stopped working" questions about this setup come down to one of these:
- Edits don't go live on their own. The
/execURL keeps running the version you deployed. After every change, open Deploy → Manage deployments, edit the deployment and pick New version, or you'll be debugging code that isn't running. - Don't set a JSON content type. A
Content-Type: application/jsonheader makes the browser send a CORS preflight first, and Apps Script can't answer it, so the request fails. Leave the header off like the code above. The script parses the body as JSON either way. - Formulas run.
appendRowtreats a value starting with=as a formula, so a visitor can put=IMPORTXML(...)in your sheet. The'prefix in the script stops that. Leave it in. - New fields need a new column. Add a
phonefield to the form and nothing saves it until you add aphoneheader by hand.
What this version doesn't do
For a personal site it's free and it works. What it leaves out:
- Spam. The URL is public and in your page source. Anyone can post to it as often as they like, and the honeypot only stops simple bots. LLM-written sales pitches get through and become rows.
- Notifications. Nobody hears about a new row unless they open the sheet. Emailing yourself means more script (
MailApp) and more quota. - A second copy. If the script errors or the sheet is renamed, the submission is lost and nothing tells you.
- Sorting. Every submission lands in the same sheet. Sending only sales leads there means writing the rules, and deciding which messages are leads.
2. Option B: a form backend that creates the sheet
With Formkove, the form posts to a Formkove URL. Each submission is saved, checked for spam, emailed to you, and added to the sheet as a row.
Point the form at Formkove. Create a form at app.formkove.com and use its endpoint as the action. No script is needed, and the _gotcha honeypot is on by default.
<form action="https://app.formkove.com/api/forms/YOUR_FORM_ID/submissions" method="POST"> Connect Google Sheets. In the form's Integrations, click Connect Google Sheets, then Connect Google, and pick your account. Formkove creates a new spreadsheet in your Drive. Click Test to add a sample row and Open sheet to see it.
Formkove only asks for access to the files it creates, so it can't open your other spreadsheets. You can remove that access in your Google account at any time, and deleting the connection keeps the sheet and its rows.
How the rows look. Each row starts with Submitted at and Submission ID. Every form field gets its own column the first time it shows up, so a new phone field just adds a column. Columns are matched by name, so you can reorder them or add your own (status, notes) and new rows still land in the right place. Values are written as plain text and numbers, so a submitted =IMPORTXML(...) stays text.
Send only some submissions. Describe your tags in plain words on the form's AI & Spam page (for example, sales-lead: wants a quote, a price or to hire us), then add a routing rule to the Sheets connection:
- Tag has any of
sales-lead
Now the sheet only gets leads, with Sentiment and Tags columns next to the fields. Rules can also test any form field, like budget is greater than 5000. Email isn't routed: you still get every real submission by email.
What comes with it:
- Spam held back before anything reaches the sheet, kept in your dashboard for 30 days in case one was a real message.
- Every submission saved, even when Google is down or the sheet was deleted. Failed deliveries are retried and listed in Delivery history.
- Rate limits on every form: 10 a minute and 30 an hour per IP address.
Google Sheets, tags and routing are on the Pro and Agency plans, and Free accounts get them on their first 50 submissions (pricing). Setup details are in the Google Sheets docs.
Originally published on formkove.com.


![[AWS] Examining the differences between AgentCore Memory session summaries and chunks [AgentCore]](https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fqiita-user-contents.imgix.net%252Fhttps%25253A%25252F%25252Fcdn.qiita.com%25252Fassets%25252Fpublic%25252Farticle-ogp-background-afbab5eb44e0b055cce1258705637a91.png%253Fixlib%253Drb-4.1.1%2526w%253D1200%2526blend64%253DaHR0cHM6Ly9xaWl0YS11c2VyLXByb2ZpbGUtaW1hZ2VzLmltZ2l4Lm5ldC9odHRwcyUzQSUyRiUyRnMzLWFwLW5vcnRoZWFzdC0xLmFtYXpvbmF3cy5jb20lMkZxaWl0YS1pbWFnZS1zdG9yZSUyRjAlMkYxOTI5NDklMkYxYmVjZGE4YTRmMWRiOWU5OTQyZDljOGMwYjZkZDA3NjkwMTM2NjgwJTJGbGFyZ2UucG5nJTNGMTc0MTQ4MzQxMD9peGxpYj1yYi00LjEuMSZhcj0xJTNBMSZmaXQ9Y3JvcCZtYXNrPWVsbGlwc2UmYmc9RkZGRkZGJmZtPXBuZzMyJnM9MDZlM2QxY2EzNTVhN2Y4N2M2ZTQxY2RlYzdmN2M0ODI%2526blend-x%253D120%2526blend-y%253D462%2526blend-w%253D90%2526blend-h%253D90%2526blend-mode%253Dnormal%2526mark64%253DaHR0cHM6Ly9xaWl0YS1vcmdhbml6YXRpb24taW1hZ2VzLmltZ2l4Lm5ldC9odHRwcyUzQSUyRiUyRnMzLWFwLW5vcnRoZWFzdC0xLmFtYXpvbmF3cy5jb20lMkZxaWl0YS1vcmdhbml6YXRpb24taW1hZ2UlMkYxZTIwZGI1ZTdlNDA3ZWFlN2I5NzBlYzk5OTg4MGRjOGMzY2MwZjY0JTJGb3JpZ2luYWwuanBnJTNGMTY2NzI3NDk2Mz9peGxpYj1yYi00LjEuMSZ3PTQ0Jmg9NDQmZml0PWNyb3AmbWFzaz1jb3JuZXJzJmNvcm5lci1yYWRpdXM9OCZiZz1GRkZGRkYmYm9yZGVyPTIlMkNGRkZGRkYmZm09cG5nMzImcz04OTI0NDcwMDk1MDMyZjUxYmZlNzE3ZjVkOGUzYmE3ZA%2526mark-x%253D186%2526mark-y%253D515%2526mark-w%253D40%2526mark-h%253D40%2526s%253D0db13b4aef231a19bc684897cf15021a%3Fixlib%3Drb-4.1.1%26w%3D1200%26fm%3Djpg%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjEuMSZ3PTk2MCZoPTMyNCZ0eHQ9JUUzJTgwJTkwQVdTJUUzJTgwJTkxQWdlbnRDb3JlJTIwTWVtb3J5JUUzJTgxJUFFJUUzJTgyJUJCJUUzJTgzJTgzJUUzJTgyJUI3JUUzJTgzJUE3JUUzJTgzJUIzJUU1JTg1JUE4JUU0JUJEJTkzJUU4JUE2JTgxJUU3JUI0JTg0JUUzJTgxJUE4JUUzJTgzJTgxJUUzJTgzJUEzJUUzJTgzJUIzJUUzJTgyJUFGJUUzJTgxJUFFJUU5JTgxJTk1JUUzJTgxJTg0JUUzJTgyJTkyJUU2JUE0JTlDJUU4JUE4JUJDJUUzJTgwJTkwQWdlbnRDb3JlJUUzJTgwJTkxJnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnR4dC1jb2xvcj0lMjMxRTIxMjEmdHh0LWZvbnQ9SGlyYWdpbm8lMjBTYW5zJTIwVzYmdHh0LXNpemU9NTYmdHh0LXBhZD0wJnM9ZmZkODAzOTdkNDVhMjM2ZmYwOTYyMmY0MDBlMGRjYzE%26mark-x%3D120%26mark-y%3D112%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjEuMSZ3PTgzOCZoPTU4JnR4dD0lNDBOYW5hXzc3NyZ0eHQtY29sb3I9JTIzMUUyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTM2JnR4dC1wYWQ9MCZzPTg1YzQ4MzUyMmVkMGVhNmYxYjhkZjU5MjVjYzhiNjQz%26blend-x%3D242%26blend-y%3D454%26blend-w%3D838%26blend-h%3D46%26blend-fit%3Dcrop%26blend-crop%3Dleft%252Cbottom%26blend-mode%3Dnormal%26txt64%3DS0RESeOCouOCuOODo-OCpOODq-mWi-eZuuOCu-ODs-OCv-ODvOagquW8j-S8muekvg%26txt-x%3D242%26txt-y%3D539%26txt-width%3D838%26txt-clip%3Dend%252Cellipsis%26txt-color%3D%25231E2121%26txt-font%3DHiragino%2520Sans%2520W6%26txt-size%3D28%26s%3Da47a097063384428563b7a5c68b429a1)