Contact Form for Google Sheets
Free HTML contact form template that sends submissions directly to Google Sheets. No backend server, no PHP, no database required. Just copy, paste, and connect.
β¨ Live Demo
Try the form below to see how it works:
π Copy-Paste Code
1<!-- Contact Form for Google Sheets -->
2<form action="https://api.sheetmonkey.io/form/YOUR_FORM_ID" method="post" class="contact-form">
3 <div class="form-group">
4 <label for="name">Name *</label>
5 <input type="text" id="name" name="Name" required placeholder="Your name" />
6 </div>
7
8 <div class="form-group">
9 <label for="email">Email *</label>
10 <input type="email" id="email" name="Email" required placeholder="your@email.com" />
11 </div>
12
13 <div class="form-group">
14 <label for="message">Message *</label>
15 <textarea id="message" name="Message" rows="5" required placeholder="Your message..."></textarea>
16 </div>
17
18 <!-- Honeypot spam protection (keep hidden) -->
19 <input type="text" name="_honeypot" style="display:none" />
20
21 <button type="submit">Send Message</button>
22</form>
23
24<style>
25 .contact-form {
26 max-width: 500px;
27 margin: 0 auto;
28 padding: 20px;
29 }
30 .form-group {
31 margin-bottom: 20px;
32 }
33 .form-group label {
34 display: block;
35 margin-bottom: 8px;
36 font-weight: 600;
37 color: #374151;
38 }
39 .form-group input,
40 .form-group textarea {
41 width: 100%;
42 padding: 12px;
43 border: 1px solid #d1d5db;
44 border-radius: 6px;
45 font-size: 16px;
46 }
47 .form-group input:focus,
48 .form-group textarea:focus {
49 outline: none;
50 border-color: #990000;
51 box-shadow: 0 0 0 3px rgba(153, 0, 0, 0.1);
52 }
53 .contact-form button {
54 width: 100%;
55 padding: 12px 24px;
56 background: #990000;
57 color: white;
58 border: none;
59 border-radius: 6px;
60 font-weight: 600;
61 cursor: pointer;
62 }
63 .contact-form button:hover {
64 background: #770000;
65 }
66</style>π Setup Instructions (3 Easy Steps)
Copy the HTML code above
Click the "Copy Code" button to copy the complete contact form HTML to your clipboard.
Create a Google Sheet
Create a new Google Sheet where you want to receive contact form submissions. Add column headers that match your form fields: Name, Email, Message
Connect to Sheet Monkey
Sign up for Sheet Monkey (free forever plan available) and connect your Google Sheet. You'll get a form endpoint URL that looks like: https://api.sheetmonkey.io/form/abc123
Replace YOUR_FORM_ID in the form code with your actual form ID, then paste the form into your website.
π What is a Contact Form for Google Sheets?
A contact form for Google Sheets is a web form that sends submissions directly to a Google Spreadsheet without requiring a backend server, database, or complex integrations. Instead of traditional form processors that store data in proprietary systems, this approach uses Google Sheets as your form backend β giving you instant access to submissions in a familiar, shareable format.
This streamlined solution eliminates the need for PHP scripts, Node.js servers, or third-party form services. When a visitor fills out your contact form, their message is automatically appended as a new row in your Google Sheet, complete with timestamps and all form field data. You can then sort, filter, analyze, or export your contact form submissions just like any other spreadsheet data.
Why Use Google Sheets as a Form Backend?
- No server required: Deploy forms on static sites (GitHub Pages, Netlify, Vercel) without backend infrastructure
- Real-time access: View form submissions instantly in Google Sheets from any device
- Easy collaboration: Share your contact form responses with team members using Google Sheets permissions
- Powerful analysis: Use spreadsheet formulas, pivot tables, and charts to analyze contact patterns
- Free data storage: Google Sheets provides 15GB free storage β enough for millions of form submissions
- Integration-ready: Connect Google Sheets to Zapier, Make, or Google Apps Script for automated workflows
- Export flexibility: Download contact data as CSV, Excel, or PDF whenever needed
Whether you're building a portfolio site, small business website, or landing page, a contact form that saves to Google Sheets gives you the simplicity of a spreadsheet database with the power of automated form processing β all without writing a single line of backend code.
β Frequently Asked Questions
Do I need a backend server for this contact form?
What should be included in a contact form?
Is this contact form free to use?
Can I customize the contact form design?
Does this work on mobile devices?
Can I get email notifications when someone submits the form?
Does the contact form have spam protection?
Can I use this contact form with WordPress, Webflow, or Squarespace?
Where is my contact form data stored?
Can I see contact form submissions in real-time?
π¨ Customization Guide
Add or Remove Fields
To add a new field (like "Phone" or "Company"), copy an existing form-group div and change the name:
<div class="form-group">
<label for="phone">Phone</label>
<input type="tel" id="phone" name="Phone"
placeholder="555-1234" />
</div>Change Colors
Update the button and focus colors by changing the CSS:
.contact-form button {
background: #990000; /* Change to your brand color */
}
.form-group input:focus {
border-color: #990000; /* Match your brand */
}Add Email Notifications
Get instant email notifications when someone submits your form. In your Sheet Monkey dashboard, enable email notifications and add your email address. You'll receive an email every time the form is submitted.
Learn more about notifications βEnable Spam Protection
The template includes honeypot spam protection by default (the hidden _honeypot field). For advanced protection, you can add reCAPTCHA or enable Sheet Monkey's built-in spam filtering.
π‘ Perfect For
Business Websites
Let customers contact you without needing a complex backend.
Support Requests
Track support inquiries in a Google Sheet for easy management.
Lead Generation
Capture leads and automatically sync them to your CRM via Google Sheets.
Portfolio Sites
Let clients contact you about projects without email clutter.
School Websites
Accept parent inquiries and store them in an organized spreadsheet.
Event Pages
Collect event questions and feedback in one central location.
Ready to Use This Form?
Get your Sheet Monkey form endpoint in 2 minutes. Free forever plan includes 100 submissions/month.