Receive An Email Notification When a New Online Form is Submitted

My team is trying to receive an email when a new design request form is submitted through our web form.

Can someone help us out? I have no idea how to do this. We want to receive an email notification every time a "new form" is submitted, not every time a column is updated.

If possible. Could someone outline the steps I need to take to do this? with photos if it is not too much to ask.

Thank you all.

Find more posts tagged with

Accepted answers

Katy H

@Nazzir S

You would accomplish this with a workflow.

Click to create a new automation from scratch:
Change Trigger to "When rows are added", you can also change column-based triggers if for instance you only want to send a notification if a certain field has been filled out.
Then change notification to alert whoever needs to receive the alert, I updated to notify everyone shared to the sheet, but this could be changed to an email address or to a contact column.

Screen Shot 2022-04-14 at 11.14.03 AM.png

Screen Shot 2022-04-14 at 11.14.41 AM.png

Screen Shot 2022-04-14 at 11.15.18 AM.png

All comments

Katy H

@Nazzir S

You would accomplish this with a workflow.

Click to create a new automation from scratch:
Change Trigger to "When rows are added", you can also change column-based triggers if for instance you only want to send a notification if a certain field has been filled out.
Then change notification to alert whoever needs to receive the alert, I updated to notify everyone shared to the sheet, but this could be changed to an email address or to a contact column.

Nazzir S

@Katy H THANK YOU SO MUCH!

This is amazing; it worked like a charm!

David G

How about only sending it to the email listed on the form? i.e. I enter the email address of the recipient I want to receive it.

Katy H

@David G then you would need to select the notification to be sent to a contact column and then choose the contact column for the person that filled out the form, either collected as a system column or as a contact column the person completing the form would fill out.

If you decide to use the system-generated column, you would need to require people to log in to access the form.

Tuhina Mukherjee

This was helpful

SBuhrman

I have the same issue and tried this, but I still get alert emails when I copy/paste an existing row. The only thing I can do is uncheck the hidden column before copying/pasting the row. Is there an easier way?

Mattisphere

@SBuhrman You could add a checkbox field called something like "New Form Submission". Add that to the form as a hidden field and checked by default. Then add a condition to the workflow example above that only runs if the "New Form Submission" field is checked. Lastly, add at the end of the workflow to uncheck the "New Form Submission" field. That way when you copy and paste the row in the future it won't trigger the notification.

Shayne_Grant

Is there anyway you can add a default email to bottom of the form? So you can receive a copy of every request.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.