Speedy Question Node icon

Speedy Question Node

speedy Question Node for sending a speedy Question, A Wait Field is Mandatory afterwards!

Actions2

Overview

This node, named "Speedy Question Node," is designed to send a message with a question that expects a response. It supports two types of questions: a simple Yes/No type and a multiple-choice type ("Auswahlfeld" or selection field). The node constructs a message including the recipient, subject, text, and question details, then sends it by executing a stored procedure call on a MySQL database.

Typical use cases include:

  • Sending interactive messages where recipients can respond with predefined options.
  • Automating workflows that require user feedback via quick questions.
  • Integrating messaging with backend systems through SQL calls.

For example, you might send a notification email asking the recipient to choose one of several options, and the response will be handled asynchronously via a webhook URL.

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 response expected: "Ja/Nein" (Yes/No) or "Auswahlfeld" (Selection).
Antwort 1 Response option 1 (required if Antworttyp is Auswahlfeld).
Antwort 2 Response option 2 (required if Antworttyp is Auswahlfeld).
Antwort 3 Response option 3 (optional, shown only if Antworttyp is Auswahlfeld).
AntwortURL URL to which the response will be sent back (defaults to the workflow's resume webhook).

Output

The node outputs an array of JSON objects representing the results of the executed SQL queries. Each output item contains a queryResult field holding the result set returned from the database after calling the stored procedure to send the message.

The structure of each output JSON object is:

{
  "queryResult": <result_of_sql_call>
}

There is no binary data output.

Dependencies

  • Requires a MySQL database connection to execute SQL queries.
  • Reads configuration from a JSON file (speedy_config.json) and an INI file specified within it for default database connection parameters.
  • Uses a stored procedure named n8n_sendMessage in the MySQL database to send the message.
  • The node depends on the presence of a webhook URL (defaulted to the workflow's resume webhook URL) to handle responses.

Troubleshooting

  • Database Connection Issues: If the node cannot connect to the MySQL server, verify the server address, port, username, password, and database name. These can come from input data, node parameters, or the INI config file.
  • SQL Execution Errors: Errors during the execution of the SQL query (e.g., malformed SQL, missing stored procedure) will be logged to the console. Ensure the stored procedure n8n_sendMessage exists and accepts the correct parameters.
  • Missing Required Parameters: For the "Auswahlfeld" operation, ensure that at least two response options (Antwort 1 and Antwort 2) are provided; otherwise, the node may fail or produce incomplete messages.
  • Webhook URL Issues: The response URL must be reachable and correctly configured to receive answers. Using the default resume webhook URL is recommended unless a custom endpoint is needed.

Links and References

Discussion