Google Form Auto-Email Script
Budget: $10 – $30 USD
I already have a Google Form feeding into its linked Sheet. I now need a short Apps Script that will do two things each time a user submits:
• Instantly email me (or any address I specify) a copy of the full submission straight from the Sheet.
• Automatically reply to the user with either a “correct” or “wrong” version of the message, based on logic we will define inside the script.
Both outgoing templates must sit somewhere I can edit later—plain text within the script, in a hidden sheet tab, or any other simple method you recommend—so I won’t have to touch code just to tweak wording.
Deliverables I expect within the one-hour slot:
1. A working Google Apps Script bound to the Form/Sheet that sends the two emails.
2. Clear pointers inside the file showing where to change recipient address, logic for right vs wrong, and the body text of each template.
3. A brief note (can be inline comments or a short doc) explaining how to adjust those elements and re-deploy.
Thanks
• Instantly email me (or any address I specify) a copy of the full submission straight from the Sheet.
• Automatically reply to the user with either a “correct” or “wrong” version of the message, based on logic we will define inside the script.
Both outgoing templates must sit somewhere I can edit later—plain text within the script, in a hidden sheet tab, or any other simple method you recommend—so I won’t have to touch code just to tweak wording.
Deliverables I expect within the one-hour slot:
1. A working Google Apps Script bound to the Form/Sheet that sends the two emails.
2. Clear pointers inside the file showing where to change recipient address, logic for right vs wrong, and the body text of each template.
3. A brief note (can be inline comments or a short doc) explaining how to adjust those elements and re-deploy.
Thanks
Related categories:
PHP
JavaScript
Data Processing
CSS
HTML
Scripting
Web Development
Google Sheets
Automation
API Integration