SQLite Web: app.db

id

Primary key. INTEGER

automation_id

INTEGER NOT NULL

status

TEXT NOT NULL

start_time

TEXT NOT NULL

end_time

TEXT

logs

[{"timestamp": "2026-06-24T20:31:50.278438", "level": "info", "message": "Starting automation execution. Context: {\"field_1771059625885\": \"Mohamed\", \"field_1771059732881\": \"+212661166146\", \"field_1771059775104\": \"0-50\", \"field_1771059785751\": \"\", \"field_1771059794160\": \"\", \"field_1771059803951\": \"Nom du cabinet: Kadi\\nEmail: koszonomdr@gmail.com\\n\\n[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\\n[TRACKING]\\nlanding_url: https://forteunoweb.com/doctors-agent?utm_source=metaads&utm_medium=BATCH_1&utm_campaign=Campaign_1_Statics_SameConcept_Test&utm_content=Texte+%C2%B7+Heures+Perdues+Assistante+%C2%B7+Fond+Vert&utm_term=Facebook_Mobile_Reels&fbclid=IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA&utm_id=52577226725349\\nreferrer: http://m.facebook.com/\\nutm_source: metaads\\nutm_medium: BATCH_1\\nutm_campaign: Campaign_1_Statics_SameConcept_Test\\nutm_content: Texte \\u00b7 Heures Perdues Assistante \\u00b7 Fond Vert\\nutm_term: Facebook_Mobile_Reels\\nfbclid: IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA\\nutm_id: 52577226725349\", \"form_id\": 1, \"form_name\": \"Product Form\", \"submission_id\": 183, \"form_created_at\": \"2026-06-24T20:31:50.255303\", \"source\": \"doctors-agent-landing-page\", \"chatbot_id\": 38, \"name\": \"Mohamed\", \"body\": \"Nom du cabinet: Kadi\\nEmail: koszonomdr@gmail.com\\n\\n[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\\n[TRACKING]\\nlanding_url: https://forteunoweb.com/doctors-agent?utm_source=metaads&utm_medium=BATCH_1&utm_campaign=Campaign_1_Statics_SameConcept_Test&utm_content=Texte+%C2%B7+Heures+Perdues+Assistante+%C2%B7+Fond+Vert&utm_term=Facebook_Mobile_Reels&fbclid=IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA&utm_id=52577226725349\\nreferrer: http://m.facebook.com/\\nutm_source: metaads\\nutm_medium: BATCH_1\\nutm_campaign: Campaign_1_Statics_SameConcept_Test\\nutm_content: Texte \\u00b7 Heures Perdues Assistante \\u00b7 Fond Vert\\nutm_term: Facebook_Mobile_Reels\\nfbclid: IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA\\nutm_id: 52577226725349\", \"customer_name\": \"Mohamed\", \"customer_phone\": \"+212661166146\", \"message_volume\": \"0-50\", \"preferred_date\": \"\", \"preferred_time_slot\": \"\", \"additional_notes\": \"Nom du cabinet: Kadi\\nEmail: koszonomdr@gmail.com\\n\\n[INFO TECHNIQUE]\\nWhatsApp: OUI\\nPays: Maroc (+212)\\n[TRACKING]\\nlanding_url: https://forteunoweb.com/doctors-agent?utm_source=metaads&utm_medium=BATCH_1&utm_campaign=Campaign_1_Statics_SameConcept_Test&utm_content=Texte+%C2%B7+Heures+Perdues+Assistante+%C2%B7+Fond+Vert&utm_term=Facebook_Mobile_Reels&fbclid=IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA&utm_id=52577226725349\\nreferrer: http://m.facebook.com/\\nutm_source: metaads\\nutm_medium: BATCH_1\\nutm_campaign: Campaign_1_Statics_SameConcept_Test\\nutm_content: Texte \\u00b7 Heures Perdues Assistante \\u00b7 Fond Vert\\nutm_term: Facebook_Mobile_Reels\\nfbclid: IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA\\nutm_id: 52577226725349\", \"_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\"}}", "node_id": null}, {"timestamp": "2026-06-24T20:31:50.278732", "level": "info", "message": "Standardized variables: ['full_name']", "node_id": null}, {"timestamp": "2026-06-24T20:31:50.279035", "level": "info", "message": "Triggered by node trigger-1 [form_submission] (canvas label: 'Form Submitted')", "node_id": "trigger-1"}, {"timestamp": "2026-06-24T20:31:50.279239", "level": "info", "message": "Executing node action-1 (action)", "node_id": "action-1"}, {"timestamp": "2026-06-24T20:31:50.279338", "level": "info", "message": "DEBUG: Processing node action-1, type=action, action=send_whatsapp", "node_id": null}, {"timestamp": "2026-06-24T20:31:50.282940", "level": "error", "message": "No recipient phone number found for WhatsApp action", "node_id": null}, {"timestamp": "2026-06-24T20:31:50.283037", "level": "info", "message": "End of path at node action-1", "node_id": "action-1"}, {"timestamp": "2026-06-24T20:31:50.283107", "level": "info", "message": "Automation completed successfully", "node_id": null}]

