All integrationsAccounting & Finance

CaptivateIQ

Work with your CaptivateIQ commissions: add and update employees, keep data worksheet records such as deals in step, update quotas, list plans, period groups and payout dates, and export payout summaries.

actions
25
triggers
7

Triggers

Start a workflow when something happens in CaptivateIQ.

  • New employeeRuns when an employee is added to CaptivateIQ, with their employee ID, name, email and status. Employees already there when the workflow is turned on don't start it. CaptivateIQ is checked at most every 5 minutes.
  • Employee updatedRuns when an employee in CaptivateIQ is added or changed, such as made inactive or given a final process date. Each change starts it once; changes made before it was turned on don't. CaptivateIQ is checked at most every 5 minutes.
  • New userRuns when someone is given a CaptivateIQ user, with their email, role and whether they're an admin. Users already there when the workflow is turned on don't start it.
  • New worksheet recordRuns when a record, such as a deal, is added to a CaptivateIQ data worksheet, with its values by column name. Records already there when the workflow is turned on don't start it.
  • Worksheet record updatedRuns when a record in a CaptivateIQ data worksheet is added or changed, with its values by column name. Each change starts it once; changes made before it was turned on don't.
  • Payouts processedRuns when payouts are processed for a new payout date, for every plan or one you choose. Hand the date to 'Export payout summaries' to get each payee's payout. Dates already processed when the workflow is turned on don't start it.
  • Job finishedRuns when a CaptivateIQ job, such as an export or an import, finishes, with its status and an export's download link. Jobs finished before the workflow is turned on don't start it.

Actions

Steps a workflow can run in CaptivateIQ.

  • List organizationsList the CaptivateIQ organizations the connection's user belongs to.
  • List employeesList employees (the people paid commission), filtered by employee ID or name. Gets one page; to see more, run it again starting at the next offset it gives.
  • Get employeeGet one employee with their email, status and final process date.
  • Add employeeAdd an employee so they can be put on commission plans. CaptivateIQ also makes a user for them unless you link an existing one. An active employee takes a seat.
  • Update employeeChange an employee's ID, name, email, final process date or status. Only the fields given change.
  • Delete employeeDelete an employee. To stop paying someone but keep their record, make them inactive or give them a final process date with 'Update employee' instead.
  • List usersList the people who can sign in to CaptivateIQ, with their role and notification settings, filtered by email or name.
  • Get userGet one user with their role, status and notification settings.
  • List data worksheetsList data worksheets (the tables commissions are calculated from, such as deals) with their columns.
  • Get data worksheetGet one data worksheet with its columns and their data types.
  • List worksheet recordsList a data worksheet's records, searched or filtered by when they were added or changed. Shows the values loaded into the worksheet, not calculated columns.
  • Get worksheet recordGet one record of a data worksheet by its unique ID.
  • Add worksheet recordAdd a record to a data worksheet, such as a closed deal, with a value for each column. Include the worksheet's unique ID column.
  • Update worksheet recordChange some columns of a data worksheet record, found by its unique ID. Columns not given keep their values.
  • Delete worksheet recordDelete a record from a data worksheet by its unique ID.
  • List attribute worksheetsList attribute worksheets (values kept per employee or per plan over time, such as region or territory) with their columns.
  • List attribute worksheet recordsList an attribute worksheet's records, each with the dates its values apply, searched or filtered by those dates.
  • List commission plansList commission plans with their period groups and the dates payouts were processed for.
  • List period groupsList period groups (a plan's stretch of time, such as FY2026) with their plan and dates.
  • List employee assumptionsList employee assumptions: which employee is on which plan and when, with their plan values such as quota.
  • Update employee assumptionChange an employee assumption's dates, payout currency or plan values, such as their quota. Only what you give changes.
  • List payout datesList the dates payouts have been processed for, newest first.
  • Export payout summariesStart exporting payout summaries (each payee's payout) for up to five payout dates as a CSV file. Use 'Get job' with the job's ID to get the download link once it's done.
  • Get jobCheck a CaptivateIQ job, such as an export, and get its download link once it has finished.
  • List report modelsList report models with their worksheets and period dates.

Automate CaptivateIQ with Lodol.

Connect CaptivateIQ, then hand Lodol the job in Slack, Claude or ChatGPT.

We’re letting people in a few at a time.