Google Sheets + Strev

Google Sheets + Strev integrations

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.

When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Create CustomerCreates a customer on your account.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Google Sheets and Strev

Discover other triggers and actions you can use with Google Sheets and Strev

- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write

- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
- Company
  Required
Trigger
Polling
Try It
- Company
  Required
Trigger
Polling
Try It
- Company
  Required
Trigger
Polling
Try It
- Company
  Required
Trigger
Polling
Try It
- Company
  Required
Trigger
Polling
Try It
- Company
  Required
- Category Name
  Required
- Sub category (optional)
Action
Write
- Company ID
  Required
- Name
  Required
- 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
Action
Write
- Company ID
  Required
- Name
  Required
- 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
Action
Write
- Company ID
  Required
- Asset ID
  Required
- Name
  Required
- 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
Action
Write
- Company ID
- Customer ID
  Required
- Name
  Required
- 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
Action
Write
- Company ID
  Required
- File URL
  Required
- MultiFile
  Required
Action
Write
- Company
  Required
- Contract Name
  Required
Action
Search
- Company ID
  Required
- Asset Name
  Required
Action
Search
- Company ID
  Required
- Customer Name
  Required
Action
Search
- Company ID
  Required
- Supplier Name
  Required
Action
Search
- Company
  Required
- Serial Number
  Required
- Manufacturer Name (optional)
Action
Search
- Company ID
  Required
- Name
  Required
- Contract Type
  Required
- Number
  Required
- Parent Contract
- Customer ID
- Supplier ID
- Country Numeric Code
  Required
- Status
  Required
- Category ID
  Required
- Description
- Business Unit ID
- Contract Start Date
  Required
- Contract End Date
  Required
- Notice Period
- Service Start Date
- End of Term Clause
- End of Term Action
- Timeline Notes
- Total Contract Spend/Value
  Required
- 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
Action
Search or write
- Company ID
  Required
- Asset Name
  Required
- Name
  Required
- Contract ID
- Category ID
- Serial Number
- Address
- State/Province
- City
- Country Numeric Code
- Location Description
- Asset Location Address
- Pseudo Number
- 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 Forms
Action
Search or write
- Company ID
  Required
- Name
  Required
- 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
Action
Search or write
- Company ID
  Required
- Name
  Required
- 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
Action
Search or write
- Company ID
  Required
- Serial Number
  Required
- Manufacturer
- Name
  Required
- Contract ID
- Category ID
- Address
- State/Province
- City
- Country Numeric Code
- Location Description
- Asset Location Address
- Pseudo Number
- 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 Forms
Action
Search or write

- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
- Company
  Required
Trigger
Polling
Try It
- Company
  Required
Trigger
Polling
Try It
- Company
  Required
Trigger
Polling
Try It
- Company
  Required
Trigger
Polling
Try It
- Company ID
  Required
- Name
  Required
- Contract ID
- Category ID
- Serial Number
- Address
- State/Province
- City
- Country Numeric Code
- Location Description
- Asset Location Address
- Pseudo Number
- 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 Forms
Action
Write
- Company ID
  Required
- Contract Type
  Required
- Name
  Required
- Number
  Required
- Parent Contract
- Customer ID
- Supplier ID
- Country Numeric Code
  Required
- Status
  Required
- Category ID
  Required
- Description
- Business Unit ID
- Contract Start Date
  Required
- Contract End Date
  Required
- Notice Period
- Service Start Date
- End of Term Clause
- End of Term Action
- Timeline Notes
- Total Contract Spend/Value
  Required
- 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
Action
Write
- Company
  Required
- Hardware Model
  Required
Action
Write
- Company
  Required
- Contract Name
- Contract Number
Action
Write
- Company ID
  Required
- Contract ID
  Required
- Name
  Required
- Number
  Required
- 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
Action
Write
- Company ID
- Supplier ID
  Required
- Name
  Required
- Category ID
- Status
- 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
Action
Write
- Company ID
  Required
- Usage Status
  Required
Action
Write
- Company
  Required
- Serial Number
  Required
Action
Search
- Company ID
  Required
- Category Name
  Required
Action
Search
- Hardware Model Name
  Required
- Company
  Required
Action
Search
- Company ID
  Required
- Usage Status
  Required
Action
Search
- Company
- Country name
  Required
Action
Search
- Company ID
  Required
- Serial Number
  Required
- Name
  Required
- Contract ID
- Category ID
- Address
- State/Province
- City
- Country Numeric Code
- Location Description
- Asset Location Address
- Pseudo Number
- 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 Forms
Action
Search or write
- Company ID
  Required
- Category Name
  Required
- Company
  Required
- Category Name
  Required
- Sub category (optional)
Action
Search or write
- Hardware Model
  Required
- Company
  Required
Action
Search or write
- Company ID
  Required
- Usage Status
  Required
- Usage Status
  Required
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 moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About Strev

Strev is an asset management software that helps track, monitor and optimize assets with ease, turning complexity into clarity and give a full control.

HelpHelp

Related categories

IT Operations

Related Zap Templates

Create new Google Sheets spreadsheets for each new asset in Strev

Create new Strev assets from new or updated rows in Google Sheets