
Completed
Posted
Paid on delivery
I’ve built a simple decision flow called “The Blood Test.” Visitors land on a webpage, click through to a Google Form, choose A, B, or C, and submit. Their choice reaches a linked Google Sheet that should immediately fire three emails, for each case. Everything is set up—the form, the sheet, and a basic Apps Script—yet the sheet keeps mapping the answers to the wrong branch and no messages are sent. My priority is the Google Sheet logic: verifying the onFormSubmit trigger, correcting any mis-read of the A/B/C response, and getting the email routine working every time. You’ll work live through AnyDesk; direct account access isn’t possible. Deliverables • Clean, commented Apps Script (or a new one if needed) inside the sheet • OnFormSubmit trigger that correctly routes choices A, B, C • Automated sending of the three existing email templates, confirmed during the session Once those three points are ticking perfectly, the project is complete. I have done much of the work myself - it should be a simple taks for someone who knows Apps Script, and Triggers. Budget $10.00 We do have a working sample that is somewhat similar. You can get an idea of hte process by doing it - just 30 -secs. [login to view URL] - give it a try. Thanks.
Project ID: 40668911
53 proposals
Remote project
Active 7 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi I can quickly fix your Google Sheets/App Script workflow and get the A/B/C routing working correctly. I’ll verify the onFormSubmit trigger, identify why responses are being misread, correct the branching logic, and ensure the three existing email templates send reliably Thank you Ivan
$10 USD in 7 days
2.1
2.1
53 freelancers are bidding on average $23 USD for this job

Hello, Drawing from 15+ years of extensive experience in web development and automation, I am confident that I can expertly resolve the issues you're facing with Google Sheets and any associated scripting problems. My technical stack includes a deep understanding of JavaScript, which is pivotal for working with Apps Script, Triggers, APIs, and other essential components to get your system fully operational. I have repeatedly proven my aptitude for efficiently troubleshoot, improve and optimize different workflows to deliver calculated results in an automated fashion. I specialize in simplifying complex systems and turning them into scalable, secure, and user-friendly products. So even though my budget is a little higher than your initial offer, this increased cost reflects the breadth of my skills and the speed at which we will be able to resolve these issues together. Moreover, I place great emphasis on maintaining open lines of communication and ensuring client satisfaction through every step of a project. As such, using AnyDesk to work live will allow us to maintain real-time collaboration whilst keeping your account access secure. Choose me for your Google Sheet project, and you'll receive high-quality work that precisely matches your needs in speedy but efficient manner. Let's make “The Blood Test” dependable! Thanks!
$30 USD in 1 day
7.8
7.8

Hi there, I can help you immediately with fixing the Google Sheet logic and ensuring that the email automation works flawlessly. I will verify the onFormSubmit trigger, make the necessary corrections to the routing of responses, and ensure that all three emails are sent as specified. I understand the urgency of this task, and with my experience in scripting and debugging Google Apps Scripts, I will deliver a clean, commented solution that meets your requirements. Your satisfaction is my top priority, and I guarantee high-quality results. Regards, Ali
$10 USD in 1 day
6.4
6.4

Hi there, I write Python automation and scripts, including JavaScript, Web Development, API Integration. For "Fix Google Sheet Email Logic and Issue Emails" I will hand over a script you can run yourself with clear setup notes and error handling. Delivery in 1 days for 12 USD. Can you share any extra details or files so I can confirm the scope? I can start today. Best regards
$12 USD in 1 day
6.4
6.4

Hi, I'm Denis. I've worked with Google Sheets and Apps Script before, especially with form submissions and automation triggers. I understand the issue here is likely in the form response parsing or trigger setup, since the flow itself is straightforward. I'll connect live through AnyDesk, check the Apps Script logic handling the A/B/C responses, verify the onFormSubmit trigger is firing correctly, and ensure the email templates are sent as expected. The goal is to make the routing reliable and confirm the emails go out every time. The main risks are mismatched form field names or incorrect trigger configurations, which we'll fix by inspecting the script step by step. Once the logic is correct and the emails are confirmed, the project will be complete. I can start working right away. Let's connect and discuss the details. Thanks, Denis.
$10 USD in 1 day
6.3
6.3

Hello, I checked your "Fix Google Sheet Email Logic and Issue Emails" project description, it looks like the focus is on delivering a clean, responsive website that works well across all devices. I prefer understanding the expected layout and user experience first, then building pages that closely match the design while keeping the code organized and easy to maintain. Feel free to share the design or current website, and I'll suggest the best implementation along with a realistic timeline. Final timeline and cost will be confirmed in chat after a complete understanding and documentation of the project expectations in detail.
$12 USD in 1 day
6.5
6.5

Hi,I can fix the existing Google Form → Sheet → Apps Script flow and make sure each A/B/C response routes to the correct branch every time. I’ll verify the onFormSubmit trigger, correct the response mapping, and test all three email templates live through AnyDesk. I’ll keep the script clean and commented so you can maintain it easily afterward.
$15 USD in 1 day
6.0
6.0

