the best video when it comes automating invoices using google forms. thanks Kewal
@user-hk2tl3tm4j
7 ай бұрын
how to automate the invoice number?
@varunpatre6391
4 ай бұрын
How can you change or generate an invoice number automated?
@sheikhwaqasahmadfairdealma3895
Жыл бұрын
Thanks for the information highly appreciated I have achieved my set goal 👍
@sashikarasnayaka5781
3 ай бұрын
Excellent.. Very clear explanation
@user-qj8ey6zj4z
Жыл бұрын
how to create an approval work flow please! great vid!
@CBBBJ
5 ай бұрын
RIP to anybody who was wearing headphones at full volume and heard that whooshing effect 😂
@user-ed5gn3dj4o
3 ай бұрын
Excellent explanation.. ❤❤❤
@samip2307
3 ай бұрын
Really helpful. Thanks
@kapilkakkar3258
Жыл бұрын
Wow 🤩 amazing learning
@KewalKishan
Жыл бұрын
Thank you :)
@shravanjat3239
3 ай бұрын
Thanks a lot brother ♥️
@pra070
Жыл бұрын
Nice & helpful. Thanks kewal
@KewalKishan
Жыл бұрын
❤thank you Prabhakar
@theeducationist2901
9 ай бұрын
LOVELY.My many problems solved in this video
@KewalKishan
9 ай бұрын
Thank you. If you would to automate with much better efficiency, you may join our 14-days free trial of WhatsAppreneur here: app.automatebusiness.com/register Enjoy your journey with us!
@indwheelzautomobile
2 ай бұрын
It was very helpful
@kinjal852008
Ай бұрын
nice video , thx for sharing , i need more info " in invoice no. how to set the no. in sequence"?
@ashutoshpundeer6125
Жыл бұрын
Great video #letsautomate
@KewalKishan
Жыл бұрын
Sure Ashutosh. Keep learning & automating🚀
@ahmedaraby573
6 ай бұрын
Perfect. How to use publisher and approval at Google form submission ?
@rahulrajbhar6694
Жыл бұрын
Thank you for the Valuable video.. Could you please help how we can send the auto reply over whatsapp instead of email
@KewalKishan
Жыл бұрын
You can attend our FREE Masterclass where you can learn how to automate your entire Business using Google Workspace and Whatsapp. Register here 👉 kewal.co/y-live
@bishastra
Ай бұрын
superb
@user-nd3ih9ss6q
6 ай бұрын
Hi Kewal ! How can I automate the invoice # in the invoice sheet vs 12345 ? Thank you!
@tallyerptutorials
Жыл бұрын
It's ok sir, but the people feels difficult to fill Google forms instead of ordinary form. Anyway the Idea is good. Can use the technic to make pos billing software for multiple shops.? Are us there any other way? Please suggest.
@iradpatil
Ай бұрын
Sir what about invoice number auto change?
@user-vq8ot7rr1t
8 ай бұрын
Hi Kewal, Thanks for this video. Very helpful for small business. However, I encountered few problems. The unit price appeared as #REF. How can I fix this? And how can I make the Invoice Number generate properly and not 12345? Hoping for your kind response!
@ashishrajput23
3 ай бұрын
Hi Everything looks fine but my template unable to fetch product price.. and everytime making new sheet with file name
@REXAGroup
9 ай бұрын
Hi.. First of all, thank you for sharing the automation to generate invoice.. How do we add unique invoice number everytime we create a new invoice
@KewalKishan
9 ай бұрын
Hi, As you're saying that the invoice number is unique, so you cannot add it as question into Google Forms. For this, you'll need to manually add a column into Google Sheets. Then you can either manually add the invoice number for each entry or use formula as required. Once done, you can use that variable in Form Publisher to add invoice number.
@rajdhonde4492
Жыл бұрын
How will google suite help Gold and silver jewellery retailers? Gold jewellery business has complicated task which i think requires customized erpsystem
@rajdhonde4492
Жыл бұрын
Please respond
@KewalKishan
Жыл бұрын
Dear Raj, Google Workspace is being used by all Industries including Jewellery. Watch this Jewellery Business Owner interview: kzitem.info/news/bejne/uKCDxXt8cHWWaXo Start your journey here: kewal.co/y-live
@sheldonbrown438
Жыл бұрын
how to i get the invoice number to changer
@PavithraChandramohan-x9r
2 күн бұрын
stuck in vlookup. Please help
@OrbitalMeditek-qx9js
5 ай бұрын
Is form Publisher works with Google Doc??
@yousefgharaibeh7079
Жыл бұрын
I create one according to your tutorial and it was fun and helpful, but I did not get the prices under unit price and total price. I did everything you did in the tutorial step by step.
@KewalKishan
Жыл бұрын
Hi Yousef, Join our Business Automation Masterclass to automate your business using Google Apps & WhatsApp Automation. Register here: kewal.co/y-live
@marshalldillon973
Жыл бұрын
It literally took me 18 times through to find the error I was having. Jump to about the 10 minuter mark. Instead of selecting just the Invoice tab select the entire document. Then it will be able to pull the price from Sheet 2.
@sukharamgurjer
Жыл бұрын
@@marshalldillon973 का
@redwantareq
Жыл бұрын
@@marshalldillon973 how did you solve the vlook up issue? can you please guide me?
@user-vq8ot7rr1t
8 ай бұрын
@@KewalKishanwhy are you creating a tutorial with error? This doesn't help small businesses like us. You cannot even give us the right formula.
@RAJEEVRAJEEV-zr6xj
Жыл бұрын
GREAT SIR
@KewalKishan
Жыл бұрын
Thank you. :)
@yadavashutoshk
Жыл бұрын
I will also suggest you to share some demo whenever your providing demo of any foormat in sheet or Forms.
@KewalKishan
Жыл бұрын
Hi Ashutosh, For the detailed information, kindly join us at- kewal.co/y-live
@user-eu5oc2ok1u
10 ай бұрын
hello thanks for your time and gave us the knowledge. sir i tried to design my own format on google sheet and as per your video i connect the google form from spreadsheet and the download the add on formpublisher. but facing an issue & issue is that the aftersubmitting the google form it is not taking up vlookup formula. i checked the formula is ok. Can you help me in that please it is my humble request.
@jasvithalani3200
8 ай бұрын
Hello sir. How we can keep multiple prices for the same product. Please help
@aayeshamutadayyinah3982
4 ай бұрын
how to auto generate Invoice Numbers? Pls Help
@jalalkia-gi8vl
5 ай бұрын
great. how can we connect it to whtasapp i mean sanding pdf file to client whatsapp
@KewalKishan
5 ай бұрын
Hi Dear, for WhatsApp Automation, you need Official WhatsApp API. Check out www.whatsflow.app/
@digimerce_pk
5 ай бұрын
How to change invoice number automatically everytime?
@mohammedrahemalsaede1234
Жыл бұрын
Hello sir, thank you for your efforts. I am trying to do the same thing as you did in the video, but I have to upload a file (image) in the invoice. How can I do that?
@KewalKishan
11 ай бұрын
Hi Mohammed, you can do that. Kindly join our live masterclass- www.kewal.co/y-live to know about how you can automate and scale your business to 10X using Google workspace and WhatsApp Automation. :)
@haphazardjahid
Ай бұрын
Formula doesn't work.
@kutulloletageng1069
Жыл бұрын
Will it be possible for the form to allow users to click/select more than 1 product on a checkbox? to avoid having a long form if i have about 30 products to choose from
@KewalKishan
Жыл бұрын
yes, it is feasible. Join Business Automation Masterclass to discover How using Google Forms, Sheets & WhatsApp Automation, you can automate your Business. Register here: kewal.co/y-live
@md.muhaiminurrahman3020
Жыл бұрын
Thanks alot. But Form Publisher addon allows only 20files/month.. 😢
@radjosadewa4951
Жыл бұрын
Nice video!!, Its help a lot.. but mine the vlookup not showing result.. address or price at pdf invoice, can you tell me where did I do wrong?
@KewalKishan
Жыл бұрын
You can attend our FREE Masterclass where you can learn how to automate your entire Business using Google Workspace and Whatsapp. Register here 👉 kewal.co/y-live
@marshalldillon973
Жыл бұрын
@@KewalKishan It literally took me 18 times through to find the error I was having. Jump to about the 10 minuter mark. Instead of selecting just the Invoice tab select the entire document. Then it will be able to pull the price from Sheet 2.
@marshalldillon973
Жыл бұрын
It literally took me 18 times through to find the error I was having. Jump to about the 10 minuter mark. Instead of selecting just the Invoice tab select the entire document. Then it will be able to pull the price from Sheet 2.
@ujjwalkotnala
Жыл бұрын
Hi sir Ujjwal this side We are having different customer and they want invoice according to them , I mean we have to create invoice in multiple templates is there any way to to create such type of excel sheet so that we can create invoice in different different templates. Please make a video on this also
@KewalKishan
Жыл бұрын
Hi Ujjwal, Although it is recommended to follow a common template, you can create 3,4 diff. templates based upon customer choices and diff forms connected to them. Implement Form publisher in all these Forms. Fill the Form and automatically invoice gets generated and emailed to client. Using Import-range formula, all data of diff.-2 sheets can be collated to a single sheet.
@user-or6tl6jy9d
Жыл бұрын
hi, what if we have around 40 products? can we just create a multiple choice grid with item name as rows and quantity required as columns? then how do we get it in the format, for only selected items to be shown as the result with the calculated price.
@user-or6tl6jy9d
Жыл бұрын
i am already in MBA 2.0 program
@KewalKishan
Жыл бұрын
Kindly share your registered email id and contact no.
@EpicInsta360
Жыл бұрын
@@KewalKishan Hi there, I am having the exact same query, could you guide me here?
@harneetsethi6583
Жыл бұрын
Can we generate dynamic number of products list in Google form . Like to one customer I have to sell just 1 item, to another may be 5, 20,40 etc???
@nikeshpandey2551
Жыл бұрын
searching the solution of same question....
@KewalKishan
Жыл бұрын
You can get dynamic numbers as well. You can register for Business Automation Masterclass to learn how to Automate your Business using Google Forms, Sheets & WhatsApp Automation👉 kewal.co/y-live
@nicojaa7035
Жыл бұрын
hi, do you have a solution to integrate google form into a proposal software? to get client answers transferred into a proposal software directly?
@KewalKishan
Жыл бұрын
Which proposal software? it might be possible using Pabbly connect. If your software has APIs to connect with external services.
@shenelianujee5441
Жыл бұрын
any limitations?
@pugazhendimudaliar317
9 ай бұрын
Do we have choice to send to WhatsApp client automatically?
@KewalKishan
8 ай бұрын
Yes, you do. Register for our free trial of WhatsAppreneur: app.automatebusiness.com/register You will realise the power of automation. We've helped many business owners the same way as you have just asked for.
@sagarranadive9840
Жыл бұрын
How many items we can add?
@ninadkelkar4339
Жыл бұрын
I have google sheet to generate invoice. However if product 1 is 10 qty, Product 2 is Nil qty & Product 3 is 12 qty. Can write formula to generate so that product 2 will not appear and on that row product 3 will appear so that invoice will show only 2 rows instead of 3 rows with row no. is blank?
@KewalKishan
Жыл бұрын
Hi Ninad, this is easy. Appscript coding is required in the same. If you are a Business Owner and want to Automate your Business using Google Sheets, Forms & WhatsApp Automation, then get started. Do Join a Free Business Freedom Class to get started👉kewal.co/y-live
@tsonguiAng
Жыл бұрын
Id like to know this answer as well.
@naitikgala3239
Жыл бұрын
I followed all the steps, but in my invoice (pdf) product and quantity fields are populated but unit price and total price show up as #REF!
@naitikgala3239
Жыл бұрын
Can you help me here
@KewalKishan
Жыл бұрын
Please register at Kewal.co/live
@selangwakal
Жыл бұрын
May I have a link to download the invoice please
@KewalKishan
Жыл бұрын
Hey! Watch the video again. At 03:08 I've explained how to get the invoice template.
@user-gh7hb3nw1t
Жыл бұрын
followed step by step however i keep getting #REF! (unresolved sheet name) on the customer invoice
@marshalldillon973
Жыл бұрын
It literally took me 18 times through to find the error I was having. Jump to about the 10 minuter mark. Instead of selecting just the Invoice tab select the entire document. Then it will be able to pull the price from Sheet 2.
@ClintonTownshipCowboys
Жыл бұрын
@@marshalldillon973 thank for replying. I figured it out at the 17th time....lol then I had to hide sheet2 so the customer would not get that part
@user-vq8ot7rr1t
8 ай бұрын
@@marshalldillon973 can you please help? I have issues with the #REF on the unit price. How did you fix it?
@abeladeyemi7758
Жыл бұрын
Hello good morning sir, please sir I have been creating it but still getting the #ref! Prompt I need help as soon as possible, what can I do to clear that off sir
@KewalKishan
Жыл бұрын
Check Formulas & their format again. Join Live Class and here you can ask your queries: kewal.co/live
@theycallmenothing401
7 ай бұрын
How to automate invoice sending to clients email
@KewalKishan
7 ай бұрын
You can use WhatsApp to automate invoice sending. Register for a free trial to do that: automatebusiness.com/free-trial
@andrewmartin4324
Жыл бұрын
I need your help to create one Google from
@KewalKishan
Жыл бұрын
Hi Andrew, you can create any type of google form by simply typing www.forms.new . If you are a business owners and want to learn more about Google workspace and whatsapp automation, then, feel free to join our live masterclass at kewal.co/y-live :)
@user-gx2sb6fe4p
10 ай бұрын
how to change the invoice no automatic?
@KewalKishan
9 ай бұрын
Hi, You will have to use a formula in Google Sheets to generate unique numbers as and when new entries are added through Google Forms.
@user-gx2sb6fe4p
9 ай бұрын
@@KewalKishan CAN I HAVE THE VIDEO ON THIS ?
@davidsonzleh9834
8 ай бұрын
I have a question to ask.
@davidsonzleh9834
8 ай бұрын
Can anyone help me.
@davidsonzleh9834
8 ай бұрын
Question: Is it possible to use vlookup when you have the same product but with different prices when using Google form and Google sheets why creating automatic invoice?
@KewalKishan
7 ай бұрын
You can use INDEX-MATCH combination for that. If you want to use VLOOKUP, you'll have to create a new column and assign a unique ID to these products. Having same product with different pricing would indicate there is some form of difference in them; they'll either have different model numbers or some form of serial number. Use that in VLOOKUP.
@Narindersingh-ns7uv
Жыл бұрын
hello sir how to also automate invoice number
@KewalKishan
Жыл бұрын
Kindly join us at - kewal.co/y-live to know about how you can automate and scale your business to 10X. :)
@OrganicPickups
Жыл бұрын
Could the answers of that form be linked to 2 other documents, like an invoice and a product sheet, let say for manufacturing, where we just need the specs but not the prices? Thanks
@KewalKishan
Жыл бұрын
Hi Organic Pickups, Join our Business Automation Masterclass to automate your business using Google Apps & WhatsApp Automation. Register here: kewal.co/y-live
@yuktitrisna
Жыл бұрын
I followed you step by step, but the results is #REF. Could you please tell me where it may gone wrong?
@KewalKishan
Жыл бұрын
Check Formulas & their format again. Join Live Class and here you can ask your queries: kewal.co/live
@ritveek979
11 ай бұрын
same
@ImdAsifulIslam
3 ай бұрын
Is it free?
@andrewmartin4324
Жыл бұрын
Hi
@ssharma7764
Жыл бұрын
I am medical products supplier. I have 300 products Mager problem -inventry management Staff Management Dr customer management Regular order mangement Reminder Self invoice generate Despatch details Online payment update
@KewalKishan
Жыл бұрын
Hi Ssharma, you can attend our live masterclass www.kewal.co/y-live to learn about how you can automate and scale your business to 10X using google workspace and whatsapp automation. :)
@JINISHSUGUNAN
Жыл бұрын
Need for hotel,
@KewalKishan
Жыл бұрын
Hi Dear, kindly register for our live masterclass at www.kewal.co/y-live to learn about how you can automate and scale your business to 10X using Google workspace and whatsapp automation. :)
@digitonsam
Жыл бұрын
bol na ke form publisher paid service hai itne mehnat karne ke baad pata chala ke only 20 invoices are allow per month
@KewalKishan
11 ай бұрын
Hi Dear, this is a paid addon from Google's end. You can use their service as per your requirement. In case of any query, kindly take the support from google on support.google.com :)
@ExpressPod_Excerpts.
Жыл бұрын
How to generate invoice number automatically I hope u didn't mentioned here.
@KewalKishan
Жыл бұрын
You can get dynamic numbers as well. You can register for Business Automation Masterclass to learn how to Automate your Business using Google Forms, Sheets & WhatsApp Automation👉 kewal.co/y-live
@jaagareality
Жыл бұрын
How to add if I have 50 products in quotation
@KewalKishan
Жыл бұрын
Hi Munigonda, It’s easy. Add 50 items in Item Master sheet where price and product is mentioned. Add these items in Google form drop down. And implement the same way and it gets automated 👍 You can use Form Ranger Addon to update Google form drop down from a column in google sheet automatically 👍
@jaagareality
Жыл бұрын
@@KewalKishan No sir My requirement is to incorporate 50 different items to be entered through form
@KewalKishan
Жыл бұрын
@@jaagareality In that case instead of radio buttons in google form, you need to use Check boxes✅
@lalitseemasoni
Жыл бұрын
Kewal where is the GST
@KewalKishan
Жыл бұрын
Hi Lalit, Just the way we picked price, gst also can be picked from item master👍
@kennojc
Жыл бұрын
Useful, but unfortunately is a tutorial for a paid app.
@KewalKishan
Жыл бұрын
To learn more, Join our Business Automation Masterclass to automate your business using Google Apps & WhatsApp Automation. Register here: kewal.co/y-live
@yadavashutoshk
Жыл бұрын
Let me give you strong feedback.Your voice flattens whenever you speak.I think most people cant understant what you say.Improve your sound quality.
@KewalKishan
Жыл бұрын
Thank you Ashutosh for feedback. We ll improve.
@shrikantagrawal3272
3 ай бұрын
Can I this help sending whatapp
@user-dm4vs7bx2e
Ай бұрын
This tutorial is DEAD. It doesn't work anymore! Final invoice gives #REF! errors. I double checked it 3 times.
Пікірлер: 138