mantenasud/google-sheets-contact-form

Google Sheets Contact Form Handler is a tool for website owners who want to capture contact form submissions without relying on a paid plugin or third-party service. It uses Google Apps Script, a free scripting platform built into Google's own suite of tools, to act as a bridge between an HTML form on your website and a Google Sheet where responses get saved. When someone fills out your contact form and submits it, the script receives that data, adds a new row to your designated Google Sheet with the timestamp, name, email, phone number, website, and description, and sends you an email notification right away. This means you know immediately when someone gets in touch, and every submission stays organized in one place for easy review later. Setup involves creating a Google Sheet with the correct column headers, pasting the script into Google Apps Script, setting your notification email address, and deploying the script as a web app. Once deployed, you paste the resulting URL into your website's form code so submissions are routed to the right place. A one-time step grants the script permission to send Gmail notifications on your behalf. A few practical protections are built in: rate limiting prevents a single email address from submitting the form more than five times within a rolling 60-minute window, and there is a fix that stops phone numbers from being misread as formulas inside Google Sheets. The script has no external dependencies, since it runs entirely on Google's own infrastructure, so there are no extra accounts or paid services to set up. This suits personal websites, small business sites, or any project where straightforward, free contact form handling is wanted without installing a plugin.