I cant figure out how to get a file that is submitted in a form to send as a email.

function onFormSubmit(e) {
  var responses = e.response.getItemResponses();
  var fileItem = responses[1]; // Assuming the file is the first response
  var responses = e.response.getItemResponses().map(item => item.getResponse());
  // Get the file response
  var uFile = fileItem.getResponse();

  // Email subject and body
  var subject = "New File Uploaded";
  var body = "A new file has been uploaded.\n\n";

  if (uFile) {
    // If a file is uploaded, include the file details in the email

    
    body += responses
  MailApp.sendEmail("[email protected]", subject, body,
    { attachments: uFile });
    Logger.log("File sent successfully!");
  } 
}

I have looked over a few forms to find anything but nope. So I come hoping some one can help.

I cant figure out how to get a file that is submitted in a form to send as a email.

function onFormSubmit(e) {
  var responses = e.response.getItemResponses();
  var fileItem = responses[1]; // Assuming the file is the first response
  var responses = e.response.getItemResponses().map(item => item.getResponse());
  // Get the file response
  var uFile = fileItem.getResponse();

  // Email subject and body
  var subject = "New File Uploaded";
  var body = "A new file has been uploaded.\n\n";

  if (uFile) {
    // If a file is uploaded, include the file details in the email

    
    body += responses
  MailApp.sendEmail("[email protected]", subject, body,
    { attachments: uFile });
    Logger.log("File sent successfully!");
  } 
}

I have looked over a few forms to find anything but nope. So I come hoping some one can help.

• google-apps-script
• triggers
• google-forms

Share Improve this question Follow edited Nov 16, 2024 at 13:09 Wicket 38.8k99 gold badges8080 silver badges195195 bronze badges asked Nov 16, 2024 at 10:00 user27821343user27821343 111 silver badge11 bronze badge

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 4

The attachments property of the options object of MailApp.sendEmail should be an array of Interface BlobSource objects.

The example below works for a Google Form with File Upload as the first question.

function formSubmitHandler(e) {
    const formResponse = e.response;
    // Response to the first question
    const itemResponse = formResponse.getItemResponses()[0];
    if(itemResponse.getItem().getType() === FormApp.ItemType.FILE_UPLOAD){        
        const file = DriveApp.getFileById(itemResponse.getResponse());
        const recipient = "Please provide an email address here";
        const subject = "Demo sending file uploded as attachmet";
        const body = "Please checkout the attachment";
        MailApp.sendEmail(recipient, subject, body, {attachments: [file]});
        Logger.log("Email sent");
    } else {
        Logger.log("Email was not sent");
    }
}

Please note that the above code should be added to the Apps Script project bound to a Form, and an installable trigger should be created.

References

1. MailApp.sendEmail(recipient, subject, body, options)
2. https://developers.google/apps-script/guides/triggers/installable
3. https://developers.google/apps-script/guides/triggers/events

Sending Email on Form Submit Using GmailApp

A modified version of the script which would be for the form it can handle multiple questions and that answers would attach in your code: body += responses.

I opted to use GmailApp for the reason for the future if OP wants to use it for managing emails, especially if you plan to work with features like threads, labels, and more.

Code.gs

function onFormSubmit(e) {

  var response = e.response;
  var itemResponses = response.getItemResponses();
  var responses = itemResponses.map(item => item.getResponse().concat("\n"));
  responses.shift()
  var file = itemResponses[0].getResponse();  // returns the file id

  var subject = "New File Uploaded";
  var body = "A new file has been uploaded.\n\n";

  if (file) {
    body += responses.toString().replace(",","");
    GmailApp.sendEmail("[email protected]", subject, body, { attachments: [DriveApp.getFileById(file)] });
    Logger.log("File sent successfully!");
  }
}

Sample Output:

Sample Form:

References:

Installable Triggers