Create if/then rules in ComTrack when new Google Sheets rows are created
This integration automatically creates if/then rules in ComTrack whenever a new row is added to a connected Google Sheet. It eliminates the need for manual rule setup by turning spreadsheet data directly into automation logic. Each new row instantly becomes an actionable condition, ensuring your workflows stay up to date without extra effort.
- When this happens...

New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.TriggerInstant - automatically do this...

List Rule FoldersList all rule folders for dynamic dropdowns.ActionSearch - then do this!

Create RuleCreate a new rule.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Google Sheets and ComTrack
Discover other triggers and actions you can use with Google Sheets and ComTrack
- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_change_sheet_structure
- No_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.- Drive
- 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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- 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
Boards: Card ArchivedTriggers when a card is archived.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Boards: Card Moved to ListTriggers when a card is moved to a new list.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Boards: New BoardTriggers when a new board is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Boards: New ChecklistTriggers when a new checklist is created in a card.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Boards: New Label Added to CardTriggers when a label is added to a card.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Chats: New MentionTriggers when a new message mentions someone.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Agent Name
- Carrier
- Agent ID
- Agent NPN
- Statement Date
- Client Full Name
- Client First Name
- Client Middle Name Initial
- Client Last Name
- Carrier Member ID
- Policy Number
- Effective Date
- Prior Plan
- Termination Date
- Termination Reason
- Line
- Sub Line
- Plan Type
- Plan
- Contract
- PBP
- Member State
- Member County
- Premium
- Agent Split
- Comp Rate
- Lives
- Commission
- Expected Commission
- Commission Action
- Agent Comp Plan
- Agent Payroll
- Lock Pay
- Upline 1 Name
- Upline 1 Comp Plan
- Upline 1 Payroll
- Upline 2 Name
- Upline 2 Comp Plan
- Upline 2 Payroll
- Upline 3 Name
- Upline 3 Comp Plan
- Upline 3 Payroll
- Upline 4 Name
- Upline 4 Comp Plan
- Upline 4 Payroll
- Upline 5 Name
- Upline 5 Comp Plan
- Upline 5 Payroll
- Upline 6 Name
- Upline 6 Comp Plan
- Upline 6 Payroll
- Upline 7 Name
- Upline 7 Comp Plan
- Upline 7 Payroll
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Card IDRequired
- TitleRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Card IDRequired
- Label IDRequired
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.WriteCreate a new record or update an existing record in your app.- TitleRequired
- Description
- Background
- Icon
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Card IDRequired
- TitleRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Card IDRequired
- TextRequired
- Parent Comment ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Card IDRequired
- Board IDRequired
- List IDRequired
- Position
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Card IDRequired
- User IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Channel NameRequired
- Creator User IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Channel IDRequired
- Message IDRequired
- User ID (who is deleting)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Message IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ChannelRequired
- User ID to RemoveRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Recipient User IDRequired
- User ID (Author)Required
- Message TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Note
- FolderRequired
- Enabled
- Order
- Number of Conditions
- Then Action Field
- Then Action Formula
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- RuleRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- FileRequired
- FilenameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- FolderRequired
- Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Board ID
- List ID
- Card TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Checklist IDRequired
- Item Text
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- Email
ActionThis is an event a Zap performs.SearchFind existing data in your app- Search QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Full Name or Part of NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Agent Name
- Carrier
- Client Full Name
- Date
- Policy Number
ActionThis is an event a Zap performs.SearchFind existing data in your app- Folder
ActionThis is an event a Zap performs.SearchFind existing data in your app- Dummy Field
ActionThis is an event a Zap performs.SearchFind existing data in your app
- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Drive
- 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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data 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 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.Search or writeFind existing data in your app, or create a new record if no data is found
Boards: Card DueTriggers when a card is due.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Boards: Card UpdatedTriggers when a card is updated.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Boards: New CardTriggers when a new card is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Boards: New New Comment in CardTriggers when a new comment is added to a card.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Chats: New ChannelTriggers when a new channel is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Chats: New FileTriggers when a new file is posted in a message.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Chats: New Message Posted AnywhereTriggers when a new message is posted anywhere in the organization.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
Chats: New UserTriggers when a new user is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Card IDRequired
- FileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Card IDRequired
- TextRequired
- Parent Comment ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Card IDRequired
- User IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Original Board IDRequired
- New Board TitleRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- List IDRequired
- TitleRequired
- Description
- Position
- Due Date
- Start Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Checklist IDRequired
- TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Item IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Card IDRequired
- Label IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Card IDRequired
- Title
- Description
- Is Complete
- Due Date
- Start Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Channel NameRequired
- Creator User IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ChannelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ChannelRequired
- User ID to InviteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ChannelRequired
- User ID (Author)Required
- Message TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- FolderRequired
- Number of RulesRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- FolderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- RuleRequired
- Note
- Folder
- Enabled
- Order
- Number of Conditions
- Then Action Field
- Then Action Formula
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Board TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Card IDRequired
- Checklist Title
ActionThis is an event a Zap performs.SearchFind existing data in your app- Label NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Channel NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Email AddressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Agent Name
- Carrier
- Client Full Name
- Date
- Policy Number
ActionThis is an event a Zap performs.SearchFind existing data in your app- RuleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- FolderRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app




