![]() ![]() It makes things simpler in my mind, but it may not for you and that’s fine. What I like to do is make a copy of my Google Sheet once I have the data, or at least a new sheet in the workbook, and change all of the column header names to match my tags. The tags do not need to match what the column names are inside of Google Sheet but it does make things go quicker if you do. Just make sure that each piece of data that you want on your Google Doc has a tag somewhere in the Doc. Each tag corresponds with a column in my Google Sheet file. In the example below, you can see all of the tags of the data that I will be using. The text in between is the ID or title that you will use to identify a column of your Google Sheet. The tags that you will need to make in your Google Docs are items that your Google Sheet will search out so that it knows where it should put given information. My suggestion would be to make a test version first and play with the settings. Text, fonts, sizes, colors, and anything else will be fully retained and the data from your Google Sheet will automatically adapt to fit what is there. The nice thing about this is that the final output will retain all of your formatting. This is just a template that will be used to generate all of the pages or other outputs that you may want. To begin with, autoCrat needs a dummy Google Doc that has tags showing where to place the data at. This is probably the most difficult step of the whole process if you haven’t done a mail merge before. Once you have given it a name click on “Next.” Step 5 Create or Choose a Template It will do everything you want, it just takes a little time. A pop-up will appear and it will take a few seconds for everything to pop-up. From there go to autoCrat and click on Open. You can do this by Add-ons -> Get Add-ons -> and searching for autoCrat. Step 1 Install the autoCrat plugin on your Google Sheets form response The data has to be sorted into a usable format for students so that they can easily see what they need to do and where they need to do it. This is when a mail merge becomes necessary. It’s not formatted properly, it’s difficult to read, and it’s not user-friendly for middle school students. Printing all of this data from Google Sheets is impossible. About 400 students fill out the form and from there, they each need a custom schedule that shows them their activities for the day. Once the activity is full, it automatically removes itself from being a choice in the Google Form ( If you want to see how to do that click here). Var body = "Here is your subject, body, ) ĭriveApp.getFileById(copyId).Have you ever needed to take data from Google Sheets and import it into Google Docs? And then print that data or create things with it? For my school’s Field Day students use a Google Form to select activities. Var pdf = DriveApp.getFileById(copyId).getAs("application/pdf") Var copyDoc = DocumentApp.openById(copyId) Var copyId = DriveApp.getFileById(docTemplate).makeCopy(docName).getId() Get document template, copy it as a new temp doc, and save the Doc’s id Get information from form and set as variables Var docName = "Recruiting Requirement Profile -" var docTemplate = "documentIDhere" // *** change template ID if new google doc is used*** ![]() Weirdly, the logger does not log anything. ![]() I would highly appreciate any input as i am at my wits end. Generate and send pdf through Google Forms to my email address - doesn't send, debugging to no assitance I have used the initial template from here:Īnd made all suggested changes from here: I am trying to use app script with a google forms sheet to populate a docs template which I then send as pdf attachment via Email. ![]()
0 Comments
Leave a Reply. |