How to Automate Invoice Creation with Google Sheets, Docs and Forms

Automate invoice (and other document) creation using Google Forms, Sheets and Docs.We’ll use Apps Script to create a workflow that automatically populates a document template using responses from a Google Form.

Google Forms Phone Regular Expression Pattern: \+?\(?\d{2,4}\)?[\d\s-]{3,}
Google Forms Email Regular Expression Pattern: [a-zA-Z0-9_\.\+-]+@[a-zA-Z0-9-]+\.[a-zA-Z0-9-\.]+

[royaljourneyroyalservices]

I'm still in awe behind how this really did come out perfectly for me....thank you for your time spent making this video.

[chervindavasol]

Thank you for sharing your knowledge! more videos and tutorials about automation like this

[jcinewilliams]

Very helpful and appears pretty straightforward. Will be adopting this tonight. Thank you for sharing.

[MessiahYeshuaLives]

Thank you for this, I have managed to adjust it to be both my invoice and now a quote form too, it took me a little figuring out but both work perfectly now. Thanks for the really helpful video and additional info in the description. (Australia based)

[tenthhousestudio]

Thank you, Worked well for me, I had to change the currency symbol from dollar to Indian rupee by changing the constant, it worked well for me.

[angeo]

The best tutorial on automatic template creation.

[bssimmonds]

Brilliant. This all works for me. Well done, Thanks

[paulinemorare]

It's really magic! It makes it seem so easy to follow. Thanks

[Buzz-and-Connect]

@Automagic Thank you very much for this, it help a lot

[felmanangeldoquena]

Lol. It's true when you said don't get scared about coding. I was really procrastinating to learn this because of the Apps Script part.

[GenNextAnalyst]

Thanks a lot! Looking forward to your new contents / videos.

[mattbaker]

Great tutorial, very easy to follow, nice and simple for a beginner

[arushaify]

Brilliant work.. amazed me.. You explained it easily.. The best video 2022

[mccallan]

Thanks man. You're a star. Awesome video well presented. Kudos.

[aivie]

This is very helpful. Hoping to see more. Thank you.

[lilylisham]

Thank you so much .. This is exactly what I was looking for.

[nssdesigns]

OK this is sort of cool... noticed the Blank rows still had a 0, 00$ value so I guess it needs some tweaking or simply deleting the lines... I was hoping for a Sheets solution to the problem where you fill in the data in a sheet and use that to propagate the invoice and then print as .pdf and send the invoice. But there's a lot of this which is good. I'll SUBSCRIBE and head off to find similar content on your channel

[EyemotionView]

Absolutely fantastic thanks very much for sharing. I subscribed after the first 2min :). Ps at 06:10 I couldn't find Script editor "App script" under the Tools Tab drop down list in my Google sheets, might be a google update...I found it under the Extensions Tab so I was able to follow along. thanks once again!

[jacksclassinrelax]

great stuff beautifully explained! thanks

[ADangerToOurDuhmockery]

for some reason I do not have the option to select "createDocFromForm". My only option is "myFunction". I must have missed something. Will watch video again and update. Very helpful video. I cannot even begin to tell you how useful this is for me.