Lorixen.
EN

Google Forms to Google Sheets With Email Alerts: A Free Enquiry Pipeline

Short answer: Link your Google Form to a response spreadsheet from the form's Responses tab, then switch on "Get email notifications for new responses" so someone is told every time a request arrives. Add Status, Owner and Next step columns to the sheet with dropdown validation, so each enquiry is visibly claimed and closed. If the built-in notification is too bare, because it does not show the answers, a short Apps Script with an "on form submit" trigger can email the full details to a shared inbox. This setup costs nothing and works well for a few dozen enquiries a week; beyond that, or when several teams need reminders and history, a form tool or CRM is the next step.

The pipeline in one picture

A visitor fills in the form, the answer lands as a new row in the sheet, an email goes to the person on duty, and the team updates the row until the enquiry is closed. Picture a small print shop taking quote requests: the form asks for name, contact, product, quantity and deadline, and the sheet becomes its quote board.

Step 1: Build the form with the fields you actually need

Keep the form short. Each extra question loses some visitors.

  • Name (short answer, required)
  • Email (short answer with response validation set to "email", required)
  • Phone (optional)
  • What do you need? (dropdown with your main services)
  • Details (paragraph)
  • Deadline (date, optional)

In Settings > Responses, decide whether to collect email addresses automatically. For public enquiry forms, turning off "Restrict to users in your organisation" is essential if you use a Workspace account, otherwise outsiders cannot submit.

  1. Open the form's Responses tab.
  2. Click Link to Sheets.
  3. Choose Create a new spreadsheet and name it, for example "Quote requests".
  4. Open the sheet. You will see a tab called "Form responses 1" with a Timestamp column and one column per question.

Google describes the options, including linking to an existing spreadsheet, in its help article on where to save form responses.

Do not rename or reorder the question columns in the responses tab. If you rearrange things, the form may start writing to different columns.

Step 3: Switch on the built-in email alert

  1. In the form's Responses tab, click the three-dot menu.
  2. Choose Get email notifications for new responses.

The notification goes to the form owner's email and says that a response arrived, with a link. It does not include the answers, and it only reaches the account that turned it on. Each colleague who wants alerts can turn it on in their own account if they have edit access to the form.

Step 4: Add tracking columns

To the right of the last question column in the response tab, add:

Column Type Example values
Status Dropdown New, Contacted, Quote sent, Won, Lost
Owner Dropdown Sam, Leila, Tom
Next step Text "Call back Thursday"
Next step date Date 2026-11-24
Notes Text Price discussed, waiting for artwork

To create the dropdowns, select the Status column (excluding the header), choose Data > Data validation, add a rule with Dropdown, and enter the options. Repeat for Owner.

Then make the sheet easier to scan:

  • Freeze the header row with View > Freeze > 1 row.
  • Conditional formatting: colour rows where Status is New in light yellow, and rows where Next step date is in the past in light red.
  • Filter view named "Open enquiries" that hides Won and Lost.

Step 5: A short Apps Script for richer emails

If you want the full enquiry in the email and sent to a shared address, use Apps Script.

  1. In the sheet, open Extensions > Apps Script.
  2. Replace the sample code with:
function sendEnquiryAlert(e) {
  const v = e.namedValues;
  const subject = 'New enquiry: ' + v['What do you need?'] + ' from ' + v['Name'];
  const body = Object.keys(v).map(k => k + ': ' + v[k]).join('\n');
  MailApp.sendEmail({
    to: 'quotes@example.com',
    subject: subject,
    body: body,
    replyTo: String(v['Email'])
  });
}
  1. Change the question names in square brackets to match your form exactly, and the address to your shared inbox.
  2. Click Triggers (the clock icon), Add trigger, choose sendEnquiryAlert, event source From spreadsheet, event type On form submit, and save.
  3. Approve the permissions prompt with the account that owns the sheet.
  4. Submit a test entry through the form.

The namedValues object is documented in Google's guide to Apps Script event objects. Setting replyTo means staff can reply straight to the customer from the alert. Apps Script has daily email quotas tied to the account type, which are generous for normal enquiry volumes.

Keeping it tidy

  • Weekly review: sort by Status and Next step date every Monday.
  • Do not delete rows. Mark spam as "Lost" or move it to an archive tab, so the form keeps writing to the right place.
  • Sharing: give staff edit access to the sheet but only the owner edit access to the form.
  • Personal data: the sheet holds names and contact details, so share it only with people who need it, and delete old enquiries on a schedule that fits your privacy notice.
  • Spam: if bots find the form, add a simple question that requires reading, or restrict how the link is shared.

When to move on

This pipeline starts to strain when:

  • several teams need their own queues and automatic assignment
  • you need reminders when an enquiry sits untouched
  • the same customer sends many requests and history matters
  • you want quotes and invoices linked to each enquiry
  • the sheet has thousands of rows and filters become slow

At that point, a form builder with routing, or a CRM that receives form submissions, keeps the same habits while adding history and automation.

FAQ

Why does the notification email not show the answers?

The built-in notification only tells you a response arrived. Use the Apps Script approach for full details.

Can the alert go to several people?

Put a comma-separated list in the script's "to" field, or send to a group address.

Will the script break if we edit the form?

If you rename a question, update the name in the script too.

Is this suitable for sensitive information?

Keep forms to basic contact details and avoid collecting health or financial data this way.

When your enquiries outgrow a spreadsheet, or you want the form wired into your website and CRM properly, send us a message and we will help you take the next step.

Sources

WhatsAppBook a call