When a new order is received via WooCommerce webhook, use Lookup Table to convert the product SKU to product name, then send a formatted email notification with the full product name.
WooCommerce to Lookup Table, then Email SMTP
Lookup Table integration
Connect Lookup Table with 918+ other apps in FlowMattic. Pick a trigger, add Lookup Table steps, map the fields from earlier steps and run the workflow on your own server with no per-task fees.
1 action Integration version 1.0 Category: Data Transformation Unlimited workflows and runs
Triggers and actions for Lookup Table
A trigger is the Lookup Table event that starts a workflow. An action is what FlowMattic does in Lookup Table from a step.
| Event | What it does | Type |
|---|---|---|
| Lookup Table | Lookup a value in a custom data table and return the corresponding value | Action |
Three steps to a running Lookup Table workflow
The builder keeps the order you think in: connect the app, choose what starts the workflow, add what should happen.
-
Connect
Authorise Lookup Table once
Add a Lookup Table connection under Connects and reuse it in every workflow. Credentials stay in your WordPress database.
-
Trigger
Pick what starts it
Start from a WordPress event, a form, a webhook, a schedule or any of the 918+ integrations, then capture a sample so later steps can map real fields.
-
Act
Add Lookup Table steps and logic
Chain Lookup Table actions with Router, Filter, Iterator and Delay, test each step against captured data, then switch the workflow on.
Lookup Table workflows people build
Each example pairs Lookup Table with an app it is often used with. Build any of them on the canvas, or start from the workflow library.
When a form submission is received via Contact Form 7, use Lookup Table to convert the 2-letter country code to the full country name, then create a Google Sheets row with the complete shipping address.
Contact Form 7 to Lookup Table, then Google Sheets
When a webhook receives an API status response, use Lookup Table to convert numeric status codes (200, 404, 500) to user-friendly messages, then send a Slack notification with the readable status message
Webhooks to Lookup Table, then Slack
When a new user registers in WordPress, use Lookup Table to convert the user role ID to a descriptive role name, then add the user to a Mailchimp list with the appropriate tag based on their role
WordPress to Lookup Table, then Mailchimp
When a form submission is captured via webhook, use Lookup Table to convert ISO language codes (en, es, fr) to full language names, then route the lead to the appropriate sales team using the Router module
Webhooks to Lookup Table, then Routers
When a payment is completed via WooCommerce, use Lookup Table to convert the payment method ID to the gateway name (PayPal, Stripe, Bank Transfer), then log the transaction in a FlowMattic Table with the full gateway name
WooCommerce to Lookup Table, then WP Tables
About Lookup Table
FlowMattic integration version 1.0
Transform and map data dynamically with FlowMattic's Lookup Table module. This powerful data mapping tool allows you to convert codes, IDs, or values into their corresponding data by referencing a custom key-value table.
Lookup Table integration changelog
What changed in each version of the integration.
v1.0 – 9 May, 2o25
– Initial release
Start automating Lookup Table today
Try the Lookup Table integration on a live demo site, or install FlowMattic on your own and keep every run on your server.
30-day money-back guarantee Unlimited workflows and runs Self-hosted