Building integrations

How do I email managers when department details change in a dataset?

Build an integration that retrieves the updated dataset row with the Dataset connector and sends the new details in an email.

Tip

Short answer: Use the Kissflow Dataset connector to retrieve the updated row, then send its details to the relevant managers in an email.

When to use this

Use this when you keep reference data, such as a dataset of department managers, and people need to know as soon as it changes. For example, when a manager's department is updated in the dataset, the integration emails the updated details to the relevant managers. This keeps the team informed of organizational changes so they can respond quickly.

Set it up

  1. Create an integration.
  2. Add the Kissflow Dataset trigger When an existing row is updated and choose your department dataset.
  3. Add the Kissflow Dataset action Retrieve a row from a dataset to fetch the updated row.
  4. Add the Send an email action.
  5. Address the email to the relevant managers. In the email body, type / and insert the retrieved row data.
  6. Test, then turn on the integration.

Tip

When you fetch a dataset row as a table, complex fields such as user fields are hidden by default. Add them to the email body as separate fields instead of inside the table.

Related answers