A Google Sheets mail merge is the best way to send a personalized email campaign (of any size) through Gmail.
Whether you need to…
- Send personalized emails at scale.
- Cold outreach to 500 (or 1,000. Or 50,000!) prospects.
- Reach out to 200 job candidates.
- Invoice 50 clients.
- Invite 25 friends to a party.
Whatever the case, you’re wound up here with me today because you know mail merge is the answer — and you can just kinda sense that Google Sheets and your Gmail account are the ideal tools to make it happen.
They are. We just need to point you in the right direction.
In this article, I’ll walk you through the four methods you can use to send a mail merge with Google Sheets.
I’ll help you figure out which method is right for you — and I’ll even give you a step-by-step guide to sending a mail merge in five minutes flat.
Google Sheets Mail Merge: Table of Contents
- What Is Mail Merge?
- Your Four Choices for a Google Sheets Mail Merge
- How to Decide Which Mail Merge Technique for Google Sheets Is Right for You
- Quickstart Guide: Sending Out a Google Sheets Mail Merge in the Next 5 Minutes
- Advanced Mail Merge Techniques: Beyond Basic Text
- The Wrap-Up: Mail Merge with Google Sheets Like a Pro
- Google Sheets Mail Merge FAQ
What Is Mail Merge?
Just to make sure we’re all speaking the same language before we begin, let’s take a quick moment to define mail merge.
Mail merge takes data from a spreadsheet or other database of contacts and automatically inserts each person’s unique info into a template — creating personalized, individual versions for each of them.
Instead of you having to manually copy and paste 100 first names and 100 personal messages into 100 emails, mail merge does it in seconds.
Each person receives their own message with their specific details.
And yes, “mail merge” is a completely antiquated sounding term but no one has come up with anything better… so we roll with it.
Using mail merge in email
This is what you’re probably here for.
A Gmail mail merge means each contact in your Google Sheet gets their own personalized email — with their name, company, custom pricing, or whatever other data you want in the message.
The key: Recipients see a normal email addressed just to them. There’s no evidence of mass sending and no other recipients visible. It looks as if you personally typed out the message.
You can merge data into subject lines, body text, links, images, and more — pretty much anywhere in an email. The more sophisticated your mail merge tool, the more you can personalize.
Using mail merge for documents, address labels, and the like
Mail merge isn’t just for email.
You can also use spreadsheets to create personalized documents in Google Docs or Microsoft Word — think certificates, letters, or contracts.
The same principle applies here as it did with email: One template, many personalized outputs.
This works for physical printed documents too, like wedding invitations with guests’ names and addresses, shipping labels for your online store, or name tags for events.
If you need to create multiple versions of something with different data, mail merge handles it.
In this article, we’re just focusing on email mail merges. We have other blog posts if you’re looking, say, to figure out how to use Google Docs for mail merge.
Your Four Choices for a Google Sheets Mail Merge
There are four primary methods to use a Google Sheet of data in an email mail merge.
Each has its pros and cons, depending on what you’re trying to accomplish.
Here’s the breakdown.
1. Using a Gmail Chrome extension
If you’re looking for the highest-quality mail merges or you’re doing anything professional or where quality is non-negotiable, you’ll likely wind up using a Chrome extension to add mail merge features to Gmail.
Chrome extensions like GMass (which was the original Gmail mail merge extension), Yesware, and Mixmax work right inside Gmail.
You connect your Google Sheet, compose in the regular Gmail window, see drafts in the regular Drafts folder, and see your sent messages in the Sent folder.
Again, the goal of Chrome extensions is turning Gmail itself into a mail merge platform.
Top 3 pros
- Works where you already work. No learning new interfaces. You’re literally using Gmail’s compose window, just with new, extra powers.
- Most feature-complete option. Extensions generally include automated follow-ups, scheduling, deliverability tools, analytics — everything you need for professional campaigns.
- Fastest setup to sending. Install extension, connect sheet, send. Under 5 minutes from start to campaign launch. (Stay tuned in this article to try that yourself!)
Top 3 cons
- Desktop and Chrome only. Chrome extensions only work in Chrome, and only on the desktop. You can’t create campaigns from your phone. (Though you’ll be able to do things like check campaign analytics on mobile)
- Costs money for professional use. Free trials exist, but you’ll pay $25+/month for real sending volumes through GMass. (Or way more for Mixmax or Yesware, as they also include significant sales team features.)
- Gmail exclusive. If you use Outlook or another email client, this won’t work for you.
2. Using a Google Sheets add-on
Add-ons like YAMM (Yet Another Mail Merge), Mailmeteor, and Mergo operate from inside Google Sheets. You set up and send campaigns from inside your spreadsheet rather than inside Gmail. (Though there is some going back and forth to Gmail.)
Top 3 pros
- Cheap plans available. Add-ons for Google Sheets mail merge are much less powerful and include way fewer features than the Chrome extensions. As a result, they’re usually (though not always) cheaper.
- Works in some browsers besides Chrome. Workspace add-ons play nicer with other browsers than Chrome extensions, so you can likely send your mail merges from Firefox and others.
- Sometimes you just need the simplest tool. If you just need names merged into emails, these tools handle it fine.
Top 3 cons
- Limited features. As I said before, the add-ons are underpowered — while the Chrome extensions are essentially full-featured email sending platforms. The add-ons lack features like auto follow-ups, advanced scheduling, and deliverability tools. You get basic mail merge and that’s it.
- Clunky workflow. Bouncing back and forth repeatedly between Sheets and Gmail to compose, preview, and send feels disconnected.
- Low sending limits. Even paid plans often cap you at 400-1,500 emails/day.
3. Using Google’s built-in mail merge tool
Google added native mail merge to Gmail in 2023. You probably didn’t know that because they gave the release zero fanfare and still essentially never promote the tool (**cough** there’s a reason **cough**). It’s included with certain Workspace plans.
Top 3 pros
- “Free” with paid Workspace. If you have Google Workspace’s Business Standard plan or higher, mail merge is included. (But if you’re a solo operator or small business, you probably don’t have that plan. It’s $14/month and up.)
- No installation or third-party tools needed. It’s built into Gmail already.
- Google-official solution. Some organizations prefer sticking with first-party tools.
Top 3 cons
- Extremely limited. Remember when I said add-ons had limited features? They do… but Google’s built-in mail merge is even more limited. You can’t schedule sends (yes, with their mail merge tool, it turns off their scheduling tool). There are no follow-ups and no tracking. You can’t even mail merge into the email subject line.
- Not included on the plan you probably have. Google does not include their mail merge tool in the $7/month Business Starter plan — aka the plan that everyone uses.
- Hard sending caps. There’s a maximum 1,500 recipients per day, period. No way around it.
4. Writing your own Google Apps Script
For the technically inclined, you can code your own mail merge using Google Apps Script.
There’s a starter template you can get here. Any modifications will have to come from your own developing work and/or a heavy vibe coding assist from a LLM.
Top 3 pros
- Completely free. The only cost here is your time and expertise.
- Total customization. Build exactly what you need, nothing more or less.
- Learning opportunity. This is a good project for if you want to develop Apps Script skills. I dunno. I needed to get to three pros to keep this article symmetrical and this was the best I could dream up for a third one.
Top 3 cons
- Requires coding knowledge. Though it seems like you can just cut-and-paste in the provided script… you can’t. JavaScript experience (or a lot of patience to vibe code with an LLM) is mandatory. This isn’t for beginners.
- Time-intensive setup. Expect hours of work for a basic mail merge tool, or days of development for anything beyond basics.
- No support or updates. When Google inevitably changes something and your script breaks, you’re on your own.
How to Decide Which Mail Merge Technique for Google Sheets Is Right for You
Alright. So those are your four options. How do you choose?
These are the three major questions you should ask yourself to assess:
1. Do you need your mail merge to be professional quality?
If you’re sending professional emails — cold outreach, customer communications, invoices, resumes, donation requests — you need professional features.
That means tracking, follow-ups, scheduling, advanced mail merge, and deliverability tools.
Chrome extensions are your best bet here. None of the other methods give you the features I just mentioned.
For birthday invitations or one-time personal use? A Google Sheets add-on will probably work fine. So would Google’s built-in tool, but I’m assuming you don’t have access in your plan.
2. What are you willing to put up with to save a little money?
Here’s some of what you give up with free or cheap tools, like most of the Google Sheets add-ons or Google’s built in tool…
You can’t schedule sends for optimal times. You can’t set up automatic follow-ups (which can 3x your response rates). You don’t get real analytics. You can’t test if your emails are going to go to spam. You can’t verify email addresses before sending. You can’t A/B test.
Basically, if you’re wondering if you can do something… odds are, you can’t.
There’s also a lot of back and forth between Google Sheets and Gmail, so the sending process is inefficient.
But, yes, these tools are cheap. In some cases, absurdly cheap.
So if saving around $15-$20/month is worth the trade-off on features and efficiency, go with YAMM or Google’s built-in option.
But calculate the time cost; if these limitations add two hours of work once a month, you’re valuing your time at $7.50 to $10/hour.
(And for the free route, think about the time it would take to set up your own mail merge apps script.)
3. Do you send out any other types of professional emails at scale?
This is the hidden consideration. If you’re doing mail merge, you probably also send cold emails, newsletters, or other email campaigns.
Tools like GMass handle all your different types of email campaigns from one place. Instead of paying for a mail merge tool AND a cold email tool AND an email marketing platform, you can just use your Chrome extension for everything.
Quickstart Guide: Sending Out a Google Sheets Mail Merge in the Next 5 Minutes
Alright, decision time is over. We are people of action.
Let’s get you sending.
I’ll use GMass since, based on the above criteria, you’ll probably wind up picking it (or you’ll try one of the others and then end up there eventually). Most important, it’s the fastest path from zero to campaign.
Start that timer…
1. Install the GMass Chrome extension (30 seconds)
Go to the Chrome Web Store and click “Add to Chrome“. Grant the permissions when asked — GMass needs access to Gmail to add its features.
Refresh your Gmail tab. You’ll see a new red “GMass” button next to the regular blue Send button in the Gmail compose window and a few other new buttons added to Gmail.
Skip the onboarding tour for now. I can’t believe I’m saying that, since I meticulously built that onboarding tour and I think it’s incredibly useful — but we don’t have time. You can always do it later.
2. Make sure your Google Sheet is ready for merging (1 minute)
Your Sheet needs:
- Column headers in row 1 (like FirstName, Company, and Email)
- An email address column (can be named anything)
- One recipient per row, starting in row 2
Quick advice: Remove spaces from column headers. Use “FirstName” not “First Name” — it’s cleaner for merging.
We don’t have time now during this five-minute sprint, but I did recently write a guide of all the best practices for formatting your Google Sheet for mail merge. Read it later, then share tips from it to impress people on dates.
3. Connect your Google Sheet in Gmail (1 minute, including granting permissions)
Click GMass’s sheet icon in Gmail (it appears next to the Gmail search bar after you’ve installed GMass).
If it’s your first time, you’ll grant GMass permission to read your sheets.
Select your Google Sheet from the dropdown, then click the button marked Connect to Spreadsheet.
GMass instantly pulls your email addresses into the To field and compresses them all into one alias address to keep things neat.
4. Compose a quick email (2 minutes)
Type your subject line. Include merge variables using {FirstName} or whatever your column headers are.
No need to go back and forth to your Google Sheet to remember them. Just type a left curly brace { and GMass will show you all your column headers. You can click on any to insert it.
Example: “Quick question about {Company}’s marketing strategy”
In the body, personalize naturally: “Hi {FirstName}, I noticed {Company} just launched a new product line…”
The curly brackets are how you merge in the data from your sheet. Each recipient will see their own specific information.
5. Send your mail merge campaign (30 seconds)
Normally, we’d want to test a mail merge before we send but that adds some time. So we’re going to YOLO this and send. (In the future, though, please do test your mail merges.)
Hit the red GMass button to send your campaign (NOT the blue Gmail send, or the mail merge won’t work).
That’s it. Each person gets their personalized email individually.
You can track opens, clicks, and replies in your GMass reporting dashboard.
Get Started with GMass
If you’re ready to run professional mail merges that actually deliver results, GMass gets you there faster and easier than any other option.
I haven’t even had a chance to cover a whole bunch of GMass’s other unique and powerful features like Spam Solver (fix your email if it’s destined for the spam folder)… the ability to break Gmail’s limits… unlimited auto follow-ups… and so much more.
All for less than you’d spend on lunch for two — and all inside of the Gmail interface you’re already comfortable with using.
Install the Chrome extension, start your free trial (no credit card required!), and send your first campaign in the next 5 minutes.
Advanced Mail Merge Techniques: Beyond Basic Text
Once you’ve mastered basic mail merge, these techniques take your campaigns to the next level.
Mail merging PDFs or other attachments
This is a technique few people know about — but you can actually send unique attachments to every mail merge recipient as well.
Add a column called “Attachment” to your Google Sheet. Put the full file path or URL for each person’s unique document.
When GMass sees this column, it automatically grabs the right file and attaches it to the recipient’s email.
This is perfect for sending personalized invoices, proposals, or reports.
Mail merging images
Create a column with URLs to different images (wrapped in HTML — don’t worry, there are instructions to help if you don’t know how to do that).
Then each of your recipients will get their own personal image in their message.
This works great for individual product recommendations, custom QR codes, or including your recipients’ company logos in your emails.
Mail merge with unique CC and BCC addresses
Need different people CCed on each email? Add “CC” and/or “BCC” columns to your sheet.
Common use: Looping in specific account managers or copying assistants on client emails without manual work.
Recurring mail merge automations
Mail merge campaigns don’t have to be one-time sends.
You can set up a campaign that goes out automatically every time you add a new contact to your Google Sheet.
You can set up the automation in just a few clicks. GMass will monitor your sheet hourly (or daily, or weekly, or whatever time frame works) and send your campaign to any new entries.
This is perfect for welcome sequences, onboarding emails, drip campaigns, renewal reminders, and more.
The Wrap-Up: Mail Merge with Google Sheets Like a Pro
There are four primary methods to mail merge Google Sheets data into emails.
Pick the best one for you based on your needs:
Need professional features? Chrome extensions like GMass give you everything — advanced mail merge, tracking, follow-ups, deliverability tools, and unlimited sends.
Sending occasionally for personal use? Super cheap tools like YAMM or Google’s built-in option work fine.
Want total control for free? Build your own with Apps Script.
Ultimately, if your emails really matter — if you’re trying to land clients, serve customers, or grow your business — invest in the right tool. The difference between 2% and 10% response rates pays for professional software hundreds of times over.
GMass takes 5 minutes to set up and costs less than a streaming subscription. You get the same mail merge powers that Fortune 500 sales teams use, right inside Gmail.
Start your free trial and see why 400,000 users trust GMass for their mail merge needs — and why they rate it an average of 4.8 out of 5 stars across tens of thousands of reviews.
Google Sheets Mail Merge FAQ
And finally, answering a few questions you might have about mail merging with Google Sheets and Gmail.
Can I use mail merge with a free Gmail account?
Yes. Most tools work with both free @gmail.com and paid Workspace accounts. Workspace accounts just have higher sending limits (2,000/day vs 500/day).
(There’s also a little tweak that has to happen if you’re sending massive bulk quantities; here’s how GMass solved that problem.)
What happens if I have blank cells in my Google Sheet?
Most mail merge tools give you the option to use fallback values.
For example, if “FirstName” is blank, you can default to “there” with {FirstName|there} so your email says “Hi there” instead of “Hi .”
Can I mail merge into subject lines?
Yes… but not with Google’s built-in mail merge tool. It inexplicably doesn’t allow mail merge tags in subject lines.
With Chrome extensions like GMass or add-ons like Mergo, yes, you can mail merge in subject lines.
Will recipients know I used mail merge?
Not if you do it right. Each person gets an individual email with no other recipients visible. Avoid obviously templated language and you’re golden.
How many mail merge emails can I send per day?
Gmail caps you at 500 (free) or 2,000 (Workspace) daily emails. Virtually all platforms will cap you around there.
GMass is the exception — it helps you (legally) break these limits to send 10,000 or more messages in a day.
Only GMass packs every email app into one tool — and brings it all into Gmail for you. Better emails. Tons of power. Easy to use.
TRY GMASS FOR FREE
Download Chrome extension - 30 second install!
No credit card required
Ajay is the founder of GMass and has been developing email sending software for 20 years.
Google is detecting the Gmass effect …. I tried with 3 emails and I had a "Verify your identity due to unusual activity" + now me spreadsheet is banned http://pasteboard.co/1Cxvl93i.png
Hi ,is there an Android compatible option?
I am an Educator ,and have been using FormMule to send out mails . Generally we need it to email Parents about the responses of Google Form ( we use for Assessments)
If there is an Android compatible option,it would be nice.
This error is likely specific to your Gmail account, as I haven't had any other reports of issues. Can you email me your email address, and then I can investigate further?
Hi,
I wanted to send out a mass email today but its unclear if the the email recipients will see all the emails in in the To: box
Also, if I do not want to personalise it (as I do not have the names), I only have a spreadsheet with email adresses. How does the email then look like? I really want to see how the email looks like before sending it off. Is this possible?
all you need to do is to follow instructions
Hi Vivianne — if you use the GMass button, then no recipient will see any other recipient's email address. Individual emails will be sent, one to each recipient with just that person's address in the To line, If you use the default Gmail "Send" button, however, then all of the email addresses will be shown in the To line.
What is I need to add a cc for only one of my email recipients, how can I do so?
If your spreadsheet only contains email addresses, that is fine. You just won't be able to personalize. You can always send yourself a test message first. In the future, I'll be adding a feature to make sending test messages easier.
My emails are on an excel spreadsheet. How do I convert / prepare the spreadsheet so it is compatible with Google Sheets for import into Gmass?
Never mind – figured it out. Copied excel data into a new Google Sheet and renamed, etc. Thanks! Great resource! Looking forward to giving it a whirl!
How about the variables? Do we have that as well? like evey email has different subject
I just tried sending a mass email to 1200 people, it seemed to go through but in my sent box i can only count about 30 emails that seemed to go out.
Any thoughts?
scratch that it seems to be working now
Hi GMass! Thanks for creating a great product. I have a list of emails (non-gmail) on one column, and a list of first names on another column. How do I pull data for the first names into the mail merge?
yea thanks
I just sent a Gmass email to 78 recipients using google sheets for my contact list. It all looked fine but I don't see anything in my sent box and it is still in drafts. I clicked to send now but it says it is scheduled for 4 am! I guess I have to wait until tomorrow morning to see if it got sent. Maybe the problem was that I asked to do drafts only but then nothing happened and I did not see any drafts. So I decided to try and send it and this is what happened. I don't want to try again until tomorrow in case it actually goes out. I'll follow up tomorrow. However, why didn't the drafts part work when it said it was? Thanks!
Hi Brian — all you do is follow the instructions in this blog post to connect to the Google Sheets spreadsheet. Then, if your column name is "FirstName" for example, you would use {FirstName} in your Subject or Message to substitute the person's actual first name.
Glad to hear it!
Abs — yes, any columns that are present in your spreadsheet can be used as personalization variables. GMass will create personalization buttons, as shown above, for each column in your spreadsheet.
Yes, it's very easy to convert an existing CSV file or Excel spreadsheet to a Google Sheets spreadsheet, and then connecting that spreadsheet to GMass. Let me know if you need any more help.
You likely received the email I sent to you and a few other users that were affected a server disk issue earlier this evening. I did re-queue your emailing after I fixed the issue, and it did go out to all 78 recipients, eliminating anyone that had already received it. As far as the scheduling, I'm wondering if you saw the time in GMT time after you sent it. It might have looked like it was going out in the future, when it was actually in mid-sending at that time. We do attempt to localize times based on your computer's set time zone though. If that happens again, please send a screenshot to hello@gmass.co.
Hello I have just tried GMass and it seems great can you tell me how many emails I can send from GMass daily as I dont have any Google apps account.
Hello I have just tried GMass and it seems great can you tell me how many emails I can send from GMass daily as I dont have any Google apps account.
With a regular Gmail account, 500 emails/24 hours. With a Google Apps account, 2000 emails/24 hours. We are about to release a feature that will make sending up to 10,000 emails very easy — we'll distribute it over multiple days so you don't violate your account limits.
how do i uninstall Gmass, i don't have anymore use for it.?
Just remove the Chrome Extension. Click the three lines icon on the right-hand side of the toolbar in Chrome, More Tools -> Extensions, locate the GMass and click remove.
Is Gmail/Google going to block this extension at some point because it potentially violates SPAM laws? Just curious. I've been waiting for an extension like this, but I'm hesitant to use it heavily because I'm worried it will be short-lived.
That is unlikely. GMass itself doesn't violate any laws, spam or otherwise. Gmail polices its network quite aggressively for spammers, so if anyone attempts to send spam through GMass, then the individual Gmail account will be closed. GMass isn't doing anything that Gmail doesn't already make possible.
Good to know. Thanks.
This is a great tool!
I tried sending emails to all residents ( 300 nos)of my colony . It seemd to work very well. Around 250 people opened as per report generated.
I am using google sheet on drive for email ids.
One of the fields is "Name". It did not work for quite some time. But when I erased and re-entered the same "name" , it worked. Does formatting of header row affect in any way ???????
Using Gmass with secrwaj@gmail.com id.
Argh. I LOVE This! Except when I click on the buttons to insert fields, they do not insert. When I type them in manually, they do not work
I am on a iMax OSX Yosemite 10.10.5 Chrome Version Version 43.0.2357.132 (64-bit)
If the header column is just "Name", then that should work just fine, whether you're using the personalization button or typing "{Name}" manually in the Subject or Body. If you want, we can do a screen share session and you can show me an example where it doesn't work, so I can fix it. Please email me at https://www.gmass.co/support/form.
When you type them in manually, they should definitely work. Can you send me a screenshot of your message before you hit the GMass button? Email me at https://www.gmass.co/support/form.
Clicking on the spreadsheet button does not load the addresses into the To field even though the connection to spreadsheet appears to be good
I like Gmass a lot but I can't figure out how to send emails to a subset of the people listed on my Google Sheets spreadsheet. It looks like when I select a spreadsheet, and compose a message, the recipients listed include everyone on the spreadsheet. I can filter out the people I don't want to email on the spreadsheet itself, but they still appear as recipients when I compose the email. How do I limit the recipients to what would be a "group" in gmail contacts?
— Arthur
I guess you sort your recipients before contact the sheet
Hi MJ,
We have a feature that was added to GMass a couple of months after the initial request. To send to only selected rows in your sheet, please visit https://www.gmass.co/blog/send-mail-merge-to-selected-rows-spreadsheet/
Hi,
What happens if there are duplicate entries in the spreadsheet? Will Gmass recognise that there are more than one instance of the same email that's being sent?
Thanks!
Unfortunately no. GMass removes duplicate email addresses from an email campaign, even if you have multiple rows of the same address but with different data in your Google Sheets spreadsheet. Several users have asked for a workaround to this though, so I am coming up with a solution.
This is by design. GMass will send to all email addresses in a chosen Google Sheets spreadsheet. To filter out certain addresses, you can manually remove them from the To field after GMass connects to the spreadsheet, or you can copy/paste just the rows you want to send to from the current spreadsheet to a new spreadsheet, and then have GMass connect to the new spreadsheet.
What happens then when you connect? Does the To field show up as blank? Please email me at https://www.gmass.co/support/form and I can help you with this.
I try to connect a sheet and I get the following:
GMass: DbEntityValidationException: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.
Not sure what to do to proceed?
Please contact our support team through http://gmass.co/g/support
When I tried to insert the column named "Name", "Dear {Name}," it won't insert. It just showed "Dear ,", do you know why? There are about 300 lines in the sheet. Thanks for your help!
Marco,
I got the same message when trying to connect to a spreadsheet with over 1500 lines.
GMass: DbEntityValidationException: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.
Does anyone know what the issue is?
Marco,
I got the same message when trying to connect to a spreadsheet with over 1500 lines.
GMass: DbEntityValidationException: Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.
Does anyone know what the issue is?
Can you please email me at https://www.gmass.co/support/form? I'd like to take a look at your spreadsheet and see what's happening. Thanks.
Marco – can you please email me at https://www.gmass.co/support/form? I want to replicate your issue and solve it permanently.
Irene – can you please email me at https://www.gmass.co/support/form so I can take a look and help you? If your column is called "Name" in Google Sheets, then that should work.
Hi,
Any idea why the test email goes through, but not the actual email?
My google sheet is pretty small, but the Gmass send tab seems to have frozen.
Thanks!
Hi, tried again and now I get this error when trying the test email function.
There was a PROBLEM sending your test email to pubudini@creately.com: Google.Apis.Requests.RequestError
Not Found [404]
Errors [
Message[Not Found] Location[ – ] Reason[notFound] Domain[global]
]
I got the same error message (hard to copy, as it disappears quickly).
I send a test email, successfully received.
I changed the concept.
I resend a test email, was refused with error message:
There was a problem sending your test email
Google.Apis.Requests.RequestError not found [404]
Errors [Message[Not Found] Location[-]
Reason [notFound] Domain[global]]
– inner:
Hi, I am unable to use the Google sheet option. When I click the Red color box to insert the sheet – it is showing "Please wait for Google sheet spreadsheets to load" for 2 mins but it doesn't get loaded. Tried relaod and restart but no luck.
This is strange. Unless you have hundreds of spreadsheets, it should load within just a few seconds. I suspect this was a temporary quirk, as people are using this feature constantly throughout the day. If you still need help, email me at https://www.gmass.co/support/form and I'll diagnose your account individually for you.
Pubudini – if you're clicking the GMass button and nothing is happening, you might have accidentally disabled it. Please see this article and follow the instructions: http://blog.gmass.co/2016/01/beware-of-checkbox-in-alert-box-gmail-email-campaigns.html
Pubudini – to answer your other question about the test email — that can happen if you hit the "Send Test Email" button before GMass has a chance to extract certain information from Gmail. Usually if you just hit it again, your email will send and the error will go away.
MarkDQ — same answer as for Pubudini. If the error still persists, please email me at https://www.gmass.co/support/form.
Marco – I just fixed the bug you reported here. Please see http://blog.gmass.co/2016/04/bug-fix-gmail-mail-merge-error.html for info on the fix. I also found you on Twitter and tweeted you just now to let you know.
I'm having this issue persistently for 3 days now. I have tried everything with the lists, I cleaned up formatting, renamed the columns, etc etc. split the list into smaller batches.
I get the test email where none of the parameters would be inserted.
I'm really puzzled why. I was supposed to start my campaign on Tuesday
Count me as another vote for this feature. My temporary workaround is to slightly edit the duplicate email addresses so multiple messages are created, sending as draft, then going in and manually correcting the email addresses and sending manually. Not ideal but I'm only merging about 50 rows with 8 or so duplicates.
Hi Ajay, Thanks for the great work. I have a query to ask.
I got around how to use GMass. But is there any way to change the name of the sender while sending mail. Please note that I have changed – "Send Mail As in the G mail Settings". But the new changed name is not getting used when sending mails via GMass.
Is there something that I am missing ? Can you tell what to do in this case ?
Yes, please see: http://blog.gmass.co/2016/03/Set-From-Name-Gmail-Email-Marketing.html
Hi!
Is there a way to trigger a gmass email upon a Google Form submission? ie, the moment a Google Sheet gets populated, that gmass can auto-send the auto-follow up email protocol?
Hi,
Firstly it worked just fine. I was really impressed by GMass. But now when I connect to a spreadsheet and send the mail to say 350 recipients it is only sending the mails to 11 or 12 addresses. I am really in need of this feature. Can you please suggest something?
I just tried sending a mass email to 3000 plus people, it seemed to go through but in my sent box i can only count about 30 emails that seemed to go out.
Any thoughts?
I have the same issue.
Can I add custom field on the title
HI Ajay,
I have been facing issues, as the Gmass is not detecting names. The final mails are sent as below:
Dear {Name},
I have tried all the tricks but am missing something.
Hi Ajay,
Gmass is working well for me.
The only problem is my signature does not appear within the message at the bottom, whenever I successfully link to a Google Sheets doc.
Is there some setting I'm missing? When I compose an ordinary email, the signature is there correctly.
Thanks..
How does gmass work? Can I edit the google sheet while my email is in draft mode and sending emails daily? Also, if a subscriber is on my list they will only get the email once, correct?
When I say I've tried everything to find a work around for this, I mean it. I'm pretty sure I've thought of everything, to include cutting the sheet down to 5 and even trying to send it to only 1, but no matter what, it will not send. It works fine with other tested sheets. Can't figure this out. And I've even made separate sheets with the same info to try to circumvent the issue. PLEASE HELP
Google.Apis.Requests.RequestError Not Found [404] Errors [Message[Not Found] Location[ – ] Reason[notFound] Domain[global]]
Hi, I thought I read where you could send up to 10,000 emails per day? It stopped me and said I could only send 500 per day. Is there anyway around this?
Just out of curiosity, is there a feature that I could compose HTML instead of plain text? Usually my messages has embedded links and if you hover the mouse into it, you’ll see an indirect link of google.com.
You always do the right thing. God Bless you.
Thank you
Hi Ajay, can you help me. I have set (apparently) everything as you describe in this page tutorial. I have loaded the google spreadsheet and wrote my e-mail.
However when i hit the “GMASS” red button i don´t see nothing happenning.
What shall i do to shoot my e-mails.
Please email us at https://www.gmass.co/support/form.
Your GMass request failed. Error details: Google.Apis.Requests.RequestError Not Found [404] Errors [ Message[Not Found] Location[ – ] Reason[notFound] Domain[global] ]
What does this error mean and how can I fix it? The first three GMass emails went great. Then one said all links in the newsletter had to be replaced. I copied and pasted another version of the email and then got the error above.
hi,i used to send 1000 emails in day with normal gmail account , past few months i cant send even 20 emails, if i send 500 emails it shows that your message has been blocked all the messages were blocked n returned back , why am i facing such problem, still my friend using gmail they are sending bulk emails, so i started using gmass from yesterday, i added 100 recipients, when i press the gmass button its shows “i can send only 50 email in a day, otherewise i have to choose a plan, i dont understand, why i have to pay when i used to send bulk email in 1000s range.please help me out,with normal gmail account all my messages are blocked by sending, so i created new email address to send as new but still am facing the same problem tat “my messages are blocked”give me some solution.. could you respond to it.
Is there any way to add emails from different worksheets within the same spreadsheet? I have one spreadsheet for all of my students with different classes on different worksheets. Each worksheet has it’s own list of emails and I need to be able to send one email to all of my students. So I need to add email addresses from four worksheets to the BCC field in one email.
Hello,
I am facing an issue with G-mass, Somehow the trail e-mails that I am sending id not able to pick the First name or last name as it should. Can you help me rectify the situation or guide me to the right way of using g-mass.
I set up a test sheet on GOOGLE SHEETS
about 5 emails….. and I get a message to wait to the sheet to load.
It has been over an hour…. Am I doing something wrong ?
Opened a new email… and tried other similiar things…but it is not loading.
Hello Ajay,
Can we send different draft emails to the 3 emails schedule for tomorrow through google sheet?
For eg. I have prepared birthday list and daily it automatically runs and send the email as per the sheet. So if there are three birthday on 1 single day then can we have an option to send 3 different draft to 3 birthdays. I have created a draft using birthday wishes image
Ajay – this is going to sound silly….does the google spreadsheet have to remain “intact” until the mailing is done or does GMass read all the necessary data upfront then you can change/delete your spreadsheet if you want? Asking because I scheduled some mail merges for the next day but when they sent, none of the personalised fields (except email) were picked up. Between scheduling the mail merge and it actually being sent, i had changed the spreadsheet and deleted a lot of the fields (in the belief GMass had already captured the data it needed). If you are scheduling the mail merge for later, does the spreadsheet need to remain unchanged in your Google Drive until the send is complete? Furthermore, if you have set up auto-follow up, does the spreadsheet need to remain unchanged until auto-follow up is complete (i think not but could you confirm?). Many thanks – a fantastic product.
Hey Stephen – I believe we spoke over the support address. GMass reads your Google Sheet at the time the Campaign sends. However, once it sends you can edit your Google Sheet as you please, and your Auto Followups will not be affected.
Getting this error
Error while sending GMass emails – can’t read spreadsheet
what need to do ?
Regards
Please contact https://www.gmass.co/support/form with a screenshot of the error.
I want to cc myself and get a copy in my inbox. Is this possible?
can i use it in Hebrew? will it take the hebrew name/company and align text from right to left?
Yes. Since GMass allows for HTML email, you could set your alignment from right to left. Please see https://www.gmass.co/blog/use-custom-html-in-gmail-compose-window/
Hi, is there a way to select specific column in Google Sheets for the email addresses to be sent to? I have 2 columns of email addresses and I want to select just 1 specific column.
Ryan Seacrest to host Oscars red carpet pre-show after denying sexual harassment
allegations by former colleague. Read more on sports
Rick Ross ‘recovering at home’ four days after hospitalisation. Read more on Movies gossip
Hi, thanks for this great solution. My question is if emails sent with Gmass provide the ability to see who has read/opened the email, or if not, if the integration of MailTracker or such solution in Gmail will also work for emails sent with Gmass.
Thank you!
Hi Jaume,
GMass has a campaign report sent to your email to keep you up to date with your campaigns.
GMass has an integrated tracking system.You can turn on/off link or email opening tracking that’s built in, or add your own tracking domain.
To learn more, please see https://www.gmass.co/blog/gmail-mail-merge-reports-and-analytics/
How much we connect gmails accounts?
Like if i use multiple accounts like in bulks gmail accounts..
It is possible like i ask above?
Hi Shahid,
You can subscribe to multiple subscriptions for different Gmail accounts. You might also be interested in signing up for a team plan if you’re planning on subscribing 5 or more email accounts. Team plans have centralized billing as well as a discounted rate from the individual premium subscription plans. Please see https://www.gmass.co/pricing and under G Suite, you will see the option to select either individual or team plans.
Hello,
I’m attempting to connect a spreadsheet to an email, but when the new message loads rather than an email list of recipients in the email field it just has “GMass Recipient List From Worksheet “. It seemed to work fine with a test spreadsheet that I created, but not with the spreadsheet that I need to connect to. I double checked the formatting on the spreadsheet and it’s set up correctly. Thanks in advance for any help you can offer.
Hi Brian,
Please contact our support team through http://gmass.co/g/support with a screenshot of your spreadsheet (including the headers) and your compose window.
Please tell me how to delete Gmass from my gmail account. I DO NOT wish to subscribe and the links are an annoyance.
I have opened another email account for my bulk emails. Thank you
Hi Rosemary,
Please see https://www.gmass.co/blog/how-to-uninstall-gmass/
Made payment on 4/2/18. Getting error to upgrade
Contact our support team by email with a screenshot of the error you’re receiving through http://gmass.co/g/support
I can get “Filter Rows” to work if I set Name=Somebody but can NOT get it to work if I set Date=CurrentDateIgnoreYear
“Connect to Spreadsheet” does nothing whereas when I set Name filter it opens compose window.
Please contact our support team through http://gmass.co/g/support with a screenshot of both your spreadsheet (including your headers) and your compose window for your email.
I am new to GMass.
1. Can I add an attachment to GMass emails?
2. Can I add different (personalized) attachment to each GMass recipient?
If so, how can I do it?
Hi Devon,
1. Yes, you can attach files using the default attach files icon in Gmail.
2. Currently, that’s not a feature offered in GMass but it is in the roadmap for future features to be added.
Has this feature been implemented yet?
does this feature is already added on GMass?
I just sent an email to 9 recipients via google sheets using GMass. I was expecting to see the mail sent, opened, and clicked updates on the sheets, as I did in my test campaigns. But so far the report is only in Gmail and not showing in the google sheets.
Hi Megha,
GMass does not update the spreadsheet, it is merely used as a list for recipients’ emails and mail merge. You can still download those details such as blocks, click and open tracking through the GMass reports found in your email.
Marvin,
and what if update the list of recipients of Google Sheet? Adding or removing some?
What if try to do the same on a list of recipient on stored as a draft of the email of a running campaign?
Hi Antoine,
Adding recipients into a Google Sheet will only work if your campaign is set to be a recurring campaign (https://www.gmass.co/blog/new-feature-recurring-automated-email-campaigns-with-gmail-and-google-sheets/). Please note that removing contacts in your connected sheet will not remove them from the running campaign.
If your campaign is not a recurring campaign, adding or removing rows does not affect the campaign.
thx
Hi sir,
i have small setup for photo editing service world wide. i already use this service. But, my gmail got spammy. Then i get few clarification mail from you if i add CNAME, TXT/DKIM, SPF record to my host domain page. Then, my mail would not be spammy. And, i can work free mind my mailing campaign. my gsuite mail id is retouchhub@retouchhub.org……now, tell me what i did next before start again mail campaign by GMASS service. this time, i dont back so before start campaign. you share me all further process. what you think.
Hi Arvind,
Please contact our support team through http://gmass.co/g/support with your most recent campaign ID that you’ve found to be landing in spam so that we could address your concern.
Can you set the delivery/send date and time of emails with a column in Sheets?
Hello? Bump…
Hi Chad,
We can’t set the delivery time but you can set the date.
Please see https://www.gmass.co/blog/gmail-birthday-emails-automatically/
Hi Chad,
You can set the date you wish to send but the time we cannot schedule. Please see https://www.gmass.co/blog/gmail-birthday-emails-automatically/ to learn more about date driven emails.
how shall i add if the person has two email? and i need to send to both mails
Eg: Mark abc@yahoo.com
def@gmail.com
Hi Melvin,
Duplicate the row so that the other columns are also filled in so you’ll have 2 rows one for each email address.
I’ve successfully connected GMass to my Google Drive and sent a test batch of 120 emails. How can I add additional emails (on separate Google Sheets tabs) to the same campaign?
Thanks!
how do i connect my googlel sheets in my drive to gmass when i click on the tables none of them come up.
Hi Steve,
If you haven’t done so already, please contact our support team through https://www.gmass.co/blog/how-to-get-support-from-the-gmass-team/
Hi
Hi Gmass Team
I am trying to create a list and upload it but Gmass is not able find the email column.
I am wondering because all emails are there…and I uploaded it before.
Can u please help me with this one
Thanks in advance!
GMass: System.Exception: Unable to find the Email column in the given worksheet: Schweiz Kontakte & Accounts all
This is what is shown.
Hi Franz,
Please contact our support team at https://www.gmass.co/blog/how-to-get-support-from-the-gmass-team/
Is there a limit to the number of emails? I’d like to purge my list by emailing all 10,000 and eliminating those that bounce.
Hi Diana,
Our subscriptions do not have usage limits. Although Google Apps accounts are officially limited to 2,000 emails per day, we have noticed over time that there are other factors that affect the send limits for an account. Age is a huge factor in this, as Google limit accounts to lower sending capacity until the account establishes its credibility. This is a measure to prevent scammers and spammers from opening accounts and sending at full capacity.
There’s some more information about these limits and factors 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/ )
We’re running internal vendor satisfaction surveys, which means that the same person must receive an email for each vendor in their portfolio. How can GMass be configured to believe that duplicate email entries on my spreadsheet means that each separate email recipient entry gets multiple emails, each personalized to the unique information in each row? e.g.
vendor 1, recipientemail1
vendor 2, recipientemail1
vendor 3, recipientemail 2
vendor 4, recipientemail 3
vendor 5, recipientemail 3
etc.
And in other cases, we have more than one staff member who can respond to a survey for each vendor, e.g.
vendor 1, recipientemail1, recipientemail4
vendor 2, recipientemail1
vendor 3, recipientemail 2, recipientemail5
vendor 4, recipientemail 3, recipientemail1
vendor 5, recipientemail 3, recipientemail2
etc.
Are both of these configurations possible?
gmass is rejecting my google sheets spreadsheet. this is what i need for my email addresses and names.
please help
Hi Alice,
Please contact our support team at https://www.gmass.co/blog/how-to-get-support-from-the-gmass-team/
Where do we see campaign results after an email has been sent? When I click on the GMASS envelope on the side it says there is a campaign error.
If the linked spreadsheet accidentally deleted after sending the email campaigns and now when the follow ups are going the error messages are getting shown. So how we could set followups again for the same campaigns.
Error: G-Mass was unable to read from your Google Sheets spreadsheet.
Please suggest a suitable solution
Hi Saharsh,
You can simply recover the spreadsheet. Since your campaigns are based on the spreadsheet ID, you would need to recover the exact sheet (not just a duplicate of it).
Thank you so much for your help and support
I have added first name in the body of my email but the screen for personalisation is not the same as shown in the tutorial and also it does not enter the (first name) and on test it doesn’t put a first name in the email.
Why is this
Hi Lisa,
Your merge tag should match your column headers for your spreadsheet. The {FirstName} and {LastName} are defaults when using Google Contacts.
Can you please add an option to connect to multiple Google sheets at the same time?
It would be very useful.
Thanks!
Hi Bill,
Please comment your request in the following article: https://www.gmass.co/blog/email-marketing-2019/. I’ve also ran your request to Ajay to see if we can have it in our roadmap ahead.
It would be nice if the extension would show the Google Sheet that I’m viewing from sheets.google.com in another tab. I’ve uploaded an .XLSX file to Google Sheets but it will not show in the listing for me to connect to the spreadsheet.
Hi William,
If you haven’t done so already, XLSX files would need to be converted to a Google Sheet. Double click on your Excel file in your Google Drive and you will see the option to open with Google Sheet. This will convert your file to a Google Sheet which you can then connect to GMass.
Is there a way to BCC mass emails, without all the other emails being sent to them.
GDPR and all
Hi Heather,
With GMass, all of the email addresses are sent an individual email addressed only to each so none of your recipients will see each other’s email addresses. You can try it out by sending a test campaign to a couple of email addresses that you have access to.
To send a test campaign, simply add those addresses in the TO field and draft out your test email and click the GMass button. When you check those mailboxes, you’ll see that each of those addresses receives an email addressed only to a single recipient. You can also see this in your Sent Folder where each individual email to each of your recipients are also listed.
This is a really good tip especially to those fresh to the blogosphere.
Simple but very precise information? Appreciate your sharing this one.
A must read post!
Aw, this was an incredibly good post. Finding the time and actual effort to make a superb article?
but what can I say? I put things off a whole lot and
never seem to get nearly anything done.
How much emails send at time means if my excel sheet contact more then 100 when GMASS not spread emails in my account they saying failed. if i am only add 100 or less then they always spread emails.
Why is doing that? can we not send more then 100 emails at the time.
Hi Avanindra,
The reason is you’re using the free version of GMass which limits the number of emails you can send or schedule to up to only 50 emails per rolling 24 hours. If you would like to lift this limit, you would need to subscribe to one of our paid plans found here: https://www.gmass.co/pricing/
I’m new to this program just downloaded and sent test message to gmass staff. Trying to test message my first campaign, When I try to connect google sheets to program, nothing happens. The dialog box does not pull up any of my google sheets data.
Hi Bruce,
Please contact our support team through http://gmass.co/g/support to help troubleshoot and isolate what’s causing this issue on your end.
I have several spreadsheets I want to sent emails to, both with and without multiple tabs.
I started from one with only 5 emails, so definitely not hitting my limits, nor have I any duplicates there, yet I get this error:
GMass: System.Exception: There are duplicate columns in the given worksheet: Sheet1
Any ideas?
Hi Barbara,
This error means that you have columns that have the same column headers. The reason why you can’t have more than 1 column header with the same name (i.e. firstname, lastname, email,etc) is because column headers are used for the merge tags for personalization. For example, if you have 2 columns with the column header “firstname” and you used the merge tag {firstname} then GMass wouldn’t be able to know which of the 2 columns that has the same header you actually want to pull from. This is the reason why we’ve made it so that whenever GMass detects duplicate column headers it will result in the error notification you’ve received.
I notice that the emails are being repeated for new days even though they do not match the ColumnName=CurrentDateIgnoreYear. Is that due to some configuration error?
Hi JJ,
Please contact our support team (https://www.gmass.co/blog/how-to-get-support-from-the-gmass-team/) with a screenshot of your spreadsheet, please include the topmost header row and a few rows below it as well as the email address where an email was sent that did not match the date as per your filter.
WE have not sent any email in the morning today but still, we are facing issues.
when we are sening one or two email with normal send button it is giving this error
You have reached a limit for sending mail. Your message was not sent.
account name :- admin@mucbf.com
can u confirm on this
Hi there! My team has received your request (26568)
Hi!
I’ve sent an email to support – but when I connect my Google Sheet to the GMass email I want to send, individual emails do not populate, but rather one gmass.co address. Is this because of the number of recipients?
(I do have columns set up as FirstName EmailAddress)
Please help!
Hi, I’ve already sent an email to support yesterday, but I haven’t received a reply yet. I’m having trouble connecting my Google Sheets to GMass. Please help, I bought the Premium version yesterday and was hoping to use it today.
Hi Andrew,
I’ve just responded to your ticket. Kindly check your email.
Hi Marvin, I don’t see a reply in my inbox or spam folder. Please kindly send again. Thanks.
Hi Andrew,
I’ve just resent the email response to your email ticket (#27452).
We purchased the premium subscription and added GMass to Chrome. However, the Google Sheets icon is not showing up in Gmail. What are we missing?
Hi David,
Upon checking the registered email you used to make this comment, your subscription has been connected to GMass. We’re showing that you’ve sent the trial campaign already. However, since you mentioned you’re not seeing the “connect Google Sheet” icon, you may have another extension installed that’s causing a conflict with GMass. Please follow the steps outlined in our “Missing GMAss button” troubleshooting guide which would help in isolating what’s causing the issue you’re encountering.
You may also contact our Support Team directly by going to gmass.co/g/support
How do I delete campaigns?
Hi Mark,
Please see https://www.gmass.co/blog/how-to-cancel-a-scheduled-mail-merge-campaign-and-stop-it-from-sending/
Hi,
I have a googlesheet with 445 email addresses, it pops up with a a dialog box which stating to add showsend@gmass.co.uk to enable the send button, however when I do this the send button is not showing, just the gmass button. Is there another step?
Please advise
Thanks
Hi Afzal,
Please use showsend@gmass.co not showsend@gmass.co.uk.
Thanks Marvin, the pop up disappears quickly so got it wrong.
Glad I can be of help. Have a great week ahead.
When a new entry arrives in to a spreadsheet, does Gmass send personalized mail to new entry or will it send email to complete list?
Hi Tarun,
It would depend if you have the campaign set up as a recurring to send to just NEW addresses or to ALL addresses. Please refer to this image: https://marvin-wordzen.tinytake.com/media/c1dffd?filename=1584043399523_TinyTake13-03-2020-04-02-56.png
Hi, is there a way to connect to a Google Sheets spreadsheet AFTER composing the email?
Thanks,
Will
Gmass can’t seem to detect the specific Google Sheet I want, is there a reason why?
The file loader doesn’t seem to be pulling in any of my Shared Drives. I hate to create a personal version — defeats the purpose of keeping the data all in one place.
Hi Lynn,
At this time, GMass does not support team drives. You would need to save the file in your account’s own drive for GMass to detect it.
Is this still the case? My organization uses team drives to make it easiest to share among our org.
My google sheet has 58 email address
BUT why gmass only show 25 recipients???
later on I tried put 10 email address on google sheet
then use gmass
but it only shows 3 recipients???
Hi Shusen,
This is because your connected Google Sheet’s email column contains cells that have multiple email addresses. Please note that the email cell should only contain a single email address.
Hi! My google spreadsheet has 2 email addresses per recipient in two different columns, meaning the name is in one column, and one email address in a second column and the second email address in the third column, but it is picking up the email addresses in only one of the columns.
Also I have 81 recipients in my list by the gmass is picking only 76.
Please advise.
Hi Ajay,
Its working fantastic.
Thank you
I am not seeing the “Google Sheets” icon next to the “Build Email List” button. Is there a way to get this to show up?
I have a G suite account. But the gmail is not allowing 1000 mails to send. It is asking for payment.
Hi Anoop,
The notification you’re receiving is due to attempting to send to 1000 recipients, however, you’re on the free version of GMass which has a limit of 50 emails per rolling 24 hours. If you’d like to remove this limit, please subscribe to one of our paid plans by going to http://www.gmass.co/pricing
I just sent my first campaign out to 7 people via Google Sheet.
If I have more people that I want to send that same campaign email to, how do I do that?
Use the same spreadsheet? Add the names directly to same worksheet?
Will GMass know NOT to send the same email out to the 7 people who’ve already received it?
Create a new spreadsheet? A new worksheet?
Thanks.
Can I please get some basic instructions and solutions on how I can mail merge and send from google sheets dynamically all text in mail merge fields and dynamic image fields? I just signed up and emailed support+id36139@gmass.zendesk.com per the sample I sent? I cannot figure this out. I appreciate your helping me resolve. See the below template. Thank you, Jenna
[Subject/Body Template:]
To: {Email}
Subject: {Custom1} {Custom2}
Body:
{Company}
{Custom3}
{Email}
{Phone}
{Custom4}
{Custom5}
Insert email signature html below in mail merge:
Hi Jenna,
Please make sure that you include the IMG HTML code within your image cells so when GMass pulls the data, it will pull the HTML to display each image. Please refer to this updated Sheet based on your Excel file.
We’ve responded to your ticket directly with a sample Google Sheet based on the image you’ve included.
I am using this to email information to parents on a team. My list is by athlete. I have two situations that aren’t working and need help.
1. Some students have two email addresses associated with them. Is there a way to send information to multiple emails without copy and pasting the columns twice in my spreadsheet. Example can I put in the email column Email1; Email2, or something?
2. Is there a way for me to send an email for EACH row, regardless of if it is a repeat email address? Some students are siblings so I have one row for Student 1 with information regarding Student 1 I want to bring into the email via fields and then another row with information for Student 2. Since the email address listed in row for Student 1 and row for Student 2 match, it isn’t sending an email for Student 2… like it knows one was already sent (but then I’m missing information for Student 2).
1. Yes you can do that. See: https://www.gmass.co/blog/mail-merge-two-people-per-row/
2. Yes, just check the box to send duplicates.
Please update the images as your product doesn’t have repeat daily to new sheet adresses.
it has repeat in the schedule
You are correct. The screenshots have now been updated. Sorry about that.
Hi Ajay,
I have a massive list from SalesQL.com. Their service finds emails from LinkedIn.
I have business and personal emails for many.
Been trying to find a way to send to either or, or both emails.
For example…
Sam Smith ssmith1@dell.com (business) and Smittyfun@gmail.com (personal).
Ideally Gmass would say, if business email is NULL, then use personal email.
Any thoughts on how I could do this?
Hi Matt,
Unfortunately, this would need to be done through a Sheet formula instead.
There seems to be a bug tonight. The gsheet I chose only have 20 unique email address, but GMass is populating the the To field with 121 email addresses. What’s going on?
Hi James,
We’ve responded to your ticket directly. Kindly check your mailbox.
Thanks all, very impressed, found the instructions superb, and all worked flawlessly!
Well done Ajay and team!
Katleen
Thank you!
An example :
10 mail campaign
After I add 1 duplicate row for mistake. Will be considered or bypassed?
Second question : VERIFIED column will be populated in both direct and draft sending mode? If I check the option VERIFY and send immediately, all the recipients mail will be real time verified before sending?
The default option is to skip duplicates, but there are cases where you may want to keep duplicates. This is addressed in this very article.
Yes, that’s correct on verification. Regardless of whether you’re sending or creating Drafts, as long as you’ve marked the option to update your Sheet, the column will update.
Is there a way to have two columns listed next to each and be uniformly spaced apart? For example one column has a list of devices and the other, across it, displays the device serial number. Each email address has different number of devices. Thank you
Yes, you can actually have spaces in your Sheet cells and have GMass respect that. We recently added an internal setting, at the request of another user, to preserve the spaces around the text in cells, for mail merge purposes. If you want us to turn that setting on for you, just let support know, and reference my comment here.
Hello,
Are there known issues with certain email platforms receiving a GMASS mailing? Using the GMASS tool, we’re trying to create a personalized email to parents of an organization. The email loads correctly from a google sheet and we’re able to copy and paste the {first_name} then add the text into the body of the email, however we’ve attempted to send a test email to a handful of different folks using Gmail.com and Hotmail/MSN.com addresses. The Gmail addresses received without incident but there’s been frustrating results with the Hotmail/MSN.com addresses. One of those address had the email go directly to junk, while others never received the email at all. What am I missing?
Hi Rick,
If you haven’t already, we recommend adding a custom tracking domain to your GMass account which would help with deliverability. (https://www.gmass.co/blog/tracking-domain/) You may also want to try our Inbox tool to (gmass.co/inbox) to get a general idea where your emails are landing.
Hello,
(I am posting this again with my wife’s info attached, please reply to both)
Are there known issues with certain email platforms receiving a GMASS mailing? Using the GMASS tool, we’re trying to create a personalized email to parents of an organization. The email loads correctly from a google sheet and we’re able to copy and paste the {first_name} then add the text into the body of the email, however we’ve attempted to send a test email to a handful of different folks using Gmail.com and Hotmail/MSN.com addresses. The Gmail addresses received without incident but there’s been frustrating results with the Hotmail/MSN.com addresses. One of those address had the email go directly to junk, while others never received the email at all. What am I missing?
Hi Sarah-Beth,
If you haven’t already, we recommend adding a custom tracking domain to your GMass account which would help with deliverability. (https://www.gmass.co/blog/tracking-domain/) You may also want to try our Inbox tool to (gmass.co/inbox) to get a general idea where your emails are landing.
I want to send email automatically for every new row added in the google sheet.
The set of data captured from import range from other sheet.
Kindly advice your plotform support this feature or not.
Hi Rajesh,
You can do this easily with a recurring campaign. With a recurring campaign, you’re scheduling GMass to look for new rows on the connected sheet at set intervals. If GMass finds new rows, then it will kick off the campaign drip for each address it finds. To learn more, please see https://www.gmass.co/blog/recurring-automated-email-campaigns-gmail-sheets/
Hi Rajesh,
You can do this by following the step by step in the following article: https://www.gmass.co/blog/recurring-automated-email-campaigns-gmail-sheets/
My google sheets are not loading when I go to select it for the campaign. There are some older sheets showing, but it is not updating to the most current sheets. Can you resolve this or look into this problem for me?
I used the gmass function yesterday. I sent out 29 emails, 20 of the emails came back as blocked emails and the other 9 couldn’t be sent out due to reaching my email limit for the day. Which I don’t see how that’s possible, when I’ve only sent less than 50 emails yesterday. Any work around in making my gmass emails to not be blocked or do I have to go back to sending the old fashioned way of one email and BCC everyone on it?
I am trying to link Google sheets from a different Google sheets account than the email account that I am using with Gmass. It shows that Gmass is linked but does not show any spreadsheets in the drop-down.
I go back to try and link but it is still stuck on the original Google account. How do I change the Google account that I use to link Google Sheets?
Help.
Is there any way to pull information from two worksheets (tabs) on a google spreadsheet?
One tab has my site members. They are the ones I want to email and their email address is in the spreadsheet.
The other tab has one-time users. They will be providing information to the members.
The information they are providing is in the second tab. The one-time users will need to send a message to the members with their email addresses for follow-up. The email won’t come from the one-time user their email address will just be in the body of the message.
Can I do this with GMass?
Hello, my question is does GMASS detect duplicates emails when uploading & will it send duplicates emails when scheduled. Also, where do you find this information on GMASS?
I look forward to your response.
thanks,
JERRY
Hi Jerry,
Yes, GMass will automatically dedupe your mailing list for a campaign. This means that after connecting your Google Sheet to send out Campaign A and let’s say jerry@gmail.com shows up on your list 10 times, GMass will only send to the 1st instance and ignore the other 9 instances. Please see https://www.gmass.co/blog/google-sheets-mail-merge/#:~:text=Step%205%20%E2%80%93%20Decide%20whether%20to%20keep%20duplicates%20(optional)
This is pretty good and straightforward. I was able to grasp it quickly and practise using it. However, I’ve not been able to get how I can use it to schedule birthday messages at different dates. Please help.
Hi,
Is there a way to make the scheduled repeat re-read the whole spreadsheet data? I am programmatically regenerating the sheet and all of the data will change (emails, personalized content etc.). Or is there a way to build an automation that would automatically generate a new GMass with an existing template? (We are sending a weekly personalized email to hundreds of recipients depending on the activity in the service so always a different group of recipients)
I seem not to understand what spam really is. Can someone explain this in simple terms because to some of us sending mass emails is tantamount to spam.
I have not yet subscribed. I have just been trying to learn how it works and that
it is user friendly. I am very keen to have this product but I am struggling to have my
emails spreadsheet created.
Can you support?
Hoping you will find this in order
Yours sincerely
Sam
I am trying to compose a GMASS message, but it is not recognizing the most current version of my Google Sheet that I wanted to pull email addresses from.
How does Gmass handle unsubscribes? Does it automatically remove or suppress those email address from the spreadsheet the next time you send a campaign?
Why is the option to create Gmail drafts disabled in my Mail merge? The Drafts option is only available when you are performing Mail Merge in plain text or HTML. It is not available if you are using a readymade Gmail draft as a Merge template.
In the above sample, The. If you want to include unicode characters, such as emojis, in your emails, you must update the code to use Mail service instead of Gmail service.
Not Bad
Hi
We use Google Mail Merge within our firm for a number of processes, using Google Sheets as the primary data source.
The issue is that when we have a date column in Google Sheets showing as YYYY-MM-DD and run the mail merge the date in the mail merged email shows as YYYY-MM-DD HH:MM:SS GMT +10 (or similar format)
Is it possible to format the date/time to DD-MM-YYYY HH:SS AM/PM in the email template ?
I am using GMASS to send a small number of e-mails once a month (about 15). These are statements going to rental property owners.
Each line in the Google sheet represents one property. Now here’s the problem… Three owners have two properties each. So GMASS picks up the first instance of the owner’s email (first property in the list), and ignores the next one.
This means I have to fiddle with the order of the list, and usually have to send the skipped statements manually.
I’m not going to say it’s a huge deal, just that I like to automate repetitive tasks, and I love GMASS, but I can’t see a way around this problem of having the same email address on multiple rows.
Any suggestions?
Thanks!
Hi John,
When you initially connect your Google Sheet to GMass (where you select the Spreadsheet and specific Worksheet), click on the “Optional Settings” option and you’ll just need to check the tickbox for “Keep duplicates”.
Suppose you connected to a GoogleSheet using the Gmail extension and you have written your draft message etc, but then you decided to add one or more additional fields to your GoogleSheet to add another field to the Gmass merge. Is there a way to refresh the GoogleSheet connection on a live Gmass template?
In the past I’ve had to copy and paste the drafted message into a new template after connecting with the latest version of the GoogleSheet.
I pull data from another system that gets downloaded into an excel spreadsheet. Can I reorder/sort the spreadsheet (alphabetically, for instance, or by date) and still send out all the mailings successfully through by using GMass with Gmail? Also, can I add entries to the excel spreadsheet at any time before I do the merge?
I Want to know that how an i send merge mail at different time zone to saperate person
Hi Ansh,
You would need to set up a campaign for each time zone you want to send. This is because the schedule (which includes the difference of GMT and your desired time zone applies to the entire campaign).
How the report works on the recipient spreadsheet when I use the same spreadsheet for more that one campaign?
Can I use any mail templates in free version?
I’m trying to do a mial merge from a google sheet. I accidentally connected GMass to the google account linked to a particular gmail. However all my docs are on a different google account. Can i disconnect and then cross connect GMass to a different google account?
What is GMass and what does it offer for email marketing?Tel-U
Thank so much for helping me.
Thanks , I’ve just been looking for information about this subject for ages and yours is the greatest I have discovered till now. But, what about the conclusion? Are you sure about the source?
I’ll immediately take hold of your rss feed as I can not to find your email subscription link or newsletter service.
Do you’ve any? Kindly allow me understand so that I
may subscribe. Thanks.
Also visit my web-site; 谷歌垃圾邮件
When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get four emails with the same comment. Is there any way you can remove me from that service? Thanks a lot!
I for all time emailed this blog post page
to all my contacts, because if like to read it then my friends will too.
Visit my web-site … 출장스웨디시
When I initially left a comment I seem to have clicked the -Notify me
when new comments are added- checkbox and from now
on each time a comment is added I get four emails with the exact same comment.
Perhaps there is a means you are able to remove me
from that service? Kudos!
my blog :: 용인출장마사지
Oh my goodness! Amazing article dude! Many thanks,
However I am encountering difficulties with your RSS.
I don’t understand why I can’t join it. Is there anybody else getting identical RSS problems?
Anyone that knows the solution can you kindly respond?
Thanx!!
Feel free to visit my web-site … about
I appreciate your insights into email marketing strategy development.
Do you mind if I quote a few of your posts as long as I provide credit and sources back to
your site? My blog site is in the very same niche
as yours and my users would genuinely benefit from a
lot of the information you present here. Please let me know if this ok with you.
Cheers!
my webpage 영등포출장마사지
I was able to merged my Gmass with my Gmail successfully. The sheet icon appeared at top of my mail box as expected. I was able to use google sheet to sent out samples to a 10 friends and everything was successful. But immediately afterwards Gmass button didn’t appear on my mail box again and google sheets and other icons didn’t appear again. But the status still showing Gmass installed. How can i address this error. I have signed out and signed in multiple times still not showing up
It’s possible GMass is conflicting with another Chrome extension you have. I’d recommend contacting support so they can specifically work through your situation.
Thank you, I’ve just been looking for info apprroximately this topic for a long time and
yours is the greatest I’ve came upon till now.
However, what inn regards to thee conclusion? Are you certain about
the source?
Here is my homepage – https://www.vapeare.com
You really make it seem so easy with your presentation but I find this topic to be really something that I think I would never understand. It seems too complex and extremely broad for me. I’m looking forward for your next post, I will try to get the hang of it!
Simply desire to say your article is as surprising. The clarity in your post is simply excellent and i could assume you are an expert on this subject. Fine with your permission allow me to grab your feed to keep up to date with forthcoming post. Thanks a million and please keep up the rewarding work.
When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get three emails with the same comment. Is there any way you can remove me from that service? Thanks a lot!
Everything said was actually very reasonable. But, consider this, what if you added a
little content? I ain’t suggesting your content is not good.,
but suppose you added a headline to possibly grab folk’s
attention? I mean Google Sheets Mail Merge: How to Send Quick,
Easy Personalized Emails is a little vanilla. You should
look at Yahoo’s front page and watch how they create post headlines
to get viewers to click. You might add a related
video or a related picture or two to grab readers interested about
what you’ve written. In my opinion, it would bring your posts a little bit more interesting.
my homepage bảng hiệu alu chữ nổi
HI there, thank you very much for the work you have done. I am with a large org who is testing waters and considering large expansion with the tool. My scenario: I manage many agents and we utilize importranges/queries to populate “Pipeline Mgmt” tools for sales.
As you know importranges/queries are not as simple as adding a row like a google form would do. Is it possible to have one large list of leads, aka recipients and a mail merge via Sheet connect and it to automatically run each time multiple leads are added?
Having a tough time visualizing as agents receive 3-5 dozen leads per day. Your reporting is amazing; adding these reporting columns to a pipeline tracker would be game changing for a sales representative.
HI there, thank you very much for the work you have done. I am with a large org who is testing waters and considering large expansion with the tool. My scenario: I manage many agents and we utilize importranges/queries to populate “Pipeline Mgmt” tools for sales.
As you know importranges/queries are not as simple as adding a row like a google form would do. Is it possible to have one large list of leads, aka recipients and a mail merge via Sheet connect and it to automatically run each time multiple leads are added?
Having a tough time visualizing as agents receive 3-5 dozen leads per day. Your reporting is amazing; adding these reporting columns to a pipeline tracker would be game changing for a sales representative.
Your place is valueble for me. Thanks!?
I will immediately grasp your rss as I can’t in finding your e-mail subscription hyperlink
or newsletter service. Do you’ve any? Please permit me recognise
so that I may subscribe. Thanks.
Stop by my homepage – About Our GMB Experts
This is the perfect blog for everyone who wishes to find out about this topic.
You realize a whole lot its almost tough to argue
with you (not that I personally will need to…HaHa).
You definitely put Intercambio Anónimo de TRX a BTC: Sin AML ni KYC new spin on a topic which has been discussed for ages.
Great stuff, just wonderful!
Can you tell us more about this? I’d want to find out some additional information.
My website; https://sebezh.borda.ru/?1-13-0-00002933-000-0-0-1743416028
This is a topic that’s near to my heart… Cheers!
Where are your contact details though?
Also visit my webpage: PUBLINANAR
Nice answer back in return of this matter with real arguments and telling all concerning that.
My homepage; gogogocheck
Very good info. Lucky me I found your site by chance (stumbleupon). I have saved as a favorite for later.
The crux of your writing whilst sounding agreeable in the beginning, did not work well with me personally after some time. Somewhere within the paragraphs you were able to make me a believer unfortunately just for a while. I however have a problem with your jumps in logic and one might do well to help fill in all those breaks. If you actually can accomplish that, I will definitely end up being impressed.
I can’t find the spreadsheet on my account , while on my other gmass accounts it’s obvious and connected, please advise
There’s certainly a great deal to find out about this topic. I really like all the points you made.
Keren banget, langsung gue pake.
Feel free to visit my web page – slot untuk index