How to send Payment Reminder Automatically from Google Sheets||Send email based on Date & Time

แชร์
ฝัง
  • เผยแพร่เมื่อ 18 พ.ย. 2024

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

  • @sheetomatic
    @sheetomatic  8 หลายเดือนก่อน +1

    Elevate your skills and reach new heights with my cutting-edge course and digital product! 🚀 Don't settle for mediocrity when you can excel beyond your wildest dreams. Click the link below to seize this opportunity now! 💡 sheetomatic.graphy.com/s/store
    #UnlockYourPotential #SkillBoost #DigitalLearning 🌟

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

    Very true sir you are touch the heart , people always looking for other doing not interested in self doing
    when they starts to pay attention towards them then they start growing

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

      I am really glad to hear that, thanks 🙏

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

    Bahat hi acha video hai, acha kuch sikhne ko mila. Email ke alawa mobile no pe bhi bhejne ka koi tarika hai kya?

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

      Yes, we can send Whats App Messages. for more details call me. Number is on Description Box

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

    Hi Sir,
    Thanks for your quick help| I just want to know i want to send the meeting reminders basis due date but at DIFFERENT TIME intervals.
    As i have meetings at different timing.

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

    Super tips and tricks for us,sir we can set reminder on Google forms,

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

    The video is very helpful for me thank you sir

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

    Nice and informative, shall like to explore more. Can we get in touch for automation MIS

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

    Sir, The tips and trick very helpful for my working life.. many many thanks sir,

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

    Thank you for this video, very useful, but we want to send payment reminder to more than one , is it possible?

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

    hello sir pls btaye agar kisi party k ek se jada bill ho to kya wo b auto generated ho jayega mail

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

    Form Mule add-on is free to use or we have to pay for it ..

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

      I think it free for 1st 100 use 🙄 don't know more about it

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

    but can we connect it to WP and Woocoomerce store and can set condition for Pending or Unpaid and Cancelled orders? Because here what you have shown is really great but how to use it on a Shop or Store that is a confusion...

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

    I like your class, Dear Sir, Its very helpful.... Thank you so much...

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

    Good One sir, 🙏🙏 your way of explaination is very easy. Keep it up sir.

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

      My please, thanks.

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

    Can we use this in delegation sheet as well ?

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

    Good video sir,
    how to set it monthly basis . Like monthly tution fee .

  • @HemantKumar-bg1rs
    @HemantKumar-bg1rs 3 ปีที่แล้ว

    sir video bohat bhadiya h,
    par kya aaisa hi koi process whatsapp/sms ka bhi ho sakta h

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

      Long and Complicated process.

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

    Sir, Very Nice video and Very Helpful 🙏.
    I have one doubt if Current date is 26-05-2021 and Next year date will be 26-05-2022 in above dates Year is Deferent than it will Sent the Reminder mail or not.....?

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

      If I want to send reminders before 10-15days is it possible and how....?

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

    Formule want full access of my google account is it safe ?

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

    Sir have a doubt,
    Us 9 se 10 ke time pe hume apna computer ON rakhna pade ga kya???

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

    How can I send multi reminders, One after 1 day and for same row reminder after one week if not paid yet.

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

    I want Pending purchase order list reminder for weekly basis, google sheet

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

    Nice video sir

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

    Thanks .it works ❤

  • @Ravikumar-to2tu
    @Ravikumar-to2tu 4 ปีที่แล้ว

    Bhai, sheet mai column kai header ko first row m hona mandatory h kya ??
    Mere header 4 row mai hai to ye work krega ya nhi plz reply asap.
    Koi tarika bhi batao plz taki m 4 row kai header pic krwa saku formmule se

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

      Haanji first row me rakhna padega

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

    Vey helpful

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

    Mobile number par nhi bhej skte kya sir

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

    Hi, thanks for the explanation
    1- How can I run the web link directly after the submit form button?
    2- How can I show the sender's mail in the form field without typing it?
    3- How do I get a student to check-in and check-out only twice a day ?
    Thank you ....

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

      Please send me your Queries on the form with supporting files so that I can help you:
      docs.google.com/forms/d/e/1FAIpQLSdcFpuYPDdVNAXh28743WRdPz4dYhX3bu3uRd7xTM1QkDGKBQ/viewform

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

    Sir..can make this like video for sms...it would be wonderful if you can for us... thanks you so much.

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

      SMS & Whats procedures are complicated. need some approval from Govt. for SMS and for Whats app approval required from Facebook.

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

    IF WE HAVE LIST OF ITEMS WHICH WE REQUIRED SO HOW CAN WE SEND MAIL TO VENDOR

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

    Sir, Thanks a lot for this video...
    I have tried working in google sheet but not appear correct answer in email to be sent column.Same formula was applied in excel then answer was coming correct.

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

      try with Text function

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

    Sir due date mai bhi today function laga de tou daily apne aap send kar dega ?

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

    Very informative video. Keep it up.

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

    CAN WE SEND THIS EVERY WEEK, SAY EVERY MONDAY? HOW TO SET THE TRIGGER THEN?

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

    Sir this add-on is free or we need to pay

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

    Can it change from sending on Email to Line Official or Facebook messenger?

  • @humanforai-d5s
    @humanforai-d5s ปีที่แล้ว

    Sir can we send reminder before 5 days?
    Thank you sir !!!!!!!!!!!!!!!!!!!!!!!!!!!!!

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

      Yes you can just set date accordingly

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

    Mail ki jgh mobile number par send ho skta hai kya sir

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

      Using Script and API you can do it

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

      @@sheetomatic koi link hai to send karna sir

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

      @@rajasthanib4u406 Not prepared yet

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

      @@sheetomatic OK thanks

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

    Good Lesson sir. Is it possible to send message to customers phone by SMS or Whatsapp? Please reply. I have data ready (about 200+ members) with phone no. as all have phone nos. but no email with everyone.
    Please reply ASAP.

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

      I am looking the Solution so that I can provide Video.

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

      I have solution, you can send them messages on whatsapp without typing to each and everyone।

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

      @@businessautomation3993 Okay, Great

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

      @@businessautomation3993 please provide the process of sending messages through whatsapp..

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

    If there are multiple rows with contact e-mail being same, how will that happen???

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

    Super thanks

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

    Can i set it up for hours instead of days?

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

    Hello Sir, This tutorial is very help full. But will it send email even if the spreadsheet not open??

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

      Yes

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

      Thank you sir. I am using regular gmail. Not gsuit. Will it work also?

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

      @@ankanjyoti Yes, you can still use it to send email.

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

      Thank you sir. I had tried, the test mail came. But when I set that for today 9-10 am, the mail not came yet

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

      Any help regarding this will be appreciated. Thanks in advance

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

    Very useful

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

    Thank you, quite helpful

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

    what's app pr kaise bheje

  • @AparnaSingh-zl2wu
    @AparnaSingh-zl2wu 3 ปีที่แล้ว +1

    Nice sir 👌👍

  • @Tabish-nl6sk
    @Tabish-nl6sk 6 หลายเดือนก่อน

    How to delete existing conditions?

  • @Ravikumar-to2tu
    @Ravikumar-to2tu 3 ปีที่แล้ว

    Suppose kro yes issi date pr rehta hai next day bhi to kya person 8 ko next day fir se reminder jayega??

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

      Nahi jaayega, clear karna padega Send Status Column ko

    • @Ravikumar-to2tu
      @Ravikumar-to2tu 3 ปีที่แล้ว

      @@sheetomatic sahi pakde ho 👍thanku for reply

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

    Osm sir really thanks

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

      Thank you very much

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

    Can we send to mobile instead of mail id sir

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

      Yes, on WhatsApp

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

      @@sheetomatic have you made any video on that sir can you please share it

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

    can you make the same work but on WhatsApp?

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

      Already did, check out my last Video

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

    Sir, text massage ka video Banaye

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

      This is Paid service, I will try to give you video soon

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

    Please let me know how to send multiple rows data in single mail.
    Like if I want to send list of today's reminder to my staff for follow-ups

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

      Trigger will check for each row when the criteria matches, email will be sent.

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

    Hello Sir, But this is not working for personal gmail account & google sheet. To use this addon do we need to have Gsuite account ??

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

      No such requirement is there. try with another account or incognito mode to check. I am still using on personal Gmail account also.

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

    Making a sheet for the client. So mail should be going from the client mail id. How can I do this? Will the client need to install this add-on or is it okay that I have downloaded it.

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

      You client needs to install it and provide the required access then your email will be keep sending from their email address.

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

      @@sheetomatic I have tried form mule but it is not sending any email on schedule time.
      Please help....

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

      @@sheetomatic it is only sending the mail's when I click on send now. It is not doing anything after that when the time selected actually come.
      I think I am mistaking somewhere.

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

      @@sheetomatic do I need to clear the cells I. Colin of send status?
      Please help...

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

      @@neerajaggarwal4689 One Script to be assigned to clear it automatically

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

    can we send reminder throughwhatsapp

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

      Through whats app api

  • @yuvrajkumar0704
    @yuvrajkumar0704 3 หลายเดือนก่อน

    Sir isi chiz ko whatsapp pe kaise bhej sakte hai

    • @sheetomatic
      @sheetomatic  3 หลายเดือนก่อน

      Please watch this video : th-cam.com/video/J216LBpfYe4/w-d-xo.html

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

    Same way we can use the sheet for Birthday or anniversary Greetings

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

      Yes, right. You can altough I have prepared separate Video on this.
      th-cam.com/video/skyOkvDjfMw/w-d-xo.html

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

    If I want to send email reminder 1 week before expiry date. How can I do it ?

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

      Add one Column and apply formula to get the Value then set the Condition accordingly

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

    auto reminder me Google sheet daily open karna padta he ye kese automatic work karega

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

      No need to open the Sheet to send it. it will send automatically.

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

    How to send reminders on message instead of email??

  • @AS-et8hf
    @AS-et8hf 3 ปีที่แล้ว

    Dear Sir, How to send more than 100 mails per day? This has 100 mails limit. Thanks.

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

      are you using Google Workspace or gmail

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

    Sir whatsapp pr automatic msg kaose bheje free or bulk me plz video bnaiye iss pr

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

    Where I can learn about the If formula? Link please 😭

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

      Also, how to do data entries on a daily basis here in this payment reminder?

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

      I am organising Webinar on the Google Sheets, if yoy are interested please do register for the same link is available in Community Section. For If formula pls click on below link:
      th-cam.com/play/PLJ2nwPX6W6AEkFoDR19RXoNmCp4YmI7pL.html

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

    From where can we download this template sir?

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

      From Description Box

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

    Due date me =today date+14 day. Karte hai to error show kar rha hai

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

    It's not working. It is showing in sent box that mail has already sent. But when I checked with the email address given, inbox has no such kind of mail. Can you please suggest how can I solve this? I am using Gmail account.

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

      I can not say anything without seeing the problems.

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

    Sir please cover Google Docs and Google sheets mail merge and labels create for two sheets per A4 size page

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

      @Jogendra Singh,This is the mail merge, its up to you that where you are using this add on. I didnt get your 2nd Qestion " labels create for two sheets per A4 size page" pls sepcify

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

      @@sheetomatic means two labels on one A4 size paper.
      How can I send an sample image to you?

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

      @gsuitetips@gmail.com

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

    Super

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

    Sir, How to stop this

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

    Add ons me hamari excel me blank show kar rha hai

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

      Try in Google Sheets by creating a File

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

    I am not able to send the automated mail due to some error. Kindly help

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

      Please do send me Email or Whats app

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

      @@sheetomatic kindly share your email ID or WhatsApp number

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

      @@vishnubabu3316 8376837912

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

    Sir with attachment kaisy kary

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

      Place the files in Google Drive and get shareable link , update it now to the Google Sheets with File Name, use tag as a File. it will be attached with mail.

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

      @@sheetomatic sir ek help chahiye mai ek hi mai id per daily different different time mail karna chahta hu with attachment kaisy karu for example 10 vjy fir 11 vjy fir 12 vjy same mail id with attachment

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

      @@sheetomatic sir jo file attachment ho vo pdf show honi chiye link show nhi hona chahiye receiver ko

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

      @@hariomgupta4677 Not possible with this one

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

      @@hariomgupta4677 Shareable link add kar sakte ho attachment alag se nahi ho payega. same email ko different -2 time me mail karne ke script lagana hoga so that send status column clear rahe next email send karne ke liye

  • @bhumitpatel-india
    @bhumitpatel-india 10 หลายเดือนก่อน

    WhatsApp pe bhejna ho toh ?

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

    Ye yadi 100,mail send krna ha alg alg party ko

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

    Kon hai yar 9 unlike dala.....??!!

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

    ❤️❤️

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

    👌🔥

  • @PANKAJYADAV-yz5pe
    @PANKAJYADAV-yz5pe 2 ปีที่แล้ว

    Sir apko call kar raha hu but phn receive nahi kar rahe hai mujhe apse kuch kam tha WhatsApp integration karna hai Google sheet k sath pls call me

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

      Okay, actually I am out of town with limited access.

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

    Is this will work when I am not available in internet or offline?

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

    Thank you so much sir very useful vedio

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

    Thank you Sir very useful video 😊