Google Sheets + Strev
Create customers in Strev from new rows in Google Sheets
Google Sheets lets you compile and record hundreds and thousands of records easily. With this Zap in place, it's even more efficient. Once active, this integration will automatically add customers into Strev every time a new record is added to a row in a specified Google Sheets spreadsheet.
Google Sheets lets you compile and record hundreds and thousands of records easily. With this Zap in place, it's even more efficient. Once active, this integration will automatically add customers into Strev every time a new record is added to a row in a specified Google Sheets spreadsheet.
- 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 CustomerCreates a customer on your account.
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 ZapPollingZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
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 foundCompanyRequired
Category NameRequired
Sub category (optional)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company IDRequired
NameRequired
Category ID
Contact Person
Contact Email
Contact Type
Address Line 1
Address Line 2
City
State/Province
Zip/Postal Code
Country Numeric Code
Phone
Mobile
Fax
Website
General Description
NDA Signed
NDA Signed Date
MSA Signed
MSA Signed Date
Supplementary Description
Additional Description
Custom Field Template ID
Custom Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company IDRequired
NameRequired
Category ID
Contact Person
Contact Email
Contact Type
Address Line 1
Address Line 2
City
State/Province
Zip/Postal Code
Country Numeric Code
Phone
Mobile
Fax
Website
General Description
Type
Business Name
Business Address Line 1
Business Address Line 2
Business City
Business State/Province
Business Zip/Postal Code
Business Country Numeric Code
EIN
Financial Description
NDA Signed
NDA Signed Date
MSA Signed
MSA Signed Date
Supplementary Description
Additional Description
Custom Field Template ID
Custom Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company IDRequired
Asset IDRequired
NameRequired
Contract ID
Category ID
Manufacturer
Serial Number
Address
City
Country Numeric Code
Location Description
Asset Owner ID
Business Unit ID
Warranty Type
Warranty Provider ID
End of Life Date
Warranty Start Date
Warranty End Date
Warranty Contact Phone
Warranty Contact Email
Warranty Notes
Support Type
Support Provider ID
Asset Supplier
End of Support Date
Support Start Date
Support End Date
Support Contact Phone
Support Contact Email
Support Notes
Usage Status
Asset Tag
Asset Notes
Original Cost
Service Start Date
Depreciation Schedule
Estimated Salvage Value
Financial Notes
Customer Part Number
Manufacturer Part Number
Hardware Model
Sales Manager Name
Sales Manager Email
Additional Sales Email
Contract Service per Item
Asset Location Address
Currency Name
Currency Symbol
New Hardware Selling Unit Price
Manufacturer Currency Name
Manufacturer Currency Symbol
Manufacturer Warranty Unit Price
Custom Field Template ID
Custom Form Template ID
Custom Fields
Custom Form Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company ID
Customer IDRequired
NameRequired
Category ID
Contact Person
Contact Email
Contact Type
Address Line 1
Address Line 2
City
State/Province
Zip/Postal
Country Numeric Code
Phone
Mobile
Fax
Website
General Description
NDA Signed
NDA Signed Date
MSA Signed
MSA Signed Date
Supplementary Description
Additional Description
Custom Field Template ID
Custom Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company IDRequired
File URLRequired
MultiFileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CompanyRequired
Contract NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany IDRequired
Asset NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany IDRequired
Customer NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany IDRequired
Supplier NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompanyRequired
Serial NumberRequired
Manufacturer Name (optional)
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany IDRequired
NameRequired
Contract TypeRequired
NumberRequired
Parent Contract
Customer ID
Supplier ID
Country Numeric CodeRequired
StatusRequired
Category IDRequired
Description
Business Unit ID
Contract Start DateRequired
Contract End DateRequired
Notice Period
Service Start Date
End of Term Clause
End of Term Action
Timeline Notes
Total Contract Spend/ValueRequired
MRC
NRC
Expenditure Type
CapEx (actual)
OpEx (actual)
Payment Terms
Financing
Financial Notes
First Offer Value
Cost Avoidance Value
Contract Risk Value
Custom Field Template ID
Custom Fields
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCompany IDRequired
Asset NameRequired
NameRequired
Contract ID
Category ID
Serial Number
Address
State/Province
City
Country Numeric Code
Location Description
Asset Location Address
Asset Supplier
Asset Owner ID
Business Unit ID
Warranty Type
Warranty Provider ID
End of Life Date
Warranty Start Date
Warranty End Date
Warranty Contact Phone
Warranty Contact Email
Warranty Notes
Support Type
Support Provider ID
End of Support Date
Support Start Date
Support End Date
Service Start Date
Support Contact Phone
Support Contact Email
Support Notes
Usage Status
Asset Tag
Asset Notes
Original Cost
Depreciation Schedule
Estimated Salvage Value
Financial Notes
Manufacturer
Parent Manufacturer Part Number
Parent Serial Number
Customer Part Number
Manufacturer Part Number
Hardware Model
Sales Manager Name
Sales Manager Email
Additional Sales Email
Contract Service Per Item
Currency Name
Currency Symbol
New Hardware Selling Unit Price
Manufacturer Currency Name
Manufacturer Currency Symbol
Manufacturer Warranty Unit Price
Custom Field Template ID
Custom Fields
Custom Form Template ID
Custom Form Fields
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCompany IDRequired
NameRequired
Category ID
Contact Person
Contact Email
Contact Type
Address Line 1
Address Line 2
City
State/Province
Zip/Postal Code
Country Numeric Code
Phone
Mobile
Fax
Website
General Description
NDA Signed
NDA Signed Date
MSA Signed
MSA Signed Date
Supplementary Description
Additional Description
Custom Field Template ID
Custom Fields
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCompany IDRequired
NameRequired
Category ID
Contact Person
Contact Email
Contact Type
Address Line 1
Address Line 2
City
State/Province
Zip/Postal Code
Country Numeric Code
Phone
Mobile
Fax
Website
General Description
Type
Business Name
Business Address Line 1
Business Address Line 2
Business City
Business State/Province
Business Zip/Postal Code
Business Country Numeric Code
EIN
Financial Description
NDA Signed
NDA Signed Date
MSA Signed
MSA Signed Date
Supplementary Description
Additional Description
Custom Field Template ID
Custom Fields
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCompany IDRequired
Serial NumberRequired
Manufacturer
NameRequired
Contract ID
Category ID
Address
State/Province
City
Country Numeric Code
Location Description
Asset Location Address
Asset Supplier
Asset Owner ID
Business Unit ID
Warranty Type
Warranty Provider ID
End of Life Date
Warranty Start Date
Warranty End Date
Warranty Contact Phone
Warranty Contact Email
Warranty Notes
Support Type
Support Provider ID
End of Support Date
Support Start Date
Support End Date
Service Start Date
Support Contact Phone
Support Contact Email
Support Notes
Usage Status
Asset Tag
Asset Notes
Original Cost
Depreciation Schedule
Estimated Salvage Value
Financial Notes
Parent Manufacturer Part Number
Parent Serial Number
Customer Part Number
Manufacturer Part Number
Hardware Model
Sales Manager Name
Sales Manager Email
Additional Sales Email
Contract Service Per Item
Currency Name
Currency Symbol
New Hardware Selling Unit Price
Manufacturer Currency Name
Manufacturer Currency Symbol
Manufacturer Warranty Unit Price
Custom Field Template ID
Custom Fields
Custom Form Template ID
Custom Form Fields
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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCompany IDRequired
NameRequired
Contract ID
Category ID
Serial Number
Address
State/Province
City
Country Numeric Code
Location Description
Asset Location Address
Asset Supplier
Asset Owner ID
Business Unit ID
Warranty Type
Warranty Provider ID
End of Life Date
Warranty Start Date
Warranty End Date
Warranty Contact Phone
Warranty Contact Email
Warranty Notes
Support Type
Support Provider ID
End of Support Date
Support Start Date
Support End Date
Service Start Date
Support Contact Phone
Support Contact Email
Support Notes
Usage Status
Asset Tag
Asset Notes
Original Cost
Depreciation Schedule
Estimated Salvage Value
Financial Notes
Manufacturer
Parent Manufacturer Part Number
Parent Serial Number
Customer Part Number
Manufacturer Part Number
Hardware Model
Sales Manager Name
Sales Manager Email
Additional Sales Email
Contract Service Per Item
Currency Name
Currency Symbol
New Hardware Selling Unit Price
Manufacturer Currency Name
Manufacturer Currency Symbol
Manufacturer Warranty Unit Price
Custom Field Template ID
Custom Fields
Custom Form Template ID
Custom Form Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company IDRequired
Contract TypeRequired
NameRequired
NumberRequired
Parent Contract
Customer ID
Supplier ID
Country Numeric CodeRequired
StatusRequired
Category IDRequired
Description
Business Unit ID
Contract Start DateRequired
Contract End DateRequired
Notice Period
Service Start Date
End of Term Clause
End of Term Action
Timeline Notes
Total Contract Spend/ValueRequired
MRC
NRC
Expenditure Type
CapEx (actual)
OpEx (actual)
Payment Terms
Financing
Financial Notes
First Offer Value
Cost Avoidance Value
Contract Risk Value
Custom Field Template ID
Custom Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CompanyRequired
Hardware ModelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CompanyRequired
Contract Name
Contract Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company IDRequired
Contract IDRequired
NameRequired
NumberRequired
Customer ID
Supplier ID
Country Numeric Code
Status
Category ID
Description
Business Unit ID
Contract Start Date
Contract End Date
Notice Period
Service Start Date
End of Term Clause
End of Term Action
Timeline Notes
Total Contract Spend/Value
MRC
NRC
Expenditure Type
CapEx (actual)
OpEx (actual)
Payment Terms
Financing
Financial Notes
Custom Field Template ID
Custom Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company ID
Supplier IDRequired
NameRequired
Category ID
Contact Person
Contact Email
Contact Type
Address Line 1
Address Line 2
City
State/Province
Zip/Postal
Country Numeric Code
Phone
Mobile
Fax
Website
General Description
Type
Business Name
Business Address Line 1
Business Address Line 2
Business City
Business State/Province
Business Zip/Postal Code
Business Country Numeric Code
EIN
Financial Description
NDA Signed
NDA Signed Date
MSA Signed
MSA Signed Date
Supplementary Description
Additional Description
Custom Field Template ID
Custom Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company IDRequired
Usage StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CompanyRequired
Serial NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany IDRequired
Category NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appHardware Model NameRequired
CompanyRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany IDRequired
Usage StatusRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany
Country nameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany IDRequired
Serial NumberRequired
NameRequired
Contract ID
Category ID
Address
State/Province
City
Country Numeric Code
Location Description
Asset Location Address
Asset Supplier
Asset Owner ID
Business Unit ID
Warranty Type
Warranty Provider ID
End of Life Date
Warranty Start Date
Warranty End Date
Warranty Contact Phone
Warranty Contact Email
Warranty Notes
Support Type
Support Provider ID
End of Support Date
Support Start Date
Support End Date
Service Start Date
Support Contact Phone
Support Contact Email
Support Notes
Usage Status
Asset Tag
Asset Notes
Original Cost
Depreciation Schedule
Estimated Salvage Value
Financial Notes
Manufacturer
Parent Manufacturer Part Number
Parent Serial Number
Customer Part Number
Manufacturer Part Number
Hardware Model
Sales Manager Name
Sales Manager Email
Additional Sales Email
Contract Service Per Item
Currency Name
Currency Symbol
New Hardware Selling Unit Price
Manufacturer Currency Name
Manufacturer Currency Symbol
Manufacturer Warranty Unit Price
Custom Field Template ID
Custom Fields
Custom Form Template ID
Custom Form Fields
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCompany IDRequired
Category NameRequired
CompanyRequired
Category NameRequired
Sub category (optional)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundHardware ModelRequired
CompanyRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCompany IDRequired
Usage StatusRequired
Usage StatusRequired
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
