<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1822615684631785&amp;ev=PageView&amp;noscript=1"/>

How to send multiple emails with different attachments in Gmail

Personalized email attachments

Have you ever wondered how to send multiple emails with different attachments in Gmail?

Well, you can now easily send a mass email or mail merge in Gmail with personalized attachment files.

Why would you ever need to do this? Let’s say you run a small business that needs to send PDF invoices to your customers once a month. Your billing software generates the PDF invoices, one for each of your 100 customers. Now you need to send the right invoice to the right customer. Until now, you’d have to prepare multiple emails manually — composing and sending 100 individual emails, and having to attach the right PDF to each email.

But now, you can automate all of this. Here’s a two-minute video demo:

What tools will you need to mail merge with individual attachments?

  1. All of your attachment files, ready to send
  2. A Google Sheet that lists the email addresses in one column and the file names in the other
  3. A place to host the files, such as Google Drive, Amazon S3, Dropbox, or your own web server
  4. A Gmail or Google Workspace account
  5. GMass installed and connected

Host your attachments somewhere

Your files can either be in your Google Drive or somewhere publicly accessible on the web, like your own web server, a public Dropbox folder, or a public AWS S3 bucket.

If you’re going to host your file attachments in your Google Drive, our software needs permission to access your Google Drive. It’s the one step you have to take in advance of sending any personalized attachments with your bulk emails.

You must give GMass read-only permissions to your Google Drive! By default, GMass doesn’t have permissions for this when you sign up for an account.

——————-

To allow GMass to download different attachment files from your Google Drive:

>>>>>>> FOLLOW THIS LINK <<<<<<<<

——————-

and log in with the same account that you’re using to send your mass email.

Also, note that the files don’t all have to be in the same folder; they can be spread across multiple folders as long as they’re in one single Google Drive account. Lastly, if you use Google Drive, be sure that the “Convert uploaded files…” setting is UNCHECKED:

UNCHECK convert uploaded files
(Click the Settings gear first at the top-right, then uncheck that box, then click DONE.)

If you don’t uncheck this box, then certain file types, like .txt files, won’t remain as txt files after you upload them; they’ll get converted to Google Docs and won’t be “attachable” to your personalized emails.

Set up your Google Sheet

First, set up your Google Sheet. Make sure your column headings are in the first row, and at a minimum you’ll need two columns, one for the email address, and one for the file to be attached. You can have other columns too, like FirstName, LastName, Company, and anything else you want to use to personalize your mail merge. Here’s what your spreadsheet should look like:

personalized attachment spreadsheet

The column containing the files can be named anything as long as it starts with “attachment.” Any of the following are valid column names:

  • Attachment
  • Attachment1
  • AttachmentFile
  • attachment10

It’s not case sensitive, either. If your files are hosted in Google Drive, then the column should contain just the file attachment name. If your files are hosted somewhere on the web, then the column should contain the full URL to the file. Here’s what your spreadsheet might look like if you’re hosting your files on your own web server for a mailing to multiple recipients.

personalized attachment with link to server

If you’re a spreadsheet wizard, feel free to use formulas for the attachment column as well. For example, if you’re sending monthly statements to your customers, and your billing software generates the monthly statements in the format of [CustomerNumber].pdf, and CustomerNumber is one of the column in your spreadsheet, you can set the attachment column to “=A1” + .pdf.

personalized attachment from spreadsheet formula

Finally, if you have blank cells in an “attachment” column, then it’s assumed that those recipients don’t have corresponding files, and the emails will be sent without any file attachment.

Connect to your spreadsheet, compose, and send your messages

If you’ve performed a mail merge with GMass before, the next step should be familiar. Click the Sheets connector button, choose your spreadsheet and worksheet, hit the “Connect” button, and a Gmail Compose will open. Type your message, and hit the GMass button. You don’t need to attach any files to this message. GMass will automatically detect the column in your spreadsheet containing the files to be attached and attach them to the individual emails.

personalized attachment email

The only reason you would attach a file directly to the Gmail Compose window is if you also want a separate attachment to go to all recipients. In that case, any files you attach to the Draft will be sent to all recipients, and additionally, any personalized attachments set in the spreadsheet will also be sent to separate emails.

