Ask Janek AI with Janek

All questions

Collect Structured Data from Emails Using AI in Make.com · published 18 July 2025

Play at 1:41 Watch on YouTube Email

How do I save order details from a Gmail message into Google Sheets in Make?

I ask the AI to turn the whole email into JSON, parse that JSON, and add the fields to a Google Sheet.

A WooCommerce order email keeps the details inside the body. They are not separate fields. The AI gets the full content from the Gmail module and I ask for name, phone number, email, and order number, with an example of the JSON I want back. Parse JSON uses that string. The fields that come out are the same name, phone number, and email. Those are the ones I need. Google Sheets adds the row.

I run it on my own inbox, which has no orders, because I will not show a customer’s data. The sheet still gets a row, and phone, customer email, and order number are empty. Raising the maximum number of results brings in more emails in one run. I only use this for marketing if the customer agreed. The other use is order tracking. The message that goes back to the customer is How do I send an order update only when the email is actually an order?