Conditional Formatting of Email
Status: Open · Asked by ftrccc on · 0 views
The trigger is Google Sheets : New or Updated Spreadsheet Row
The action is Gmail : Send Email
I use a Google form to populate the Google Sheet. One of the questions on the form is:
Would you like to add the following text to your message? It is a Yes/No question. The column values on the sheet are Yes or No.
When I format the email to send can I make a text calculation like:
If [Add Column Text] = "Yes" Then "[preformatted text from the form]"
Hi @ftrccc,
Thank you for your query.
Yes, this can be achieved. The recommended approach is to use the router.
You can use a Router to handle this condition cleanly:
- Add a Router after your Google Sheets trigger
- Create two routes:
Route 1 (Yes condition):
- Add a Filter: Column Value = Yes
- Configure Gmail action with the additional preformatted text included
Route 2 (No condition):
- Add a Filter: Column Value = No
- Configure Gmail action without the additional text
This way, the email content is dynamically controlled based on the user’s response.
Please try this setup and let us know if you need help configuring it.
yes, this worked. very powerful functionality!
Glad we were able to help.
We’d really appreciate it if you could share some quick feedback on the support you received:
Google Search
Thank you for your time.
Thanks & Regards,
Arshil Ahmad
Customer Support Associate
? Pabbly.com