ExploreEducationHow do I build?MembersToolsWorkshopsJobs

Get started with
Makerpad today

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

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

The perfect way to keep on top of everything Makerpad.

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.

Bring no-code skills to your work

From learning new skills for your projects to automating and shipping faster in your team
For BusinessFor individuals

Share

Tutorials
/
✉️ Auto email podcast guests to share their episode when published
Categories
Added to your list!
Oops! Something went wrong while submitting the form.
Marked as complete!
Oops! Something went wrong while submitting the form.
Mark as completeSave to watch later

✉️ Auto email podcast guests to share their episode when published

Link to Demo

In this tutorial we're going to create a simple automation that automatically sends an email to podcast guests once their episode is live. This will contain a link to the episode to encourage it to be shared out.

What you'll need.

  1. Zapier
  2. Airtable
  3. Gmail
  4. Slack (Optional)

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 without writing code.

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

The perfect way to keep on top of everything Makerpad.

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.

First up duplicate a template from Airtable - http://bit.ly/mpairtablebase.

Open up the Airtable base and remove any of the other episodes and seasons leaving just one.

Next create a new view by clicking on Episodes by Season in top left and then ‘Add a view: Grid View’. Rename it ‘Released Episodes’. Add a filter, ‘Where’ the ‘Stage’ contains released.

Next add another field into your main Episodes by Season table. Add a ‘Look up’ field next to your ‘Guest Name’ field and configure it to look up your ‘Guests Email’.

Next open Zapier and create a new Zap.

Set Airtable as the first app and set the Trigger to 'New Record in View'. Connect your Airtbale account.

Connect your base and set your Table to 'Episodes. Set your view to 'Released Episodes'.

Press continue and click test. Now head to Airtable change the stage of the podcast episode to 'Released' which should trigger the Zap.

If it goes green you should have the data through. Check by opening the step back up.

Next connect Gmail. Select Send Email. Connect your Gmail account.

Now map the records across from Airtable to customise your email to your guest. Put the 'Guest Email' from the previous step into the 'To' field then customise the body to contain the 'Episode Name' and 'Link/URL'.

Continue and test.

For this last part we're going to connect Slack to notify the team that the email has gone out.

Add Slack as the next step. Connect your Slack account and set the channel you want the message to go to.

Customise the message to contain the Guests Name and Email along with the episode name if needed.

If you want to you can name your bot and give it an icon for personalisation.

Press continue and test. That's it.

Put your Zap live and you're good to go.

If you have any questions about this be sure to reach out either in the Makerpad Slack channel or reach out on twitter @tomosman.

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

Ready to get started?

Join the community and start turning your ideas into solutions