Microsoft Excel + Sage Sales Management + Filter by Zapier

Microsoft Excel + Sage Sales Management integrations

Add rows to a Microsoft Excel table for new matched activity filters in ForceManager CRM

Effortlessly manage your sales activities with this convenient workflow that links ForceManager CRM and Microsoft Excel. When a new activity aligns with your selected filter in ForceManager CRM, this automation promptly inserts a row into the designated table within your Excel file. Stay in control of your sales process and guarantee that all essential data is readily available in a single centralized location.

When this happens...
New ActivityTriggers when a new activity is created.
TriggerInstant
automatically do this...
Only continue if...Set up rules to specify when this Zap can continue running.
ActionFilter
then do this!
Add Row to TableAdds a new row to the end of a specific table.
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 these apps

Discover other triggers and actions you can use with Sage Sales Management, Filter by Zapier, and more

Sales Order Updated
Triggers when a sales order is updated.
Trigger
Instant
Try It
Calendar Item Updated
Triggers when a calendar item is updated.
Trigger
Instant
Try It
New Activity
Triggers when a new activity is created.
Trigger
Instant
Try It
New Contact
Triggers when a new contact is created.
Trigger
Instant
Try It
New Sales Order
Triggers when a new sales order is created.
Trigger
Instant
Try It

Contact Updated
Triggers when a contact is updated.
Trigger
Instant
Try It
- List
  Required
- Description in Spanish
  Required
- Description in Brasilian Portuguese
- Description in German
- Description in Dutch
- Description in English
- Description in French
- Description in Italian
- Description in Portuguese
- Description in Russian
- Description in American English
- External ID
- ID Parent
- Order
- Str ID Environment
Action
Write

- Account ID
  Required
- Name
- Branch
- Owners
- Type
- Segment
- Status
- Vat Number
- Public
- Read Only
- Comments
- Phone
- Phone 2
- Phone 3
- Fax
- Email
- Website
- Address 1
- Address 2
- City
- Post Code
- Region
- Country
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- External ID
Action
Write
- Name
  Required
- Branch
  Required
- Owners
  Required
- Type
- Segment
- Status
- Vat Number
- Public
- Read Only
- Comments
- Phone Number 1
- Phone Number 2
- Phone Number 3
- Fax
- Email
- Website
- Address 1
- Address 2
- City
- Post Code
- Country
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- External ID
Action
Write
- Task or Event
  Required
- Contact
  Required
- Subject
  Required
- Owner
  Required
- Start Date
  Required
- End Date
  Required
- Start Hour
  Required
- End Hour
  Required
- Branch
  Required
- Account
- Opportunity
- All Day
- City
- Comment
- External ID
- Permission Level
- Read Only
- Reminder
- Send Notification
- Activity Type
- Completed
Action
Write
- Reference
  Required
- Owner
  Required
- Sales Probability
  Required
- Branch
  Required
- Status
  Required
- Type
- Total
- Sales Forecast Date
- Closed Date
- Won Date
- Lost Date
- Account 1
  Required
- Account 2
- Account 3
- Comment
- Address 1
- Address 2
- City
- Post Code
- Region
- Country
- Currency
- External ID
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- Read Only
Action
Write
- Contact
- First Name
- Last Name
- Account
- Gender
- Owner
- Type
- Address Line 1
- City
- Comment
- Country
- Email Address
- Email Address 2
- Email Address 3
- External ID
- Fax
- Linkedin
- Permission Level
- Phone Number 1
- Phone Number 2
- Post Code
- Read Only
- Region
- Skype
- Use Company Address
- Birthday
- Marketing Communications
Action
Write
- Calendar Item ID
  Required
- Task or Event
- Contact
- Subject
- Owner
- Start Date
- End Date
- Start Hour
- End Hour
- Branch
- Account
- Opportunity
- All Day
- City
- Comment
- External ID
- Permission Level
- Read Only
- Reminder
- Send Notification
- Activity Type
- Completed
Action
Write
- Opportunity ID
- Reference
- Owner
- Sales Probability
- Branch
- Status
- Type
- Total
- Sales Forecast Date
- Closed Date
- Won Date
- Lost Date
- Account 1
- Account 2
- Account 3
- Comment
- Address 1
- Address 2
- City
- Post Code
- Region
- Country
- Currency
- External ID
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- Read Only
Action
Write
- List
  Required
- Field Name
  Required
- Field Value
  Required
Action
Search
- Help
Action
Search
- Help
Action
Search
- Help
Action
Search
- Field Name
  Required
