[
    {
        "label": "When an order is paid, send basic order info to a Google Sheets spreadsheet",
        "trigger_type": [
            "order_paid"
        ],
        "object_type": "order",
        "app_id": "triggers",
        "settings": {
            "priority": 0,
            "condition_groups": [
                {
                    "conditions": [],
                    "actions": [
                        {
                            "type": "google_sheets",
                            "settings": {
                                "token_object_type": "order",
                                "url": "[CLICK TO EDIT]",
                                "tab": "",
                                "rows": "{{ order.name}}\r\n{{ order.admin_url }}\r\n{{ order.email}}\r\n{{ order.created_at}}\r\n{{ order.publication.name }}\r\n{{ order.financial_status }}\r\n{{ order.customer.accepts_marketing}}\r\n{{ order.subtotal_price_set.presentment_money.currency_code }}\r\n{{ order.subtotal_price}}\r\n{{ order.total_shipping_price_set.shop_money.amount }}\r\n{{ order.total_tax_set.shop_money.amount}}\r\n{{ order.total_price }}\r\n{{ order.discount_codes | map('code') | join(\", \") }}\r\n{{ order.total_discounts}}\r\n{{ order.shipping_lines | map('title') | join(\", \") }}\r\n{{ order.line_items | map('quantity') | join(\", \") }}\r\n{{ order.shipping_address.first_name}}\r\n{{ order.shipping_address.last_name }}\r\n{{ order.shipping_address.phone }}\r\n{{ order.shipping_address.address1 }}\r\n{{ order.shipping_address.address2 }}\r\n{{ order.shipping_address.city }}\r\n{{ order.shipping_address.company }}\r\n{{ order.shipping_address.province }}\r\n{{ order.shipping_address.zip }}\r\n{{ order.shipping_address.country }}",
                                "wait": "0",
                                "cw_timezone": "America\/New_York",
                                "custom_wait": ""
                            },
                            "weight": 999,
                            "target_key": null
                        }
                    ]
                }
            ],
            "shared_workflow_id": 24
        },
        "description": "This workflow fires when an order is paid. The workflow will send basic details about an order to a Google Sheet, using our \"Advanced\" Google Sheet action which allows for free-form coding in the action."
    }
]