Writing ad copy at scale can be a frustrating, time-consuming process — especially for large e-commerce brands or agencies handling multiple campaigns across platforms like Google Ads, Meta, and LinkedIn. At Clicktrust, we’ve been using Make.com (formerly Integromat) to automate ad copy generation using data from Google Sheets combined with AI-powered creativity via ChatGPT.
In this guide, we’ll show you exactly how to streamline your ad creation process and generate high-quality, tailored ads at scale using this powerful combination of Make.com, Google Sheets, and ChatGPT.
What is Make.com?
Make.com is an advanced automation platform — think of it as a more cost-effective and flexible alternative to Zapier. With over 10,000 integrations, Make.com allows you to connect tools like Google Sheets, Google Ads, and ChatGPT to create powerful automated workflows that save time and reduce manual work.
Why Automate Ad Copy Creation?
Creating ad copy manually for each product, offer, and campaign is tedious and prone to inconsistency. By automating the process, you can:
- Scale ad creation for e-commerce product feeds.
- Maintain consistent brand messaging across platforms.
- Save hours of manual work.
- Easily personalize ad copy based on product attributes, offers, and benefits.
- Improve collaboration between marketing teams and agencies.
Step-by-Step: Setting up Automated Ad Copy Creation
Step 1: Prepare Your Data in Google Sheets
Create a Google Sheet with columns like:
- Product Name
- Key Benefits
- Offer/Promotion
- Call-to-Action (CTA)
This sheet will act as the source data for generating ad copy.
Step 2: Set Up a New Scenario in Make.com
In Make.com, create a new scenario and choose Google Sheets as the first module. Configure it to search for rows in the sheet you prepared.
Step 3: Integrate ChatGPT for Ad Copy Generation
Once your data is flowing from Google Sheets, the next step is to feed it into ChatGPT via Make.com’s OpenAI module.
- Add a Create Completion step using the OpenAI integration.
- Use a prompt that tells ChatGPT to generate like the following:
Generate separate ads with FIFTEEN (15) Google Ads headlines (max 30 characters each) and FOUR descriptions (max 90 characters each) for each product. The tone should be professional yet approachable, emphasizing security, savings, and customer trust. Output the headlines in a single line, separated by commas, also include a comma after the last headline.Then, output the descriptions, also separated by commas. Avoid using commas in the descriptions. Just use points. No need to identify which are which, so avoid using ad headlines and descriptions in your output, simply the headlines and descriptions with commas are enough. Generate FIFTEEN (15) headlines and 4 descriptions for a Google Ads campaign. Format the response as structured JSON. (Provide an example of JSON structure as shown in the picture below, use ChatGPT to have a JSON format example generated)
- Ensure your output format is JSON to easily parse the results into individual fields later.
Step 4: Parse JSON Output
After ChatGPT generates the ad copy in JSON format, add a Parse JSON module in Make.com. This breaks the response into distinct fields like Headline 1, Headline 2, Description 1, and so on.
Step 5: Send Results Back to Google Sheets
Finally, add a Google Sheets – Add Row module to feed the generated copy back into your spreadsheet. This creates a centralized repository of AI-generated ad copy that can be reviewed, edited, and uploaded to your ad platforms.
Bonus Tip: Automate Email Notifications
For teams or agencies, you can add one more step to the scenario:
- Send the generated ads directly to your inbox or to your client for approval.
This creates a seamless, automated approval workflow — cutting down even more on manual back-and-forth.
Key Benefits of This Setup
- Generate high-quality, consistent ad copy in minutes.
- Adapt to any platform — Google, Meta, LinkedIn — with minor tweaks.
- Scale effortlessly as product catalogs and campaigns grow.
- Enhance collaboration between marketing teams and agencies.
- Reduce errors caused by manual input.
Final Thoughts
Make.com is an incredibly powerful automation tool, especially when paired with AI copy generation tools like ChatGPT. This workflow can be adapted to countless marketing use cases — from ad copy generation to email subject line writing, product description updates, and beyond.
At Clicktrust, we use this exact approach to help our clients save time, reduce costs, and scale their digital campaigns faster. Want us to help set up a similar automation for your business? Get in touch today — we’d love to help you unlock the power of automation and AI.
