🧠 Beginner’s Guide: Automate Google Forms with Make.com

Ever wanted to make Google Forms work smarter—not harder?

In this beginner-friendly guide, I’ll show you how to automate form responses using Make.com (formerly Integromat).

✅ No coding required
✅ Fully visual setup
✅ Perfect for solopreneurs, admins, or anyone tired of copy-pasting

By the end, you’ll know how to:

• Create a Google Form

• Automatically send responses to your email

• Log every response in a Google Sheet

Let’s build your first automation.

🛠️ Step 1: Set Up Your Google Form

1. Go to Google Forms and create a new form.

2. Add sample questions:

   • Name (Short answer)

   • Email (Short answer)

   • Message (Paragraph)

3. Click Send to get the link (no need to share yet).

📊 Step 2: Prepare Your Google Sheet

1. Open Google Sheets and create a new spreadsheet.

2. In Row 1, add headers that match your form fields exactly:

   • Name

   • Email

   • Message

🌐 Step 3: Sign Up at Make.com

1. Go to Make.com and create a free account.

2. Once inside, click Create a new scenario.

🔌 Step 4: Connect Google Forms to Make

1. In the scenario builder, click the big + button.

2. Search for Google Forms. Here is a detailed guide on how to connect your Google account to access your new form (Full Google Form Connection Guide)

3. Choose Watch Responses as your trigger.

4. If prompted, connect your Google account.

5. For Form ID:

   • Open your form

   • Copy the long string in the URL between /d/ and /edit

   • Paste it into Make

6. Set Limit to 1 (so it grabs one response at a time).

📥 Step 5: Add Google Sheets to the Scenario

1. Click the next + button.

2. Search for Google Sheets and choose Add a Row.

3. Connect your Google account if asked.

4. For Spreadsheet ID:

   • Copy it from your Sheet’s URL (between /d/ and /edit)

5. Choose your Sheet Name (usually “Sheet1” unless renamed).

6. Map fields: Match each form field to a column in your sheet using the drag-and-drop UI.

📧 Step 6: Set Up Email Notifications

1. Click the next + button again.

2. Search for Email or Gmail.

3. Set up your connection. Detailed guide here

4. Choose Send an Email.

5. Fill in:

   • To: Your email

   • Subject: e.g., “New Google Form Submission”

   • Body: Use the form fields to build your message like:

     yaml

     CopyEdit

     New submission:
Name: {{Name}}
Email: {{Email}}
Message: {{Message}}


🧪 Step 7: Test It Out

1. Click Run Once in the bottom left of your scenario.

2. Fill out your Google Form with sample data.

3. Check:

   • Your Google Sheet: New row added? ✅

   • Your Email inbox: Notification received? ✅

✅ Step 8: Turn It On

If the test worked:

1. Click the ON switch (top-right) to activate your scenario.

2. Done! Your automation now runs quietly in the background. ⏰

🧩 What You Just Built

🎉 Final Thoughts

This is just the tip of the iceberg with Make.com.

Now that you’ve connected your first tools, you can:

• Send Slack or SMS alerts

• Trigger CRM workflows

• Build more advanced sequences—all visually

Start small. Think big. Automate more.