Full list

Supported Triggers & Actions

Everything you can automate between PostgreSQL and PostWire.

When this happensTriggers

A trigger is an event that starts a workflow.

Postgresql (mutiple table)

Postgresql (mutiple table)

Get all the data, which was updated in last 15 min, from all the table provided.

New Post Published

New Post Published

Runs once for each network that accepts a post (published from the API, dashboard, n8n, MCP or the scheduler), with the network, the post's ID and public URL, the account, the brand and source ("api" or "schedule"). A post to several networks fires once per network that published it; an Instagram video still processing or a large YouTube/TikTok upload fires when it finishes. Leave Brand empty to run for every brand. Note: Each run returns one flat event for one network: event_id, event_type ("post.published"), created_at, platform, status, post_id, url, error, code, account (platform, handle, display_name, brand_id, brand, label), brand_id, source ("api" or "schedule"), schedule_id, idempotency_key and label. The IDs, timestamps and URL in the sample are only examples, so map fields by key and not by the example values.

Post Fails to Publish

Post Fails to Publish

Runs once for each network that refuses a post or can't be sent (not connected, media unreachable, plan limit or the network's own error), with the network, the error text, a machine-readable code and the brand. A post to several networks fires once per failed network; status "unknown" with code "timed_out" means the network didn't answer in time and the post may still have gone out. Leave Brand empty to run for every brand.

Request a new Trigger for PostgreSQL

Do thisActions

Action is the task that follows automatically within your PostgreSQL integrations.

Execute a Query (advanced)

Execute a Query (advanced)

You can select, create, update or delete row(s) of table via custom SQL query.

Insert row

Insert row

Adds a new row into the table.

Get Post Status

Get Post Status

Get the current status of one post, returned as one object. Pass the network's post ID with its Network to get that post's status (for example published or processing), or pass the PostWire ID of a post that waits for approval or is scheduled, with Network left empty, to get pending_approval (with who was asked), rejected (with the reason), scheduled, or each network's result once it went out.

Publish Post

Publish Post

Publish a post now to one or more connected networks of a brand.

Generate Post Drafts

Generate Post Drafts

Write a native post draft for each selected network from one idea, without publishing.

Schedule Post

Schedule Post

Queue a post for a chosen time or the brand's next free slot.

How to build your first workflow with viaSocket
2-Minute Guide

Learn how to build your first workflow

Follow a simple walkthrough to create, test, and launch your first automation.

  1. 1

    Connect your apps

    Link the apps you want to automate.

  2. 2

    Configure your workflow

    Set up triggers, actions, and map your data.

  3. 3

    Test & publish

    Test your workflow and publish it.

Trusted by Thousands. Recognized by the Best.

Recognized by leading review platforms and trusted by 10,000+ businesses worldwide.

Workflow: Auto Close Inactive viaSocket Connections
YOU
◆AI Workflow Builder

From idea to automation.
AI will build it for you

Just describe the task in plain English. viaSocket AI selects the right apps, builds the workflow, maps the fields, and prepares everything for review before you publish.

No coding required|Review before publishing|Works with 2,300+ apps
Create with AI

Need help building your workflow?

Get help instantly from AI or reach out to our support team.

viaSocket Support

We're here to help

Online
Support agent
What can I help you with?
How can I set trigger?
10:30 AM ✓

Instant answers

AI assistant available 24/7

Expert support

Connect with our specialists

Trusted & secure

Your data is safe with us

Start automating PostgreSQL and PostWire free

No credit card required. Set up your first workflow in minutes.

Frequently Asked Questions

How do I connect PostgreSQL and PostWire?

Sign up for a free viaSocket account, then authorize both your PostgreSQL and PostWire accounts. From there, pick a trigger in one app and an action in the other. Your first workflow can be live in under five minutes.

Does this integration work in real time?

Yes. viaSocket uses instant triggers where available, so data moves between PostgreSQL and PostWire as soon as the event happens. Scheduled polling triggers run at a maximum interval of 15 minutes.

Can I control which data gets sent from PostgreSQL to PostWire?

Yes. You can map specific fields, apply filters to skip records that do not match your conditions, and transform values before they reach PostWire. No coding required.

Can the integration run in both directions?

Yes. You can set up a workflow where PostgreSQL triggers actions in PostWire, and a separate workflow where PostWire triggers actions in PostgreSQL. Both run independently and in real time.

What happens if a step in the workflow fails?

viaSocket logs every run so you can see exactly what succeeded and what failed. Failed tasks can be retried from the dashboard without re-configuring the workflow.

Is viaSocket free to use?

Yes, there is a free plan that covers basic workflows between PostgreSQL and PostWire. Paid plans unlock higher task limits, faster polling, and advanced features like multi-step workflows and conditional logic.

Do I need to know how to code to set this up?

No. The entire PostgreSQL and PostWire integration is built through a visual, point-and-click interface. Code blocks are available if you want them, but they are never required.