Call Tools PCC + Google Sheets
Create Call Tools PCC contacts from new or updated Google Sheets rows
Keep your Call Tools PCC contact list up-to-date with this seamless workflow. When a new or updated row is detected in your Google Sheets spreadsheet, a contact will be created or updated in your Call Tools PCC app. Save time and stay organized, all in one smooth process.
Keep your Call Tools PCC contact list up-to-date with this seamless workflow. When a new or updated row is detected in your Google Sheets spreadsheet, a contact will be created or updated in your Call Tools PCC app. Save time and stay organized, all in one smooth process.
- When this happens...
New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - 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.Api Docs Info
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
Bottom-Up
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
Bottom-Up
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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Text Bold
Text Italic
Text 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
Bottom-Up
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
Headers
Overwrite?
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
Call Tools is a multi-channel cloud contact center and hosted pbx with a data centric focus.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsRelated Zap Templates
- Create contacts in Call Tools PCC for new Google Sheets rows
- Create contacts in Call Tools PCC from new or updated rows in Google Sheets team drive
- Create new contacts in Call Tools PCC from new 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