Notification (email) when forms submitted

Ask for Help
2

Not anything native to Glide or Google Sheets but you could write a script to do it. Sending the actual email is pretty easy. https://developers.google.com/apps-script/reference/mail

      MailApp.sendEmail({
        to: "youremail@whatever.com",
        subject: "New Form Added",
        body: "This is the body of the email."
      });

What you would do is set up a timed trigger that runs a function that checks for the additional row that a Form added. You would create a column that holds a true false, to indicate that an email has been sent or not. Jump to the last row and check that flag, and if it false, just send the email. Then change the flag cell to true. You could include anything in the email from that sheet row so you would have an idea of who filled out the form if you saved emails or other info.

3 Likes