I am a teacher who runs the Credit Recovery program at my school. I am trying to create a way to make a scenario that allows me to put together data for a progress report on a Google Sheet, turn that into a Google Doc, then attach that to an email to send to both the student and their parent/ guardian.
I can do the Google Sheet to Google Doc. I’ve been doing that type of automation for a while. However, the process of getting the email to do what I want that is the issue.
I tried to do it where I had the content of the progress report in the email, but it turned it all to a single paragraph instead of the separated paragraphs that I had initially designed for the progress report.
Can we see some screenshots of what you accomplished so far?
I suppose you only need a “Google Drive - Download a file” module between the google doc creation and the Send email module. Then, in Send email, map the attachment to the Downloaded file.
The problem is that the Download File module is asking for a file name, but that should be created with the “Create a Document from a Template” and it wants me to add a file ID. I am really confused, even after reading the help pages.
If this is too much, is there a way to get the information to populate in the body of a message and for that message to not bunch up into a single paragraph?
