Get the code
Fork or download the repository from GitHub:Or click Fork on GitHub to create your own copy under your account.
Create your Google Sheet and deploy the Apps Script
- Go to sheets.google.com and create a new spreadsheet.
- Rename the first sheet tab to
RSVP_responses. - Copy the Sheet ID from the URL — it’s the long string between
/d/and/edit: - In your spreadsheet, open Extensions → Apps Script.
- Replace all existing code with the contents of
google-apps-script.jsfrom this repo. - Find the
SHEET_IDvariable near the top of the script and replace the placeholder with your Sheet ID:google-apps-script.js - Find the
sendEmail()function and update thejohnnyEmailvariable with your own address:google-apps-script.js - Click Save, then run the
setup()function to initialize headers and formatting. - Click Deploy → New deployment → Web app. Set:
- Execute as: Me
- Who has access: Anyone
- Click Deploy, authorize permissions, and copy the Web app URL.
Connect the website to your Apps Script
Open
script.js and replace the URL in the submitForm() function with your web app URL:script.js
Customize your wedding details
Open Date and time:Venue:
index.html and update the following:Couple names (hero section):index.html
index.html
index.html
The Love Story section, gallery images, and Wedding Details cards also contain content to personalize. See Wedding Details for the full guide.
Update the countdown timer date
Open Replace
script.js and set your actual wedding date and time:script.js
Oct 25, 2025 17:30:00 with your wedding date in the same format.Next steps
Setup Guide
Detailed Google Sheets and Apps Script configuration
Customization
Personalize every section of your invitation
Styling
Change colors, fonts, and images
Troubleshooting
Solutions to common setup issues