Capture Contact Form Submissions
Save unique Contact Us form entries to Google Sheets and notify users and admin, avoiding duplicates for clean records.
Google SheetsEmail NotificationsDuplicate PreventionTelegram Alerts
Capture Contact Us Form Submissions Workflow
This workflow automates processing of Contact Us form submissions by capturing each entry, checking for duplicates, storing unique submissions in a Google Sheet, and sending notifications. It prevents duplicate data entries and repeated alerts.
The workflow performs these steps:
- Receives the form submission through a webhook.
- Captures the current date and time in IST (Asia/Kolkata) timezone.
- Checks for duplicates by comparing the email, message, and submission date against records in Google Sheets.
- If the submission is unique, saves it into a Google Sheet with columns: date, time, name, email, and message.
- Sends a confirmation email to the user.
- Sends a detailed Telegram message to the admin.
Requirements
- Needle platform account with workflow creation access.
- Google Sheets account with read/write permissions to the target spreadsheet.
- Google Sheets connector configured in Needle.
- Email connector (e.g., Gmail) configured for sending confirmation emails.
- Telegram Bot API connector set up with the admin chat ID.
- Contact Us form configured to POST submissions to the Needle webhook URL.
Workflow Details
| Node | Purpose |
|---|---|
| Webhook Trigger | Listens for each Contact Us form submission. |
| AI Processor | Captures IST date/time and performs a strict duplicate check against Google Sheets data. |
| Duplicate Check | Reads all existing rows and looks for an exact match on email, message, and date. |
| Stop on Duplicate | Ends workflow immediately if a duplicate is found. |
| Google Sheets Upsert | Inserts a new row with the submission details if the entry is unique. |
| Send Confirmation Email | Sends a confirmation email to the submitter only if no duplicate is detected. |
| Notify Admin via Telegram | Sends submission details to admin via Telegram if submission is unique. |
Output
Unique submissions are saved in Google Sheets. The user receives a confirmation email, and admin is notified via Telegram. Duplicate submissions are ignored without storage or notifications.
Important Notes
- Duplicate check is mandatory and runs before any data insertion or notifications.
- Date and time are captured once per submission in IST and reused throughout.
- The workflow follows a single linear execution path per submission without retries or loops.
- No notifications or data insertion occur for duplicates.
- The Google Sheet columns must be: date | time | name | email | message in this exact order.
- Ensure the form payload fields match expected names ('name', 'email', 'message').
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.