Send a Gmail update when a Google Sheets issue is marked resolved
Automatically email the requester when an issue’s status changes to “solved”, then update the Google Sheets row so the notification is only sent once.
By Gourav Choudhary
Installed by 1 users
- solved mail not sentSend MailUpdate Spreadsheet Row
- ifcbyEbILhN4
Send a Gmail update when a Google Sheets issue is marked resolved
Send a Gmail update when a Google Sheets issue is marked resolved
Introduction
Track support issues in Google Sheets and keep customers informed automatically. When an issue is updated to solved, this workflow sends a resolution email via Gmail and then updates the sheet to record that the email was sent.
Benefits
- Automatically notifies customers as soon as their issue is resolved
- Prevents duplicate emails by checking an “is mail sent?” flag before sending
- Keeps your Google Sheets tracker accurate by writing back the sent status
- Saves time for support teams by eliminating repetitive follow-ups
Trigger Event
When a row is added or updated in Google Sheets (your issue tracker sheet).
Actions
- Check the issue status and email flag: If the row’s
statusissolvedandis mail sent?isno, continue. - Send the resolution email (Gmail): Email the requester using the
emailvalue from the row, with a ready-to-send “issue resolved” message. - Update the same Google Sheets row: Mark
is mail sent?as sent (so the workflow won’t email again for the same resolved issue). - If conditions aren’t met: The workflow skips sending and makes no changes.
Can't find the right template?
Start with AI
Frequently Asked Questions
This template automates a specific workflow by connecting multiple apps and removing manual steps. It’s useful for anyone who wants to save time, reduce errors, and streamline repetitive tasks using automation.
No. You can install and customize this template without writing any code. Everything is done through simple configuration.
Only the apps shown on the template page are required. You can customize messages, add or remove steps, apply conditions, connect more apps, and add extra actions like notifications, data updates, or triggering other automations.
Yes. Once configured, it can be used for live workflows and production systems. You can also duplicate the template and customize it for different teams or processes.
Most templates can be set up in just a few minutes. You can pause, edit, duplicate, or delete the workflow anytime.
You can start with the free plan; limits depend on your viaSocket plan and usage. If you need help, you can contact viaSocket support, check the Knowledge Base, or book a demo.
