Make.com Tutorial For COMPLETE Beginners 2024

Поделиться
HTML-код
  • Опубликовано: 24 янв 2025

Комментарии • 164

  • @DeanJohn7
    @DeanJohn7 6 месяцев назад +6

    if when first testing the form didnt work for you when trying to get the data try setting "choose where to start at" to ALL or just wait a little big and run module again.

  • @travisross8704
    @travisross8704 Год назад +10

    Dude! Had to stop the video 3/4 way through and thank you so much because you’re bringing me that much closer to my dream of running make Automations. First I’ll make this onboarding automation for my agency I work with, then I’ll do it for my own AAA, and for a few clients pro bono. And 💥 off to the races. 🎉 thank you 🙏

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Amazing to hear this Travis - hope its going well!

  • @Ginatto
    @Ginatto 11 месяцев назад +1

    Dude, thank you very much for the video. I'm looking for ways to create a chatbot, and this tutorial was the best. I'm full of ideas!

  • @adamturcotte6982
    @adamturcotte6982 Год назад +3

    Three certain things in life. Death, taxes, and Gavin uploading a banger video

  • @extractive5282
    @extractive5282 Год назад +8

    You just made my AAA journey much easier :)

    • @Thibbyy
      @Thibbyy  Год назад +1

      Very glad to hear this!

    • @mohammedb4ig
      @mohammedb4ig Год назад

      Hey man. What is your discord? I want to start my AAA along side someone else so we can both learn together. Thanks.

  • @austintomko
    @austintomko Год назад +4

    This is the content I am looking for. Having a positive mindset is great and all, but that seems to be all other "gurus" like to talk about. This was super insightful. Can't wait for what is to come.

    • @Thibbyy
      @Thibbyy  4 месяца назад +1

      You are a legend

  • @IOSALive
    @IOSALive 9 месяцев назад +2

    Gavin Thibodeau, This is perfect! I subscribed right away!

  • @asta249
    @asta249 Год назад +1

    Thank you Gavin for this tutorial, very simple and informative!

  • @hownowLLC
    @hownowLLC 9 месяцев назад +3

    Tip for others: when testing the scenario run after making changes (adding modules like the Create a Folder in Google Drive), you may not always see each step complete -- just the form submission. If that's happening, change the 'Choose where to start' settings to a specific date that's prior to when you started building. Or, just submit a new form if you want to stick with 'Choose manually'.
    Basically what's happening is the older form submission from 'Choose manually' isn't getting recognized.
    P.S. This is a FANTASTIC beginners tutorial. Thank you, we're sharing it with our team!

    • @champagnebulge1
      @champagnebulge1 9 месяцев назад +1

      Thanks! Yea I was getting hung up on that at about 5:30 to 6:00 in the tutorial.

    • @vidpic8311
      @vidpic8311 9 месяцев назад +1

      Exactly and a lot of assumptions

    • @michaelr.4258
      @michaelr.4258 8 месяцев назад

      Thank you! Had this same problem. I choose "All" and it worked.

  • @michaelr.4258
    @michaelr.4258 8 месяцев назад +1

    Great stuff man! This was my introduction into automation and I love it. Great job explaining things. Thank you!!!

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Thank you for this feedback man

  • @Keshav-Anand
    @Keshav-Anand Год назад +2

    Thanks bro super helpful! Looking forward for more tutorials.

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Going hard on more tutorials now!

  • @chrisp9349
    @chrisp9349 Год назад +1

    Bro thank you, I use this method to filter our leads for local businesses we partner with. Depending on what the customer selects i have it set to that it will send an email to one of our local contractors.

  • @tokshiva
    @tokshiva Год назад +9

    Thanks for this detailed tutorial. But got stuck in between.
    I just followed along. When I right click on google form and choose where to start as manually, I could see the new record created. Then I clicked on it and said ok. Now I could see the bubble. But when I clicked on it, I could not see any records. Operation1 with a dropdown symbol has no records.
    Where am I going wrong??

    • @jillsnguetsop
      @jillsnguetsop Год назад +1

      also facing the same issue

    • @shameelkhan209
      @shameelkhan209 Год назад

      @@jillsnguetsop i have a solution for that instead of starting with google form module directly start with the webhook

    • @anayaqureshi10
      @anayaqureshi10 5 месяцев назад

      I am facing the same issue, did you find the reason/solution?

    • @gioyouniverse
      @gioyouniverse 3 месяца назад

      Same Issue ! After submitting the form and re running the form on make id does not show any data under operations

    • @MAsad-zd9ki
      @MAsad-zd9ki 3 месяца назад

      @@gioyouniverse yeah i got the same error but i closed the tab opened it again and instead of select ing the option "select manually" i selected the option "All" and it was then good to go .

  • @waltervasquez1782
    @waltervasquez1782 4 месяца назад +1

    Great tutorial for beginners! I am just entering the game of Automation and this was simple to follow. Thank you!

    • @Thibbyy
      @Thibbyy  4 месяца назад

      thank you so much!

  • @SALON_DAIN
    @SALON_DAIN 9 месяцев назад +1

    Thank you for your work, Im learning so much from it and looking forward to seeing more!

  • @JamesFromCS
    @JamesFromCS Год назад +1

    Hey Gavin,
    I was completely lost until I found your video. Great explanation and now I think I can get the hang of this.
    Cheers!

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Love to hear this James

  • @robertohidaka5897
    @robertohidaka5897 11 месяцев назад +1

    Great content gavin!!!

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Thank you legend

  • @shinichikudo9038
    @shinichikudo9038 Год назад +5

    hello, after I do the "'choose where to start" function, the bubble does reflect the value of the number of submissions however the operation does not display the answers, why is that? I followed your instructions.

  •  Год назад +1

    Thanks from Brazil!! ❤🎉

  • @BlackGirlInMexico
    @BlackGirlInMexico 7 месяцев назад +1

    Great tutorial, thank you!

  • @moosazstudio
    @moosazstudio 6 месяцев назад +1

    A very good tutorial for beginners. Thanks buddy

  • @인증고운
    @인증고운 7 месяцев назад +1

    I love you guy! it is really helpful to me.

  • @Firlithodzen
    @Firlithodzen 3 месяца назад

    Ich mag deine Art, die Dinge zu erklären

  • @IronSnipEdits
    @IronSnipEdits Год назад +1

    Awesome work ❤!

  • @KasterRepair
    @KasterRepair 10 месяцев назад +2

    Still confusing but amazing to see what it can do. I will keep learning thank you @Gavin

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Keep it up man it takes time

  • @nbeizaie
    @nbeizaie 6 месяцев назад +1

    Wow! you are such a good instructor! Great content.

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Thanks so much!

  • @gerardolopez9368
    @gerardolopez9368 Год назад +1

    Your an amazing person ❤️

  • @luwi.official
    @luwi.official Год назад +1

    Thanks man! Very helpful

  • @tokyopoplofi
    @tokyopoplofi Год назад +1

    Great video Gavin, Thank you.
    Quick question : what screen recording are you using that makes your cursor moves smoothly like that 😍🎉 ?

  • @SUDHANSHU934
    @SUDHANSHU934 Год назад +2

    This is awesome video.... Appreciate the way you preety much explain everything in simple manner....so calm ❤
    Love it

    • @Thibbyy
      @Thibbyy  Год назад

      Thanks so much man really appreciate it

  • @mig-lito
    @mig-lito 3 месяца назад +1

    Great tutorial! thanks for making it!😇

    • @Thibbyy
      @Thibbyy  3 месяца назад

      @@mig-lito Thanks for the feedback! Glad to hear it helped you 🤝

  • @DeanLargaespada
    @DeanLargaespada Месяц назад

    Great video! Thanks for sharing. What are you using to record?

  • @Tromulous
    @Tromulous Год назад +1

    Hit a road block when attempting to connect google drive to the form submission trigger as I didn't have a company email to use as the "connection" I only have personal Gmail accounts. I was able to work through the process of creating an OAuth client for my account but it seems like a ton of extra work for a simple connection. If a Client is using a "personal" Gmail account to manage business operations, will I need to set up a custom OAuth client every time I want to link their Google drive to an initial trigger like a form getting a new submission? thanks.

    • @Thibbyy
      @Thibbyy  Год назад +2

      Definitely a ton of extra work. I've only worked with clients who use a google workspace, its more than likely this will be the case for any legitimate business. I've worked with more than a dozen and none of them had personal gmails

  • @davidlepez200
    @davidlepez200 Год назад +1

    Great stuff ! Cheers !

  • @timorlenok
    @timorlenok Год назад +1

    Thanks a lot! Hope to see more that type of content♥

    • @Thibbyy
      @Thibbyy  Год назад

      Much more to come here and in my exclusive community (automationunlocked.co)

  • @thedailyhelp8884
    @thedailyhelp8884 7 месяцев назад +1

    Easy to follow and so helpful. We'll done.

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Thank you

  • @ilias8884
    @ilias8884 Год назад +1

    Need more videos like this bro❤

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Dropping them now 😈

  • @ajitpatil1113
    @ajitpatil1113 11 месяцев назад +1

    hey i am not getting google drive create folder anywhere it showing faild to load data is any body know how to get out of this situation

  • @ChrismAIAutomation
    @ChrismAIAutomation Год назад +1

    nice, what software are you using for screen cast thanks

  • @DuaneDouglas
    @DuaneDouglas Год назад +1

    Thanks for the excellent tutorial. Make scenarios now feel a lot less intimidating.

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Very glad to hear this

  • @garywhite6622
    @garywhite6622 22 дня назад

    Great Training!!

  • @Spinstormgaming
    @Spinstormgaming 11 месяцев назад +3

    Impossible to complete. They now have restricted scopes of customer Gmail accounts

    • @vidpic8311
      @vidpic8311 9 месяцев назад

      Can u explain this thanks ?

    • @Spinstormgaming
      @Spinstormgaming 9 месяцев назад

      @@vidpic8311 from my experience when setting up any automation that includes Gmail I found that it would give me an error message no matter what Gmail account I tried to link it to.

    • @mondlienxele7865
      @mondlienxele7865 8 месяцев назад

      Very frustrating… 😩😩

    • @talkwithyourself8321
      @talkwithyourself8321 5 месяцев назад

      It's really frustrating as my work happens mostly from Gmail accounts only.

  • @alpha7s708
    @alpha7s708 Год назад +2

    Which video editing software do you use?

    • @Thibbyy
      @Thibbyy  Год назад +1

      Adobe Premiere

  • @MB-yz2vc
    @MB-yz2vc 4 месяца назад +1

    Love this tutorial. My question since this was based on a real account for you is what was the process they had for getting the information into the google form? Who was entering that? How is that being collected by the business?

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Thank you! Yeah this was just an example. Some real use cases for this are companies who have “Work With Us” forms on their website, where prospective clients fill out a form to try and work together. There could also be similar forms filled out for lead magnets, and this is how you would take that data and send the lead magnet for example. Lots of other use cases. Let me know if any of that is confusing haha

  • @harryp-90
    @harryp-90 3 месяца назад

    Love your video bro! What screen recording tool do you use by the way?

  • @rockstxrkoo3032
    @rockstxrkoo3032 Год назад +1

    Do I have to do this everytime a new response is made? Or is it possible that I can do this automatically?

    • @Thibbyy
      @Thibbyy  Год назад

      No, you just turn the scenario on and it runs anytime a new response comes in

  • @BrandFounder
    @BrandFounder Год назад +2

    Now became everything is automatically wooow

  • @anikmitra8937
    @anikmitra8937 Год назад +2

    What’s the point of a webhook as opposed to just using the Google Form trigger?

    • @Thibbyy
      @Thibbyy  Год назад

      Webhooks act as instant triggers. This means the data comes immediately. Contrary to scheduled triggers, which periodically ask a given service for new data to be processed, thus using more operations and costing the client/yourself more money. That’s how Make charges, based on operations

  • @CharlieLinTV
    @CharlieLinTV Год назад +1

    Good on ya mate! 😊

    • @Thibbyy
      @Thibbyy  Год назад

      Charlie Lin the goat!!

  • @SparkSpeedSolutions
    @SparkSpeedSolutions Год назад

    Do you know if you can link voice flow with make?

  • @jonsulzberger6297
    @jonsulzberger6297 2 месяца назад

    Hi Gavin, thanks for your hard work tomorrow produce this great content. I am trying the tut for complete beginners 2024 and was successful in adding the google form but the second step adding the Google drive won’t let me proceed with my gmail and i tried following the steps for enabling API in google cloud but getting lost. Any advice? Thanks Jon

  • @wojciechurban1162
    @wojciechurban1162 6 месяцев назад

    Hi, how to use webhooks for Gmail? Becouse i didnt found any addons for gmails, only for sheets or forms.

  • @justine3782
    @justine3782 4 месяца назад

    Hello everyone, I'm having a lot of trouble despite the tutorials, but first of all, thank you so much for spending the time to explain all this, really! I'd like to start with something very basic: replying to an email to the sender + cc people, automatically by filtering with a keyword in the subject line. The scenario works fine after the test, but the return email that's supposed to go out automatically is neither sent to the “sender” nor to the “cc” people. Note that I don't know the e-mail addresses of the people in cc and they change each time. I'm on Outlook. If anyone has any ideas ... thank you very much!

    • @Thibbyy
      @Thibbyy  4 месяца назад

      Hey Justine - I would have to see this in a bit more detail. If interested, my skool community is a great spot to post any issues you have with automations. There are also calls every week to get 1:1 support from myself & other experts. Here is the link! www.skool.com/digital-operations/about

  • @TuanLieu-r9c
    @TuanLieu-r9c 10 месяцев назад

    very helpful! also, what software are you using to record the software simulation?

  • @mikesandlin2967
    @mikesandlin2967 10 месяцев назад +1

    Once you got to adding a module: Google Drive, completely blocked. Need to create Cloud account, credentials, authorizations, enable API's (of which Make nor Integromat are found). You are using a non-Gmail email account so this didn't happen to you, but I suspect a lot of folks here are. Has this been addressed?

    • @vidpic8311
      @vidpic8311 9 месяцев назад

      Exactly so the question is why does he pick that example to teach when the majority of us can't do it so effing annoying....

    • @wongsimon2387
      @wongsimon2387 5 месяцев назад

      @@vidpic8311 This tutorial skipped many preliminary setups. Most people encounter problems when following his steps.

  • @mikejezek5214
    @mikejezek5214 Год назад

    Thank you so much for this. Would love to see a video like this on Voiceflow for chatbots. And maybe a video on the different types of automations to sell to clients.

  • @traveldigitalera
    @traveldigitalera 5 месяцев назад

    i added the form ID but in operation it shows no data. any clue?

  • @iqoolll
    @iqoolll Год назад +1

    Hey gav! Great video I have a question what do you think about goHighLevel do you use this in your agency?

    • @Thibbyy
      @Thibbyy  Год назад +1

      Thanks man! I think GHL is great but not necessary for an ai automation agency

  • @Betamax84
    @Betamax84 Год назад

    Thanks for this!

  • @gianlucamb9
    @gianlucamb9 Год назад +4

    Hey Gavin, great stuff! I just found your channel recently and I'm glad I did. I'm still getting familiar with Webhooks but I'm realizing they will definitely bring your automation game to the next level. Do you have a preference between Make and Zapier or does it just depends on the project you are working on?

    • @Thibbyy
      @Thibbyy  Год назад +2

      Hey man - much appreciated. I prefer Make over zapier. In very few instances I use Zapier, really only if a clients software doesn’t have an API but they have a Zap integration

  • @alfredom9692
    @alfredom9692 Год назад

    thank you for this tutorial....just curious what are you using to record your screen?

  • @will-wilder
    @will-wilder Год назад +1

    Thanks for this! Awesome tutorial Gavin... I have a question though. Did you create a new account for your client or do you do them all in your personal make account... I'm asking because we probably need access to their google drive account right?

    • @Thibbyy
      @Thibbyy  Год назад +2

      Appreciate this Will, more to come from here. We have clients create a make account and then invite us as collaborators. We then send them looms or demonstrate on a video call on how they can make connections

  • @joshuafrancis1456
    @joshuafrancis1456 Год назад

    when choosing where to start, my filled inn form pops up. but when i choose 'run this module only' after that it dioen't provide what i filled in in the form in the little bubble. it just stays the same as when there was no data. does soemoene know how to fix this?

  • @fredwestholm1289
    @fredwestholm1289 Год назад +1

    did everything up until I got to run this module only and it isn't giving me the information he has in the video. I tried three time with same result.

  • @nenisuryani2619
    @nenisuryani2619 Год назад +1

    Hey Gavin, I want to start Ai service but as a freelancer, my question is do I need to setup a professional email so I can look legit, or can I use my personal one?

    • @Thibbyy
      @Thibbyy  Год назад +1

      Hey there - its certainly not a requirement to start as a freelancer. A domain and a branded email is a nice-to-have, but not 100% necessary at first.

  • @explorewithluke
    @explorewithluke 8 месяцев назад

    That plugin digital inspiration doesn’t work anymore for web hooks

  • @levelupdigitalcreations3118
    @levelupdigitalcreations3118 Год назад

    Curious to know what if the client already has a different form that they use but they want to connect it to make? What’s the first thing you do?

  • @user-fs9sz4bw9w
    @user-fs9sz4bw9w Год назад

    why is your video or mouse so smooth? 😬

  • @himanshuseervi3181
    @himanshuseervi3181 Год назад

    Why do we need a google drive folder?

  • @seanthomas2442
    @seanthomas2442 Год назад

    Excellent job. This is better than zapier

  • @SD-rg5mj
    @SD-rg5mj Год назад

    hello could you tell me what you think of my idea, I would like to use artificial intelligence in my Google sheet, but I would like artificial intelligence to describe to me my images which are in my Google sheet, is this possible? if not do I have to use automation software?
    anyway thank you for your videos

  • @tellmebouts7v7n
    @tellmebouts7v7n Год назад +1

    The operation failed with an error. 404: NOT_FOUND - Requested entity was not found
    can I get some help??

    • @Thibbyy
      @Thibbyy  Год назад

      Are you sure your google connection is the same as the form you made?

  • @Batman.challenge
    @Batman.challenge 11 месяцев назад

    Hi gavin i am trying this but when i run it only running simgle module i am too run each module manually please guide me how i ca sort this

    • @vidpic8311
      @vidpic8311 9 месяцев назад

      Exactly my exact sentiments a bunch of useless steps without clear and showing the entire screen

  • @levelupdigitalcreations3118
    @levelupdigitalcreations3118 Год назад

    What software did you use for this presentation to share your screen?

    • @hadialjeiroudi2715
      @hadialjeiroudi2715 9 месяцев назад

      It's called Screen Studio, it only works on MacOS.

  • @stonee1272
    @stonee1272 Год назад

    God Bless you! Thank you a lot 🙏

  • @גולןבןדוד-נ8ת
    @גולןבןדוד-נ8ת 8 месяцев назад

    Graet video

  • @bankgrowbets
    @bankgrowbets Год назад +1

    This is powerful

    • @Thibbyy
      @Thibbyy  Год назад

      Thanks man, sure is. This is only the basics as well

  • @talkwithyourself8321
    @talkwithyourself8321 5 месяцев назад

    Yes. They have restricted gmail accounts. Is there any other way to get it. It would really help, if anyone knows any method to resolve that.

    • @Thibbyy
      @Thibbyy  3 месяца назад

      Make has documentation and videos on how to set this up, see here: www.make.com/en/help/connections/connecting-to-google-services-using-a-custom-oauth-client

  • @Mrjoseoasis
    @Mrjoseoasis 3 месяца назад

    Hello sir, i'm stucked in the last part of the webhook. I run it and fill a responde, and the webhook reconizes my input, but it doesn't flow to Gmail. I have edited every module so it takes de input from the webhook (The forms). I did every step in the video but with no success.

    • @Thibbyy
      @Thibbyy  3 месяца назад

      Hi there - are you able to delete the Gmail, add a new one, and then input the data from the form? This usually works. If not, you can also manually map in the data.

  • @isidoremisa7543
    @isidoremisa7543 Месяц назад

    stuck at google drive create a folder step, i cant even connect my google drive to make

  • @Anthony-fh4gd
    @Anthony-fh4gd Год назад

    I filled out the form, and chose manually where to start from,?but if I click on the bubble? I see operation 1 but no data. Anyone an idea what I did wrong?

    • @sandjibalde5545
      @sandjibalde5545 Год назад

      same here, have you found an answer? im really stuck atm

    • @Anthony-fh4gd
      @Anthony-fh4gd Год назад

      @@sandjibalde5545 No, moved on to another video

  • @AIGahan
    @AIGahan 7 месяцев назад

    Lots of so, so, so going in there, so

  • @staciasalmon654
    @staciasalmon654 10 месяцев назад

    Very Clear! Thank You!❤

  • @Splithub
    @Splithub Год назад

    Zoom hurts my eyes good video tho

  • @westerntree1
    @westerntree1 4 месяца назад

    I've been following your real estate journey and it's impressive to see your progress. I've recently started exploring alternative investment options, and I've found a technique that's allowed me to trade the crypto market with surprisingly low risk and high reward. I've been learning from a pro trader I've been following for a while now, and it's been a game-changer for me. Looking forward to seeing your next move in the real estate space

  • @jservitus8275
    @jservitus8275 10 месяцев назад +9

    you are a really good tech trainer however in your videos keep the panning and zooming to a minimum and stop spinning your mouse to highlight your focus. VERY distracting. the brain just does not process information like this. It's not a music video. Other than that excellent stuff. Hope to see more.

    • @LePookieBear00
      @LePookieBear00 3 месяца назад +1

      Information is in the form of sound, or words. If you can’t process it shut your damn eyes

  • @claudioghisoni5999
    @claudioghisoni5999 Год назад

    Great Video, Thank You ... But too much Zoom was hiding the detail occasionally. I also started loosing you in the last 7 mins of the video as you selected a different Gmail "Condition" field in WebHooks (compared the first time you did it) without explaining why??? ... But honestly, the many points you covered (so well) makes this one of the best MAKE Vids on RUclips.

  • @sojibrajii
    @sojibrajii Год назад +1

    U need attractive RUclips thumbnail designer?

    • @KVN3K
      @KVN3K Год назад

      Loool what

  • @vidpic8311
    @vidpic8311 9 месяцев назад +1

    This tutorial 🤢🤢🤢lots of things on the screen you didn't show, U assume we know things already, so I give this tutorial D- .

  • @abdull_um
    @abdull_um Год назад +1

    Love the video man. You are one of the real people out here. Is there any way we can connect. Email or something??

    • @Thibbyy
      @Thibbyy  Год назад

      Appreciate this bro and for sure hit up my email in the description

  • @magicjohnson4464
    @magicjohnson4464 Год назад +1

    You may have answered this before, but could you use this instead of Mailchimp, Aweber, Getresponse, and other auto-email marketing software?

    • @Thibbyy
      @Thibbyy  Год назад

      You could but we still use convertkit its much easier

  • @siubrown3448
    @siubrown3448 Год назад +1

    Gavin, apparently, there's stuff you have to do to sync MAKE to Google Forms because I'm doing exactly what you're doing in the video and I am getting an error.
    You cannot set us up for success if you don't walk us through the prerequisite stuff.

  • @welcomedigital.digital
    @welcomedigital.digital 11 месяцев назад

    Hey Gavin thx for the great explain :) Master ! Today marks my first day in the Digital Operators community! (and its free

  • @johnatron22
    @johnatron22 Год назад

    This is awesome! Thank you! Is it possible to set up google my business auto reply to google reviews with Chatgpt? would love to see that!! Thanks!

  • @narendraBehera-u2v
    @narendraBehera-u2v Год назад

    thanks bro

  • @ig.ruwail8056
    @ig.ruwail8056 Год назад +1

    can u please make more advanced tutorials

    • @gavinwiener
      @gavinwiener Год назад

      What would you count as advanced?

    • @Thibbyy
      @Thibbyy  Год назад

      Sure, what are you interested in seeing?

    • @ig.ruwail8056
      @ig.ruwail8056 Год назад

      @@Thibbyy This tutorial is great but it was pretty beginners level and I loved it, you can prolly ask chat gpt for some brainstorming on how you can automate multiple businesses and make tutorials for each, For example if someone buys a google sheet of 100 leads how we could make it send personalized email to each of them offering our service or smth like that idk