Microsoft Excel + Simpro

Update Microsoft Excel rows when Simpro customers are updated

Keep your client information consistently up-to-date with this workflow. When customer details are modified in Simpro, it instantly adds a new row in your Microsoft Excel spreadsheet, facilitating real-time data updates. This not only reduces manual tracking but also enhances data accuracy, simplifying your task management while saving time and effort. Experience a seamless process and stay updated with key client changes effortlessly.

When this happens...
Company Customer Updated
Triggers when a company customer is updated.
TriggerInstant
automatically do this!
Add Row
Adds a new row to the end of a worksheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

What does this mean?

New Company Customer
Triggers when a company customer is created.
Trigger
Instant
Try It
New Individual Customer
Triggers when an individual customer is created.
Trigger
Instant
Try It
New Job
Triggers when a job is created.
Trigger
Instant
Try It
New Quote
Triggers when a quote is created.
Trigger
Instant
Try It
New Schedule
Triggers when a job, lead, quote or activity schedule is created.
Trigger
Instant
Try It

New Site
Triggers when a site is created.
Trigger
Instant
Try It
- Company NameRequired
- Preferred Techs
- Phone
- Do Not Call
- Alt Phone
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
- Email
- EIN
- Website
- Fax
- Company Number
Action
Write

- Title
- Given NameRequired
- Family NameRequired
- Preferred Techs
- Phone
- Do Not Call
- Alt Phone
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
- Email
- Cell Phone
Action
Write
- CustomerRequired
- SiteRequired
- Cost CenterRequired
- Customer Contact
- Additional Contacts
- Site Contact
- Description
- Notes
- Salesperson
- Project Manager
- Technicians
- Date Issued
- Due Date
- Validity Days
- Order No
- Name
- Stage
- Year
- Month
- Percent
- Status
- Tags
- Auto Adjust Status
- Catalog
- Billable Status
- Estimated Time
- Fit Time
- Base Price
- Markup
- Sales Tax Code
- Sell Price
- Quantity
- Income Account
- Type
- Rate
- Markup
- Sales Tax Code
- Time (Hours)
- Income Account
- Type
- Billable Status
- Description
- Estimated Cost
- Markup
- Estimated Time
- Sales Tax Code
- Actual Cost
- Actual Cost Date
- Sell Price
- Quantity
- Income Account
- Prebuild
- Billable Status
- Estimated Time
- Fit Time
- Base Price
- Markup
- Sales Tax Code
- Sell Price
- Quantity
- Income Account
- Service Fee
- Billable Status
- Fit Time
- Base Price
- Markup
- Sales Tax Code
- Sell Price
- Income Account
Action
Write
- NameRequired
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Billing Contact
- Contact
- Title
- Given Name
- Family Name
- Email
- Work Phone
- Cell Phone
- Fax
- Position
- Preferred Notification Method
- Public Notes
- Private Notes
- Zone
- Preferred Technicians
- Customers
- STC Zone
- VEEC Zone
Action
Write
- ID
- Order No
- Name
Action
Search
- ID
- Name
- Address
- City
- State
- Postal Code
- Country
Action
Search
- ID
- Phone
- Cell Phone
- Alt Phone
- Email
Action
Search
- ID
- Email
- Work Phone
- Cell Phone
- Alt Phone
- Title
- Given NameRequired
- Family Name
- Fax
- Department
- Position
- Notes
Action
Search or write
- ID
- Company NameRequired
- Phone
- Alt Phone
- Email
- EIN
- Website
- Fax
- Company Number
- Preferred Techs
- Do Not Call
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
Action
Search or write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

Company Customer Updated
Triggers when a company customer is updated.
Trigger
Instant
Try It
Individual Customer Updated
Triggers when an individual customer is updated.
Trigger
Instant
Try It
Job Updated
Triggers when a job is updated.
Trigger
Instant
Try It
Quote Updated
Triggers when a quote is updated.
Trigger
Instant
Try It
Schedule Updated
Triggers when a job, lead, quote or activity schedule is updated.
Trigger
Instant
Try It
Site Updated
Triggers when a site is updated.
Trigger
Instant
Try It
- Title
- Given NameRequired
- Family Name
- Email
- Work Phone
- Fax
- Cell Phone
- Department
- Position
- Notes
- Alt Phone
Action
Write
- CustomerRequired
- SiteRequired
- Cost Center
- Customer Contact
- Additional Contacts
- Site Contact
- Order No
- Name
- Description
- Notes
- Date Issued
- Due Date
- Due Time
- Tags
- Salesperson
- Project Manager
- Technician
- Stage
- Status
- Response Time
- Auto Adjust Status
Action
Write
- StaffRequired
- Date
- Start TimeRequired
- End TimeRequired
- Schedule RateRequired
- Notes
- Locked
- Type
Action
Write
- ID
- Email
- WorkPhone
- CellPhone
- AltPhone
Action
Search
- ID
- Staff
- Date
- Type
Action
Search
- ID
- Company Name
- Phone
- Alt Phone
- Email
- EIN
- Website
- Fax
- Company Number
Action
Search
- ID
- Order No
- Name
Action
Search
- ID
- NameRequired
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Billing Contact
- Contact
- Title
- Given Name
- Family Name
- Email
- Work Phone
- Cell Phone
- Fax
- Position
- Preferred Notification Method
- Public Notes
- Private Notes
- Zone
- Preferred Technicians
- Customers
- STC Zone
- VEEC Zone
Action
Search or write
- ID
- Phone
- Cell Phone
- Alt Phone
- Email
- Title
- Given NameRequired
- Family NameRequired
- Preferred Techs
- Do Not Call
- Address
- City
- State
- Postal Code
- Country
- Address
- City
- State
- Postal Code
- Country
- Customer Type
- Tags
- Part Tax Code
- Discount Fee
- Notes
- Customer Profile
- Customer Group
- Account Manager
- Currency
- Account Name
- Routing No
- Account No
- Payment Method
- Credit Limit
- On Stop
- Vendor Order No Required
- Archived
- Sites
Action
Search or write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
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.

Related categories

Similar apps

About Simpro

Simpro is a field service and job management software package. Optimize workflow processes & field service operations for trade businesses.

Related categories

Project Management

Related Zap Templates

Add rows in Microsoft Excel whenever new schedules are created in Simpro

Add new rows in Microsoft Excel for every new job in Simpro

Add new Simpro jobs to Microsoft Excel rows instantly

Microsoft Excel + Simpro

Update Microsoft Excel rows when Simpro customers are updated

New Company Customer

New Individual Customer

New Job

New Quote

New Schedule

New Site

Create Company Customer

Create Individual Customer

Create Service Quote

Create Site

Find Quote

Find Site

Find Individual Customer

Find or Create Contact

Find or Create Company Customer

New Row

New Worksheet

Add Row

Add Row to Table

Update Row

Find Row(s)

Company Customer Updated

Individual Customer Updated

Job Updated

Quote Updated

Schedule Updated

Site Updated

Create Contact

Create Service Job

Create Schedule Block(s)

Find Contact

Find Schedule

Find Company Customer

Find Job

Find or Create Site

Find or Create Individual Customer

New Row in Table

Updated Row

Add Row(s)

Create Spreadsheet

Find Row

Find or Create Row

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

About Simpro

Related categories

Related Zap Templates

Related Zap Templates