How to include every field in a new record in an email using sendgrid automation

Hey ​@DannyNeedsHelpInTheMountains 

If you find yourself creating too many fields too often, that might undercover a database schema/architecture that could be improved. 
 

Silly example:

Contact table with fields:

First Name

Last Name

Pet Name

As contacts might have more than one pet you might start creating fields:

Pet 2 Name

Pet 3 Name

etc. 
 

If that is the case, you would probably want to have a Pets table linked to the Contacts table, where each per would have its own record.

This might not be your case, but just to keep in mind!

Mike, Consultant @ Automatic Nation

​@DisraeliGears01 I should have been more specific in the body of my question. I’m currently creating a zap in Zapier that automates sending the notification email every time a new record is created. 

I don’t see the ability to select a list vs grid, or have the email notification know to select all fields or only those that have been filled in. I think what you’re describing is available only in Airtable’s native email tool. 

Is there a solution for this via Zapier? 

You would either need to use Airtable’s built-in automations to do that, or you could create your new records in Airtable by using Fillout’s advanced forms for Airtable. Fillout will let you automatically send every field that was filled out to whatever email address you want.

- ScottWorld, Expert Airtable Consultant

Hey ​@DannyNeedsHelpInTheMountains 

We’ll tackle this by creating a dynamic automation using Make (formerly Integromat) that listens for new records in Airtable and automatically builds the email body based on all populated fields—no need to manually update anything when new fields are adde. The idea is to use Airtable’s webhook or trigger module, fetch the full record, loop through the fields programmatically, and only include those that contain data. This keeps the email content clean and adaptive to your evolving table structure.

The approach includes:

• Watch Records module in Airtable (for new entries)

• An iterator to loop through key-value pairs in the record

• Text aggregator to compile the email body

• SendGrid module to shoot off a dynamic email with only the fields that have values

Let’s Schedule the call 

Hi,
the pattern for “A new...’ is usually the most important data of record, partially in Subject, the rest in Message, with a link to a new record. (and maybe List or Grid)
Note that when record created manually, the trigger ‘When record created’ might be useless, because it has no data at that moment. I’m using “When record matches condition” with single-select or checkbox field because ‘{Text field} is non-empty’ has the same flaw - it runs right after you enter 1-2 letters in a field.
When it’s not urgent, you can play with formula using TODAY( ) and CREATED_TIME( )