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

  • @labnol
    @labnol4 жыл бұрын

    ⬇️ 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

    @alhootalazrq611

    4 жыл бұрын

    hi

  • @alisonpateysecretary1549
    @alisonpateysecretary15492 жыл бұрын

    This is the second instruction video by Amit I have watched. So good! So clearly explained. thank you so much.

  • @nunovurbiznis
    @nunovurbiznis3 жыл бұрын

    OMG I LOVE this extension! The whole suite of services is awesome. I'm sold! Thank you!

  • @susanproctor7963
    @susanproctor79633 жыл бұрын

    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!!!

  • @braggdesignstudio
    @braggdesignstudio3 жыл бұрын

    Love this video, Amit. Thank you for the detailed clear instructions.

  • @nghilam483
    @nghilam4833 ай бұрын

    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!!

  • @RaakeshV
    @RaakeshV4 жыл бұрын

    Hello Amit is has been long time. Thanks for the video please keep posting more videos and blog posts.

  • @childrenreadingskills6024
    @childrenreadingskills60242 жыл бұрын

    This is a fantastic app. Thank you. You made our job so much easier.

  • @mollyb9146
    @mollyb91463 жыл бұрын

    Very helpful tutorial, thank you!

  • @jangerston
    @jangerston3 жыл бұрын

    Helpful tutorial; quite clear instructions.

  • @heypaulobame
    @heypaulobame4 жыл бұрын

    Very valuable. Thanks a lot Amit

  • @jonathangomes1054
    @jonathangomes10543 жыл бұрын

    Sooo very useful! Thanks Amit.

  • @bridevalley
    @bridevalley2 жыл бұрын

    Excellent tutorial. Thank you!

  • @AndyRP
    @AndyRP3 жыл бұрын

    Excellent videos a it. This has made my job easier!

  • @kenwang9410
    @kenwang94104 жыл бұрын

    Thank you for the instruction. I have question: Is there a way to automatically adding commas between populated fields in the mail merge?

  • @mashaalmalik4845
    @mashaalmalik48454 жыл бұрын

    Thank you! Super helpful

  • @principalkakkar1717
    @principalkakkar17174 жыл бұрын

    You are amazing sir Thanks ... Hats Off

  • @sarahhudson4006
    @sarahhudson40062 жыл бұрын

    THANK YOU - you just helped me work out how to send out a big pile of party invitations for our street party!

  • @sarahhudson4006

    @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.

  • @jamesherpel1553
    @jamesherpel15532 жыл бұрын

    Thank you!

  • @diegonielsen2350
    @diegonielsen23503 жыл бұрын

    Hi, How can I make the plugin stay active and send emails automatically when a google sheet row is completed?

  • @sukygoh9007
    @sukygoh90074 жыл бұрын

    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.

  • @brunovincent1969
    @brunovincent19693 жыл бұрын

    Is there a way to throttle the emails, so they send at 1-5 minutes or chosen intervals, like Gmass does?

  • @alnoorparbatani8406
    @alnoorparbatani84064 жыл бұрын

    Thank you, Buddy

  • @michaelburns718
    @michaelburns7182 жыл бұрын

    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.

  • @breekrage6055
    @breekrage60552 жыл бұрын

    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

  • @logandrayson4175
    @logandrayson41753 жыл бұрын

    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?

  • @liamstubbins3579
    @liamstubbins35793 жыл бұрын

    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

  • @shelbysmith6581
    @shelbysmith65814 жыл бұрын

    Only the "Help" option is showing now... Can you please let me know how to fix this.

  • @alphafarabia
    @alphafarabia4 жыл бұрын

    Thanks you .. Thank you .. Thank you

  • @raghavendrakarnatakapu4386
    @raghavendrakarnatakapu43864 жыл бұрын

    Greetings Amit, Is there way to insert filtered rows from a spreadsheet during mail merge?

  • @RamaKrishnaSistu
    @RamaKrishnaSistu4 жыл бұрын

    Is there any chance to create email sequence. Like other email marketing tools?

  • @aajeducation8539
    @aajeducation85394 жыл бұрын

    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.

  • @pecshollywoodnyelvstudio6762
    @pecshollywoodnyelvstudio67622 жыл бұрын

    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!

  • @ReisFamilyWebsite
    @ReisFamilyWebsite4 жыл бұрын

    Hi Amit, I am having problems with the plugin. Can you help me? It appears to not be working properly.

  • @esism667
    @esism6673 жыл бұрын

    Can you mail merge to a Google doc to create a separate Google doc file for each field from your Google sheet?

  • @gyanukarki3559
    @gyanukarki35593 жыл бұрын

    can we attach multiple attachments to a single mail address by adding another column of file attachments??

  • @boarder9328
    @boarder93284 жыл бұрын

    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 :(

  • @jessyukionna11
    @jessyukionna114 жыл бұрын

    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?

  • @khairulhadiburhan2649
    @khairulhadiburhan2649 Жыл бұрын

    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

  • @dhruvwork
    @dhruvwork Жыл бұрын

    Tussi great ho!

  • @heatherbyrd-henderson6898
    @heatherbyrd-henderson68983 жыл бұрын

    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.

  • @abhishekshrivastava6009
    @abhishekshrivastava60094 жыл бұрын

    Is there a way you can show how the reports would look like?

  • @MiaMormino
    @MiaMormino3 жыл бұрын

    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?

  • @jenjohnson8288
    @jenjohnson82882 жыл бұрын

    Hello Thank you! is there a way to do tis from a mac email address?

  • @shant486
    @shant4864 жыл бұрын

    how to trigger send button when a new row is added?

  • @sophieblecha4118
    @sophieblecha41182 жыл бұрын

    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

  • @equiposInn
    @equiposInn Жыл бұрын

    Hi, I want to now if an automatic email is triggered once a new row is added thanks

  • @drvipulvyascoach
    @drvipulvyascoach3 жыл бұрын

    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?

  • @taoscakes7251
    @taoscakes72514 жыл бұрын

    Can this be used for non GSuite subscribers, with just a regular free gmail account?

  • @jaipurbiofertilizers
    @jaipurbiofertilizers9 ай бұрын

    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.

  • @jithinjosef
    @jithinjosef3 жыл бұрын

    Hi Can I send a mail multiple times, ie, on different dates

  • @jeevanhmt1733
    @jeevanhmt17334 жыл бұрын

    Sir how we sent a pdf file link to our various customer only link so he can download file from link

  • @tmetm13
    @tmetm13 Жыл бұрын

    will this list update say if someone unsubscribed from your email list???

  • @priyad1037
    @priyad10373 жыл бұрын

    i need to do individual attachment can i do it

  • @liberospadaccino
    @liberospadaccino2 жыл бұрын

    Nice vid. Any vid to how export Gmails (from specific receiver) to Google speadsheets automactically for free ?

  • @midshipsport
    @midshipsport2 жыл бұрын

    You are on KZread now. I remember you were the 1st professional blogger in India. QUESTION: Can this be used for the WEBMAILS?

  • @urmilashende3878
    @urmilashende38784 жыл бұрын

    Excellent Sir I want to remake video in local language Marathi...Pls give permission

  • @logandrayson4175
    @logandrayson41753 жыл бұрын

    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

    @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.

  • @pareshrawal9044
    @pareshrawal90444 жыл бұрын

    Pls post 1 video daily pls

  • @cx1291
    @cx12917 ай бұрын

    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

  • @MauroJuniorMJ
    @MauroJuniorMJ3 жыл бұрын

    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. :)

  • @vjoshikol
    @vjoshikol3 жыл бұрын

    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

    @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?

  • @maheshmakwana4551
    @maheshmakwana45514 жыл бұрын

    when I select file for contact then "google drive refuse to connect" message shown. can you guide me for that?

  • @akhileshsinghvns

    @akhileshsinghvns

    4 жыл бұрын

    same with me

  • @jeyyys.9570

    @jeyyys.9570

    4 жыл бұрын

    same here. what should I do?

  • @jenniferboyle2223
    @jenniferboyle22233 жыл бұрын

    I keep getting "No valid email recipient specified" in the mail merge status. Can you offer any info on this?

  • @labnol

    @labnol

    3 жыл бұрын

    Make sure that you have any email address column in the Google sheet

  • @nehalahmed9104
    @nehalahmed91042 жыл бұрын

    Is it free or do the emails have limit?

  • @heinrichhelmbold419
    @heinrichhelmbold4194 жыл бұрын

    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.

  • @malagsallaround1569
    @malagsallaround15692 жыл бұрын

    {{FIRST NAME}} cannot be substituted. I have this error every possible solution that i know to fix this no one works

  • @hervearseneau625
    @hervearseneau6253 жыл бұрын

    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..

  • @dsa821
    @dsa8213 жыл бұрын

    Music is annoying. However, the content is Great!

  • @KevinTorres-pw3ny

    @KevinTorres-pw3ny

    2 жыл бұрын

    just mute or play your own music

Келесі