Close logo
PostgreSQL logo

Workflow template

Sync new Close leads to PostgreSQL

Upsert lead IDs and names into your CRM reporting table using a unique external_id column. Connect Close and PostgreSQL. Select a schema and an existing table, and match the mapped columns to your table. Enable the workflow once both sides are configured.

How it works

Workflow steps

1 Trigger · 1 Action
Close1 · Trigger

New lead

Start the Workflow when new lead occurs.

PostgreSQL2 · Action

Upsert the database row

Insert a row or update mapped columns when a unique key already exists. Use a stable key for repeatable delivery.

Before activation

Set up your workflow

  1. Copy the template

    Open the template in FastHook to create an editable Workflow Draft.

  2. Connect your accounts

    Connect your accounts for Close, PostgreSQL.

  3. Review the Workflow

    Review the Steps, field mappings, routes, and provider settings.

  4. Activate

    Activate the Workflow when the Draft is ready, then verify a test run.

Questions about this template

Does the template copy someone else's credentials?

No. FastHook creates a disconnected Draft. Connect your own Close, PostgreSQL accounts before activation.

Can I change the Steps and mappings?

Yes. The copied Workflow is an editable Draft. Review every Step, input, mapping, and route before you activate it.

What is copied into my workspace?

FastHook recreates the Trigger configuration, Action Steps, routes, and mappings with new IDs. Provider accounts, credentials, and secrets are never copied.

When does the Workflow start running?

Only after you connect the required accounts, finish the configuration, and explicitly activate the Draft.

Explore connected apps