Step 2: Configure Message Validation and Routing

Filter for the correct group chat and route message types before hitting Airtable.

1. In Validate Group Message, configure the condition to match the chat ID using Left Value {{ $json.body.messages[0].chat_id }} and Right Value [YOUR_ID].
2. Confirm the true output from Validate Group Message connects to Route Message Type, and the false output connects to No-Op Placeholder for ignored messages.
3. In Route Message Type, keep the four outputs enabled with their existing conditions for {{ $json.body.messages[0].text.body }}, {{ $json.body.messages[0].action.emoji }}, and message {{ $json.body.messages[0].type }} values of voice and image.

Step 3: Connect Airtable and Retrieve the Contact Record

Once a message type is identified, the workflow searches Airtable for the WhatsApp user.

1. Add your Airtable connection in Retrieve WhatsApp Record.
2. Credential Required: Connect your Airtable credentials.
3. Set the Base to WhatsApp Engagement Database and the Table to Table 1.
4. Set Operation to search and Filter By Formula to ={WhatsApp_ID} = {{ $json.body.messages[0].from }}.

Step 4: Set Up the Counter Processing

Increment the engagement counter before writing the record back to Airtable.

1. In Increment Counter, keep the JavaScript code as-is to increment Count:
2. Use the existing code in jsCode:
3. var count = $input.first().json.Count; // Aktuellen Wert abrufen count += 1; // Eine 1 dazuaddieren return { Count: count }; // Aktualisierten Wert zurückgeben

Step 5: Configure Airtable Record Update

Update the matching Airtable record with the new count, sender ID, and last interaction date.

1. Open Modify Airtable Record and connect Airtable credentials.
2. Credential Required: Connect your Airtable credentials.
3. Set the Base to WhatsApp Engagement Database and the Table to Table 1.
4. Set Operation to update.
5. In Columns, map values to:
6. Count → {{ $json.Count }}
7. WhatsApp_ID → {{ $('Incoming Webhook Trigger').item.json.body.messages[0].from }}
8. Last interaction → {{ $now.format('yyyy.MM.dd') }}
9. Keep Matching Columns set to WhatsApp_ID to update the correct record.

Step 6: Test and Activate Your Workflow

Validate the end-to-end flow with a real payload before switching it to production.

1. Click Execute Workflow and send a test WhatsApp event to the Incoming Webhook Trigger URL.
2. Confirm the run path follows Incoming Webhook Trigger → Validate Group Message → Route Message Type → Retrieve WhatsApp Record → Increment Counter → Modify Airtable Record.
3. In Airtable, verify the matching record’s Count increases and Last interaction updates to today’s date.
4. Click Activate to enable the workflow for production use.