Google Sheets + Simpro
Create new Simpro contacts from new rows in Google Sheets
Automate your contact management with this workflow. When you add a new row in your Google Sheets, it instantly creates a new contact in your Simpro app. Save your time and stay organized by letting this automation handle your routine data entry tasks. No more toggling between apps, this workflow ensures your contact information remains consistent and current.
Automate your contact management with this workflow. When you add a new row in your Google Sheets, it instantly creates a new contact in your Simpro app. Save your time and stay organized by letting this automation handle your routine data entry tasks. No more toggling between apps, this workflow ensures your contact information remains consistent and current.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create ContactCreates a new contact.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Company Customer Updated
Triggers when a company customer is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Individual Customer Updated
Triggers when an individual customer is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Job Updated
Triggers when a job is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Quote Updated
Triggers when a quote is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Schedule Updated
Triggers when a job, lead, quote or activity schedule is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Site Updated
Triggers when a site is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Title
Given NameRequired
Family Name
Email
Work Phone
Fax
Cell Phone
Department
Position
Notes
Alt Phone
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.StaffRequired
Date
Start TimeRequired
End TimeRequired
Schedule RateRequired
Notes
Locked
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
Email
WorkPhone
CellPhone
AltPhone
ActionThis is an event a Zap performs.SearchFind existing data in your appID
Staff
Date
Type
ActionThis is an event a Zap performs.SearchFind existing data in your appID
Company Name
Phone
Alt Phone
Email
EIN
Website
Fax
Company Number
ActionThis is an event a Zap performs.SearchFind existing data in your appID
Order No
Name
ActionThis is an event a Zap performs.SearchFind existing data in your appID
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundID
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Company Customer
Triggers when a company customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Individual Customer
Triggers when an individual customer is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Job
Triggers when a job is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Quote
Triggers when a quote is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Schedule
Triggers when a job, lead, quote or activity schedule is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Site
Triggers when a site is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ID
Order No
Name
ActionThis is an event a Zap performs.SearchFind existing data in your appID
Name
Address
City
State
Postal Code
Country
ActionThis is an event a Zap performs.SearchFind existing data in your appID
Phone
Cell Phone
Alt Phone
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appID
Email
Work Phone
Cell Phone
Alt Phone
Title
Given NameRequired
Family Name
Fax
Department
Position
Notes
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundID
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
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Related categories
About Simpro
Related categories
Related Zap Templates
- Add new Simpro Service Jobs to Google Sheets
- Add newly updated service job details in Simpro to Google Sheet rows
- Create spreadsheet rows in Google Sheets for new schedules in Simpro
- Update Google Sheets spreadsheets when jobs are updated in Simpro
- Update Google Sheets rows as Simpro customers are updated
- Create spreadsheet rows in Google Sheets for new company customers in Simpro
- Create Google Sheets rows from new Simpro quotes
- Create service quotes in Simpro from new or updated rows in Google Sheets
- Create multiple spreadsheet rows in Google Sheets from new quotes in Simpro
- Create new rows in Google Sheets for every new Simpro customer