Automated weekly/hourly email digest

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

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

Join today for free and access 200+ tutorials

Join Makerpad today and you'll get access to hundreds of tutorials and educational content to help you create projects, automate workflows, and build software, without writing code.

Learn alongside 4 thousand professionals, no coding required.

Get Started Free

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

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

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

Join today for free and access 200+ tutorials

Join Makerpad today and you'll get access to hundreds of tutorials and educational content to help you create projects, automate workflows, and build software, without writing code.

Learn alongside 4 thousand professionals, no coding required.

Get Started Free

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

Get help and discuss

Open community forum

More lessons

Connecting Airtable and Twitter for an automated tweet email newsletter
Creating an Airtable base for an automated tweet email newsletter
Setting up an automated tweet email newsletter template in Mailchimp
Create a job board newsletter sign-up form with Convertkit
Turn Yac voice memos into Asana tasks
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
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.