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/121...
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-dire...
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
Watch video Unlock AI Power: Intro to Auto-Completion online, duration hours minute second in high quality that is uploaded to the channel Make 21 June 2024. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 3,626 times and liked it 57 visitors.