How to Mail Merge with Gmail and Google Sheets
HTML-код
- Опубликовано: 23 июл 2024
- 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...
Download Document Studio
gsuite.google.com/marketplace...
Tech Support: amit@labnol.org
⬇️ 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
hi
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!!!
This is the second instruction video by Amit I have watched. So good! So clearly explained. thank you so much.
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.
Sooo very useful! Thanks Amit.
Very helpful tutorial, thank you!
THANK YOU - you just helped me work out how to send out a big pile of party invitations for our street party!
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.
Excellent tutorial. Thank you!
Very valuable. Thanks a lot Amit
Helpful tutorial; quite clear instructions.
Thank you for the instruction. I have question: Is there a way to automatically adding commas between populated fields in the mail merge?
You are amazing sir
Thanks ... Hats Off
Thank you! Super helpful
Excellent videos a it. This has made my job easier!
Thank you!
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!
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.
Thank you, Buddy
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 to throttle the emails, so they send at 1-5 minutes or chosen intervals, like Gmass does?
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.
Greetings Amit, Is there way to insert filtered rows from a spreadsheet during mail merge?
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
Hello Thank you! is there a way to do tis from a mac email address?
Thanks you .. Thank you .. Thank you
Tussi great ho!
Hi, How can I make the plugin stay active and send emails automatically when a google sheet row is completed?
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
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 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?
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 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, 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?
Only the "Help" option is showing now... Can you please let me know how to fix this.
Is there a way you can show how the reports would look like?
can we attach multiple attachments to a single mail address by adding another column of file attachments??
Hi, I want to now if an automatic email is triggered once a new row is added
thanks
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
Nice vid. Any vid to how export Gmails (from specific receiver) to Google speadsheets automactically for free ?
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 "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?
Can this be used for non GSuite subscribers, with just a regular free gmail account?
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 :(
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.
You are on RUclips now. I remember you were the 1st professional blogger in India. QUESTION: Can this be used for the WEBMAILS?
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?
Hi
Can I send a mail multiple times, ie, on different dates
how to trigger send button when a new row is added?
Excellent Sir
I want to remake video in local language Marathi...Pls give permission
will this list update say if someone unsubscribed from your email list???
Sir how we sent a pdf file link to our various customer only link so he can download file from link
Pls post 1 video daily pls
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.
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.
i need to do individual attachment can i do it
Is it free or do the emails have limit?
when I select file for contact then "google drive refuse to connect" message shown. can you guide me for that?
same with me
same here. what should I do?
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.
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?
I keep getting "No valid email recipient specified" in the mail merge status. Can you offer any info on this?
Make sure that you have any email address column in the Google sheet
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.
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..
{{FIRST NAME}} cannot be substituted.
I have this error every possible solution that i know to fix this no one works
Music is annoying. However, the content is Great!
just mute or play your own music