Google Sheets Automation to Fix Messy Data! Make.com Tutorial

Описание: Messy data is killing your segmentation and campaigns. In this step-by-step tutorial, you’ll learn how to use AI + Make.com to automatically standardize fields (like US states, for example) the moment a new row hits your Google Sheet—then push the cleaned value back into the same row. Faster ops, cleaner lists, better targeting.

What you’ll learn:
• How to trigger an automation on new/updated rows in Google Sheets
• The exact AI prompt to standardize values (and return null on invalid inputs)
• Field mapping to update the correct row with the AI result
• How to test each module safely before going live

Useful links:
Make.com sign up https://www.make.com/en/register?pc=t...
OpenAi models https://platform.openai.com/docs/models

Timestamps:
0:00 Why data inconsistency costs you customers
0:39 Real example: “California” vs “CALI” vs “CA”
1:34 Solution overview: AI standardization workflow
1:59 Quick demo: AI fixes state names live
2:36 How the automation is structured (Sheets + Make.com)
3:11 Create a scenario & choose the trigger
4:16 Connect Google Sheets to Make.com (permissions)
5:21 Configure headers, ranges & fetch limits
6:21 Set the starting row and run logic
6:28 Pick your AI provider/model in Make.com
8:11 The exact prompt to standardize US states
9:29 Map fields: pass input and capture AI result
11:07 Test modules in isolation (debug like a pro)
13:16 End-to-end run: NJ → New Jersey
14:52 Scheduling: free vs paid run intervals
15:30 Wrap-up & next steps

If this saved you time (or headaches), drop a like, comment your next data-cleaning use case, and subscribe for more AI automations that compound your growth.