A simple Email Subscription Form that collects user email addresses, shows a successful submission message, and stores the emails directly into Google Sheet (Sheet1, first column) using Google Apps Script.
This project uses Google Sheets as a lightweight backend database for easy email management.
- Collects user email addresses
- Shows success message after submission
- Stores emails in Google Sheet → Sheet1
- Emails are saved in the first column (Column A)
- Uses Google Apps Script as backend
- Simple and clean UI
- Easy to integrate into any website
- HTML
- CSS
- JavaScript
- Google Sheets
- Google Apps Script
- User enters an email address in the subscription form
- JavaScript sends the email to Google Apps Script
- Apps Script saves the email in Sheet1 (Column A)
- A success message is displayed to the user
- Create a new Google Sheet
- Rename the sheet to Sheet1
- Go to Extensions → Apps Script
- Add a script to receive and store the email
- Deploy the script as a Web App
- Use the Web App URL in your JavaScript file
- Newsletter subscriptions
- Landing pages
- Marketing campaigns
- Email collection forms