Google Sheets + Simpro

Create Google Sheets rows from new Simpro quotes

Stay organized and efficient with Simpro and Google Sheets by tracking new quotes in an easy-to-read format. Whenever a new quote is created in your Simpro account, this workflow will add a new row in your selected Google Sheets spreadsheet, keeping all your data neatly compiled and accessible. Perfect for businesses looking to streamline their quote handling process and improve record keeping.

When this happens...
New Quote
Triggers when a quote is created.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
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
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write

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
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more Help

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.

Help

Related categories

Project Management

Google Sheets + Simpro

Create Google Sheets rows from new Simpro quotes

New Company Customer

New Individual Customer

New Job

New Quote

New Schedule

New Site

Create Company Customer

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

Create Individual Customer

Title

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