Make.com Automation Step by Step Tutorial for Beginners

Overview

This guide follows the exact steps shown in the YouTube video "Make.com Automation Step by Step Tutorial for Beginners". It teaches how to:

1. Sign up for a free Make.com account.
2. Navigate the dashboard and understand key sections.
3. Create a new scenario that triggers on a Google Forms response.
4. Connect Google Forms and Google Sheets.
5. Map form data to spreadsheet columns.
6. Test and activate the scenario.

Prerequisites

• A Google account with access to Google Forms and Google Sheets.
• A Make.com account (free plan is sufficient for this tutorial).
• Basic familiarity with Google Forms.

Step‑by‑Step Instructions

1. Create a Make.com Account

1. Go to Make.com and click Sign up.
2. Enter your email, password, and click Create account.
3. Verify your email if prompted.
4. You will land on the main dashboard.

2. Explore the Dashboard

• On the left sidebar you’ll see options: Scenarios, Templates, Connections, Help, etc.
• The Scenarios tab is where you build automations.

3. Create a New Scenario

1. Click Scenarios → Create a new scenario.
2. In the scenario editor, click the large + icon in the center to add a trigger.

4. Add a Google Forms Trigger

1. Search for Google Forms and select it.
2. Choose the action Watch responses (trigger when a new response is received).
3. Click Add to create a new connection or select an existing one.
4. In the connection dialog, click Add to authorize Make to access your Google account.
5. After authorization, paste the Form ID (found in the form’s URL) into the Form ID field.
6. Set the Limit (e.g., 2 for testing) and click OK.

5. Add a Google Sheets Action

1. Click the + icon next to the trigger to add an action.
2. Search for Google Sheets and select it.
3. Choose Add a row.
4. Authorize the Google Sheets connection if prompted.
5. Select the target spreadsheet and sheet.
6. Map each column:
   • Click the field next to a column name.
   • In the popup, choose the corresponding form response field (e.g., Email, Name, Address).

6. Test the Scenario

1. In Google Forms, submit a test response.
2. Back in Make, click Run once at the bottom left.
3. Watch the execution progress; each module will show a green check when successful.
4. Verify that the new row appears in Google Sheets.

7. Activate the Scenario

1. Toggle the Scheduling switch to ON.
2. Set the interval (default 15 min) or leave as is.
3. Click Save or Activate.

Tips & Gotchas

• Free plan limit: 1,000 operations/month. Each trigger run counts as one operation.
• Form ID: The string between /d/ and /edit in the form URL.
• Connection reuse: Once a Google account is connected, you can use it for multiple modules.
• Testing: Use the Run once button before activating to catch mapping errors.
• Error handling: For production scenarios, consider adding a Error handler module to log failures.
• Naming: Give your scenario a descriptive name (e.g., Form to Sheet).