1. Create a Google form to collect whatever data you want. Here's an example of one of mine:
2. Create a Google doc for the form data. Where the data should be entered into the form, place double brackets. It looks like this:
3. Go back to the form, select "Tools" from the menu bar, and search scripts.
4. Search for the AutoCrat script and click "Install." This will take a few minutes. You'll be asked to Authorize it, and then the spreadsheet will open a new sheet in the document. Simply tab over to Sheet1.
5. Click on the new autoCrat tab at the top and click "Run Initial Configuration."
6. Select the name of the document you created in step 2, and when prompted, just follow the bouncing ball (clicking save/submit) until you get to step 4. Match the document tags to the sheet header titles in the form, as shown:
7. On the next screen, choose "Save merged file to Docs." Choose the folder you want to save it to and choose your naming convention. Choose the type of file you want to save (google doc or .pdf), and check "Send merged files via email." Your form should have had an area for users to input email. Copy and paste the field setting for the email input into the next field.
8. Click Save settings and allow the documents to merge. You'll notice a new column that appears in the spreadsheet. This is your verification that the form has sent. You'll also have a copy of the sent form in your Google Docs, should you need it. Your new document will have all the information your users provided in the form of a letter.
The possibilities of this tool are endless! And there you go. That's just Google. Making your life a little easier.
