Google Sheets + JustCall

Log missed calls in JustCall to newly created rows in Google Sheets

Stay on top of your missed calls effectively using this simple workflow. When a call is missed in JustCall, the details are immediately logged into a new row in Google Sheets. By centralizing all crucial call data, it promotes easy access and quick response times for your follow-up actions.

When this happens...
Missed Call
Trigger when an incoming call is missed
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

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.
Trigger
Instant
Try It
Call Answered
Triggers when a call answered an queue.
Trigger
Instant
Try It
Call Initiated
Triggers when a call initiated from JustCall.
Trigger
Instant
Try It
[Legacy] Incoming Call
Triggers for a new incoming call
Trigger
Instant
Try It
Incoming Caller Exits Queue
Triggers when an incoming call exits an queue.
Trigger
Instant
Try It

Missed Call
Trigger when an incoming call is missed
Trigger
Instant
Try It
Call Completed
Triggers when a call ends and gets logged in your JustCall call logs. (For voicemails use New Voicemail trigger)
Trigger
Instant
Try It

New Contact
Triggers when a new contact is added to your JustCall address book.
Trigger
Polling
Try It
[Legacy] New Text
Triggers when a new text is sent from (or received on) your JustCall numbers
Trigger
Polling
Try It
SMS Delivery Status Updated
Triggers when an outgoing SMS gets delivered
Trigger
Instant
Try It
SMS Sent
Triggers when an SMS is sent via JustCall (outgoing only)
Trigger
Instant
Try It
[Legacy] Call Updated
Triggers when you add/update notes and disposition codes for a particular call
Trigger
Instant
Try It
- CampaignRequired
- PhoneRequired
- First Name
- Last Name
- Email
Action
Write
- Customer/Client NumberRequired
- JustCall Number
- Country Code
Action
Write
- firstnameRequired
- lastname
- phoneRequired
- email
- company
- notes
- Agent ID
Action
Write
- To NumberRequired
- FromRequired
- Body
- Media LinksRequired
Action
Write
- To NumberRequired
- FromRequired
- BodyRequired
- Media LinksRequired
Action
Write
- To NumberRequired
- FromRequired
- BodyRequired
Action
Write
- Contact ID
- phone
- email
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
Action
Search or write

Call AI Report Generated
Triggers when the AI-powered insights for a JustCall call are generated
Trigger
Instant
Try It
Call Completed (Sales Dialer)
Triggers when a call is completed in Sales Dialer.
Trigger
Instant
Try It
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).
Trigger
Instant
Try It
Incoming Caller Enters Queue
Triggers when an incoming call enters an queue.
Trigger
Instant
Try It
New Incoming Call
Triggers for a new incoming call
Trigger
Instant
Try It
New Appointment
Triggers when a new appointment is scheduled via JustCall Appointment Scheduler (Public Calendar)
Trigger
Polling
Try It
[Legacy] Call Ended
Triggers when a call ends and gets logged in your JustCall call logs. (For voicemails use New Voicemail trigger)
Trigger
Polling
Try It
SMS Sent or Received
Triggers when a new text is sent from (or received on) your JustCall numbers
Trigger
Instant
Try It
New Voicemail
Triggers whenever there is a new voicemail
Trigger
Instant
Try It
SMS Received
Triggers when an SMS is received in JustCall (incoming only)
Trigger
Instant
Try It
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).
Trigger
Instant
Try It
- CampaignRequired
- PhoneRequired
- First Name
- Last Name
- Email
Action
Write
- Call IdRequired
Action
Write
- Customer/Client NumberRequired
- JustCall Number
Action
Write
- Campaign IDRequired
- PhoneRequired
Action
Write
- To NumberRequired
- FromRequired
- BodyRequired
- Date & TimeRequired
- Offset (in minutes)
Action
Write
- To NumberRequired
- FromRequired
- BodyRequired
Action
Write
- Contact idRequired
- First NameRequired
- Last Name
- Phone NumberRequired
- Email
- Company
- Notes
- Other Phone Label
- Other Phone Number
Action
Write
- phoneRequired
Action
Search
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- First row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

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

About JustCall

JustCall helps sales and support teams to connect easily with their leads & customers. We provide a cloud based service that allows you to make calls and send text messages.

Learn more

Related categories

Phone & SMS

Related Zap Templates

Log completed JustCall calls by creating respective rows in Google Sheets

Create spreadsheet rows in Google Sheets for every sms received in JustCall

Google Sheets + JustCall

Log missed calls in JustCall to newly created rows in Google Sheets

AI Voice Agent Data Generated for Call

Call Answered

Call Initiated

[Legacy] Incoming Call

Incoming Caller Exits Queue

Missed Call

Call Completed

New Contact

[Legacy] New Text

SMS Delivery Status Updated

SMS Sent

[Legacy] Call Updated

Add Contact to Sales Dialer Campaign

[Legacy] Check for Text Replies

Create Contact

[Legacy] Send a Multimedia Text Message

Send a Multi-Media Message

Send a Text Message

Find Contact

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Copy Worksheet

Create Worksheet

Delete Spreadsheet Row(s)

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

Call AI Report Generated

Call Completed (Sales Dialer)

Call Updated (Sales Dialer)

Incoming Caller Enters Queue

New Incoming Call

New Appointment

[Legacy] Call Ended

SMS Sent or Received

New Voicemail

SMS Received

Call Updated

[Legacy] Add to Sales Dialer Campaign

Get Voice Agent Data

Check Reply to SMS

Delete Contact From Sales Dialer Campaign

Schedule a Text Message

[Legacy] Send a Text Message

Update Contact

Find Contact in Sales Dialer

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Spreadsheet

Clear Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

About JustCall

Related categories

Related Zap Templates

Related Zap Templates