Create an order form for clients with Google Workspace & Document Studio

[@walterwa256]

Wow… I am so going to set up an Order Form

[@gadjuma8029]

All budding entrepreneurs assemble! This is very useful! 🇰🇪🇰🇪

[@zurepezthis583]

Oh my God, thank you very much, this really helps my college assignment :(. thank you shem!!!

[@numbat9593]

This is what I am actually looking for. Thanks so much I would try it out

[@walterwa256]

Thank you Shem

[@ShemOpolot]

You’re welcome.

[@TheGrifhinx]

Google forms keeps inserting new rows a the top of the responses sheet and does not contain all the formulas created in the responses sheet, so how is that fixed?

[@stylznailsandmore2025]

Thank you for sharing ❤❤❤❤

[@Omega-lw3ke]

Thank you very much this is so helpful

[@RadioSahal]

Thank you that was Awesome!

[@Mrs_Slop]

Hi! I was doing perfect until it says no markers found. I have the two swiggle brackets and copy and pasted the titles from the cell. I don't understand and i can't find anything online. :(

[@ShemOpolot]

@@Mrs_Slop hey! I’m sorry to hear that. This is a pretty old video and solution. It’s also hard to troubleshoot via the comment section. However, I think there are some better options you can use for this sort of thing today: Gumroad, etc., maybe? I’m sorry if this isn’t a super helpful response.

[@suequeen2023]

Thanks for the knowledge. I just have a question, what if a customer wants to order 2 or 3 orders of the candles. How do you go about it especially in the order list and invoice?

[@ShemOpolot]

Thanks for watching. Unfortunately, this method is limited in that way. You’d have to pay for a Google Forms extension to configure it that way. But there might be better inexpensive methods to do this now: Gumroad, Kajabi?

[@lilianezeli5521]

Thanks for this video. what if the person wants to order for different colors of candle which is more like a real situation, Please how do we go about it?

[@ShemOpolot]

Hi! I'm glad you like the video. Unfrotunately, this method is very limited. It's a workaround for a specific case where someone doesn't want to spend money. Ordering different candles would probably require filling out different forms 😔

[@KidsExceptionalEvents]

Hi, do you have a tutorial in google forms where my client can choose an order and then they will be able to see their total price?

[@ShemOpolot]

Hey! Thanks for watching, first of all. There a few Google Forms plug-ins that can help with this, but they aren't free. And if you're willing to use them, you might as well just pay for a more established solution like Shopify, Gumroad, etc. I hope this is helpful.

[@shiana35]

how do it get it to be automated responses. without dragging it down each time I get a response.

[@ShemOpolot]

Hi! Thanks for reaching out. It should automate responses. Is this not working on your end? Also, this was ages ago. I probably need to do a refresher. There are simpler alternatives.

[@blackscopecannon8422]

Thank you so much!!

[@TBellas2019]

How do you get the excel sheet to coincide with the Google form

[@ShemOpolot]

It’s Google Sheet, which is automatically connected to every Google Form. Is this clear?

[@amk.diaries6043]

Very formative video I have ever seen. But I'm looking to add a credit card payment method to my google form is there any way ? thank you in advance.

[@ShemOpolot]

I believe there's an add-in called Neartail you can use but it isn't free.

[@hunkyvampire]

Great video but it would be nice if there was a way for the customer to order multiple items too within 1 form.

[@ShemOpolot]

@@hunkyvampire you’re right. But, that’s what we get for free.

[@hunkyvampire]

@@ShemOpolot you mean to say if I pay you, you could help me out?

[@ShemOpolot]

@@hunkyvampire no, no. I mean the option I share in the video is free, but there are other non-free options with more functionality.

[@ruwabs]

Hi Shem, is this a form of a funnel? lead magnet? Also, is link and form created and supported by and through Google?

[@ShemOpolot]

Hi Ruthie! Thanks for watching😊. This is neither a funnel not a lead magnet (if I understand those 2 terms correctly😅). It's a way for you to automate the process of your clients ordering your product(s) and receiving all the relevant information about payment and delivery in an email. Document Studio is an add-in from Google Workspace. Add-ins can come with certain risks, but based on my research it's safe to use. I hope this response is satisfactory😊. Otherwise, we can keep chatting or you can email me.

[@kutulloletageng1069]

Did i have to pay for those plugins used?

[@ShemOpolot]

Nope Not at all. But this was years ago, things may have changed 😅

[@normanangel9427]

Hi Shem, This is so helpful and great work sharing with us this knowledge. Qn. What if the customer wanted to order more than one type of item in this case candles in one order form? How would we deal that in terms of computation ?

[@ShemOpolot]

Hi Norman, Thanks for watching! Yeah that's a challenge. There are some add-ins in Google Forms that allow one to create a proper order form, but they may be glitchy or not free. This method works best for people selling one type of item.

[@RaviKumar-gd3ew]

Hii This is ravi from India. Actually am working in travels company here we have nearly 100 vehicles data to mainten every day drivers attendance and daily meter tracking In google sheet is there any data entry for that

[@ShemOpolot]

Hi Ravi! Sounds like you can use Excel or Google Sheets for that. But you may have to build it from scratch.

[@ImdAsifulIslam]

Is it all for free?

[@ShemOpolot]

Yes. It’s limited, but free.

[@ShariWilliams-fn5js]

Great job you did move really fast. but great video thank you

[@notorioustofu3482]

Great video, but Document Studio's permissions are a bit too much

[@ShemOpolot]

You're right. I suppose this is what they mean by, "cheap things will cost you."

[@dorothyjones1130]

【ｐｒｏｍｏｓｍ】