For example, let’s say you publish a PDF newsletter monthly that you also want to send to everyone along with their personalized invoices. Then, you would attach the PDF newsletter to the Gmail Compose window, and after clicking GMass, each of the bulk personalized emails would be sent the same newsletter PDF as one attachment and an individual personalized invoice PDF as a second attachment.

Need to send personalized emails with more than one attachment?

Do you need to send more than one personalized attachment per recipient? For example, if every month, you send your customers an invoice and an account summary, and they are two different PDFs, then you can have TWO columns in your spreadsheet, for example:

  • Attachment1
  • Attachment2

GMass will notice this, and send both personalized files to each recipient.

multiple personalized attachments

Automate this to send emails with attachments every day, week, or month

Do you typically send your customers multiple messages each month?

You can set your campaign and spreadsheet up once, and then let the emails send on autopilot every day, week, or month, based on your business’ needs. Let’s say you want your email with attachments to send on the first of every month. Just schedule your initial email to send on the first of the month, and then set it to repeat MONTHLY.

automate personalized attachments

Now, on the first of every month, GMass will automatically read your spreadsheet, retrieve the files, and send the emails with their corresponding attachment. All you need to do before the first of each month is get new files in place, either to your Google Drive, or wherever you’re hosting them.

Error handling for missing files or permissions in GMass or Google

If GMass can’t retrieve the file for a particular email address, that recipient will be skipped over and you’ll get a report at the end of the campaign of all recipients who were skipped. If you intentionally don’t want certain recipients to receive any attachments with their emails, just make those cells blank under the “attachment” column — that way, they will still receive the email but without anything attached. It makes sending multiple emails with different needs quite easy.

If you’re hosting your files on Google Drive, but GMass doesn’t have permission to read from your Google Drive, then your campaign will error out with this error:

Insufficient Permission: Request had insufficient authentication scopes. [403]
Errors [
        Message[Insufficient Permission: Request had insufficient authentication scopes.] Location[ – ] Reason[insufficientPermissions] Domain[global]
]
GMass didn’t have sufficient permissions to your Gmail account to do what you wanted. If you were trying to send personalized attachments, re-connect your Gmail account and then click the RESTART link.

Using Dropbox to store files for your mail campaign

If you want to use Dropbox to store the files you want attached to your emails, then you’ll have to do some manual work — you’ll have to create public URLs for each and every single file you want to attach, even if all the files are in the same Dropbox folder. While Dropbox makes it easy to get a public link to a folder, and even a public link to a file, Dropbox does not make it easy to generate public links for say, 100 files, without going through the link creation process manually for each of the hundred links you’ll need for a campaign with multiple emails.

To generate a public link to a file, just right-click the file and choose “Copy Dropbox Link,” and then place that URL in the appropriate Google Sheet column.

how to copy dropbox link

 

But again, you will have to repeat that process for every single file, because there’s no pattern that you can follow to determine the links yourself. For example, if you have two files in Dropbox, doc1.pdf and doc2.pdf, and you generate public URLs to them, they will look like this:

https://www.dropbox.com/s/bz2536zash23znd/doc1.pdf?dl=0
https://www.dropbox.com/s/kjdjf91w5xuip6n/doc2.pdf?dl=0

Now let’s say you have 100 files for which you need to generate public links. While you can see the left portion of the URL includes “dropbox.com,” as expected, and the right portion includes the file name, as expected, there’s a unique identifier string inserted in the middle that prevents you from generating these URLs on your own for easy copying and pasting into a Google Sheet that controls multiple emails.

If you do go through the process of manually generating the Dropbox link for each file, then your Google Sheet will look like this:

Google Sheet with manual Dropbox URLs

BUT… those links won’t work as attachments in that form. Because those URLs actually go to Dropbox pages that display the PDF file, not the PDF file itself. And for this process to work, we need to get at the PDF itself. We’ll achieve that with Dropbox’s force download feature.

You’ll need to change the final 0 in each link to a 1.

So your links would now be:

https://www.dropbox.com/s/bz2536zash23znd/doc1.pdf?dl=1
https://www.dropbox.com/s/kjdjf91w5xuip6n/doc2.pdf?dl=1

