[
    {
        "label": "Maintain a list of order fulfillment quantities on google sheet",
        "trigger_type": [
            "order_created",
            "order_updated"
        ],
        "object_type": "order",
        "app_id": "triggers",
        "settings": {
            "priority": 50,
            "condition_groups": {
                "1": {
                    "conditions": [],
                    "actions": {
                        "1": {
                            "type": "google_sheets_v2",
                            "settings": {
                                "wait": "0",
                                "custom_wait": "",
                                "url": "[CLICK TO EDIT]",
                                "title": null,
                                "settings": {
                                    "tab": "0",
                                    "update_mode": "update",
                                    "primary_key": ""
                                },
                                "cells": [
                                    {
                                        "weight": "0",
                                        "value": "{{ order.name }}"
                                    },
                                    {
                                        "weight": "1",
                                        "value": "{{ order.customer.first_name }}"
                                    },
                                    {
                                        "weight": "2",
                                        "value": "{{ order.customer.last_name }}"
                                    },
                                    {
                                        "weight": "3",
                                        "value": "{{ order.customer.email }}"
                                    },
                                    {
                                        "weight": "4",
                                        "value": "{% for line_item in order.line_items %}\r\n  {{ line_item.title }} x {{line_item.fulfillable_quantity }}\r\n{% endfor %}\r\n"
                                    }
                                ],
                                "token_object_type": "order"
                            },
                            "weight": 999,
                            "target_key": "order"
                        }
                    }
                }
            },
            "shared_workflow_id": 46039
        },
        "description": "This workflows exports a list of order line items and their fulfillable quantities. When the order is fulfilled, it adjusts the quantities to reflect, the remaining unfulilled quantities. "
    }
]