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/1ZjogMs3I4HhA8OjkopABjaxFL5_i5Li-fv7XU0FDhrM/copy 

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/48bc3dd1bc785601422e80b2de98359e 

#goolesheets