Use Cases
- Automate database schema updates for ChatWoot contacts
- Ensure data integrity by recreating necessary database tables
- Facilitate efficient management of ChatWoot contact data
How It Works
Trigger the workflow manually to initiate the migration process Execute SQL commands to drop the existing 'chatwoot_contacts' table if it exists Create a new 'chatwoot_contacts' table with the required fields and indexes
Setup Steps
- 1Import the workflow into n8n
- 2Click on 'Test workflow' to run the migration process
- 3Verify the successful creation of the 'chatwoot_contacts' table in the Postgres database
Apps Used
Postgres
ChatWoot
Categories
Target Roles
Industries
Tags
#database automation
#process automation
#workflow management