ExploreEducationHow do IΒ build?MembersToolsWorkshopsJobs

Join Makerpad today

Makerpad is home to over 10 thousand folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
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.
Get up to $200 by referring a friend

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
/
πŸ”— Send personalized attachments with YAMM
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

πŸ”— Send personalized attachments with YAMM

Link to Demo

In this tutorial you will learn how to send an email or many emails with a personalized attachment.

What you'll need

  • Yet Another Mail Merge (YAMM)
  • Google Sheets
  • Google Docs
  • Gmail
  • Google Drive

Estimated time to complete

  • 10 minutes

‍

If you have not installed Yet Another Mail Merge within Google Sheets do so here: https://gsuite.google.com/marketplace/app/yet_another_mail_merge/52669349336

In your Google Sheet, add the following columns: ID, First Name, Last Name, Email Address. Add in data. The ID should be a unique identifier.

Create a draft in Gmail with a subject line and body. If you want to personalize the email use mail merge fields that map to your columns such as {{First Name}}. If you want to design something for the body of the email, use Google Docs and design within Tables. Once you are done with your email. Save to drafts and star it.

Create a folder in Google Drive. Upload your personalized attachments. Each attachment should have your unique identifier (in this case the ID number). Make sure each file has a shareable link turned on.

Head into Google Sheets. Click Add-Ons, select Yet Another Mail Merge and select Start Mail Merge. Select your email template. Click + Alias, Filters, Personalized Attachments. Select Import From Drive Folder. Find your folder. If you don't see attachments, then try clicking only once and then click Select. Choose what you want to match against (in this case it is ID). Click Back and then you can send emails or send a test 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

‍

You must be a member to view the full lesson

Join Makerpad today

Makerpad is home to over 10 thousand folks learning to automate business workflows and build projects without code. Access PRO content, join the community & get expert support.
Learn how to build without code today
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.
Get up to $200 by referring a friend

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

Tools

Tutorials

Stories

Ready to get started?

Join the community and start turning your ideas into solutions