If you’re dealing with lots of links, a find-replace will save you lots of time on this process.

Go to Edit > Find and replace or hit Command/Control+Shift+H.

Find dl=0 and replace it with dl=1. I also recommend checking Also search within links if you pasted in the Dropbox URLs and Google turned them into links. Click the Replace all button

Using Amazon S3 to store your attachments

Using S3 is a much more convenient option than Dropbox to store files for the purpose of personalized attachments, because S3 makes it easy to determine the public URL for any file. By default, an S3 bucket isn’t public, so make sure that if you create a bucket for the purpose of attaching files to multiple emails, you make your bucket public. You must UNCHECK the “Block all public access” box and then CHECK the acknowledgement box:

how to make Amazon S3 bucket public

 

Then, when you upload your files to a bucket, make sure you choose “Grant public read access…” to the objects:

Grant public read access to object in Amazon S3

After your files are uploaded, S3 provides you with the public URL for each file, and it’s simply the DNS name you chose for your bucket in combination with the filename:

Amazon S3 object URL

So in this case, my first two files will have the URL:

https://emailattachments.s3-us-west-2.amazonaws.com/doc1.pdf
https://emailattachments.s3-us-west-2.amazonaws.com/doc2.pdf

Note that these URLs don’t actually work, so don’t try visiting them! But, any files I upload to this bucket will have a URL in the same format, which means my Google Sheet would look like this:

Google Sheet with Amazon bucket URLs

Other mail merge tips and tricks

What else can you do to make your emails with personalized files even better?

Ready to send better emails and save a ton of time?


GMass is the only tool for marketing emails, cold emails, and mail merge — all inside Gmail. Tons of power but easy to learn and use.


TRY GMASS FOR FREE

Download Chrome extension - 30 second install!
No credit card required
Love what you're reading? Get the latest email strategy and tips & stay in touch.
   