TEXT

context_snapshot

{"field_1771059625885": "Mohamed", "field_1771059732881": "+212661166146", "field_1771059775104": "0-50", "field_1771059785751": "", "field_1771059794160": "", "field_1771059803951": "Nom du cabinet: Kadi\nEmail: koszonomdr@gmail.com\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nlanding_url: https://forteunoweb.com/doctors-agent?utm_source=metaads&utm_medium=BATCH_1&utm_campaign=Campaign_1_Statics_SameConcept_Test&utm_content=Texte+%C2%B7+Heures+Perdues+Assistante+%C2%B7+Fond+Vert&utm_term=Facebook_Mobile_Reels&fbclid=IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA&utm_id=52577226725349\nreferrer: http://m.facebook.com/\nutm_source: metaads\nutm_medium: BATCH_1\nutm_campaign: Campaign_1_Statics_SameConcept_Test\nutm_content: Texte \u00b7 Heures Perdues Assistante \u00b7 Fond Vert\nutm_term: Facebook_Mobile_Reels\nfbclid: IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA\nutm_id: 52577226725349", "form_id": 1, "form_name": "Product Form", "submission_id": 183, "form_created_at": "2026-06-24T20:31:50.255303", "source": "doctors-agent-landing-page", "chatbot_id": 38, "name": "Mohamed", "body": "Nom du cabinet: Kadi\nEmail: koszonomdr@gmail.com\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nlanding_url: https://forteunoweb.com/doctors-agent?utm_source=metaads&utm_medium=BATCH_1&utm_campaign=Campaign_1_Statics_SameConcept_Test&utm_content=Texte+%C2%B7+Heures+Perdues+Assistante+%C2%B7+Fond+Vert&utm_term=Facebook_Mobile_Reels&fbclid=IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA&utm_id=52577226725349\nreferrer: http://m.facebook.com/\nutm_source: metaads\nutm_medium: BATCH_1\nutm_campaign: Campaign_1_Statics_SameConcept_Test\nutm_content: Texte \u00b7 Heures Perdues Assistante \u00b7 Fond Vert\nutm_term: Facebook_Mobile_Reels\nfbclid: IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA\nutm_id: 52577226725349", "customer_name": "Mohamed", "customer_phone": "+212661166146", "message_volume": "0-50", "preferred_date": "", "preferred_time_slot": "", "additional_notes": "Nom du cabinet: Kadi\nEmail: koszonomdr@gmail.com\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nlanding_url: https://forteunoweb.com/doctors-agent?utm_source=metaads&utm_medium=BATCH_1&utm_campaign=Campaign_1_Statics_SameConcept_Test&utm_content=Texte+%C2%B7+Heures+Perdues+Assistante+%C2%B7+Fond+Vert&utm_term=Facebook_Mobile_Reels&fbclid=IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA&utm_id=52577226725349\nreferrer: http://m.facebook.com/\nutm_source: metaads\nutm_medium: BATCH_1\nutm_campaign: Campaign_1_Statics_SameConcept_Test\nutm_content: Texte \u00b7 Heures Perdues Assistante \u00b7 Fond Vert\nutm_term: Facebook_Mobile_Reels\nfbclid: IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA\nutm_id: 52577226725349", "_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"}, "trigger": {"field_1771059625885": "Mohamed", "field_1771059732881": "+212661166146", "field_1771059775104": "0-50", "field_1771059785751": "", "field_1771059794160": "", "field_1771059803951": "Nom du cabinet: Kadi\nEmail: koszonomdr@gmail.com\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nlanding_url: https://forteunoweb.com/doctors-agent?utm_source=metaads&utm_medium=BATCH_1&utm_campaign=Campaign_1_Statics_SameConcept_Test&utm_content=Texte+%C2%B7+Heures+Perdues+Assistante+%C2%B7+Fond+Vert&utm_term=Facebook_Mobile_Reels&fbclid=IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA&utm_id=52577226725349\nreferrer: http://m.facebook.com/\nutm_source: metaads\nutm_medium: BATCH_1\nutm_campaign: Campaign_1_Statics_SameConcept_Test\nutm_content: Texte \u00b7 Heures Perdues Assistante \u00b7 Fond Vert\nutm_term: Facebook_Mobile_Reels\nfbclid: IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA\nutm_id: 52577226725349", "form_id": 1, "form_name": "Product Form", "submission_id": 183, "form_created_at": "2026-06-24T20:31:50.255303", "source": "doctors-agent-landing-page", "chatbot_id": 38, "name": "Mohamed", "body": "Nom du cabinet: Kadi\nEmail: koszonomdr@gmail.com\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nlanding_url: https://forteunoweb.com/doctors-agent?utm_source=metaads&utm_medium=BATCH_1&utm_campaign=Campaign_1_Statics_SameConcept_Test&utm_content=Texte+%C2%B7+Heures+Perdues+Assistante+%C2%B7+Fond+Vert&utm_term=Facebook_Mobile_Reels&fbclid=IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA&utm_id=52577226725349\nreferrer: http://m.facebook.com/\nutm_source: metaads\nutm_medium: BATCH_1\nutm_campaign: Campaign_1_Statics_SameConcept_Test\nutm_content: Texte \u00b7 Heures Perdues Assistante \u00b7 Fond Vert\nutm_term: Facebook_Mobile_Reels\nfbclid: IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA\nutm_id: 52577226725349", "customer_name": "Mohamed", "customer_phone": "+212661166146", "message_volume": "0-50", "preferred_date": "", "preferred_time_slot": "", "additional_notes": "Nom du cabinet: Kadi\nEmail: koszonomdr@gmail.com\n\n[INFO TECHNIQUE]\nWhatsApp: OUI\nPays: Maroc (+212)\n[TRACKING]\nlanding_url: https://forteunoweb.com/doctors-agent?utm_source=metaads&utm_medium=BATCH_1&utm_campaign=Campaign_1_Statics_SameConcept_Test&utm_content=Texte+%C2%B7+Heures+Perdues+Assistante+%C2%B7+Fond+Vert&utm_term=Facebook_Mobile_Reels&fbclid=IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA&utm_id=52577226725349\nreferrer: http://m.facebook.com/\nutm_source: metaads\nutm_medium: BATCH_1\nutm_campaign: Campaign_1_Statics_SameConcept_Test\nutm_content: Texte \u00b7 Heures Perdues Assistante \u00b7 Fond Vert\nutm_term: Facebook_Mobile_Reels\nfbclid: IwZXh0bgNhZW0BMABhZGlkAAAv0ZsdW11zcnRjBmFwcF9pZAwzNTA2ODU1MzE3MjgAAR6bZ4UHqKHhw8wMlzKx7wu-b6PlyhzrPCwDgJ-Xak7DHcnDtFj6Oe1GGR-DOg_aem_s1-px0SDLxYjZUipSAWzOA\nutm_id: 52577226725349", "_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"}, "automation_id": 6}, "full_name": "Mohamed", "automation_id": 6}

TEXT

app.db — automation_runs

Update row 195 in automation_runs