Hi Steffy! I’ll go over my set up below – still new and learning too, but this is what I’ve got!
- First, Etsy’s had a weird bug lately where personalization info isn’t always included, because the customer doesn’t have the option available when they order. (Maybe you had those “order placed on a platform where personalization is not supported” gray banners on your order page a week or two ago – but only on certain orders??) IDK what circumstances mean customers can’t add personalization (using older versions of the app, maybe?)
- Etsy stopped posting those banners, but you can still see where personalization is sometimes missing, meaning the customer didn’t have the option to add it when they ordered(?):
That explains why you’re not getting personalization info on some receipts… You’ll see that some Receipts on Make will only have 2 variations listed; those will correspond to your Etsy order page, where the personalization option is also missing:
Here’s my setup for adding order item info to Google Sheets:
-
Iterator for Transactions (For orders with multiple items, it ensures you get the variation info for each individual item.) …ignore my router-to-nowhere.
-
Array Aggregator to map the info to the corresponding columns in your google sheets,
-
Google Sheets Bulk Add Rows adds a row for each item in an order; orders with multiple items would then have multiple rows. Also, adds all rows at once so it only uses one operation
Here’s my Array Aggregator setup, and how to map the variations. You can mix and match info from both the Receipts module (orange) and the iterator (green) to map other information to your google sheet.
I use the Receipts module for “high-level” info that applies to the whole order (buyer name, order number, shipping etc.), and the iterator for extracting info on individual items in that order (size, quantity, variations, etc.)
I added a “bonus” formula for variation 3 (in “column 8”, below); that way, if no personalization is requested, it just leaves the cell empty:
I also took into account “Message from Buyer”, (orange, from receipts module.) That catches any requests a customer made NOT using the personalization box. (Side note: the “Message from Buyer” will not return any messages from your Etsy inbox, only notes that a customer includes when they order.) I rarely get them, but sometimes it happens and I would miss the personalization request otherwise:
Hopefully this helps!! Depending on the info you need to track, you may want a set up like the one above to break orders all the way down into individual items (useful for keeping inventory, tracking personalizations, costs per item, etc.) Then have a separate/related “high-level” sheet that tracks whole orders (useful for finances, shipping costs per order, fees, etc.) In that case, you can skip the iterator, and just map your high-level info directly from the Receipts module to the array aggregator.
…NOW, if only anyone could figure out how to get Etsy’s “Submit Tracking Info” module to work (it’s giving me an “unauthorized” error), and/or somehow fix the random rate limiting errors! 