Hi Sir, It takes 1~2hours to fix it.I have 7 years experience in Google Sheet, automation and worked with 131 clients here. Let’s connect
$20 USD in 1 day
5.5
5.5

I've debugged Google Apps Script workflows with onFormSubmit triggers and Sheet-based routing before, so this is in my wheelhouse. I’ll open the Sheet, inspect the current script, verify the trigger setup, and test the A/B/C parsing logic to confirm it matches the column mapping. Then I’ll refactor the email dispatch to use the existing templates and run live validation during the AnyDesk session to ensure each branch fires correctly. After confirmation, I’ll document the final script inline and leave the trigger active. I can start immediately. Thanks, Andrii.
$20 USD in 1 day
5.3
5.3

Being an expert in API integration and automation with a strong command of JavaScript, I am confident I can tackle your Google Sheet email logic issue effectively. I understand the intricacies of building and troubleshooting systems integrated with multiple platforms, which makes me the perfect fit for your project. Over years of my career, I have successfully developed solutions similar to yours leveraging Google Forms and Sheets with Apps Scripts even more sophisticated APIs. Moreover, your tight budget is not a problem for me since I'm more focused on delivering value and solidifying long-term client relationships than justifying my work with monetary terms. In fact, I have impeccably engineered several cost-effective projects such as this for clients who are still appreciating my ability to keep their processes running without constant manual fixes. To summarize, my specialty lies in creating seamless workflows between platforms using APIs, addressing misrouting issues skillfully, and making sure email sequences are sent out as intended. My commitment to clear communication helps me understand my clients' actual needs. Hence, after meticulously analyzing your project's requirements, I can deliver an efficient Google Sheet system that automates those three emails correctly each time choices A, B, or C are submitted via the Google Form you've set up. Let's get it done!
$20 USD in 2 days
4.9
4.9

Hi - Truong here "ONFORM SUBMIT A/B/C EMAIL ROUTING" — the sheet is reading the choice incorrectly and the trigger is not firing the right emails. I’d first verify the installed trigger and the exact form-response column, then test A, B and C separately so the routing and all three existing templates are confirmed live. I’ll keep the Apps Script clean and commented so it’s easy to maintain. Can you confirm whether the three emails should send to the form submitter, or to fixed recipient addresses? Looking forward to working with you.
$20 USD in 1 day
4.8
4.8

Hi, I can see the issue is in the Google Sheet logic, not the form itself: the A/B/C response is being misread, and the trigger isn’t reliably sending the three emails. I’ve worked with Google Sheets, Apps Script, and onFormSubmit triggers to clean up branching logic, correct value parsing, and make email automations fire consistently. I’d start by checking the submitted cell value, the trigger setup, and the existing template calls, then tighten the script so each branch maps exactly to A, B, or C. Since you already have most of it built, I’ll focus on fixing what’s there, commenting the code clearly, and confirming the full flow live through AnyDesk until the three emails send as expected. If you’d like, I can get this sorted quickly. Best regards, Gabriel
$100 USD in 1 day
4.6
4.6

Hello, I checked your project "Fix Google Sheet Email Logic and Issue Emails" and already have a clear understanding of your requirements and how to deliver them efficiently. I have solid experience in JavaScript, Web Development, and I've successfully completed similar projects by delivering high-quality, scalable, and reliable solutions. Why choose me? * Strong expertise in JavaScript, Web Development * Clean, optimized, and scalable implementation * Fast communication and regular progress updates * Focused on delivering results, not just completing the task I'm ready to start immediately and would be happy to discuss the details. Best regards, Umer
$25 USD in 1 day
4.0
4.0

Easy peasy. The issue with the A/B/C routing logic and the onFormSubmit trigger is probably a straightforward fix. I will do it for 10$ - pay me whatever you want if you are happy with the result. However, I do not work over AnyDesk. I suggest adding me directly to the project workspace or sharing the Google Sheet and Apps Script with the appropriate permissions. I think it is possible to grant this access securely so I can fix the script and verify the email templates without needing remote desktop sharing. Let me know
$10 USD in 7 days
4.0
4.0

Hi-Abror Here From Uzbekistan. "Fix Email Automation Logic" - I can repair your Google Apps Script using triggers, debugging, and workflow automation methods. I can review the form submission logic, correct A/B/C response mapping, and configure reliable email automation through Apps Script triggers with proper testing during your session. I will deliver clean commented scripts, verify onFormSubmit behavior, test all branches, and confirm that existing email templates are sent correctly after each submission. Can you share the current Apps Script and sheet structure before the AnyDesk session? Looking forward to working with you.
$100 USD in 7 days
3.3
3.3