- Field Value
  Required
Action
Search
- Email or Phone
  Required
Action
Search
- External ID
  Required
Action
Search
- Field Name
  Required
- Field Value
  Required
Action
Search
- List
  Required
- Field Name
  Required
- Field Value
  Required
- Description in Spanish
  Required
- Description in Brasilian Portuguese
- Description in German
- Description in Dutch
- Description in English
- Description in French
- Description in Italian
- Description in Portuguese
- Description in Russian
- Description in American English
- External ID
- ID Parent
- Order
- Str ID Environment
Action
Search or write
- Field Name
  Required
- Field Value
  Required
- Name
  Required
- Branch
  Required
- Owners
  Required
- Type
- Segment
- Status
- Vat Number
- Public
- Read Only
- Comments
- Phone Number 1
- Phone Number 2
- Phone Number 3
- Fax
- Email
- Website
- Address 1
- Address 2
- City
- Post Code
- Country
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- External ID
Action
Search or write
- Email or Phone
  Required
- First Name
  Required
- Last Name
  Required
- Account
  Required
- Gender
- Owner
- Type
- Address 1
- City
- Comment
- Country
- Email Address
- Email Address 2
- Email Address 3
- External ID
- Fax
- Linkedin
- Permission Level
- Phone Number 1
- Phone Number 2
- Post Code
- Read Only
- Region
- Skype
- Use Company Address
- Birthday
- Marketing Communications
Action
Search or write
- External ID
  Required
- First Name
  Required
- Last Name
  Required
- Account
  Required
- Gender
- Owner
- Type
- Address 1
- City
- Comment
- Country
- Email Address
- Email Address 2
- Email Address 3
- External ID
- Fax
- Linkedin
- Permission Level
- Phone Number 1
- Phone Number 2
- Post Code
- Read Only
- Region
- Skype
- Use Company Address
- Birthday
- Marketing Communications
Action
Search or write
- Field Name
  Required
- Field Value
  Required
- Reference
  Required
- Owner
  Required
- Sales Probability
  Required
- Branch
  Required
- Status
  Required
- Type
- Total
- Sales Forecast Date
- Closed Date
- Won Date
- Lost Date
- Account 1
  Required
- Account 2
- Account 3
- Comment
- Address 1
- Address 2
- City
- Post Code
- Region
- Country
- Currency
- External ID
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- Read Only
Action
Search or write
- Only continue if...
  Required
Action
Filter
- 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
- 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

Activity Updated
Triggers when an activity is updated.
Trigger
Instant
Try It
New Account
Triggers when a new account is created.
Trigger
Instant
Try It
New Calendar Item
Triggers when a new calendar item is created.
Trigger
Instant
Try It
New Opportunity
Triggers when a new opportunity is created.
Trigger
Instant
Try It
Account Updated
Triggers when an account is updated.
Trigger
Instant
Try It
Opportunity Updated
Triggers when an opportunity is updated.
Trigger
Instant
Try It
- Status
  Required
- Account
- Account Address
- Branch
- Contact
- Currency
- Closed Date
- Archived
- Blocked
- Comment
- Discount 1
- Discount 2
- Discount 3
- Discount 4
- External ID
- Internal Comment
- Main Sales Order
- Opportunity
- Rate
- Read Only
- Reference
  Required
- Number
- Sales Forecast Date
- Owner
- Total
- Year
Action
Write
- Contact ID
  Required
- First Name
- Last Name
- Account
- Gender
- Owner
- Type
- Address 1
- City
- Comment
- Country
- Email Address
- Email Address 2
- Email Address 3
- External ID
- Fax
- Linkedin
- Permission Level
- Phone Number 1
- Phone Number 2
- Post Code
- Read Only
- Region
- Skype
- Use Company Address
- Birthday
- Marketing Communications
Action
Write
- Account
  Required
- Type
  Required
- Owner
  Required
- Date
  Required
- Contact
- Opportunity
- Check-in
- Check-in Type
- Checkout Date
- Comment
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- Read-only
- External ID
Action
Write
- First Name
  Required
- Last Name
  Required
- Account
  Required
- Gender
- Owner
- Type
- Address 1
- City
- Comment
- Country
- Email Address
- Email Address 2
- Email Address 3
- External ID
- Fax
- Linkedin
- Permission Level
- Phone Number 1
- Phone Number 2
- Post Code
- Read Only
- Region
- Skype
- Use Company Address
- Birthday
- Marketing Communications
Action
Write
- Account
- Name
- Branch
- Owners
- Type
- Segment
- Status
- Account Value Added Tax identification number
- Public
- Read-only Account
- Comments
- Phone Number 1
- Phone Number 2
- Phone Number 3
- Fax
- Email
- Website
- Address 1
- Address 2
- City
- Post Code
- Region
- Country
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- External ID
Action
Write
- Activity ID
  Required
