Need help finalizing a scenario - lost in the weeds

Help Needed:Customer Support Automation (AI + 3-Day Follow-Up)

Context:

I’m building a **customer support automation system It’s designed to:

  • Automatically process incoming support emails
  • Use OpenAI to analyse, summarise, and reply
  • Log each case to a Google Sheet
  • Notify our team via Google Chat
  • Then — follow up with any unresolved tickets after 3 days

Main Scenario: Customer Support (Triggered by New Emails)

  • Trigger: Watch Emails
  • Get full message details
  • Use OpenAI to:
    • Classify the enquiry
    • Extract order number
    • Summarise the issue
    • Write a polite response in Australian English
  • Save the AI response
  • Parse the JSON result
  • Send the customer reply via Gmail
  • Log to Google Sheets
  • Notify internal team via Google Chat

Follow-Up Flow: 3 Days Later

  • Runs daily on a schedule
  • Searches the support log (Google Sheets)
  • Finds tickets where:
    • Status = Open
    • Date is more than 3 days ago
  • Sends a friendly follow-up email
  • Updates the status to "Followed Up"

What’s Not Working

  • I have the modules built and a blueprint file, but it
    Customer_Support AI Cleaned.blueprint (1).json (249.1 KB)
    doesn’t import into Make
  • I believe the blueprint is not correctly formatted (even though it’s JSON).
  • I need the **complete scenario in a valid .blueprint file that Make accepts.
  • I also want to confirm the module connections and flow logic are correct.

:folded_hands: What I Need Help With

  1. A clean working version of the full scenario in .blueprint format:
    Includes both the main support flow and 3-day follow-up
    Is importable directly into Make.com
  2. Optional but helpful:
    review or correct column names used in Google Sheets
    Confirm how to structure the daily follow-up date comparison
    I can provide:

Screenshots
My exported .blueprint file
A copy of the sheet I’m using
The OpenAI prompt and formatting

Thanks in advance for any help — this automation is critical for scaling up our support and making sure no one gets left waiting.

Hello @Peter_Wolff, welcome to the make Hire a pro section , I would love to work with you on this, you can book a call Here to discuss the project requirements

Hi Peter,

I don’t see any attachments in your post but my first step would be to run your JSON blueprint through an online validator, and/or ask an AI (ChatGTP, Claude, Cursor) to review and correct the blueprint for you.

You can’t confirm if the module connections are correct from the blueprint alone, as these are unique to Make environment that blueprint is implemented in, and the connections that this environment has set up (it’s advisable to always run through all modules after implementing a blueprint to make sure everything is set correctly, especially the ones that use connections)

Column names in Google Sheets are not so relevant to your automation as columns are identified by position.
you could add a timestamp to each sheet/row entry and run a daily operation by reading sheet rows and take action when 3 days have passed.

Hope that helps

thanks for the reply duativ, I have used AI (open ai chatty G) have found it gets the scenario to run with out errors, however the output…basically parsing the customers email and composing a reply and it not happening, back to chatty g and more back and forth… so I am lost in the weeds now

Hi @Peter_Wolff

Being No.1 Platinum partner of Make and #1 for Make (as per the last report), we are happy to collaborate on delivering technical solutions using Make.

We have strong expertise by delivering solutions to 650+ clients across 20+ countries.

To discuss the next steps, feel free to book a slot from Calendly:

Calendly

Between, we also run training on Make and AI Automation with 200+ members helping to automate own business guided by engineers to solve your all Make queries in real time.

Hello @Peter_Wolff,

If you’re looking for someone with 2+ years of experience and certified expertise to solve this, I’d be happy to help. I’ve worked on similar automation projects using Make.com, Google Sheets, and OpenAI, and I’m confident I can help fine-tune the setup and get everything running smoothly.

Feel free to check out my services, and if you’d like, we can also connect on LinkedIn. I’d love to stay in touch and be a resource for you moving forward.

Looking forward to help you make this work seamlessly!

Hey Peter,
I’m a former Make.com employee and helped build some of the original templates that are still in use on the platform. I’m also a software developer with experience in automation, QA, and integrating OpenAI, Gmail, Google Sheets, and more through Make.

I’d be happy to take a look at your blueprint file and help clean it up for import, validate the flow logic, and assist with the follow-up automation.

Feel free to reach out or check my Linkedin

This topic was automatically closed after 30 days. New replies are no longer allowed.