How to Mail Merge with Gmail and Google Sheets

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ม.ค. 2025

ความคิดเห็น • 78

  • @labnol
    @labnol  4 ปีที่แล้ว +9

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

  • @susanproctor7963
    @susanproctor7963 4 ปีที่แล้ว

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

  • @nghilam483
    @nghilam483 9 หลายเดือนก่อน

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

  • @alisonpateysecretary1549
    @alisonpateysecretary1549 3 ปีที่แล้ว

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

  • @sarahhudson4006
    @sarahhudson4006 3 ปีที่แล้ว

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

    • @sarahhudson4006
      @sarahhudson4006 3 ปีที่แล้ว

      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.

  • @nunovurbiznis
    @nunovurbiznis 4 ปีที่แล้ว

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

  • @RaakeshV
    @RaakeshV 4 ปีที่แล้ว +3

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

  • @MiaMormino
    @MiaMormino 4 ปีที่แล้ว

    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?

  • @sukygoh9007
    @sukygoh9007 4 ปีที่แล้ว +2

    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.

  • @childrenreadingskills6024
    @childrenreadingskills6024 3 ปีที่แล้ว

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

  • @jaipurbiofertilizers
    @jaipurbiofertilizers ปีที่แล้ว

    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.

  • @equiposInn
    @equiposInn ปีที่แล้ว

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

  • @braggdesignstudio
    @braggdesignstudio 4 ปีที่แล้ว

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

  • @diegonielsen2350
    @diegonielsen2350 4 ปีที่แล้ว +1

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

  • @khairulhadiburhan2649
    @khairulhadiburhan2649 2 ปีที่แล้ว

    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

  • @breekrage6055
    @breekrage6055 2 ปีที่แล้ว +1

    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

  • @tmetm13
    @tmetm13 ปีที่แล้ว +1

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

  • @jenjohnson8288
    @jenjohnson8288 2 ปีที่แล้ว

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

  • @michaelburns718
    @michaelburns718 2 ปีที่แล้ว

    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.

  • @jonathangomes1054
    @jonathangomes1054 3 ปีที่แล้ว

    Sooo very useful! Thanks Amit.

  • @jessyukionna11
    @jessyukionna11 4 ปีที่แล้ว

    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?

  • @aajeducation8539
    @aajeducation8539 4 ปีที่แล้ว +2

    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.

  • @RamaKrishnaSistu
    @RamaKrishnaSistu 4 ปีที่แล้ว +2

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

  • @logandrayson4175
    @logandrayson4175 4 ปีที่แล้ว

    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?

  • @heypaulspeaks
    @heypaulspeaks 4 ปีที่แล้ว

    Very valuable. Thanks a lot Amit

  • @drvipulvyascoach
    @drvipulvyascoach 4 ปีที่แล้ว

    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?

  • @boarder9328
    @boarder9328 4 ปีที่แล้ว

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

  • @liamstubbins3579
    @liamstubbins3579 4 ปีที่แล้ว

    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

  • @kenwang9410
    @kenwang9410 4 ปีที่แล้ว

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

  • @AndyRP
    @AndyRP 4 ปีที่แล้ว

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

  • @esism667
    @esism667 4 ปีที่แล้ว

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

  • @shelbysmith6581
    @shelbysmith6581 4 ปีที่แล้ว +1

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

  • @midshipsport
    @midshipsport 2 ปีที่แล้ว

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

  • @brunovincent1969
    @brunovincent1969 4 ปีที่แล้ว

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

  • @logandrayson4175
    @logandrayson4175 4 ปีที่แล้ว

    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.

  • @gyanukarki3559
    @gyanukarki3559 4 ปีที่แล้ว

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

  • @maheshmakwana4551
    @maheshmakwana4551 4 ปีที่แล้ว +1

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

  • @bridevalley
    @bridevalley 2 ปีที่แล้ว

    Excellent tutorial. Thank you!

  • @nehalahmed9104
    @nehalahmed9104 2 ปีที่แล้ว +1

    Is it free or do the emails have limit?

  • @ReisFamilyWebsite
    @ReisFamilyWebsite 4 ปีที่แล้ว

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

  • @shant486
    @shant486 4 ปีที่แล้ว

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

  • @heatherbyrd-henderson6898
    @heatherbyrd-henderson6898 3 ปีที่แล้ว

    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.

  • @cx1291
    @cx1291 ปีที่แล้ว

    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

  • @jangerston
    @jangerston 4 ปีที่แล้ว

    Helpful tutorial; quite clear instructions.

  • @vjoshikol
    @vjoshikol 3 ปีที่แล้ว

    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?

  • @priyad1037
    @priyad1037 4 ปีที่แล้ว

    i need to do individual attachment can i do it

  • @mollyb9146
    @mollyb9146 4 ปีที่แล้ว

    Very helpful tutorial, thank you!

  • @principalkakkar1717
    @principalkakkar1717 4 ปีที่แล้ว

    You are amazing sir
    Thanks ... Hats Off

  • @sophieblecha4118
    @sophieblecha4118 2 ปีที่แล้ว

    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

  • @raghavendrakarnatakapu4386
    @raghavendrakarnatakapu4386 4 ปีที่แล้ว

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

  • @pecshollywoodnyelvstudio6762
    @pecshollywoodnyelvstudio6762 2 ปีที่แล้ว

    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!

  • @jithinjosef
    @jithinjosef 4 ปีที่แล้ว

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

  • @liberospadaccino
    @liberospadaccino 2 ปีที่แล้ว

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

  • @mashaalmalik4845
    @mashaalmalik4845 4 ปีที่แล้ว

    Thank you! Super helpful

  • @jenniferboyle2223
    @jenniferboyle2223 4 ปีที่แล้ว

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

    • @labnol
      @labnol  4 ปีที่แล้ว

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

  • @taoscakes7251
    @taoscakes7251 4 ปีที่แล้ว

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

  • @jeevanhmt1733
    @jeevanhmt1733 4 ปีที่แล้ว

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

  • @MauroJuniorMJ
    @MauroJuniorMJ 4 ปีที่แล้ว

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

  • @jamesherpel1553
    @jamesherpel1553 2 ปีที่แล้ว

    Thank you!

  • @dhruvwork
    @dhruvwork 2 ปีที่แล้ว

    Tussi great ho!

  • @urmilashende3878
    @urmilashende3878 4 ปีที่แล้ว

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

  • @hervearseneau625
    @hervearseneau625 4 ปีที่แล้ว

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

  • @alnoorparbatani8406
    @alnoorparbatani8406 4 ปีที่แล้ว

    Thank you, Buddy

  • @malagsallaround1569
    @malagsallaround1569 2 ปีที่แล้ว

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

  • @heinrichhelmbold419
    @heinrichhelmbold419 4 ปีที่แล้ว

    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.

  • @alphafarabia
    @alphafarabia 4 ปีที่แล้ว

    Thanks you .. Thank you .. Thank you

  • @pareshrawal9044
    @pareshrawal9044 4 ปีที่แล้ว

    Pls post 1 video daily pls

  • @dsa821
    @dsa821 4 ปีที่แล้ว +1

    Music is annoying. However, the content is Great!