Connect ComTrack and Google Sheets to power AI-driven automation
- No-code AI automation
- Full audit trails and controls
- SOC 2 and GDPR compliant
- Easy visual workflow builder
- 9,000+ apps, 450+ AI tools
- Free tier available
Launch your first automated workflow
Start with a template that brings ComTrack and Google Sheets together. Build enterprise-grade automation in minutes.
Our most popular template
Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works
Zapier makes it easy to integrate ComTrack with Google Sheets - no code necessary. See how you can get setup in minutes.
Choose a trigger
A trigger is the event that starts your Zap—like a "Boards: Card Archived" from ComTrack.
Add your action
An action happens after the trigger—such as "Create Spreadsheet Column" in Google Sheets.
You’re connected!
Zapier seamlessly connects ComTrack and Google Sheets, automating your workflow.
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
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
New ApplicationTriggers when a new application is created in ComTrack — from the disposition form, HealthSherpa import, or any other source. Polls up to every few minutes depending on your Zapier plan.
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.- First Name
- Last Name
- Middle Name
- Suffix
- Date of Birth
- Email
- Phone Number
- Language
- Street Address
- Street Address Line 2
- City
- State
- Postal Code
- County
- FIPS Code
- Policy Number
- Policy Holder Name
- Submit Date
- Effective Date
- Annual Premium
- Client Type
- New to Carrier
- Agent Name
- Agent NPN
- Referring Agent
- Medicare Number
- Medicaid Eligible
- Medicaid Number
- Needs Extra Help
- Part A Effective Date
- Part B Effective Date
- Confirmation Number
- HealthSherpa ID
- External ID
- Status
- Notes
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- 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.- 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- 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.- Api_docs_info
- 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
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023




93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Connect ComTrack and Google Sheets to integrate crucial parts of your business
With Zapier, you can integrate everything from basic data entry to end-to-end processes. Here are some of the business-critical workflows that people automate with Zapier.




