Email Automate your Sales Leads

 What is Make.com and why use it?

Make.com is a no‑code automation platform that lets you connect different apps like Google Forms, Gmail, Outlook, and AI services in a drag‑and‑drop interface. You build “scenarios” that listen for events in one app and trigger actions in others. Make provides ready‑made integrations for Google Forms, Gmail, generic Email, Outlook, and Gemini AI, which makes it ideal for this kind of automation.

When you combine Make.com with an AI model (Gemini or ChatGPT), you get the best of both worlds:

Make.com handles workflow logic—when to trigger, which email account to use, where to store data.

AI handles content generation—it writes the actual email text based on the form answers.

Let us define a simple, powerful use case:

When a student submits a Google Form to inquire about a course, the system sends a personalized, AI‑generated email from Gmail or Outlook within seconds.

The flow looks like this:

Trigger: A new response is submitted in Google Forms.

AI step: The answers are sent to Gemini or ChatGPT, which writes a custom reply.

Email step: The reply is emailed automatically via Gmail or Outlook.

This pattern can later be extended to other sources like Typeform, website forms, CRMs, or even Excel uploads.

Prerequisites

To follow the steps, you need:

A Make.com account (the free tier is usually enough for small experiments).

A Google Form that collects responses (ideally linked to a Google Sheet).

A Gmail account and/or Outlook/Microsoft 365 account for sending emails.

​An AI provider:

Gemini via Google AI Studio and the Gemini AI integration in Make.com, or

Note: Prepare the Google Form/Source Info in a proper Form in AI Understanding columns format

Step 1 – Connect Google Forms as the trigger

After logging in to Make.com, you first create a new scenario.

Click “Create a new scenario” in Make.com.

On the blank canvas, click the “+” icon and search for Google Forms.

Choose an event such as “Watch Responses” (or watch the linked Google Sheet if you prefer).

Connect your Google account, then select the correct form or sheet.

Run the scenario in “Run once” mode and submit a test response so Make.com can detect the structure.

At this point, the scenario can see every future form submission and access all its fields: name, email address, selected course, questions, and more.

Step 2 – Ask Gemini or ChatGPT to write the email

The real magic happens in the AI step. This is where the raw form data turns into a natural, human‑sounding email.

Using Gemini via Make.com

Make.com has a Google Gemini AI integration, which makes this easy.

​Add a second module after Google Forms and search for “Gemini AI”.

Pick an action like “Generate Content”.

Create a connection by pasting your API key from Google AI Studio.

In the prompt field, describe the email you want. For example:

“You are an assistant for an online training institute.

Write a friendly confirmation email to the student based on their form responses.

Include:

– a greeting with their name,

– a short summary of the course they selected,

– next steps (demo date, WhatsApp/Telegram group, payment or counseling link),

– a polite closing.

Student name: {{Name}}

Selected course: {{Course}}

Student question: {{Question}}”

Map the actual form fields (from the first module) into the placeholders.

When the scenario runs, Gemini will generate a complete email body based on real data.

​Step 3 – Send the email automatically

Now you need a module that actually sends the AI‑generated text via email.

Sending with Gmail

Add a third module and search for Gmail.

​Choose “Send an Email”.

Connect your Gmail account.

Map the fields:

To: use the email address from the Google Form.

Subject: something like “Thank you for your interest in our Oracle EPM Training”.

Body: insert the output from Gemini/ChatGPT.

Make.com tutorials on Google Forms–Gmail automation use exactly this pattern: input → generate content → send email.

​Sending with Outlook

If your organization prefers Outlook:

Choose the Microsoft 365 Email or Outlook module instead.

​Use “Create and Send a Message” or “Create Draft”.

Connect your Microsoft account.

Map the same fields (“To”, “Subject”, “Body”).

Creating drafts rather than sending immediately lets a human review AI‑generated text first. This “human‑in‑the‑loop” approach is common in production setups.

Step 4 – Test, monitor, and go live

Before switching it on for real students, you should test the entire flow.

Save the scenario and click “Run once”.

Submit a test form entry (use your email).

Watch each module’s logs in Make.com:

Does the Google Forms module show the new response?

Does Gemini/ChatGPT return a well‑structured email?

Does Gmail/Outlook successfully send or draft the message?

Adjust the AI prompt to fix style issues: too long, too short, too formal, wrong language, etc.

When satisfied, turn on scheduling so the scenario runs regularly (e.g., every 1 or 5 minutes).

From this point forward, your Google Form becomes a fully automated AI‑powered email system.