Summary
Keywords
Full Transcript
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
