How to attach personalized documents from unique Google Drive folders to their respective emails

  1. Find the Google Drive Folders of the files that you would like to attach


  2. Add the "Personalized" columns to your google sheet; in this case it will be either First Name and Last Name or it will be Full Name.


  3. Build your "Personalized Attachments Path" for Go Mail Merge to use when finding your attachments. In our scenario this is our full personalized path:

    My Drive/Classroom/Report Cards/{{First Name}} {{Last Name}}/Report Card.pdf

  4. Notice that {{First Name}} matches the First Name Column in the Google Sheet exactly, including the space. Also, notice the space in between {{First Name}} {{Last Name}} that space is required as well in order to match the folder, if we had a - or an _ then we would use that instead of the space.

  5. The above path will then find the correct file for each respective recipient, for example our first row will result in this:

    My Drive/Classroom/Report Cards/Billy Check/Report Card.pdf

  6. Billy Check will then receive his respective report card as an attachment.

  7. You can add as many personalized paths as you like, Gmail does have a limit of up to 25 attachments per email. Here is the end result: