SQLite Web: app.db

id

Primary key. INTEGER

name

TEXT NOT NULL

description

TEXT

chatbot_id

INTEGER NOT NULL

trigger_type

TEXT NOT NULL

is_active

INTEGER (default 1

flow_data

{"nodes": [{"id": "trigger-1", "type": "trigger", "position": {"x": 251.5, "y": 99.5}, "data": {"label": "Form Submitted", "triggerType": "form_submission", "form_id": 1, "testResult": {"triggered_at": "2026-02-26T18:05:54.275193", "trigger_type": "form_submission", "name": "Test value", "email": "", "phone": "", "Phone": "", "body": "Sample message for testing.", "form_data": "{\"field_1771059625885\": \"Test value\", \"field_1771059732881\": \"Test value\", \"field_1771059775104\": \"Test value\", \"field_1771059785751\": \"2026-02-26\", \"field_1771059794160\": \"Test value\", \"field_1771059803951\": \"Sample message for testing.\", \"form_id\": 1, \"form_name\": \"Product Form\", \"submission_id\": 61, \"source\": \"test\", \"chatbot_id\": 38, \"name\": \"Test value\", \"body\": \"Sample message for testing.\", \"customer_name\": \"Test value\", \"customer_phone\": \"Test value\", \"message_volume\": \"Test value\", \"preferred_date\": \"2026-02-26\", \"preferred_time_slot\": \"Test value\", \"additional_notes\": \"Sample message for testing.\"}", "field_1771059625885": "Test value", "field_1771059732881": "Test value", "field_1771059775104": "Test value", "field_1771059785751": "2026-02-26", "field_1771059794160": "Test value", "field_1771059803951": "Sample message for testing.", "form_id": 1, "form_name": "Product Form", "submission_id": 61, "form_created_at": "2026-02-26T18:05:54.275193", "source": "test", "chatbot_id": 38, "customer_name": "Test value", "customer_phone": "Test value", "message_volume": "Test value", "preferred_date": "2026-02-26", "preferred_time_slot": "Test value", "additional_notes": "Sample message for testing.", "_field_labels": {"field_1771059625885": "customer_name", "field_1771059732881": "customer_phone", "field_1771059775104": "message_volume", "field_1771059785751": "preferred_date", "field_1771059794160": "preferred_time_slot", "field_1771059803951": "additional_notes"}}}, "width": 220, "height": 112, "selected": false, "dragging": false, "positionAbsolute": {"x": 251.5, "y": 99.5}}, {"id": "if_else-3-1772095076195", "type": "if_else", "position": {"x": 281.2026808227903, "y": 319.34798580980316}, "data": {"combinator": "AND", "conditions": [{"left": "{{trigger.additional_notes}}", "operator": "is_empty", "right": ""}]}, "width": 358, "height": 156, "selected": false, "dragging": false, "positionAbsolute": {"x": 281.2026808227903, "y": 319.34798580980316}}, {"id": "action-4-1772095275643", "type": "action", "position": {"x": 917.2777458404773, "y": 465.9372046197716}, "data": {"label": "New Action", "actionType": "send_whatsapp", "template": "\ud83d\udce9 Nouveau Lead\n\ud83d\udc64 Nom :  {{trigger.name}}\n\ud83d\udcde T\u00e9l\u00e9phone :{{trigger.customer_phone}}\n\ud83c\udff7\ufe0fNombre de message par jour : {{trigger.message_volume}}\n\ud83d\udcd2Notes : {{trigger.additional_notes}}", "recipient": "33766648942"}, "width": 220, "height": 112, "selected": false, "dragging": false, "positionAbsolute": {"x": 917.2777458404773, "y": 465.9372046197716}}, {"id": "action-5-1772095876275", "type": "action", "position": {"x": 1508.7789508398123, "y": 571.7531611751305}, "data": {"label": "New Action", "actionType": "send_whatsapp", "template": "Bonjour \ud83d\udc4b\nMerci pour votre demande du Syst\u00e8me Cabinet Pilote\nNotre \u00e9quipe souhaite vous appeler tr\u00e8s prochainement pour en discuter.\nPourriez-vous nous indiquer le moment de la journ\u00e9e qui vous conviendrait le mieux pour \u00eatre appel\u00e9 ?\n\n\u00c0 tr\u00e8s vite inchaAllah \ud83d\ude80", "recipient": "{{trigger.field_1771059732881}}"}, "width": 220, "height": 112, "selected": true, "positionAbsolute": {"x": 1508.7789508398123, "y": 571.7531611751305}, "dragging": false}, {"id": "action-6-1772095880187", "type": "action", "position": {"x": 1159.8324670035015, "y": 677.7057986357951}, "data": {"label": "New Action", "actionType": "delay", "seconds": 2}, "width": 220, "height": 112, "selected": false, "dragging": false, "positionAbsolute": {"x": 1159.8324670035015, "y": 677.7057986357951}}, {"id": "action-6-1772153862357", "type": "action", "position": {"x": 1079.7235786571405, "y": 265.26504330970363}, "data": {"label": "New Action", "actionType": "send_whatsapp", "template": "\ud83d\udce9 Nouveau Lead\n\ud83d\udc64 Nom :  {{trigger.name}}\n\ud83d\udcde T\u00e9l\u00e9phone :{{trigger.customer_phone}}\n\ud83c\udff7\ufe0fNombre de message par jour : {{trigger.message_volume}}", "recipient": "33766648942"}, "width": 220, "height": 112, "selected": false, "dragging": false, "positionAbsolute": {"x": 1079.7235786571405, "y": 265.26504330970363}}], "edges": [{"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "trigger-1", "sourceHandle": null, "target": "if_else-3-1772095076195", "targetHandle": null, "id": "reactflow__edge-trigger-1-if_else-3-1772095076195"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "if_else-3-1772095076195", "sourceHandle": "false", "target": "action-4-1772095275643", "targetHandle": null, "id": "reactflow__edge-if_else-3-1772095076195false-action-4-1772095275643"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-4-1772095275643", "sourceHandle": null, "target": "action-6-1772095880187", "targetHandle": null, "id": "reactflow__edge-action-4-1772095275643-action-6-1772095880187"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-6-1772095880187", "sourceHandle": null, "target": "action-5-1772095876275", "targetHandle": null, "id": "reactflow__edge-action-6-1772095880187-action-5-1772095876275"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "if_else-3-1772095076195", "sourceHandle": "true", "target": "action-6-1772153862357", "targetHandle": null, "id": "reactflow__edge-if_else-3-1772095076195true-action-6-1772153862357"}, {"type": "deletableSmoothstep", "animated": false, "style": {"strokeWidth": 2, "strokeDasharray": "8 4", "stroke": "var(--color-border, #94a3b8)"}, "interactionWidth": 20, "source": "action-6-1772153862357", "sourceHandle": null, "target": "action-6-1772095880187", "targetHandle": null, "id": "reactflow__edge-action-6-1772153862357-action-6-1772095880187", "selected": false}]}

TEXT NOT NULL

schedule

TEXT

created_at

TEXT NOT NULL

updated_at

TEXT

webhook_token

TEXT

app.db — automations

Update row 4 in automations