Brex + Google Sheets
Create Brex users from new Google Sheets rows (Team Drive)
This Zapier template creates Brex users from new Google Sheets rows in Team Drive. The column headers of the spreadsheet should be: 1) First name 2) Last name 3) Email 4) Manager 5) Department 6) Location.
This Zapier template creates Brex users from new Google Sheets rows in Team Drive. The column headers of the spreadsheet should be: 1) First name 2) Last name 3) Email 4) Manager 5) Department 6) Location.
- When this happens...
New Spreadsheet Row (Team Drive)Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create UserCreates a User
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 found
Pending Card Transactions
Triggers when a card has pending transactions
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Transfer Processed
Triggers when an incoming or outgoing transfer has been processed
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.UserRequired
Card Name
Card TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company NameRequired
Email
Phone
Payment Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.UserRequired
Monthly Limit (in USD)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Location NameRequired
Location Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Budget IDRequired
Budget Name
Budget Description
Owner User IDs
Member User IDs
Limit Amount
Currency
Limit Type
Spend Type
Start Date
End Date
Limit Visibility
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Vendor NameRequired
Email
Phone
Payment Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Record Limit
Next Cursor
From
To
ActionThis is an event a Zap performs.SearchFind existing data in your appDepartment Name to Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appBudget IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appUser IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Payment TypeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appLocation NameRequired
Location Description
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 foundTransfer Failed
Triggers when a transfer has failed
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Budget NameRequired
Budget Description
Parent Budget ID
Owner User IDs
Member User IDs
Period TypeRequired
Limit AmountRequired
Currency
Limit TypeRequired
Spend TypeRequired
Start Date
End Date
Limit VisibilityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
EmailRequired
Manager
Department
Location
User Role
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Department NameRequired
Department description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Card IDRequired
Recipient EmailRequired
Sender NameRequired
Message
Expiry
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.List Cash Accounts
Lists all the existing cash accounts with their status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Vendor name
Payment InstrumentRequired
AccountRequired
AmountRequired
Internal DescriptionRequired
External MemoRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User
Status
Manager
Department
Location
User Role
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Card IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appAccountRequired
Record Limit
Posted At Start
Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appEmailRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCard IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appLocation Name to Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDepartment NameRequired
Department description
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 Brex
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Create spreadsheet rows in Google Sheets for new Brex transfer processes
- Create Brex vendors for new Google Sheets rows
- Create Brex credit cards from new Google Sheets rows
- Create Brex cards from new rows in Google Sheets (Team Drive)
- Track pending Brex transactions by creating new rows in Google Sheets