Skip to content

ConnectWise integration

Connect Gabriel to ConnectWise PSA (formerly ConnectWise Manage) so your sales team and your service desk work from the same customer list. The integration works the same way as the Autotask integration, in two directions:

  • From ConnectWise to Gabriel: an admin imports companies, their contacts and their sites whenever they choose. Records you already have are skipped, so nothing is copied twice.
  • From Gabriel to ConnectWise: you push companies, contacts and opportunities to ConnectWise. With auto-sync on, later edits to linked records in Gabriel update ConnectWise too.

Edits made in ConnectWise after an import don’t flow back to Gabriel on their own.

An admin can set the integration up themselves under Settings > Integrations > PSA Integration, including during a trial. Setting it up and importing need the Manage organization settings permission. Once it’s connected, anyone who can edit a company or opportunity can push it.

In ConnectWise PSA, go to System > Members > API Members and create an API member. On its API Keys tab, add a key and copy the public key and private key. ConnectWise shows the private key only once.

You’ll also need:

  • Your site: the address you sign in at, such as na.myconnectwise.net.
  • Your company ID: the company you type on the ConnectWise sign-in page.

You don’t need a client ID. Gabriel supplies its own.

ConnectWise checks every request Gabriel makes against the API member’s security role, not your own. Give it a role with:

ConnectWise area Access What Gabriel uses it for
Companies: Company Maintenance Inquire, Add, Edit Importing companies, checking for duplicates and pushing companies
Companies: Contacts Inquire, Add, Edit Importing contacts, linking contacts already in ConnectWise, and pushing contacts
Sales: Opportunity Inquire, Add, Edit, Delete Pushing opportunities and their amounts (forecast items), and updating them with auto-sync
System: Member Maintenance Inquire Listing your members under Object owner mapping
System: Table Setup Inquire Reading company types, statuses, markets, stages and communication types
Finance: Billing Cycles Inquire (optional) Setting the billing cycle (monthly, quarterly, annual) on recurring amounts
  • Give access to all records, not only the API member’s own.
  • Delete is only for forecast items. Gabriel removes a forecast item it wrote when you delete the line item it came from. It never deletes companies, contacts or opportunities.
  • Import only? If you never push to ConnectWise, Inquire is enough.
  1. Go to Settings > Integrations > PSA Integration.
  2. If nothing is connected yet, click Set up ConnectWise.
  3. Enter the Site, Company ID, Public key and Private key.
  4. Click Test connection.

A successful test saves the credentials and turns on Enable integration, so you don’t need to save first. The page then shows a Connected status line and four tabs, as for Autotask: Import, Sync, Mappings and Connection. Each tab saves on its own with the bar at the bottom of the screen.

To change the private key later, open the Connection tab, type the new one and save. Leave it blank to keep the current one. Changing the site, company ID or public key needs the private key again.

On the Mappings tab, under Object owner mapping, match each Gabriel user to a ConnectWise user (a member), pick a Default owner for anyone unmapped, and click Save changes.

  • A company’s account manager becomes its territory manager in ConnectWise when the company is first created there.
  • An opportunity’s assignee becomes its sales rep. ConnectWise needs a sales rep on every opportunity, so set a Default owner before you push one.

On the Mappings tab, under Company type mapping, choose the ConnectWise company type for each Gabriel company type. The type is set when a company is first created in ConnectWise. Changing it later in Gabriel doesn’t change it in ConnectWise.

The Import tab works as it does for Autotask:

  • Import companies: choose the Company types to import (none ticked means every type), whether to Import contacts, Import locations (the company’s sites become its addresses) and Include inactive, then click Preview & select or Import all.
  • Import contacts: add filters such as Primary contact · is · Yes, or Contact type · is · Decision maker, then preview or import every match. A contact whose company isn’t in Gabriel brings the company with it.

Imports read from ConnectWise and never change anything there.

  1. Open the company and click … (more actions).
  2. Click Push to ConnectWise, or Sync to ConnectWise if it’s already linked.
  3. Choose Sync Contacts and Sync Opportunities, then click Continue.

If ConnectWise has a company with a similar name, you see Potential duplicate found: Link & Update links to it and overwrites its name, phone, website and address with Gabriel’s; Create New makes a new one.

A new company gets a ConnectWise identifier made from its name (letters and digits, up to 25 characters), with a number added if another company already uses it. Unlike Autotask, ConnectWise doesn’t need a phone number.

Open the opportunity, click …, then Push to ConnectWise. ConnectWise needs these before it creates an opportunity, and the option is greyed out with the reason until they’re in place:

  • An expected close date.
  • A primary contact that’s already in ConnectWise.
  • A sales rep: the assignee mapped to a member, or a Default owner.

