Sign up for updates

Get a weekly update every Sunday with our announcements, company updates and a behind-the-scenes of what our community are building.
Over 11,000 people get our updates, join us!
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.
β­  all tutorials

Send a personalized download link with YAMM

This tutorial is available for pro members only

Request access

In this tutorial you will gather leads with Typeform, create a branded email in Google Docs and send a personalize download link email to leads using Google Sheets and YAMM.

What you'll need

  • Yet Another Mail Merge (YAMM)
  • Typeform
  • Google Sheets
  • Google Docs

Estimated time to complete

  • 10 mins

Create a Typeform that collects First Name, Last Name, and an Email Address. Connect it to Google Sheets. Change A1 to First Name.

Install Yet Another Mail Marge from the Gsuite marketplace or via their website. Once installed, click on Add-on and select Yet Another Mail Merge and select Start Mail Merge. From here you can use a template from YAMM or create your own in Google Docs.

If you create your own in Google Docs then keep in mind that newsletters are built with tables. In other words, tables = containers. If you want to personalize the email, use {{First Name}} where appropriate. Once you are done, paste the contents of the Google Doc into the body of a blank email. Insert a subject line and star the Draft. Head back into your Google Sheet, and hit the refresh symbol next to Email Template. Choose the starred draft from the drop down. Send an email.

I hope you enjoy this tutorial preview, if you have any questions please reach out on Twitter @amiedelisa or @makerpad.

For access to this full tutorial please head over to https://www.makerpad.co

‍

The full tutorial is available for pro members only

Request access

In this tutorial you will gather leads with Typeform, create a branded email in Google Docs and send a personalize download link email to leads using Google Sheets and YAMM.

What you'll need

  • Yet Another Mail Merge (YAMM)
  • Typeform
  • Google Sheets
  • Google Docs

Estimated time to complete

  • 10 mins

Create a Typeform that collects First Name, Last Name, and an Email Address. Connect it to Google Sheets. Change A1 to First Name.

Install Yet Another Mail Marge from the Gsuite marketplace or via their website. Once installed, click on Add-on and select Yet Another Mail Merge and select Start Mail Merge. From here you can use a template from YAMM or create your own in Google Docs.

If you create your own in Google Docs then keep in mind that newsletters are built with tables. In other words, tables = containers. If you want to personalize the email, use {{First Name}} where appropriate. Once you are done, paste the contents of the Google Doc into the body of a blank email. Insert a subject line and star the Draft. Head back into your Google Sheet, and hit the refresh symbol next to Email Template. Choose the starred draft from the drop down. Send an email.

I hope you enjoy this tutorial preview, if you have any questions please reach out on Twitter @amiedelisa or @makerpad.

For access to this full tutorial please head over to https://www.makerpad.co

‍

Lesson details

In this tutorial you will gather leads with Typeform, create a branded email in Google Docs and send a personalize download link email to leads using Google Sheets and YAMM.

What you'll need

  • Yet Another Mail Merge (YAMM)
  • Typeform
  • Google Sheets
  • Google Docs

Estimated time to complete

  • 10 mins

Create a Typeform that collects First Name, Last Name, and an Email Address. Connect it to Google Sheets. Change A1 to First Name.

Install Yet Another Mail Marge from the Gsuite marketplace or via their website. Once installed, click on Add-on and select Yet Another Mail Merge and select Start Mail Merge. From here you can use a template from YAMM or create your own in Google Docs.

If you create your own in Google Docs then keep in mind that newsletters are built with tables. In other words, tables = containers. If you want to personalize the email, use {{First Name}} where appropriate. Once you are done, paste the contents of the Google Doc into the body of a blank email. Insert a subject line and star the Draft. Head back into your Google Sheet, and hit the refresh symbol next to Email Template. Choose the starred draft from the drop down. Send an email.

I hope you enjoy this tutorial preview, if you have any questions please reach out on Twitter @amiedelisa or @makerpad.

For access to this full tutorial please head over to https://www.makerpad.co

‍

Previous submissions
No items found.
Supporting details

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.
More lessons
How Cal Newport manages his inbox with Trello and Zapier
Automate scheduling meetings, calendar invites, and CRM admin work
Sales automation workflow using Typeform / Airtable / Callingly
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
Capture email metadata and save as an image with Zapier
Find & save competitor info and emails with Hunter
Email outreach & sequencing with Reply.io & Gmail
Source Leads from a Spreadsheet with Dashdash
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
Create a targeted sales list in dashdash
Build a writing habit with Glide
Build a Reading Tracker in Glide
Job application tracker with Airtable
Auto-accept LinkedIn invites
Document automation and workflows with Documate
Automated task management in Trello
Dynamically generate Google Docs
Automate + qualify your lead generation with Standard Library
Generate and send contracts automatically with PandaDoc
Automated Airtable sales notifications in Zapier
Create a sales pipeline in Airtable
Save Gmail attachments to Google Drive + Airtable
Automated sales reporting for Shopify with Integromat
Daily stand-ups or check-in bot in Slack and FlowXO
Pull LinkedIn Company info & create a new record in Webflow
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
Update salesforce opportunities with computed data
Automatically get data from Mailchimp to your CRM
Group Scheduling App
Sales CRM - build a sales pipeline
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 weekly/hourly email digest
Automated transcription from a Dropbox file
Segmenting prospects for sales funnels

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