Step 2: Connect Email Intake and HTML Parsing

Bring in email-based inquiries and extract clean text from HTML email bodies.

1. Add Inbound Email Listener and connect your IMAP inbox settings.
2. Connect Inbound Email Listener to Extract Email Body.
3. In Extract Email Body, set Operation to extractHtmlContent.
4. Set Data Property Name to {{ $json.html }}.
5. Under Extraction Values, set CSS Selector to body and Key to text.

Step 3: Set Up Field Mapping for Email and Web Form Inputs

Normalize data from both sources into a single schema used throughout the workflow.

1. In Map Email Fields, keep Include Other Fields enabled.
2. Map customerName to {{ $json.from.name }} and customerEmail to {{ $json.from.address }}.
3. Map subject to {{ $json.subject }} and message to {{ $json.text }}.
4. Set source to email and receivedAt to {{ $json.date }}.
5. Set inquiryType to {{ $json.subject.toLowerCase().includes('urgent') || $json.subject.toLowerCase().includes('緊急') ? 'urgent' : ($json.subject.toLowerCase().includes('billing') || $json.subject.toLowerCase().includes('請求') ? 'billing' : 'general') }}.
6. In Map Form Fields, keep Include Other Fields enabled.
7. Map customerName to {{ $json.body.name }}, customerEmail to {{ $json.body.email }}, and subject to {{ $json.body.subject }}.
8. Map message to {{ $json.body.message }}, source to webform, and receivedAt to {{ $now }}.
9. Set inquiryType to {{ $json.body.type || 'general' }}.

Step 4: Combine and Route Requests

Merge the two input sources and route requests by inquiry type.

1. Open Combine Requests and set Mode to combine.
2. Set Combine By to combineByPosition.
3. Connect Map Email Fields and Map Form Fields into Combine Requests (indices 0 and 1 respectively).
4. Configure Route by Request Type with three outputs using Equals on {{ $json.inquiryType }}: general, urgent, and billing.
5. Note that Combine Requests outputs to both Route by Request Type and Send Acknowledgement in parallel.

Step 5: Configure Output and Notification Nodes

Log inquiries to Google Sheets, post Slack notifications, and send acknowledgements.

1. In Log to Sheets, set Operation to appendOrUpdate.
2. Set Document ID to <__PLACEHOLDER_VALUE__Google Sheets Document ID__> and Sheet Name to <__PLACEHOLDER_VALUE__Sheet Name (e.g., Inquiries)__>.
3. Keep the auto-mapped columns for customerName, customerEmail, subject, message, source, receivedAt, and inquiryType.
4. In Slack Urgent Alert, set Channel to <__PLACEHOLDER_VALUE__Slack Channel ID for Urgent Alerts__> and keep the message template as configured.
5. In Slack General Notice, set Channel to <__PLACEHOLDER_VALUE__Slack Channel ID for General Inquiries__> and keep the message template as configured.
6. In Send Acknowledgement, set Send To to {{ $json.customerEmail }} and Subject to Re: {{ $json.subject }}.
7. Confirm the email Message body remains the provided Japanese acknowledgement text.

Step 6: Test and Activate Your Workflow

Validate each path to ensure inquiries are logged and notifications are sent as expected.

1. Click Execute Workflow and submit a test web form to trigger Web Form Hook.
2. Send a test email to the monitored inbox to trigger Inbound Email Listener.
3. Confirm that Combine Requests sends data to Route by Request Type and Send Acknowledgement in parallel.
4. Verify a new row appears in the Google Sheet via Log to Sheets.
5. Confirm Slack messages arrive in the correct channels from Slack Urgent Alert or Slack General Notice.
6. Check that Send Acknowledgement emails the sender with the correct subject and message.
7. When satisfied, toggle the workflow to Active for production use.