Free lesson · Make: no-code automation · about 40 minutes

Every enquiry — in a sheet and in your inbox

You will connect a Google Form, Google Sheets and email in one Make scenario.

Materials language: Bulgarian. The software menus are in English, and the lessons show where everything is.

You need

The exercise is designed for the software's free plan.

The form and the sheet
Make a Google Form with the fields Name, Phone, Service, Message. In “Responses” click “Link to Sheets” — that gives you a sheet of responses.
Trigger
In Make: Create scenario → Google Sheets module “Watch New Rows” → choose the sheet and the responses tab. “Limit”: 10.
Filter and email
Add an Email → Send an email module (or Gmail). Put a filter between the two modules: continue only if “Phone” is not empty.
```
Subject: New enquiry: {{Service}} from {{Name}}
Body: Phone: {{Phone}}
Message: {{Message}}
```
Test and switch on
“Run once”, then fill in the form. Check the run history and the email that arrived. Switch the scenario on with a 15-minute schedule.

Send 3 enquiries: two with a phone number and one without.

Add a “Handled” column to the sheet and fill it in by hand after calling back.

Liked the lesson? See the whole course.