Call Tools PCC + Google Sheets
Create new contacts in Call Tools PCC from new rows in Google Sheets team drive
Keep your contacts updated without manual efforts. Once you add a new row to your Google Sheets on Team Drive, this workflow ensures the same information gets added in the Call Tools PCC app. Streamline your communication process and keep your team on the same page with this efficient workflow.
Keep your contacts updated without manual efforts. Once you add a new row to your Google Sheets on Team Drive, this workflow ensures the same information gets added in the Call Tools PCC app. Streamline your communication process and keep your team on the same page with this efficient workflow.
- When this happens...
New Spreadsheet Row (Team Drive)Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create ContactCreates a new Contact
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 ZapScheduledZapier 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.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
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
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
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
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
New Phone Call
Triggers when a new phone call is created (after the call ends). Note that depending how fast the agent saves a call disposition, the agent selected call disposition might not be available on the Call object. Use the "Created Call Disposition" trigger instead of the agent call disposition id is needed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Support Case
Triggers when an agent in Call Tools creates a new support case with one of your callers. This is not a case opened with Call Tools support.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact Disposition Event
Triggers when a contact disposition is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Email Address
Triggers when a new email address is added to a contact. Does not trigger for bulk processes such as CSV contact imports.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Note
Triggers when an agent in Call Tools saves a new note on a contact.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Phone Number
Triggers when a new phone number is created and added to a contact. Does not trigger for bulk phone number creation on processes such as CSV import of contacts.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact Tag Event
Triggers when an agent adds or removes a tag on a contact. Does not trigger for bulk tag operations during a CSV contact import or a bulk update/tagging of contacts.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Bucket IDRequired
Contact IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EntryRequired
Scrub Existing Contacts
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
Contact Disposition
Last Call Agent Disposition
Ready [to Contact]
Status
Do Not Contact
Suppress Until [Future DateTime]
Owned By [User ID]
Add Tags
Remove Tags
Add To Buckets
Remove From Buckets
User Distribution Queue ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Call Disposition IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appContact Disposition IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appContact IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPhone Number 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 appPhone Number
Area Code
Ready
Status
Do Not Contact
Address
City
State
Zip Code (postal code)
County
Country
Contact Disposition ID
Last Agent Call Disposition ID
First Name
Last Name
Owned By User ID (uuid)
Last Call System Disposition
ActionThis is an event a Zap performs.SearchFind existing data in your appPhone NumberRequired
Contact ID
ActionThis is an event a Zap performs.SearchFind existing data in your appPhone NumberRequired
Add Tags
Add To Buckets
User Distribution Queue ID
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 ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
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
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
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
ColumnsRequired
Row CountRequired
First Row
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 foundNew Calendar Event
Triggers when a new calendar event is created by an agent in Call Tools.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Call Disposition Event
Triggers when a new call disposition is created by an agent in Call Tools.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact
Triggers when a individual new contact is created by an user or over the API. Does not trigger for bulk contact creation processes such as CSV imports of contacts.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Email
Triggers when a new email is sent by a agent in Call Tools.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Goal Achievement
Triggers when a new goal achievement is created by an agent or an automation in Call Tools.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Opportunity
Triggers when a new opportunity is created by an agent or automation in Call Tools.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New SMS
Triggers when a SMS message is sent or received within Call Tools.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Connector Button Click
Triggers when an agent clicks a connector button on the agent dashboard in Call Tools.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Add Tags
Add To Buckets
User Distribution Queue ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
Tag IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Calendar Event Type IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appContact IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appContact IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appContact IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTag 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 appPhone NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPhone Number
Area Code
Ready
Status
Do Not Contact
Address
City
State
Zip Code (postal code)
County
Country
Contact Disposition ID
Last Agent Call Disposition ID
First Name
Last Name
Owned By User ID (uuid)
Last Call System Disposition
Add Tags
Add To Buckets
User Distribution Queue ID
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 Call Tools PCC
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Create contacts in Call Tools PCC for new Google Sheets rows
- Create Call Tools PCC contacts from new or updated Google Sheets rows
- Create contacts in Call Tools PCC from new or updated rows in Google Sheets team drive
- Create new Call Tools PCC contacts from new or updated rows in Google Sheets
- Organize new Call Tools PCC contact disposition events by creating rows in Google Sheets