Unlock AI Power: Intro to Auto-Completion
דרג סרטון זה
התחבר כדי לדרג
תיאור
Boost your marketing campaigns with AI 🚀 In this video, we’ll show how to use OpenAI to auto-complete Google Sheets with capital cities for each country. Perfect for personalizing your marketing lists quickly and efficiently. Steps: 1. Create a new scenario on Make.com or *use this template* https://www.make.com/en/templates/12120-ai-tools-101-simple-auto-completion-with-openai-and-google-sheets 2. Add the Google Sheets module to retrieve your list. 3. Set the range of values to A1:C1000 and enable headers. Next, add the OpenAI module: - Select “Create a Chat Completion” with GPT-4. - Map the prompt to your country list to get each capital city. Finally, update your Google Sheet with the new data: - Add a second Google Sheets module to update rows. - Map the capital city to column B. Run your automation and watch the magic happen! 🪄 Automate tedious tasks and enhance productivity with Make.com and OpenAI. Don’t forget to like, share, and hit that subscribe button for more AI-powered automation hacks! 🔔 Enjoyed the video? LIKE & SUBSCRIBE so you can learn how to automate anything & everything with Make. ENTER OUR COMMUNITY: https://community.make.com/ CONTINUE LEARNING HERE: https://academy.make.com/ GET TO KNOW OUR PARTNER DIRECTORY: https://www.make.com/en/partners-directory Make is a no-code, visual integration platform that lets you connect any apps or APIs to automate and optimize workflows. Create your free account today to start automating your work. 00:00:00 Introduction to OpenAI and Workflow Automation 00:00:04 Setting Up OpenAI Connection 00:00:33 Google Sheets Integration 00:01:02 Connecting Google Sheets to Workflow 00:01:31 Selecting Spreadsheet and Values 00:02:55 Testing Google Sheets Module 00:03:14 Adding OpenAI Module 00:04:01 Prompt Creation for Capital Cities 00:05:26 Updating Google Sheets with OpenAI Results 00:07:21 Recap: Completing the AI Workflow