[ { "label": "Export Daily Sales to Google Sheet", "trigger_type": [ "order_created" ], "object_type": "order", "app_id": "triggers", "tags": [], "settings": { "priority": 0, "condition_groups": { "1": { "conditions": [], "actions": { "1": { "type": "trigger_child_workflow", "settings": { "target_path": "order.line_items", "exported_workflow": { "label": "Line Item subworkflow", "trigger_type": [ "manual" ], "object_type": "line_item", "app_id": "triggers", "tags": [], "settings": { "priority": 0, "condition_groups": { "1": { "conditions": [], "actions": { "4": { "type": "step", "settings": [], "weight": -10, "target_key": null }, "3": { "type": "debug", "settings": { "wait": "0", "custom_wait": "", "action_label": "", "title": "", "body": "{% set day_val = \"sold_\"~'now'|date('Ymd') %}\r\n{% set oldval = line_item.variant.database[day_val] %}\r\n{% set val =line_item.quantity|plus(oldval) %}\r\nNew Qty: {{val}}", "token_object_type": "line_item" }, "weight": 10, "target_key": "line_item" }, "2": { "type": "database_key_value", "settings": { "wait": "0", "custom_wait": "", "resource_type": "variants", "resource_id": "{{ line_item.variant_id }}", "key": "sold_{{'now'|date('Ymd')}}", "value": "{% set day_val = \"sold_\"~'now'|date('Ymd') %}\r\n{% set oldval = line_item.variant.database[day_val] %}\r\n{% set val =line_item.quantity|plus(oldval) %}\r\n{{val}}", "token_object_type": "line_item" }, "weight": 20, "target_key": "line_item" }, "5": { "type": "step", "settings": [], "weight": 29, "target_key": null }, "1": { "type": "google_sheets_v2", "settings": { "wait": "0", "custom_wait": "", "url": "https:\/\/docs.google.com\/spreadsheets\/d\/1mJRFXSoU3NLOOGKs1I4lGRvrjn1uC9hg5tRTYy9HAAA\/edit?usp=sharing", "title": "Untitled spreadsheet", "settings": { "tab": "0", "update_mode": "update", "primary_key": "" }, "cells": [ { "weight": "0", "value": "{{ line_item.title }}" }, { "weight": "1", "value": "{% set day_val = \"sold_\"~'now'|date('Ymd') %}\r\n{% set oldval = line_item.variant.database[day_val] %}\r\n{{oldval}}" } ], "token_object_type": "line_item" }, "weight": 30, "target_key": "line_item" } } } } } } }, "weight": 999, "target_key": "order" } } } }, "shared_workflow_id": 29438 } } ]