There are many ways to send emails from Power Automate. This post will demonstrate how to build a flow to Send email from Power Automate with Sendgrid using dynamic templates.
There are many advantages to using SendGrid:
- Ability to send from any alias in your domain.
- Dynamic Templates are easy to maintain and build with SendGrid editor.
- Simple to track email delivery.
- Great solution if you are sending a high volume of emails.
- SendGrid has comprehensive testing tools to ensure emails are deliverable.
The first part of the process is to create a dynamic template in SendGrid. I implemented a flow to send customer balance statements and the resulting email looked like this:
SendGrid will replace the values between the double curly braces with values supplied from Power Automate.
Once you have created your template SendGrid will assign a template ID. Copy the Template ID for the next step in Power Automate:
Next, generate a SendGrid API Key for access from Power Automate and then you can build your flow. Here is my sample flow (click to zoom):
Here is my JSON code:
{ "from": { "email": "[email protected]", "name": "Tachytelic Accounts" }, "personalizations": [ { "to": [ { "email": "[email protected]" } ], "bcc": [ { "email": "[email protected]" } ], "subject": "Statement from Tachytelic.net", "dynamic_template_data": { "Current": "5,890.08", "Days0_30": "5,118.00", "Days30_60": "0.00", "Days60_90": "0.00", "Days90plus": "12,384.00", "CustomerName": "Sample Customer", "Total": "23,392.09" } } ], "template_id": "d-420f62e9c0074c899610f056b0141d11" }
In Production flows like this one are used to:
- Send large batches of customer statements.
- Send PDF Invoices which are generated from a word template
- Notify customers of delivery of goods.
The SendGrid template tools make it easy to create consistent branded emails from Power Automate. You can get a free account on their website to try it out.
Leave a Reply