Creating Gmail Digests from Airtable Data in Tabular Format with Zapier

Other Questions Airtable
1

I’m struggling to set up a Zapier workflow that sends Airtable data as a digest email through Gmail. My goal is to present the information in a neat table format.

I’ve tried a few approaches:

  1. Putting all the HTML (email content and table structure) in the Digest zap. This led to repeated headers for each data entry.

  2. Splitting the HTML between Digest and Schedule zaps. The table columns didn’t line up properly.

  3. Using row HTML in the Digest zap and wrapping it with table HTML in the Schedule zap. This resulted in one super-long row.

Here’s a snippet of my current setup:

<tr>
    <td width="150">{{deal_title}}</td>
    <td width="150">{{option_type}}</td>
    <td width="150">{{option_status}}</td>
    <td width="150">TBD</td>
    <td width="150">{{option_url}}</td>
    <td width="150">{{deal_url}}</td>
<tr>

<!DOCTYPE html>
<html>
<head>
<style>
table { font-family: sans-serif; border-collapse: collapse; }
td, th { border: 1px solid #ddd; padding: 8px; text-align: left; }
tr:nth-child(even) { background-color: #f2f2f2; }
</style>
</head>
<body>
<h2>Option Overview - Pending Deadlines</h2>
<table>
  <tr>
      <th width="200">Title</th>
      <th width="200">Option Type</th>
      <th width="200">Option Status</th>
      <th width="200">Deadline</th>
      <th width="200">Option Link</th>
      <th width="200">Deal Link</th>
  </tr>
 [DIGEST]
</table>
</body>
</html>

Any ideas on how to fix this?

2

I’ve wrestled with similar Zapier-Airtable-Gmail setups before, and I think I see where the issue might be. Your approach is close, but needs a slight tweak.

Try moving all the HTML, including the table structure, into the Schedule zap. In the Digest zap, focus solely on generating the content for each row. Something like this:

In Digest zap:

<td>{{deal_title}}</td><td>{{option_type}}</td><td>{{option_status}}</td><td>TBD</td><td>{{option_url}}</td><td>{{deal_url}}</td>

Then in the Schedule zap, wrap it all together:

<!DOCTYPE html>
<html>
<head>
<style>
/* Your existing CSS */
</style>
</head>
<body>
<h2>Option Overview - Pending Deadlines</h2>
<table>
  <tr>
    <th>Title</th><th>Option Type</th><th>Option Status</th><th>Deadline</th><th>Option Link</th><th>Deal Link</th>
  </tr>
  [DIGEST]
</table>
</body>
</html>

This should solve the alignment issues and prevent repeated headers. Let me know if you need any clarification!

3

I’ve encountered this issue before, and here’s a solution that worked for me:

In the Digest zap, use this format for each row:

{{deal_title}}{{option_type}}{{option_status}}TBD{{option_url}}{{deal_url}}

Then in the Schedule zap, structure your email like this:

table { font-family: sans-serif; border-collapse: collapse; width: 100%; } td, th { border: 1px solid #ddd; padding: 8px; text-align: left; } tr:nth-child(even) { background-color: #f2f2f2; }

Option Overview - Pending Deadlines

[DIGEST]
TitleOption TypeOption StatusDeadlineOption LinkDeal Link

This approach should resolve your alignment issues and create a clean, tabular format in your digest emails.

4

hey there, i’ve dealt with similar zapier headaches before. have u tried using a plain text digest instead of html? might be simpler. just do something like:

{{deal_title}} | {{option_type}} | {{option_status}} | TBD | {{option_url}} | {{deal_url}}

then in the schedule zap, split the text by line and wrap each in table rows. could solve ur formatting issues