❓
Knowledge Base
📨

SendGrid

If you're an Enterprise customer, you can use your own SendGrid account to send emails. Below is a suggested template for standard email reports, where

  • title - The title of the block
  • totalRowsReturned - the rows in the SQL results
  • dfHtml - The results rendered in HTML

Standard template

<html>
    <head>
      <title>{{title}}</title>
      <style>
        table {
            border-collapse: collapse;
        }
        table, th, td {
            border: 1px solid black;
            text-align: left;
            padding-left: .5rem;
            padding-right: .5rem;
            padding-top: .25rem;
            padding-bottom: .25rem;
        }
        html {
          font-family: sans-serif;
          line-height: 1.15;
        }
        body {
          margin: 0;
          font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, "Noto Sans", sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji";
        }
      </style>
    </head>
    <body>
    <div style="padding-left: 3rem;padding-top: 1rem;">
        <a href={{blockLink}}>{{title}}</a> returned {{totalRowsReturned}} rows
    </div>
    <div style="padding-left: 3rem;padding-top: 1rem;">
        {{{dfHtml}}}
    </div>
      <div data-role="module-unsubscribe" class="module" role="module" data-type="unsubscribe" style="color:#444444; font-size:12px; line-height:20px; padding:16px 16px 16px 16px; text-align:Center;" data-muid="4e838cf3-9892-4a6d-94d6-170e474d21e5">
        
        <p style="font-size:12px; line-height:20px;">
          <span class="Unsubscribe--unsubscribeLink" href="{{{unsubscribe}}}" target="_blank" style="font-family:sans-serif;text-decoration:none;">
            Sent via <a href="http://seekwell.io/">SeekWell</a>, to unsubscribe contact your team admin
          </span>
        </p>
      </div>
    </body>
</html>

Story template

<html>
    <head>
      <title>{{title}}</title>
      <style>
        table {
            border-collapse: collapse;
        }
        table, th, td {
            border: 1px solid black;
            text-align: left;
            padding-left: .5rem;
            padding-right: .5rem;
            padding-top: .25rem;
            padding-bottom: .25rem;
        }
        html {
          font-family: sans-serif;
          line-height: 1.15;
        }
        body {
          margin: 0;
          font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, "Noto Sans", sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji";
        }
      </style>
    </head>
    <body>
    <div style="padding-left: .25rem;padding-top: .25rem;">
        {{{storyHtml}}}
    </div>
    <div style="padding-left: .25rem;padding-top: 1rem;">
        Generated by <a href={{blockLink}}>{{title}}</a>
    </div>
      <div data-role="module-unsubscribe" class="module" role="module" data-type="unsubscribe" style="color:#444444; font-size:12px; line-height:20px; padding:16px 16px 16px 16px; text-align:Center;" data-muid="4e838cf3-9892-4a6d-94d6-170e474d21e5">
        
        <p style="font-size:12px; line-height:20px;">
          <span class="Unsubscribe--unsubscribeLink" href="{{{unsubscribe}}}" target="_blank" style="font-family:sans-serif;text-decoration:none;">
            Sent via <a href="http://seekwell.io/">SeekWell</a>, to unsubscribe contact your team admin
          </span>
        </p>
      </div>
    </body>
</html>

Adding the template

In SendGrid, click "Email API" → "Dynamic Templates" → "Create a Dynamic Template" in the top right.

image

Send the Template ID to contact@seekwell.io

image