61 Comments
  1. Hi there! Thank you so much for adding this new feature! Quick question- does this support attachments with spaces in the file name? Or could that possibly result in errors?

    1. Hi Jillian,

      Since the attachment link is based on the Google Drive link, the filename itself doesn’t contain any spaces as it’s assigned an attachment ID which is what is used for the links.

  2. Clarification: Does the file need the .pdf added to the end of its name? Or can they just be Name1, Name2, etc?

  3. Hi,

    I have followed the steps, from a pdf in my google drive I clicked ‘get sharable link’ and copied the link into the attachments column on the spreadsheet. However, when I send this what is received is a file named ‘view’ which can only be opened in a brower, so a pdf is not received. Can you help?

    thanks,

    1. Hi Asha,

      The free version is limited to sending a maximum of 50 emails per rolling 24 hours. If you’d like to lift this limit, please check out our paid subscriptions (gmass.co/pricing)

      1. Greetings!

        Could you clarify on this maximum limit. Would I be able to add around 300 emails to the campaign, then the program recognizes it has reached 50 and it will pause until 24 hours have passed, then resume with the next 50? Or do I need to batch them on my own?

        Thank you.

  4. Thanks for this app. Question regarding attachments that are in a subdirectory on the Google Drive. How do you identify those files in the spreadsheet to link with the email? What is the syntax for that field?

  5. Hello! Is there a way of referencing the file name on a Google Shared Drive? I couldn’t do it when the file was on a Shared Drive so I had to move all the files to MyDrive.

    1. I am waiting on a response for this as well. We do not store any client files in “My Drive”, all of our client files are located in a Shared Drive that our staff has access to (with the correct permissions set up). PLEASE ADVISE. If this is not a feature, it needs to be ASAP.

  6. Gmass is amazing! Loving this software. Quick question; if I add attachements to a google sheet mail merge to be sent with my original email will those same attachments be attached to the follow-up emails as well?

  7. Hi,

    Facing the same problem like people before.I have followed the steps, from a pdf in my google drive I clicked ‘get sharable link’ and copied the link into the attachments column on the spreadsheet. However, when I send this what is received is a file named ‘view’ which can only be opened in a brower, so a pdf is not received. Can you help?

    thanks

  8. Hi, I am trying to use the “Attachment” option for a test email – however, I keep getting:

    “Error: Your test email to [email protected] was NOT sent. It might be on your account’s Unsubscribe or Bounce list. There was an error:

    [email protected]: Gmass-UnableToFindAttachment.jpg (Unable to find the specified file.)”

    How can I resolve this? The file and the email both appear to be valid…

    Thanks in advance!

    1. Hi Jagannath,

      Please try sending to a different email address as it appears you’re sending to and from the same email account.

      1. I’m receiving the same error, but I’m using a different test email. It seems as though Gmass isn’t sending any emails for me right now, and I can’t even send a test (I receive that message). My subscription is paid, and I haven’t sent any Gmass emails in 48 hours. Please help!

    2. How does GMass know which PDF to use if we have multiple files with the same file name in our Google Drive? Like we have attachment1.pdf through attachmentX.pdf for each campaign, but in different folders?

      1. Hi Cedric,

        It wouldn’t and will use the 1st instance of that filename. Even though you can use files from different folders, the actual files would need to have unique filenames.

  9. Hi,

    I can’t seem to get past the connect account issue. I keep getting the following error: Object reference not set to an instance of an object.

    I really don’t know what to do to fix it.

  10. Hi, I want to send individualized PDFs and am using the =A1 + “.pdf” way, but it’s not pulling the attachments from google drive… is that because they’re in a folder or where should I place them in order for the sheet to pull them as shown in the example where attachments are named “1001.pdf”>

  11. How do you get the pdf files into the spread sheet? The pdf files are in google drive. The demo tells everythibg but not this. The demo uses already pdf entered spreadsheet

  12. Is there a limit to the number of emails that can be sent at one time?
    I may have as many as 10,000 to send with personalized attachments.

    1. Hi Brian,

      The sending limit is something that is enforced by Gmail, not by GMass. According to Google, regular G Suite accounts are limited to 2,000 while Gmail accounts (those ending with @gmail.com or @googlemail.com) are officially limited to sending a maximum of 500 emails per day. But other factors like the age of the account, content of the Campaign, or reputation of the domain can affect your sending limit.

      There’s some more information about these limits here:
      https://www.gmass.co/blog/how-many-emails-can-you-really-send-with-gmass-and-gmail/ ( https://www.gmass.co/blog/how-many-emails-can-you-really-send-with-gmass-and-gmail/ )  

      You can configure your account with an external SMTP server if you’d like to send unlimited emails without Gmail-imposed sending limits. See: https://www.gmass.co/blog/unlimited-mail-merge-sending-gmail/ ( https://www.gmass.co/blog/unlimited-mail-merge-sending-gmail/ )  

  13. Many times when I am sending out emails for invoices, I have the primary email and then 1 or 2 cc emails that will be getting the same attachment. Can GMass handle this scenario?

    Could I list them on my Google Sheet as customer 1000, 3 times with different email addresses for each line? Hate to do that because it will compromise my Gmail limits.

  14. Hello,

    I’m probably too late but for some reason the pdf files I have stored in my google drive are converted to some other file type once the emails are sent. I made sure to uncheck the “convert files” setting from GMASS, so I don’t know what else I am missing and it looks like there are other people having the same problem, but I haven’t seen them answered yet.

    Looks like great software otherwise.

    1. Hi Colby,

      What you’re encountering appears to be caused by having the actual sharable URL/Link to your file in Google Drive. Remember that if you’re using the Google Drive option to store your attachments, to not use the actual URL/Link for the file but just the file name and extension.

      Please refer to this sample screenshot’s attachment column: https://marvin-wordzen.tinytake.com/media/1074de2?filename=1624359276556_TinyTake22-06-2021-06-54-31.png

  15. Hola, ya he intentado crear 3 campañas pero no me adjunta los pdf. Alguien tiene alguna idea de lo que puede pasar allí? Gracias

  16. I have duplicate email addresses on different lines of my spreadsheet that have different attachments. This is intentional and I don’t want gmass to remove duplicate email addresses. Is there a setting I can use to make sure an email is sent from each line regardless of whether the email address is on other lines also?

    1. Hi Stoney,

      You can do this when you initially connect your Google Sheet were you select the Spreadsheet and Worksheet you wish to connect to GMass, there is an option to open the “Optional settings” where you’ll just need to check the tick box to “Keep Duplicates”. This way, GMass will send to every row regardless how many times an email address shows up in your list. Please see https://www.gmass.co/blog/google-sheets-mail-merge/#:~:text=Step%204%3A%20Decide%20Whether%20to%20Keep%20Duplicates%20(Optional)

      1. Hi,

        Wondering if there is a way to make the other recipients in the list anonymous? I don’t want clients to see each others’ names attached in the email string. Is this already taken care of? If not, is there a way to change that setting? Thanks in advance!

        1. Hi William,

          You actually don’t have to since GMass will send individual emails to every recipient addressed only to 1 person per email. So if you have a campaign scheduled to 50 recipients, GMass will send 50 individual emails for each of the 50 recipients.

  17. Hi There!
    I’m about to serve as a Student account admin for our Band organization and was looking for a solution to send unique attachments to nearly 300 contacts on a monthly basis. Knowing that yearly the contact list will change, I wanted to find a sustainable solution. I’m glad I found this site and cannot wait to try it out. Thank you for the detailed instructions.

  18. I am a novice and need a person to show me how to accomplish my objectives and lead me through a successful bulk email with attachments

  19. Attachment file location and naming (location) syntax.
    It seems that this topic has arisen previously, but I don’t see a clear answer.

    My experience is that ‘it works’ when the attachment files are located in the same gdrive folder (or subfolder) as the controlling gsheet. It would be just great (please!) if you could tell us how it is generally supposed to work, and how to reference files (attachments) that are in different folders than the spreadsheet. Thanks.

  20. Is there a limit to the number of attachments you can have? I’m working on a campaign now and it seems like you can attach a max of 3, is that correct or is there something wrong with my spreadsheet?

    1. Hi Irteza,

      Yes, it is. You can send campaigns with unique attachments for each recipient with a standard plan.

  21. Hi there,
    I attached a word document, and it was sent, but the file itself won’t open and kept showing message Temporary error 404. What shall I do?

    1. Hi Riham,

      Please make sure that the document is shared so that anyone with the link can view/access the file. If you’re still running into issues, please contact support (gmass.co/g/support)

  22. Hi
    I have tested Gmass bulk mail with different attachments but the mails are going to spam floder how can i fix it

  23. Hello, Is it possible to send to more than one email address per recipient, for instance if I enter two addresses in a cell and separate them with a comma or semicolon?

  24. Hey,
    I have tested this and it’s amazing. Can I know the limit of emails for free version and paid version?

  25. As far as me being a member here, I wasn’t aware that I was a member for any days, actually. When the article was published I received a username and password, so that I could participate in Comments, That would explain me stumbuling upon this post. But we’re certainly all members in the world of ideas.

  26. It’s difficult to get knowledgeable individuals within this topic, however, you be understood as you know what you are referring to! Thanks

  27. Ta for giving the hyperlink but unhappily it looks incapable to pull up? Will any person possess a mirror or even different supply?

  28. it sometimes difficult to select the right kind of mens clothing but there are helpful buying guides on the internet*

  29. There are a couple of interesting points in time on this page but I don’t determine if I see them all center to heart. There exists some validity but I’ll take hold opinion until I consider it further. Great post , thanks and now we want a lot more! Included in FeedBurner at the same time

  30. I as well as my buddies appeared to be looking through the nice key points found on your site and unexpectedly developed a horrible suspicion I had not thanked the blog owner for those tips. The guys were definitely as a result joyful to read through them and now have in truth been tapping into them. Appreciate your actually being really thoughtful as well as for going for this kind of decent subject matter millions of individuals are really needing to be aware of. My sincere regret for not expressing appreciation to you earlier.

  31. The Case For HIIT Cardio – Why You Should Concider it… By the way you might want to check out this cool site I found……

Leave a Reply to Osama Haniya Cancel reply

Your email address will not be published. Required fields are marked *

Start your free trial of GMass now

Install in 30 seconds — no credit card or sign up form required

Try GMass for free Then check out the quickstart guide to send your first mail merge email in minutes!

GMass

Share This