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

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

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

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 Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Create Spreadsheet

Clear Spreadsheet Row

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

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

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Copy Worksheet

Create Worksheet

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get many Spreadsheet Rows (Advanced)

Find or Create Worksheet

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About Simpro

Related categories

Related Zap Templates

Related Zap Templates