Update Google Sheets from approval emails in Gmail and send an automatic reply
When an approval or acceptance email arrives in Gmail, this automation finds the matching record in Google Sheets, updates the candidate status (Interview or Reject), and sends the appropriate confirmation email back automatically.
By Rishabh Kushwah
Installed by 1 users
- acceptanceUpdate Spreadsheet RowSend Email
- ifcbQRaLRgZEUpdate Spreadsheet Row 1Send Email 1
Update Google Sheets from approval emails in Gmail and send an automatic reply
Update Google Sheets from approval emails in Gmail and send an automatic reply
Introduction
Keep your hiring (or approval) tracker accurate without manual follow-ups. This workflow monitors Gmail for decision emails, updates the right row in Google Sheets, and instantly sends the correct response to the candidate.
Benefits
- Eliminates manual sheet updates after approval/acceptance emails
- Ensures candidates get a fast, consistent response every time
- Reduces mistakes by matching and updating the correct spreadsheet row automatically
- Keeps your pipeline status (Interview/Reject) always up to date
Trigger Event
When a new email is received in Gmail that matches your selected filters (such as specific subject keywords and/or a sender email).
Actions
- Extract the candidate’s email address from the incoming email body.
- Search Google Sheets for the row where the Email column matches the extracted candidate email.
- Check the email text for acceptance/approval keywords (for example: “accept”, “approved”, “yes”, “candidate has been shortlisted”).
- If acceptance is detected:
- Update the candidate’s Status in Google Sheets to Interview.
- Send an “Interview Scheduled / Next Steps” email to the candidate.
- If acceptance is not detected (else case):
- Update the candidate’s Status in Google Sheets to Reject.
- Send an application update email to the candidate.
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.