- Account
- Type
- Owner
- Date
- Contact
- Opportunity
- Check-in
- Check-in Type
- Checkout Date
- Comment
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- Read Only
- External ID
Action
Write
- List
  Required
- Entity ID
  Required
- Description in Spanish
- Description in Brasilian Portuguese
- Description in German
- Description in Dutch
- Description in English
- Description in French
- Description in Italian
- Description in Portuguese
- Description in Russian
- Description in American English
- External ID
- ID Parent
- Order
- Str ID Environment
Action
Write
- Sales Order ID
  Required
- Status
- Account
- Account Address
- Branch
- Contact
- Currency
- Closed Date
- Archived
- Blocked
- Comment
- Discount 1
- Discount 2
- Discount 3
- Discount 4
- External ID
- Internal Comment
- Main Sales Order
- Opportunity
- Rate
- Read Only
- Reference
  Required
- Number
- Sales Forecast Date
- SalesRepId
- Total
- Year
Action
Write
- User ID
  Required
Action
Search
- Help
Action
Search
- Help
Action
Search
- Name, Email or Phone
  Required
Action
Search
- External ID
  Required
Action
Search
- Field Name
  Required
- Field Value
  Required
Action
Search
- Opportunity Name
  Required
Action
Search
- Opportunity External Id
  Required
Action
Search
- Name, Email or Phone
  Required
- Name
  Required
- Branch
  Required
- Owners
  Required
- Type
- Segment
- Status
- Vat Number
- Public
- Read Only
- Comments
- Phone Number 1
- Phone Number 2
- Phone Number 3
- Fax
- Email
- Website
- Address 1
- Address 2
- City
- Post Code
- Country
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- External ID
Action
Search or write
- External ID
  Required
- Name
  Required
- Branch
  Required
- Owners
  Required
- Type
- Segment
- Status
- Vat Number
- Public
- Read Only
- Comments
- Phone Number 1
- Phone Number 2
- Phone Number 3
- Fax
- Email
- Website
- Address 1
- Address 2
- City
- Post Code
- Country
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- External ID
Action
Search or write
- Field Name
  Required
- Field Value
  Required
- First Name
  Required
- Last Name
  Required
- Account
  Required
- Gender
- Owner
- Type
- Address 1
- City
- Comment
- Country
- Email Address
- Email Address 2
- Email Address 3
- External ID
- Fax
- Linkedin
- Permission Level
- Phone Number 1
- Phone Number 2
- Post Code
- Read Only
- Region
- Skype
- Use Company Address
- Birthday
- Marketing Communications
Action
Search or write
- Reference
  Required
- Owner
  Required
- Sales Probability
  Required
- Branch
  Required
- Status
  Required
- Type
- Total
- Sales Forecast Date
- Closed Date
- Won Date
- Lost Date
- Account 1
  Required
- Account 2
- Account 3
- Comment
- Address 1
- Address 2
- City
- Post Code
- Region
- Country
- Currency
- External ID
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- Read Only
Action
Search or write
- Opportunity External Id
  Required
- Reference
  Required
- Owner
  Required
- Sales Probability
  Required
- Branch
  Required
- Status
  Required
- Type
- Total
- Sales Forecast Date
- Closed Date
- Won Date
- Lost Date
- Account 1
  Required
- Account 2
- Account 3
- Comment
- Address 1
- Address 2
- City
- Post Code
- Region
- Country
- Currency
- External ID
- Geocoded
- Geocoding Accuracy
- Latitude
- Longitude
- Permission Level
- Read Only
Action
Search or write
- 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

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

About Sage Sales Management

Sage Sales Management is a mobile CRM that allows you to measure, analyse and improve your sales team’s performance.

HelpHelp

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Forms

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

About Filter by Zapier

Only allow a Zap to proceed when a certain condition is met. For example, if you're sending a text message when you receive a new email, you could use a Filter that only sends a text message when the email received is from a certain address.

Learn moreLearn moreHelpHelp

Related categories

Developer Tools

Zapier

Related Zap Templates

Create rows in Microsoft Excel for new ForceManager opportunities

Create accounts, contacts, and calendar items in ForceManager CRM from new Microsoft Excel rows