Hello, I understand that your Google Form → Google Sheet → Apps Script workflow is already mostly built, but the A/B/C response is being mapped incorrectly and the email automation is not firing. I can troubleshoot the setup live through AnyDesk and: • Inspect the Form response columns and identify the incorrect A/B/C mapping. • Verify the onFormSubmit trigger, event object, permissions, and execution flow. • Correct the script so each A, B, or C submission reliably routes to the correct branch. • Connect each branch to the appropriate existing email template and recipients. • Add clear comments to the final Apps Script for easy future maintenance. • Test the complete workflow with live submissions and confirm the correct emails are delivered. I have strong experience with Google Apps Script, Forms, Sheets, triggers, event objects, conditional logic, and automated email workflows. I’ll troubleshoot the actual cause rather than simply hard-code a temporary fix, while preserving your existing setup wherever possible. I’m available immediately and can work entirely through AnyDesk without requiring direct account access. I can also review your working sample to quickly understand the intended process. I’m happy to work within your $10 budget for this focused troubleshooting task. Best Regards, Sajjad
$30 USD in 1 day
3.3
3.3

Hello! How are you doing? I've been developing as a full stack for more than a 5 years now, and as a Computer Science graduate I know how to do your project and I do have all the required skillset. I've already made a project similar to yours, so it would be awesome to work in a project like this again and be capable of help you have a software that it's able to function in the way you need!! Can you enter in contact so we can discuss the project? Thanks!
$20 USD in 1 day
3.0
3.0

Hi, ensuring accurate routing of responses in your Google Sheet is crucial for maintaining the integrity of your email notifications. I’d start by reviewing your existing Apps Script to pinpoint where the logic is misaligned with the A/B/C responses and ensure the onFormSubmit trigger is firing correctly. After that, I’ll set up the email functionality to automatically send out the corresponding templates based on user selections. This should take around an hour or two to complete, allowing for testing to ensure everything works seamlessly. Do you have specific email templates ready, or would you like to go over them during the session? Also, are there any particular error messages or issues you've noticed that could help me troubleshoot the script? I’ve worked on similar Google Sheets and Apps Script integrations, so I’m confident I can get this sorted out for you. Let’s get started! Best, Mohammad
$60 USD in 1 day
2.4
2.4

Hi, I can quickly troubleshoot and fix the Google Apps Script and onFormSubmit trigger. I’ll verify the A/B/C response mapping, correct the routing logic, and make sure all three email templates fire reliably on submission. I’m comfortable working live through AnyDesk and can test each branch with you before wrapping up. This should be a straightforward fix, and I can get it working cleanly without overcomplicating the existing setup. Thanks!~ Dennis
$20 USD in 1 day
2.5
2.5

Hey — saw your post about fixing Google Sheet email logic for “The Blood Test” flow. Email triggers often fail when the sheet formulas or script timing aren’t aligned, causing missed or duplicate emails. Quick question: Are you using Google Apps Script for sending emails, or a third-party add-on? I’ve solved similar timing and logic issues in Sheets before to ensure reliable email sending. Send over your script or a sample sheet, and I’ll take a look.
$20 USD in 7 days
0.9
0.9

██╗░░██╗██╗██████╗░███████╗ ███╗░░░███╗███████╗ ██║░░██║██║██╔══██╗██╔════╝ ████╗░████║██╔════╝ ███████║██║██████╔╝█████╗░░ ██╔████╔██║█████╗░░ ██╔══██║██║██╔══██╗██╔════╝░ ██║░╚═╝░██║██╔══╝░░ ██║░░██║██║██║░░██║███████╗ ██║░░░░░██║███████╗ ╚═╝░░╚═╝╚═╝╚═╝░░╚═╝╚══════╝ ╚═╝░░░░░╚═╝╚══════╝ I can fix your “The Blood Test” workflow directly through AnyDesk without needing account access. The issue sounds like a focused Apps Script/trigger debugging task, and I’ll trace the submitted A/B/C value from the form event into the Sheet and email logic rather than patching blindly. My approach: ✅ Inspect the existing Apps Script and form-response structure ✅ Correct the A/B/C branching and column/value mapping ✅ Verify and repair the installable onFormSubmit trigger ✅ Fix the three email routes and preserve your existing templates ✅ Add clear logging/error handling so failed submissions are easy to diagnose ✅ Run live test submissions for A, B and C and confirm the correct emails fire I’ll work within your existing setup and keep the solution simple, reliable, and maintainable. Your 30-second sample also gives me a useful reference for validating the intended flow. I can complete this live in one focused session within your $10 budget.
$10 USD in 7 days
0.0
0.0

Milpitas, United States
Payment method verified
Member since Mar 29, 2026
$8-15 USD / hour
$10-30 USD
$10-30 USD
$10-30 USD
$10-30 USD
$30-250 USD
€250-750 EUR
$2-8 USD / hour
₹600-1500 INR
$10-30 USD
₹37500-75000 INR
$30-250 USD
$10-30 USD
$30-250 USD
$250-750 USD
₹12500-37500 INR
$750-1500 USD
$300-400 USD
$3000-5000 USD
₹1500-12500 INR
$250-750 USD
$250-750 USD
€2-6 EUR / hour
$10-30 USD
$250-750 USD