Commissionly + Microsoft Excel

Commissionly + Microsoft Excel integrations

Create Commissionly opportunities when new rows are added to Microsoft Excel

If you are calculating commissions in Excel you can now use this automation to pass your row data though to Commissionly commissions calculation app. Each time a new row is added to your Excel spreadsheet and a new opportunity will be created and the commission calculated. You will have error-free and fast commission calculations.

When this happens...
New RowTriggers when a new row is added to a worksheet in a spreadsheet.
TriggerPolling
automatically do this!
Create/Update OpportunityUsed to create or update an opportunity in Commissionly. Remote Module and Remote ID fields must be in use for UPDATE to work and Remote Module should be be Opportunities.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Microsoft Excel and Commissionly

Discover other triggers and actions you can use with Microsoft Excel and Commissionly

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Column Index
  Required
- Apply To
- Header Preservation
Action
Write

- Plan Restrictions
- Storage_source
- Folder
- Title
  Required
- Column Headers
- Zap_step_id
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Write

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Row
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Search or write
New Opportunity
Triggers when a new opportunity is created in Commissionly.
Trigger
Polling
Try It
New Product
Triggers when a new product is created in Commissionly.
Trigger
Polling
Try It
- Name
  Required
- Email
- Phone Number
- Mobile Number
- Address
- State
- City
- Zipcode
- Country
- Additional Information
- Owner
- Remote Module
- Remote Id
Action
Write
- Event Name
- Owner
- Date Range
- Start Date
- End Date
- Status
- Won Date
- Description
- Remote Module
- Remote ID
Action
Write
- Product Name
  Required
- Product Category
- Salesprice
- Costprice
- Description
- Owner
- Remote Module
- Remote Id
Action
Write

- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Table
  Required
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Range
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- Apply To
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
- Column Headers
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- New Name
  Required
Action
Write
- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet Name
  Required
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet ID
  Required
- Row ID
  Required
- No_match_copy
Action
Search
- Plan Restrictions
- Storage_source
- Folder
- Workbook
  Required
- Worksheet
  Required
- Lookup Column
  Required
- Lookup Value
  Required
Action
Search or write
New Company/Account
Triggers when a new company added in Commissionly.
Trigger
Polling
Try It
New Person/Contact
Triggers when a new person (people) added in Commissionly.
Trigger
Polling
Try It
- Activity Name
- Owner
- Category
- Description
- Remote Module
- Remote Id
Action
Write
- Lastname
  Required
- Firstname
- Title
- Email
- Phonenumber
- Mobilenumber
- Address
- State
- City
- Zipcode
- Country
- Parent
- Additionalinformation
- Owner
- Remote Module
- Remote Id
Action
Write
- Parent
- Opportunity Name
  Required
- Owner
- Status
- Won Date
- Opportunity Value
- Order Type
- Description
- Remote Module
- Remote ID
Action
Write
- Table Name
  Required
Action
Write

About Commissionly

Commissionly is the cloud based sales commission software focused solely on the small to medium business sector.

HelpHelp

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Forms

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn moreLearn moreHelpHelp

Related categories

Microsoft

Spreadsheets

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents