Full list

Supported Triggers & Actions

Everything you can automate between PostgreSQL and Harvest.

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 Client Created

New Client Created

Trigger when new client is created

New User

New User

Trigger when user is created

New Contact

New Contact

Trigger when new contact is created

New Project

New Project

Trigger when new project is created

New Time entry

New Time entry

Trigger when new time entry is created

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.

Create a Client

Create a Client

Creates a new client

Update a Client

Update a Client

Update an existing client

Create a Contact

Create a Contact

Craete a new contact

Update a Contact

Update a Contact

Update an existing contact

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,000+ 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 Harvest free

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

Frequently Asked Questions

How do I connect PostgreSQL and Harvest?

Sign up for a free viaSocket account, then authorize both your PostgreSQL and Harvest 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 Harvest 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 Harvest?

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

Can the integration run in both directions?

Yes. You can set up a workflow where PostgreSQL triggers actions in Harvest, and a separate workflow where Harvest 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 Harvest. 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 Harvest integration is built through a visual, point-and-click interface. Code blocks are available if you want them, but they are never required.