Rispondi al feedback
Mantieni tutto organizzato con le raccolte
Salva e classifica i contenuti in base alle tue preferenze.
Livello di programmazione: principiante
Durata: 15 minuti
Tipo di progetto: automazione con un menu personalizzato e
un trigger basato su eventi
Obiettivi
- Comprendere cosa fa la soluzione.
- Scopri cosa fanno i servizi Apps Script all'interno della
soluzione.
- Configura lo script.
- Esegui lo script.
Informazioni su questa soluzione
Crea automaticamente bozze di risposte via email al feedback ricevuto tramite Moduli Google. Questa
soluzione si concentra sul feedback degli studenti sui corsi, ma puoi applicarla a qualsiasi
caso d'uso per cui ricevi feedback tramite Moduli Google.
Come funziona
Lo script installa un trigger basato sugli eventi che viene eseguito ogni volta che un utente invia un modulo. A ogni invio del modulo, lo script crea una bozza di email in Gmail. L'email
è indirizzata alla persona che ha inviato il modulo e include le risposte
e un messaggio di ringraziamento generico. Puoi modificare l'email prima di
inviarla.
Servizi Apps Script
Questa soluzione utilizza i seguenti servizi:
- Servizio script: installa il trigger basato su eventi
che si attiva quando qualcuno invia un modulo.
- Servizio Fogli: invia le risposte del modulo a Gmail.
- Servizio Gmail: crea la bozza di email con
il messaggio di ringraziamento e le risposte del modulo.
Prerequisiti
Per utilizzare questo esempio, devi soddisfare i seguenti prerequisiti:
- Un Account Google (gli account Google Workspace potrebbero
richiedere l'approvazione dell'amministratore).
- Un browser web con accesso a internet.
Configurare lo script
Fai clic sul pulsante seguente per creare una copia del foglio di lavoro di esempio Rispondi al feedback. Il progetto Apps Script per questa
soluzione è allegato al foglio di lavoro.
Crea una copia
Esegui lo script
- Fai clic su Strumento di risposta al modulo >
Attiva risposte automatiche in bozza. Potresti dover aggiornare la pagina per visualizzare questo menu personalizzato.
Quando ti viene richiesto, autorizza lo script.
Se nella schermata per il consenso OAuth viene visualizzato l'avviso Questa app non è verificata,
continua selezionando Avanzate >
Vai a {Project Name} (non sicuro).
Fai clic su Strumento di risposta al modulo > Attiva di nuovo
le risposte automatiche.
Fai clic su Strumenti > Gestisci modulo
> Vai al modulo live.
Compila il modulo e fai clic su Invia.
Apri Gmail e controlla le bozze. Dovresti avere una nuova bozza
con la risposta
del modulo.
Esamina il codice
Per esaminare il codice Apps Script per questa soluzione, fai clic su
Visualizza codice sorgente di seguito:
Visualizza codice sorgente
Collaboratori
Questo esempio è stato creato da Ben Collins, educatore presso benlcollins.com
ed esperto di Google Developers.
Questo esempio è gestito da Google con l'aiuto degli esperti Google.
Passaggi successivi
Salvo quando diversamente specificato, i contenuti di questa pagina sono concessi in base alla licenza Creative Commons Attribution 4.0, mentre gli esempi di codice sono concessi in base alla licenza Apache 2.0. Per ulteriori dettagli, consulta le norme del sito di Google Developers. Java è un marchio registrato di Oracle e/o delle sue consociate.
Ultimo aggiornamento 2025-08-31 UTC.
[null,null,["Ultimo aggiornamento 2025-08-31 UTC."],[[["\u003cp\u003eThis solution automatically creates draft email replies to Google Forms feedback using an event-driven trigger.\u003c/p\u003e\n"],["\u003cp\u003eThe script uses the Script, Spreadsheet, and Gmail services to install the trigger, retrieve form data, and create draft emails, respectively.\u003c/p\u003e\n"],["\u003cp\u003eSetting up involves making a copy of the provided spreadsheet and enabling auto draft replies via the custom menu.\u003c/p\u003e\n"],["\u003cp\u003eTo run the script, enable replies, fill out and submit the form, then check your Gmail drafts for the automatically generated draft email containing the form responses.\u003c/p\u003e\n"]]],[],null,["# Respond to feedback\n\n**Coding level** : Beginner \n\n**Duration** : 15 minutes \n\n**Project type** : Automation with a [custom menu](/apps-script/guides/menus) and\nan [event-driven trigger](/apps-script/guides/triggers/installable#event-driven_triggers)\n\nObjectives\n----------\n\n- Understand what the solution does.\n- Understand what the Apps Script services do within the solution.\n- Set up the script.\n- Run the script.\n\nAbout this solution\n-------------------\n\nAutomatically create draft email replies to feedback from Google Forms. This\nsolution focuses on course feedback from students, but you can apply it to any\nuse case for which you receive feedback via Google Forms.\n\n### How it works\n\nThe script installs an event-driven trigger that runs each time a user submits a\nform. With each form submission, the script creates an email draft in Gmail. The\nemail is addressed to the person who submitted the form and includes the form\nresponses and a generic thank-you message. You can edit the email before you\nsend it.\n\n### Apps Script services\n\nThis solution uses the following services:\n\n- [Script service](/apps-script/reference/script)--Installs the event-driven trigger that fires when someone submits a form.\n- [Spreadsheet service](/apps-script/reference/spreadsheet)--Sends the form responses to Gmail.\n- [Gmail service](/apps-script/reference/gmail)--Creates the email draft with the thank-you message and form responses.\n\nPrerequisites\n-------------\n\nTo use this sample, you need the following prerequisites:\n\n- A Google Account (Google Workspace accounts might require administrator approval).\n- A web browser with access to the internet.\n\nSet up the script\n-----------------\n\nClick the following button to make a copy of the **Respond to feedback** sample\nspreadsheet. The Apps Script project for this\nsolution is attached to the spreadsheet.\n\n[Make a copy](https://docs.google.com/spreadsheets/d/18cHBZp8iCICnoqECeSqMWbem3XJdIQnLd9xyVEAI1JM/copy)\n\nRun the script\n--------------\n\n1. Click **Form reply tool** \\\u003e **Enable auto draft replies**. You might need to refresh the page for this custom menu to appear.\n2. When prompted, authorize the script.\n If the OAuth consent screen displays the warning, **This app isn't verified** ,\n continue by selecting **Advanced** \\\u003e\n **Go to {Project Name} (unsafe)**.\n\n3. Click **Form reply tool** \\\u003e **Enable auto\n draft replies** again.\n\n4. Click **Tools** \\\u003e **Manage form**\n \\\u003e **Go to live form**.\n\n5. Fill out the form and click **Submit**.\n\n6. Open Gmail and check your drafts. You should have a new draft\n with the form\n response.\n\nReview the code\n---------------\n\nTo review the Apps Script code for this solution, click\n**View source code** below: \n\n#### View source code\n\n### Code.gs\n\n\u003cbr /\u003e\n\nsolutions/automations/course-feedback-response/Code.js \n[View on GitHub](https://github.com/googleworkspace/apps-script-samples/blob/main/solutions/automations/course-feedback-response/Code.js) \n\n```javascript\n// To learn how to use this script, refer to the documentation:\n// https://developers.google.com/apps-script/samples/automations/course-feedback-response\n\n/*\nCopyright 2022 Google LLC\n\nLicensed under the Apache License, Version 2.0 (the \"License\");\nyou may not use this file except in compliance with the License.\nYou may obtain a copy of the License at\n\n https://www.apache.org/licenses/LICENSE-2.0\n\nUnless required by applicable law or agreed to in writing, software\ndistributed under the License is distributed on an \"AS IS\" BASIS,\nWITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\nSee the License for the specific language governing permissions and\nlimitations under the License.\n*/\n\n/**\n * Creates custom menu for user to run scripts.\n */\nfunction onOpen() {\n let ui = SpreadsheetApp.getUi();\n ui.createMenu('Form Reply Tool')\n .addItem('Enable auto draft replies', 'installTrigger')\n .addToUi();\n}\n\n/**\n * Installs a trigger on the Spreadsheet for when a Form response is submitted.\n */\nfunction installTrigger() {\n ScriptApp.newTrigger('onFormSubmit')\n .forSpreadsheet(SpreadsheetApp.getActive())\n .onFormSubmit()\n .create();\n}\n\n/**\n * Creates a draft email for every response on a form\n *\n * @param {Object} event - Form submit event\n */\nfunction onFormSubmit(e) {\n let responses = e.namedValues;\n\n // parse form response data\n let timestamp = responses.Timestamp[0];\n let email = responses['Email address'][0].trim();\n\n // create email body\n let emailBody = createEmailBody(responses);\n\n // create draft email\n createDraft(timestamp, email, emailBody);\n}\n\n/**\n * Creates email body and includes feedback from Google Form.\n *\n * @param {string} responses - The form response data\n * @return {string} - The email body as an HTML string\n */\nfunction createEmailBody(responses) {\n // parse form response data\n let name = responses.Name[0].trim();\n let industry = responses['What industry do you work in?'][0];\n let source = responses['How did you find out about this course?'][0];\n let rating = responses['On a scale of 1 - 5 how would you rate this course?'][0];\n let productFeedback = responses['What could be different to make it a 5 rating?'][0];\n let otherFeedback = responses['Any other feedback?'][0];\n\n // create email body\n let htmlBody = 'Hi ' + name + ',\u003cbr\u003e\u003cbr\u003e' +\n 'Thanks for responding to our course feedback questionnaire.\u003cbr\u003e\u003cbr\u003e' +\n 'It\\'s really useful to us to help improve this course.\u003cbr\u003e\u003cbr\u003e' +\n 'Have a great day!\u003cbr\u003e\u003cbr\u003e' +\n 'Thanks,\u003cbr\u003e' +\n 'Course Team\u003cbr\u003e\u003cbr\u003e' +\n '****************************************************************\u003cbr\u003e\u003cbr\u003e' +\n '\u003ci\u003eYour feedback:\u003cbr\u003e\u003cbr\u003e' +\n 'What industry do you work in?\u003cbr\u003e\u003cbr\u003e' +\n industry + '\u003cbr\u003e\u003cbr\u003e' +\n 'How did you find out about this course?\u003cbr\u003e\u003cbr\u003e' +\n source + '\u003cbr\u003e\u003cbr\u003e' +\n 'On a scale of 1 - 5 how would you rate this course?\u003cbr\u003e\u003cbr\u003e' +\n rating + '\u003cbr\u003e\u003cbr\u003e' +\n 'What could be different to make it a 5 rating?\u003cbr\u003e\u003cbr\u003e' +\n productFeedback + '\u003cbr\u003e\u003cbr\u003e' +\n 'Any other feedback?\u003cbr\u003e\u003cbr\u003e' +\n otherFeedback + '\u003cbr\u003e\u003cbr\u003e\u003c/i\u003e';\n\n return htmlBody;\n}\n\n/**\n * Create a draft email with the feedback\n *\n * @param {string} timestamp Timestamp for the form response\n * @param {string} email Email address from the form response\n * @param {string} emailBody The email body as an HTML string\n */\nfunction createDraft(timestamp, email, emailBody) {\n console.log('draft email create process started');\n\n // create subject line\n let subjectLine = 'Thanks for your course feedback! ' + timestamp;\n\n // create draft email\n GmailApp.createDraft(\n email,\n subjectLine,\n '',\n {\n htmlBody: emailBody,\n }\n );\n}\n```\n\n\u003cbr /\u003e\n\n\u003cbr /\u003e\n\nContributors\n------------\n\nThis sample was created by Ben Collins, Educator at [benlcollins.com](https://www.benlcollins.com/)\nand Google Developer Expert.\n\n- Find Ben on Twitter [@benlcollins](https://twitter.com/benlcollins).\n- Read Ben's [blog](https://www.benlcollins.com/).\n\nThis sample is maintained by Google with the help of Google Developer Experts.\n\nNext steps\n----------\n\n- [Event-driven triggers](/apps-script/guides/triggers/installable#event-driven_triggers)\n- [Custom menus in Google Workspace](/apps-script/guides/menus)"]]
