Microsoft Excel + Sage Sales Management + Filter by Zapier

Microsoft Excel + Sage Sales Management integrations

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

The era of manually importing contacts is a thing of the past. Simply configure this Zap, and we'll handle the creation workflows for you. It will activate whenever you add a new row to an Excel spreadsheet, automatically generating an account, a contact and a task in ForceManager CRM with all the pertinent details.

When this happens...
New RowTriggers when a new row is added to a worksheet in a spreadsheet.
TriggerPolling
automatically do this...
Find ContactFinds a contact by email or phone number.
ActionSearch
then do this...
Only continue if...Set up rules to specify when this Zap can continue running.
ActionFilter
then do this...
Create AccountCreates a new account.
ActionWrite
then do this...
Create ContactCreates a new contact.
ActionWrite
then do this!
Create Calendar ItemCreates a new calendar item.
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 Microsoft Excel, Sage Sales Management, and more

- 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
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
- 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
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

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

Find accounts and create ForceManager CRM opportunities from new Microsoft Excel rows