Is there a way to have the Google Doc automation create documents from a pre-existing template? I want to set up the new automation to generate letters, however, I need them to have a specific header and footer. If there was a functionality to select...

I have a table where I want an email per record to be sent when a record matches conditions. For example: Contact Email is NOT Blank and Check Box 1 is Checked and Check Box 2 is Checked and Contacted is Empty The Actions are: Send an Email and Updat...