Google Sheets + JustCall
Create multiple rows in Google Sheets for each answered call in JustCall
Turn every answered call in your JustCall app into a well-organized record with this automation. Once turned on, each new incoming call answer in JustCall will initiate the creation of multiple rows in your chosen Google Sheets spreadsheet. This ensures all call details are instantly and conveniently sorted, saving time and maintaining accurate records.
Turn every answered call in your JustCall app into a well-organized record with this automation. Once turned on, each new incoming call answer in JustCall will initiate the creation of multiple rows in your chosen Google Sheets spreadsheet. This ensures all call details are instantly and conveniently sorted, saving time and maintaining accurate records.
- When this happens...
Call AnsweredTriggers when a call answered an queue.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
AI Voice Agent Data Generated for Call
Trigger is only applicable for calls picked up by the JustCall AI Voice Agent and provides data associated with and collected by the Voice Agent.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Call Answered
Triggers when a call answered an queue.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Call Initiated
Triggers when a call initiated from JustCall.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.[Legacy] Incoming Call
Triggers for a new incoming call
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Incoming Caller Exits Queue
Triggers when an incoming call exits an queue.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Missed Call
Trigger when an incoming call is missed
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Call Completed
Triggers when a call ends and gets logged in your JustCall call logs. (For voicemails use New Voicemail trigger)
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact
Triggers when a new contact is added to your JustCall address book.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan[Legacy] New Text
Triggers when a new text is sent from (or received on) your JustCall numbers
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCall AI Report Generated (Sales Dialer)
Triggers when the AI-powered insights for a Sales Dialer call are generated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.SMS Received
Triggers when an SMS is received in JustCall (incoming only)
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Call Updated
Triggers when a call is updated(This event will only contain the keys for which the values of a call are actually updated).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.CampaignRequired
PhoneRequired
First Name
Last Name
Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Call IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer/Client NumberRequired
JustCall Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Campaign IDRequired
PhoneRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To NumberRequired
FromRequired
BodyRequired
Date & TimeRequired
Offset (in minutes)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To NumberRequired
FromRequired
BodyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact idRequired
First NameRequired
Last Name
Phone NumberRequired
Email
Company
Notes
Other Phone Label
Other Phone Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.phoneRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNo 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 found
Call AI Report Generated
Triggers when the AI-powered insights for a JustCall call are generated
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Call Completed (Sales Dialer)
Triggers when a call is completed in Sales Dialer.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Call Updated (Sales Dialer)
Triggers when a call is updated in Sales Dialer(This event will only contain the keys for which the values of a call are actually updated).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Incoming Caller Enters Queue
Triggers when an incoming call enters an queue.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Incoming Call
Triggers for a new incoming call
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Appointment
Triggers when a new appointment is scheduled via JustCall Appointment Scheduler (Public Calendar)
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan[Legacy] Call Ended
Triggers when a call ends and gets logged in your JustCall call logs. (For voicemails use New Voicemail trigger)
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planSMS Sent or Received
Triggers when a new text is sent from (or received on) your JustCall numbers
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Voicemail
Triggers whenever there is a new voicemail
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.SMS Delivery Status Updated
Triggers when an outgoing SMS gets delivered
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.SMS Sent
Triggers when an SMS is sent via JustCall (outgoing only)
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.[Legacy] Call Updated
Triggers when you add/update notes and disposition codes for a particular call
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.CampaignRequired
PhoneRequired
First Name
Last Name
Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer/Client NumberRequired
JustCall Number
Country Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.firstnameRequired
lastname
phoneRequired
email
company
notes
Agent ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To NumberRequired
FromRequired
Body
Media LinksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To NumberRequired
FromRequired
BodyRequired
Media LinksRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To NumberRequired
FromRequired
BodyRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact ID
phone
email
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
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
About Google Sheets
Related categories
About JustCall
Related categories
Related Zap Templates
- Add rows to Google sheets for new calls in JustCall
- Create new JustCall contacts from updated Google Sheets rows
- Add new texts from JustCall to Google Sheets as spreadsheet rows
- Add new JustCall voicemails to Google Sheets as rows
- Send text messages via JustCall for new Google Sheets rows
- Create text messages in JustCall for new spreadsheet rows (team drive) in Google Sheets
- Send text messages via JustCall for new or updated rows in Google Sheets
- Add new or updated Google Sheets rows to JustCall sales dialer campaigns
- Delete JustCall contacts from sales dialer campaign when new or updated rows appear in Google Sheets
- Create spreadsheet rows in Google Sheets for new appointments in JustCall
- Add new Google Sheets rows to JustCall sales dialer campaigns
- Log new JustCall incoming calls as rows in a Google Sheets spreadsheet
- Send text messages via JustCall for new or updated rows in Google Sheets team drive
- Log missed calls in JustCall to newly created rows in Google Sheets
- Update Google Sheets rows with new JustCall texts
- Log ended calls from JustCall into new Google Sheets spreadsheets
- Create spreadsheet rows in Google Sheets for updated calls in JustCall
- Log completed JustCall calls by creating respective rows in Google Sheets
- Create spreadsheet rows in Google Sheets for every sms received in JustCall
- Create new JustCall contacts from new or updated Google Sheets rows
- Send a text message with JustCall for new or updated rows in Google Sheets
- Log JustCall sent sms in Google Sheets by creating spreadsheet rows
- Log new JustCall calls as rows in a Google Sheets spreadsheet
- Send a text message in JustCall for each new spreadsheet row in Google Sheets
- Schedule text messages in JustCall for new rows in Google Sheets
- Send JustCall SMS messages for new Google Sheets rows
- Update Google Sheets rows when JustCall completes calls
- Create multiple rows in Google Sheets when new callers enter queue in JustCall
- Generate rows in Google Sheets for new calls data created by JustCall's ai voice agent
- Create multiple rows in Google Sheets for every new appointment in JustCall
- Add contacts to JustCall sales dialer campaign from new or updated rows in Google Sheets
Related Zap Templates
- Add rows to Google sheets for new calls in JustCall
- Add new JustCall voicemails to Google Sheets as rows
- Send text messages via JustCall for new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new appointments in JustCall
- Send text messages via JustCall for new or updated rows in Google Sheets team drive
- Log ended calls from JustCall into new Google Sheets spreadsheets
- Create spreadsheet rows in Google Sheets for every sms received in JustCall
- Log JustCall sent sms in Google Sheets by creating spreadsheet rows
- Schedule text messages in JustCall for new rows in Google Sheets
- Create multiple rows in Google Sheets when new callers enter queue in JustCall
- Add contacts to JustCall sales dialer campaign from new or updated rows in Google Sheets
- Create new JustCall contacts from updated Google Sheets rows
- Send text messages via JustCall for new Google Sheets rows
- Add new or updated Google Sheets rows to JustCall sales dialer campaigns
- Add new Google Sheets rows to JustCall sales dialer campaigns
- Log missed calls in JustCall to newly created rows in Google Sheets
- Create spreadsheet rows in Google Sheets for updated calls in JustCall
- Create new JustCall contacts from new or updated Google Sheets rows
- Log new JustCall calls as rows in a Google Sheets spreadsheet
- Send JustCall SMS messages for new Google Sheets rows
- Generate rows in Google Sheets for new calls data created by JustCall's ai voice agent
- Add new texts from JustCall to Google Sheets as spreadsheet rows
- Create text messages in JustCall for new spreadsheet rows (team drive) in Google Sheets
- Delete JustCall contacts from sales dialer campaign when new or updated rows appear in Google Sheets
- Log new JustCall incoming calls as rows in a Google Sheets spreadsheet
- Update Google Sheets rows with new JustCall texts
- Log completed JustCall calls by creating respective rows in Google Sheets
- Send a text message with JustCall for new or updated rows in Google Sheets
- Send a text message in JustCall for each new spreadsheet row in Google Sheets
- Update Google Sheets rows when JustCall completes calls
- Create multiple rows in Google Sheets for every new appointment in JustCall