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=thalitamilan 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.