Gmail to Google Sheets: A Racquet Club’s Contact Forms on Autopilot

Overview

Denver Racquet Club needed a way to automatically capture website contact form submissions arriving via Gmail and store them in a structured Google Sheet — eliminating manual copy/paste data entry. The request was to use Google Apps Script only (no third-party tools, no n8n, no Zapier) to keep it native to the Google ecosystem with zero external dependencies.

The Challenge

• Manual copy/paste of contact form submissions from Gmail into spreadsheets
• No visibility into message sentiment or urgency
• No profanity detection for incoming messages
• Requirement to stay fully within the Google ecosystem — no third-party tools

What We Built

• Automated Gmail monitoring with label-based query filtering and duplicate prevention
• Field parsing from Wix form emails — First Name, Last Name, Email, Phone, Message
• Profanity detection with punctuation-aware regex boundaries to avoid false positives
• Sentiment analysis with priority levels (HIGH / MEDIUM / LOW / Neutral) and color-coded rows
• Execution logging to a dedicated Log tab with timestamped status entries
• Runs automatically at 7:00 AM and 7:00 PM daily via time-based triggers
• Auto-built Sentiment Reference sheet for staff training

Technologies Used