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. 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