Ask Janek AI with Janek

All questions

Write Smart Emails and Send Order Updates Automatically in Make.com · published 22 July 2025

Play at 3:22 Watch on YouTube Email

How do I match an order attachment to the right customer in Make.com?

I ask the AI for only the customer name, find that name in the sheet without caring about capitals, and the row tells me the language, the email, and the order number.

The AI is told to output only the name, so I know which customer the file belongs to. Google Sheets searches for that name. I set the match to equal and case insensitive. A name in lowercase still hits. I leave the other search settings. If the name is Thomas, the row gives me Thomas’s email and the language the order was placed in, so the update is written in that language, plus the order number.

On the send module I map the order number again and the AI result. That result includes the tracking number taken from the Doc, which came from the PDF in the email. For this video I put my own address in the To field so the test arrives in my inbox. In a real run the address is the one from the sheet.