Make.com + Google Sheets Automation Tutorial: Build Real Workflows Fast

Make.com + Google Sheets Automation Tutorial

Google Sheets is the most widely used database in small business. Nearly every client you work with stores important data in a spreadsheet — leads, contacts, inventory, appointments. Make.com connects that spreadsheet to the rest of the world. This tutorial shows you exactly how.

Why This Combination Is So Powerful

Google Sheets provides the accessible, familiar interface. Make.com provides the automation logic. Together they enable non-technical business owners to see their data, manage it manually when needed, and let automation handle everything else.

Use cases this combination unlocks:

• Sheet row added → Send SMS to new lead
• Form submitted → Append row + notify team
• Scheduled trigger → Read all rows + send batch emails
• Status column changed → Trigger action in another app
• External API data → Write results to sheet

Setting Up the Connection

Step 1: Connect Google Sheets to Make.com

1. Create a new scenario in Make.com
2. Add a Google Sheets module
3. Click "Create a connection"
4. Sign in with the Google account that owns the spreadsheet
5. Grant Make.com the required permissions

Your connection is now stored in Make.com credentials. Every subsequent Google Sheets module in any scenario can use this same connection.

Step 2: Identify Your Sheet ID

The Sheet ID appears in the spreadsheet URL: https://docs.google.com/spreadsheets/d/[SHEET_ID]/edit

Copy this value — you will use it to reference the sheet in Make.com.

Core Modules You Need to Know

Want to build this yourself? NURO University walks you through it step by step. Start free →

Workflow 1: New Lead Notification

Use case: Sales team wants an instant SMS when a new lead is added to a spreadsheet (via a form or manual entry).

Trigger: Google Sheets — Watch New Rows (Leads sheet)

Steps:

1. Filter: only process if Status column = "New"
2. Twilio: Send SMS to sales rep's phone: "New lead: {{Name}} | {{Phone}} | {{Interest}}"
3. Google Sheets: Update the row — set Status to "Notified"

Build time: 15 minutes

Workflow 2: Bulk Email Campaign from Sheet

Use case: Send a personalized email to everyone in a spreadsheet (newsletter, promo, outreach list).

Trigger: Make.com Schedule (manual or time-based)

Steps:

1. Google Sheets: Search Rows (filter: Email Sent = FALSE)
2. Iterator: Process each row individually
3. Gmail: Send personalized email using row data (Name, Company, custom message)
4. Google Sheets: Update row — set Email Sent = TRUE, Sent Date = today

Important: Add a "Sleep" module (1-2 second delay) between iterations to respect Gmail sending limits.

Build time: 30-45 minutes

Workflow 3: Appointment Reminder from Calendar Sheet

Use case: A simple appointment tracker in Google Sheets — send SMS reminders automatically.

Trigger: Make.com Schedule — runs daily at 7 AM

Steps:

1. Google Sheets: Search Rows — filter where Appointment Date = tomorrow AND Reminder Sent = FALSE
2. Iterator: Process each appointment row
3. Twilio: Send reminder SMS: "Reminder: Your appointment at [Business] is tomorrow at {{Time}}. Reply CONFIRM or RESCHEDULE."
4. Google Sheets: Update row — set Reminder Sent = TRUE

Build time: 45 minutes

Workflow 4: Form → Sheet → CRM + Email

Use case: Website contact form → Google Sheet log + CRM contact + welcome email, all automatically.

Trigger: Webhook (form submission)

Steps:

1. Google Sheets: Add Row (log the lead)
2. HubSpot/GoHighLevel: Create Contact
3. Gmail: Send welcome email
4. Google Sheets: Update Row — add CRM ID, set Status = "Processed"

Build time: 30 minutes

Workflow 5: Weekly Report Generation

Use case: Every Monday morning, summarize last week's leads/sales data from the sheet and email it to the owner.

Trigger: Make.com Schedule (Monday 8 AM)

Steps:

1. Google Sheets: Search Rows — filter by last week's date range
2. Tools (Aggregator): Sum revenue, count leads, count conversions
3. Text Parser: Build email template with aggregated numbers
4. Gmail: Send report to owner

Build time: 1-2 hours (mostly in the aggregation and template steps)

Common Issues and Fixes

Ready to Build Your AI Automation Business?

Stop reading about AI automation — start building it. NURO University gives you the exact frameworks, templates, and step-by-step training to land your first client and scale to $10K/month.

Join NURO University Free →

No tech background required. Start seeing results in your first 30 days.