⭠ all tutorials

Automated weekly/hourly email digest

Available for Unlimited All Access members only

Get access

This is a super simple way to set up a weekly/daily newsletter that is almost completely Automated!

The full tutorial is available for pro members only

Request access

Airtable

First we need to set up a simple Airtable base. Create a table with Title and URL. You can add as many fields of different types as you like here, depending on what you want to include in your Email digest.

We will be using Mailchimp in this app so make sure you have an account set up.

Zapier

Now let's set up our automation. Create a Zap and select Airtable as the Trigger App.

We want this to trigger when a new record is added (i.e. a new article with a URL is added)

Connect the correct Base and table

Now select the 'Digest' app by Zapier.

Select 'Append Entry and Schedule Digest'

Here we enter our details. The Title (doesn't have to be the same as your Mailchimp campaign), Entry (here you enter the content, so select the fields you wish to add from your Airtable base). I've used

HTML formatting (see next screenshot below) which can help make the emails look nice. So each of my emails should have a bold "These are the latest links this week" then a list of hyperlinked titles all on separate lines (paragraph formatting).

Set the frequency, day of the week and time of day you want your digest to be sent.

This is a quick format for HTML formatting.

Now we need to link our Mailchimp

First we need a new campaign to be created in Mailchimp each time the digest runs.

You can select your list, give it a subject name, from name and email address. See the below screenshot for more details to include

In the same form "Edit Template". You will need to add the Email Content. Click the + and from Step 2, select 'Current Digest'. (If you run tests your content may show up weirdly like the below but don't panic!)

Now we need to set up the action app to send the actual campaign.

For the template, you need to select 'Use A Custom Value' and then in the 'Custom Value for Campaign ID' field, select the ID from Step 3. This makes sure it's the campaign that has just been created.

And there we have it! An automated email digest. There are lots of ways to customise this of course and for some advanced ideas:

  • Automate populating your Airtable base by using the Pocket Chrome extension like in this tutorial

This is a super simple way to set up a weekly/daily newsletter that is almost completely Automated!

Airtable

First we need to set up a simple Airtable base. Create a table with Title and URL. You can add as many fields of different types as you like here, depending on what you want to include in your Email digest.

We will be using Mailchimp in this app so make sure you have an account set up.

Zapier

Now let's set up our automation. Create a Zap and select Airtable as the Trigger App.

We want this to trigger when a new record is added (i.e. a new article with a URL is added)

Connect the correct Base and table

Now select the 'Digest' app by Zapier.

Select 'Append Entry and Schedule Digest'

Here we enter our details. The Title (doesn't have to be the same as your Mailchimp campaign), Entry (here you enter the content, so select the fields you wish to add from your Airtable base). I've used

HTML formatting (see next screenshot below) which can help make the emails look nice. So each of my emails should have a bold "These are the latest links this week" then a list of hyperlinked titles all on separate lines (paragraph formatting).

Set the frequency, day of the week and time of day you want your digest to be sent.

This is a quick format for HTML formatting.

Now we need to link our Mailchimp

First we need a new campaign to be created in Mailchimp each time the digest runs.

You can select your list, give it a subject name, from name and email address. See the below screenshot for more details to include

In the same form "Edit Template". You will need to add the Email Content. Click the + and from Step 2, select 'Current Digest'. (If you run tests your content may show up weirdly like the below but don't panic!)

Now we need to set up the action app to send the actual campaign.

For the template, you need to select 'Use A Custom Value' and then in the 'Custom Value for Campaign ID' field, select the ID from Step 3. This makes sure it's the campaign that has just been created.

And there we have it! An automated email digest. There are lots of ways to customise this of course and for some advanced ideas:

  • Automate populating your Airtable base by using the Pocket Chrome extension like in this tutorial

This is a super simple way to set up a weekly/daily newsletter that is almost completely Automated!

Airtable

First we need to set up a simple Airtable base. Create a table with Title and URL. You can add as many fields of different types as you like here, depending on what you want to include in your Email digest.

We will be using Mailchimp in this app so make sure you have an account set up.

Zapier

Now let's set up our automation. Create a Zap and select Airtable as the Trigger App.

We want this to trigger when a new record is added (i.e. a new article with a URL is added)

Connect the correct Base and table

Now select the 'Digest' app by Zapier.

Select 'Append Entry and Schedule Digest'

Here we enter our details. The Title (doesn't have to be the same as your Mailchimp campaign), Entry (here you enter the content, so select the fields you wish to add from your Airtable base). I've used

HTML formatting (see next screenshot below) which can help make the emails look nice. So each of my emails should have a bold "These are the latest links this week" then a list of hyperlinked titles all on separate lines (paragraph formatting).

Set the frequency, day of the week and time of day you want your digest to be sent.

This is a quick format for HTML formatting.

Now we need to link our Mailchimp

First we need a new campaign to be created in Mailchimp each time the digest runs.

You can select your list, give it a subject name, from name and email address. See the below screenshot for more details to include

In the same form "Edit Template". You will need to add the Email Content. Click the + and from Step 2, select 'Current Digest'. (If you run tests your content may show up weirdly like the below but don't panic!)

Now we need to set up the action app to send the actual campaign.

For the template, you need to select 'Use A Custom Value' and then in the 'Custom Value for Campaign ID' field, select the ID from Step 3. This makes sure it's the campaign that has just been created.

And there we have it! An automated email digest. There are lots of ways to customise this of course and for some advanced ideas:

  • Automate populating your Airtable base by using the Pocket Chrome extension like in this tutorial

You must be a member to view the full lesson

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

Airtable

First we need to set up a simple Airtable base. Create a table with Title and URL. You can add as many fields of different types as you like here, depending on what you want to include in your Email digest.

We will be using Mailchimp in this app so make sure you have an account set up.

Zapier

Now let's set up our automation. Create a Zap and select Airtable as the Trigger App.

We want this to trigger when a new record is added (i.e. a new article with a URL is added)

Connect the correct Base and table

Now select the 'Digest' app by Zapier.

Select 'Append Entry and Schedule Digest'

Here we enter our details. The Title (doesn't have to be the same as your Mailchimp campaign), Entry (here you enter the content, so select the fields you wish to add from your Airtable base). I've used

HTML formatting (see next screenshot below) which can help make the emails look nice. So each of my emails should have a bold "These are the latest links this week" then a list of hyperlinked titles all on separate lines (paragraph formatting).

Set the frequency, day of the week and time of day you want your digest to be sent.

This is a quick format for HTML formatting.

Now we need to link our Mailchimp

First we need a new campaign to be created in Mailchimp each time the digest runs.

You can select your list, give it a subject name, from name and email address. See the below screenshot for more details to include

In the same form "Edit Template". You will need to add the Email Content. Click the + and from Step 2, select 'Current Digest'. (If you run tests your content may show up weirdly like the below but don't panic!)

Now we need to set up the action app to send the actual campaign.

For the template, you need to select 'Use A Custom Value' and then in the 'Custom Value for Campaign ID' field, select the ID from Step 3. This makes sure it's the campaign that has just been created.

And there we have it! An automated email digest. There are lots of ways to customise this of course and for some advanced ideas:

  • Automate populating your Airtable base by using the Pocket Chrome extension like in this tutorial

Get help and discuss

Open community forum

Related lessons

Collecting recurring payments with involve.me
Collecting one time and recurring payments with involve.me
Calculating custom prices with involve.me
Making a calculator with involve.me
Develop a custom CRM using Retool and 8base
Generate a task list for projects in Airtable
Sync files across Airtable, Hubspot, and Google Drive
How Cal Newport manages his inbox with Trello and Zapier
Create a Welcome Bot in Slack
Build a Birthday Bot for Slack
Extract data from PDF: How to convert PDF files into structured data
Convert PDF bank and credit card statements to Excel
How to batch convert PDF to Excel
Convert pdf to Excel spreadsheet or Google Docs sheet
Custom Slack + Airtable Task Management Application
Create Images Automatically with Bannerbear & Zapier
🎂 Send Automated Birthday Messages to a Channel in Slack
Zapier - the basics
Approval Workflow in Coda
Send a personalized download link with YAMM
Mailchimp - the basics
Build a writing habit with Glide
Build a Reading Tracker in Glide
Job application tracker with Airtable
Add Convertkit to your Webflow site for email subscribers
Document automation and workflows with Documate
Automated task management in Trello
Dynamically generate Google Docs
Weekly email digest of interesting links with Zapier
Subscribe to newsletter with an SMS
A Substack clone with Webflow & Memberstack
Save Gmail attachments to Google Drive + Airtable
Newsletter archiver using Mailchimp, Airtable and Integromat
Daily stand-ups or check-in bot in Slack and FlowXO
Simple multiple-step form with Boundless
5 minute journal for everyday using Notion
To-Do template for everyday using Notion
Build a Mail Merge with Airtable, Gmail, and Standard Library.
Build a Slack / Airtable / Stripe CRM
Automatically get data from Mailchimp to your CRM
Group Scheduling App
Fundraising CRM - Startups seeking to raise funding
👨‍👩‍👧‍👦Personal CRM - keep track of people in your life
Scheduled summary of Stripe charges in Slack
Automated digest of Pocket activity
Automated transcription from a Dropbox file
Newsletter generator chrome extension
Browse all →

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.