ContentRunner Channel Upsert (Stage) icon

ContentRunner Channel Upsert (Stage)

Insert or update a channel/chat in n8n_content_runner by tg_chat_id

ContentRunner Channel Upsert (Stage)

AI-generated

Summary

Upserts a Telegram channel or chat into the n8n_content_runner PostgreSQL table using tg_chat_id, updating title and chat_type if provided.

Inputs

  • tgChatId (required) — Unique Telegram chat/channel ID (for private chats usually same as from_id, for groups/channels it is chat_id).
  • title — Channel or chat title.
  • chatType — Chat type: 'private', 'group', 'supergroup', or 'channel'.

Output shape

list of items; each item has a json property containing the database row and a pairedItem property indicating the input index.

If continueOnFail is enabled, items with missing tgChatId produce an error object instead of throwing; otherwise the node fails on error.

Examples

Example 1: Basic upsert of a channel using provided chat ID, title, and type.

Set tgChatId to 123456, title to 'My Channel', chatType to 'channel'.

Example 2: Upsert with only chat ID and title, leaving chatType empty.

Set tgChatId to 789012, title to 'Another Group', chatType omitted.

Example 3: Handle missing tgChatId with continueOnFail enabled, returning error object.

Leave tgChatId empty, enable continueOnFail; the node outputs an item with json: {error: 'tg_chat_id is required'}.

Links

Discussion