Actions2
Overview
This node, named "Speedy Question Node," is designed to send a message with an embedded question that expects a user response. It supports two types of questions: a simple Yes/No type and a multiple-choice selection (switch) type with up to three possible answers. The node constructs a message containing the recipient, subject, text, and a structured question payload including a response URL where answers can be sent back.
A key feature is that after sending the question, a wait state is expected in the workflow to pause execution until a response is received via the provided webhook URL.
Typical use cases include:
- Sending quick surveys or polls to users.
- Requesting confirmation or decisions (Yes/No).
- Collecting user input through predefined options.
- Automating workflows that depend on user feedback.
For example, you might send a question asking "Do you approve this request?" with Yes/No options, or present a choice among several options for scheduling a meeting.
Properties
| Name | Meaning |
|---|---|
| Empfänger | Sets the recipient of the message. |
| Betreff | Sets the subject of the message. |
| Text | Sets the main text content of the message. |
| Antworttyp | Selects the type of answer expected: "Ja/Nein" (Yes/No) or "Auswahlfeld" (multiple choice). |
| Antwort 1 | First answer option (required if Antworttyp is Auswahlfeld). |
| Antwort 2 | Second answer option (required if Antworttyp is Auswahlfeld). |
| Antwort 3 | Third answer option (optional, shown only if Antworttyp is Auswahlfeld). |
| AntwortURL | URL where the user's response will be sent back (defaults to the workflow's resume webhook URL). |
Output
The node outputs an array of JSON objects representing the results of executing a SQL stored procedure call that sends the message. Each output item contains a queryResult field holding the result of the database call.
The structure of the output JSON is roughly:
{
"queryResult": { /* result from the SQL CALL n8n_sendMessage(...) */ }
}
No binary data output is produced by this node.
Dependencies
- Requires access to a MySQL database where a stored procedure named
n8n_sendMessageexists. This procedure handles sending the actual message. - Reads configuration from an external INI file (
speedy_config.json) to obtain default database connection parameters. - Uses a webhook URL (usually the workflow's resume webhook) to receive responses asynchronously.
- Requires proper credentials and network access to connect to the MySQL server.
Troubleshooting
- Database Connection Errors: If the node cannot connect to the MySQL server, verify the server address, port, username, password, and database name. These can come from either the node parameters or the external config file.
- Missing Stored Procedure: Ensure the
n8n_sendMessagestored procedure exists and is accessible by the database user. - Invalid or Missing Parameters: The node requires at least the recipient and text fields to be set. For multiple-choice questions, at least two answer options must be provided.
- Response URL Issues: The response URL must be reachable and correctly configured to handle incoming answers; otherwise, the workflow may hang waiting for a response.
- Error Executing SQL Query: The node logs errors when the SQL query fails. Check the error messages for syntax issues or permission problems.