Here is the step-by-step workflow automation process to easily add a searchable meta value to your existing mysql data using n8n:
- Trigger: Configure the trigger node to connect to your mysql database and select the table you want to add the meta value to. Set the trigger to run when a new row is added to the table.
- Get Data: Use the Get Data node to retrieve the existing data from the newly added row in the mysql table.
- Compute Value: Add a Compute Value node to calculate the meta value you want to add based on the existing data from the mysql table.
- Set Data: Use the Set Data node to set the newly calculated meta value to a field in the data object.
- Update Row: Add an Update Row node to update the row in the mysql table with the newly calculated meta value.
Apis, scripts or tools used in this workflow:
- n8n: Workflow automation tool
- Mysql database
