AI for Data Enrichment: Automate Google Sheets with Make.com Tutorial

Struggling with incomplete contact data? In this video, you’ll learn how to use AI for data enrichment and automate your workflow inside Google Sheets with Make.com. Instead of spending hours manually filling in missing company descriptions or details, you’ll see how to set up an AI-powered automation that does it for you—step by step. This tutorial walks you through connecting Google Sheets, using Perplexity AI for accurate company descriptions, parsing results in JSON, and updating your spreadsheet automatically. Whether you’re in sales, marketing, or operations, this process will save you time, reduce costs, and help you scale smarter without expensive enrichment tools. Make.com signup https://www.make.com/en/register?pc=thalitamilan Read more about Perplexity models https://docs.perplexity.ai/getting-started/models Buy Perplexity credits https://docs.perplexity.ai/getting-started/pricing ⏱️ Timestamps: 00:00 – Introduction to AI for data enrichment 00:05 – Example: fictional contacts list in Google Sheets 00:18 – The missing company description problem 00:29 – Using AI automation for enrichment 00:39 – Tools: Google Sheets, Make.com & Perplexity 01:27 – Setting up the automation inside Make.com 01:49 – Trigger: new row added in Google Sheets 02:38 – Fetching company descriptions with Perplexity 03:28 – Why JSON output is essential for structured data 04:54 – Parsing JSON for clean spreadsheet mapping 07:00 – Updating rows in Google Sheets automatically 08:55 – Testing automation with Google and LinkedIn examples 11:40 – Logs & validation of the automation 13:00 – Adapting the process for different use cases 14:30 – Wrapping up and key takeaways