How to Mail Merge with Gmail and Google Sheets
Send personalized emails with Mail Merge for Gmail add-on. Trusted by 2.5 million Gmail users, developed by Google Developer Expert for GSuite and Google Apps Script.
Download Mail Merge
gsuite.google.com/marketplace/app/mail_merge_with_attachments/223404411203
Download Document Studio
gsuite.google.com/marketplace/app/document_studio/429444628321
Tech Support: amit@labnol.org
Пікірлер: 79
⬇️ Mail Merge for Gmail gsuite.google.com/marketplace/app/mail_merge_with_attachments/223404411203 ⬇️ Document Studio for Google Sheets gsuite.google.com/marketplace/app/document_studio/429444628321
@alhootalazrq611
4 жыл бұрын
hi
This is the second instruction video by Amit I have watched. So good! So clearly explained. thank you so much.
OMG I LOVE this extension! The whole suite of services is awesome. I'm sold! Thank you!
I was trying to create an automation to send out personalised student progress reports for about a week, trying out 14 different products, before I found this. Thank you thank you thank you!!!
Love this video, Amit. Thank you for the detailed clear instructions.
Your video is so detail and concise. I'm amazed here at 2024~~ others video is no where near organized like yours! THANK YOU SO MUCH!!
Hello Amit is has been long time. Thanks for the video please keep posting more videos and blog posts.
This is a fantastic app. Thank you. You made our job so much easier.
Very helpful tutorial, thank you!
Helpful tutorial; quite clear instructions.
Very valuable. Thanks a lot Amit
Sooo very useful! Thanks Amit.
Excellent tutorial. Thank you!
Excellent videos a it. This has made my job easier!
Thank you for the instruction. I have question: Is there a way to automatically adding commas between populated fields in the mail merge?
Thank you! Super helpful
You are amazing sir Thanks ... Hats Off
THANK YOU - you just helped me work out how to send out a big pile of party invitations for our street party!
@sarahhudson4006
2 жыл бұрын
Some of the features in this video are only for Premium users, but this is such a great add-on it's worth the price of entry.
Thank you!
Hi, How can I make the plugin stay active and send emails automatically when a google sheet row is completed?
Hi I would like to ask whether is it possible to add cc email in the template instead of just an email address to one receiver only. Please advice thank you.
Is there a way to throttle the emails, so they send at 1-5 minutes or chosen intervals, like Gmass does?
Thank you, Buddy
Thanks for the helpful video, is there a way to schedule a follow up email after the mail merge is sent, that will go into the same email thread? Thank you.
Hey Amit, can you add a feature to this that allows a Merge Field to be used for the BCC and CC fields? Thank you
Is there a way when composing the email draft that you could put first name and business name so if on the spreadsheet I have a business name but not a first name it would put the business name?
Thanks for tutorial looked very good, until I tried to run test email and error message came back as "Please select a Gmail draft to use as a template for Mail Merge" I have one in Gmail drafts but it states its not there. Please advise
Only the "Help" option is showing now... Can you please let me know how to fix this.
Thanks you .. Thank you .. Thank you
Greetings Amit, Is there way to insert filtered rows from a spreadsheet during mail merge?
Is there any chance to create email sequence. Like other email marketing tools?
Sir, I have a question , how your's tracking system works. Please make a video on how to track email using the web app, image and any type of tracking link, without using google analytics.
Hi Amit, a super useful add-on this IS! Is it possible to operate it by shortcuts, key combinations, for example for the function "Select files from Computer" (just to avoid a lot of mouse work). Do you have a list of such? That would be excellent, please let me know. Many thanks!
Hi Amit, I am having problems with the plugin. Can you help me? It appears to not be working properly.
Can you mail merge to a Google doc to create a separate Google doc file for each field from your Google sheet?
can we attach multiple attachments to a single mail address by adding another column of file attachments??
When a row says "MAIL SENT" (in the Mail Merge Status column), the row is not automatically skipped for me. Those people would still receive an email even though I have already contacted them. Does anyone know how to fix this? I don't want to make a new spreadsheet every time :(
The "Mail Merge Status" did not show if the emails were opened, even if I ticked the "Track Email Opens". Is there something else I have to do?
Thank you for the video, the recent mail merge is no longer free, the trial version is only limited to 25 emails with the trademark Mail Merge attach to it, is there another alternative add-on for this purpose? Thanks
Tussi great ho!
Hi there - How do I know if I have a mail merge license (is that the same thing as or what comes with purchasing the premium service?) Thank you.
Is there a way you can show how the reports would look like?
Once I hit "Run mail merge", immediately it says no valid email recipient specified. I've used mail merge countless times before and have never run into this issue. Any tips on what I'm doing wrong?
Hello Thank you! is there a way to do tis from a mac email address?
how to trigger send button when a new row is added?
Hello Amit, I love your video and your product. They are fantastic. I just have one question I am currently using Mail merge Gsuit and I need to add an outlook email address as an alias as a sender and receiver email address. How can I ass it to the server? Best
Hi, I want to now if an automatic email is triggered once a new row is added thanks
Hi Amit thanks for the video. I installed it bt cant see the add on in the sheet. Does it work only with G Suite or with free Gmail too?
Can this be used for non GSuite subscribers, with just a regular free gmail account?
I don't want to send emails to customer's email. I want to send emails to my sales person associated with the particular lead. Please suggest, how can I schedule emails to sales team based on target dates.
Hi Can I send a mail multiple times, ie, on different dates
Sir how we sent a pdf file link to our various customer only link so he can download file from link
will this list update say if someone unsubscribed from your email list???
i need to do individual attachment can i do it
Nice vid. Any vid to how export Gmails (from specific receiver) to Google speadsheets automactically for free ?
You are on KZread now. I remember you were the 1st professional blogger in India. QUESTION: Can this be used for the WEBMAILS?
Excellent Sir I want to remake video in local language Marathi...Pls give permission
Let's say I run mail merge and out of 100 emails 30 of them the email was invalid/didn't work. I contact the client and re-enter and fix their email. How do I send emails to just those 30 emails that didn't work? They are in the list of 100 do I have to delete the other 70? Also, what is the best way to ask questions and get support? Thank you for your time.
@KevinTorres-pw3ny
2 жыл бұрын
like he explained, to resend an email just delete the schedule mail merge status, and in your case I would fix the emails and create another column with fix status so you only send to those you fixed email.
Pls post 1 video daily pls
Hi Amit, I enjoyed your video. My one major problem is having the test email linking with my test client contacts. I need some assistance. Thanks
Thank you, amazing plugin and support video. I'm running on no budget at the moment. Do you have any annual subscription trial? I'm happy to share it on social for you. :)
The configure mail merge option says it failed to connect with the google drive. It shows its a free trial version. Do we need to switch to the paid version to execute it.
@labnol
3 жыл бұрын
Are you logged into multiple Google accounts in the same browser? Google add-ons may sometimes display an error when multiple accounts are authorized in the same browser session. Open Google Chrome, go to the menu and choose New Incognito Window. Here open the same Google Sheet and try again. Let me know if that resolves the issue?
when I select file for contact then "google drive refuse to connect" message shown. can you guide me for that?
@akhileshsinghvns
4 жыл бұрын
same with me
@jeyyys.9570
4 жыл бұрын
same here. what should I do?
I keep getting "No valid email recipient specified" in the mail merge status. Can you offer any info on this?
@labnol
3 жыл бұрын
Make sure that you have any email address column in the Google sheet
Is it free or do the emails have limit?
Adding attachments for 300 people is just not viable with this method. It would be much better to be able to use a script to populate the attachment link eg : //path/reportcard.pdf. So the report cards would be generated per name into a specific folder with an app like InDesign. Then to send out the report cards I would like to specify the path to the folder and using a script just add the filename per report card.
{{FIRST NAME}} cannot be substituted. I have this error every possible solution that i know to fix this no one works
It is nice, but $40 per year to use over 25 emails per day... also without the paid version, it writes Sent from Mail Merge on your email.. kindda defeats the purpose a bit..
Music is annoying. However, the content is Great!
@KevinTorres-pw3ny
2 жыл бұрын
just mute or play your own music