How to Automate Invoice Creation with Google Sheets, Docs and Forms
Automagic Automagic
3.68K subscribers
255,404 views
4.1K

 Published On Feb 7, 2021

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.


Template: https://docs.google.com/document/d/1Z...


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-\.]+

Apps Script Code: https://gist.github.com/automagictv/4...

show more

Share/Embed