If the company isn’t in ConnectWise yet, click Push to ConnectWise with company. It sends the company, the primary contact and the opportunity together.

A new opportunity starts in ConnectWise’s default stage and status. Later pushes don’t change the stage or status, so moving a deal along in ConnectWise is never undone by Gabriel.

On the Sync tab, turn on Enable auto-sync and click Save changes. Editing a linked company, contact or opportunity then updates it in ConnectWise. New records still need one manual push.

When an update fails, Gabriel marks the record as failed, stops updating it, and notifies every admin with the reason. Clicking the notification opens the Sync tab, where Sync issues lists each record that needs attention.

  • Failed: fix the cause, then click Retry.
  • ConnectWise never confirmed this create: the push may have arrived without Gabriel hearing back, so Gabriel won’t resend it and risk a duplicate. Click Resolve and search ConnectWise. If the record is there, enter its ID and click Link to ConnectWise ID. If not, click Mark not created, then Retry.

On the Connection tab, turn off Enable integration to pause imports, pushes and auto-sync, or click Disconnect to remove the saved credentials. Tick Also clear ConnectWise links only when you’re switching accounts or moving to Autotask. It can’t be undone: pushing a record again creates a new one in ConnectWise.

While records are linked, Gabriel refuses another ConnectWise account’s credentials (“These credentials belong to a different ConnectWise account”). Disconnect and clear the links first.

  • Company: name, phone, website and primary address, plus the type, status and territory manager on first push.
  • Contacts already in ConnectWise are linked, not copied. A contact on the ConnectWise company with the same email, or the same name where one has no email, is linked and updated.
  • Contact: name, title, active status, email and work phone. Gabriel updates the contact’s default email and work phone and leaves its other numbers and addresses alone.
  • Opportunity: name, notes, expected close date, company and contact, plus the sales rep, stage and status on first push.
  • Only what changed. After the first push, an update sends only the fields you changed in Gabriel since the last push, and nothing if you changed none. A field someone edits in ConnectWise stays as it is until that field is changed in Gabriel. A blank field in Gabriel never clears ConnectWise.
  • Opportunity amounts: ConnectWise keeps an opportunity’s money on its Forecast tab, so Gabriel writes forecast items there:
    • With line items, each line becomes a forecast item with its description, quantity, price and cost. A recurring line is sent as recurring revenue per billing cycle, over the line’s term (or the deal’s). Recurring items count by contract year and start when the deal closes: its expected close date, or the day it actually closed if that was later.
    • Without line items, the deal’s totals are sent: its MRR as one recurring item over the contract term, and its one-time fees (or its whole value, if it has no MRR or one-time split) as one one-time item.
    • Later pushes and auto-sync keep these items in step with Gabriel: editing, adding or removing a line item updates ConnectWise, and only the values that differ are sent. Forecast items you add in ConnectWise yourself are never touched.
    • Changed in ConnectWise? If someone edits one of Gabriel’s forecast lines in ConnectWise, Gabriel doesn’t overwrite it. The deal shows what changed (what it was, what ConnectWise has now, and Gabriel’s value) and its owner gets a notification. Choose Send Gabriel’s values to write Gabriel’s values to ConnectWise, or Keep ConnectWise’s to leave the line as it is until its amount changes in Gabriel.
    • Lines are sent as text. They aren’t linked to your ConnectWise product catalog.
  • A manually overridden deal value isn’t sent when the deal has line items. ConnectWise shows the sum of the lines.
  • Company type changes after the first push aren’t sent.
  • Opportunities, tickets and agreements can’t be imported.
  • Previews are capped at 100 companies and 500 contacts.
Message What to do
“Enter the ConnectWise site as a host name” Type just the address, such as na.myconnectwise.net, without https://.
“Enter the private key again when you change the site, company ID or public key” Type the private key again and save.
“Test the connection before turning the ConnectWise integration on” Click Test connection. A successful test turns it on.
“Autotask is connected” Disconnect Autotask first. Gabriel connects one PSA at a time.
“Its company hasn’t been synced yet” Push the opportunity’s company first.
“Its contact hasn’t been synced yet” Push the contact’s company with Sync Contacts on, or use Push to ConnectWise with company.
“No sales rep could be determined” Map the assignee, or set a Default owner, on the Mappings tab.
“These credentials belong to a different ConnectWise account” Disconnect with Also clear ConnectWise links ticked, then connect the new account.
“ConnectWise acceptance needs review” or “A ConnectWise create is already reserved” Resolve the record under Sync issues on the Sync tab.