I want to create automated reports for test takers. The test taker completes the test via the FORMLY platform https://www.getformly.com/ --> the results are generated directly to Google Sheets (simply numbers). 1) In this Google Sheet, I'd need to prepare a formula and convert specific numbers into a written score in new cells (e.g., low, average, high). I can do this myself. 2) In the Google Docs file, I have precisely described the specific content for the report, depending on the score someone received. 3) I also have a template prepared in Google Docs. Where data is to appear, I have tags in curly braces, e.g., Hello {{Name}}! Your test score is {{Overall_Score}}. Interpretation: {{Description_N1}}.
4) The completed report with the completed data should be sent to the test taker. Will your tool allow me to create such automation?