Google Sheets + JustCall

Add rows to Google sheets for new calls in JustCall

With this integration, every new call made or received via JustCall will create a spreadsheet row, saving you tedious layout tasks. Automatically get ready to add important information once a call in JustCall ends, leaving you more time to monitor your call center agents by reading a Google Sheet.

When this happens...
Call Ended
Triggers when a call ends and gets logged in your JustCall call logs. (For voicemails use New Voicemail trigger)
TriggerScheduled
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Try this template

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

Supported triggers and actions

What does this mean?

New Appointment
Triggers when a new appointment is scheduled via JustCall Appointment Scheduler (Public Calendar)
Trigger
Scheduled
Try It
New Contact
Triggers when a new contact is added to your JustCall address book.
Trigger
Scheduled
Try It
New Voicemail
Triggers whenever there is a new voicemail
Trigger
Instant
Try It
- CampaignRequired
  Select your existing AutoDialer Campaign. You can create new campaigns from JustCall.io web portal.
- PhoneRequired
  Contact's Phone Number
- First Name
  Contact's First Name
- Last Name
  Enter Contact's Last Name
- Email
Action
Write
- firstnameRequired
  first name of the contact
- lastname
  last name of the contact
- phoneRequired
  phone number of the contact
- email
  email of the contact
- company
  company of the contact
- notes
  notes related to the contact
- Agent ID
  Will create this contact only under the specified agent associated with provided agentid
Action
Write

- To NumberRequired
  Enter the recipient's number
- FromRequired
  Please select a number to text from. You can add new numbers from JustCall.io web portal.
- Body
  Add the contents of your text message here.
- Media LinksRequired
  Comma seperated links of media files. Maximum 5 links are allowed. Links should be publicly accessible and their cumulative size should not exceed 5 MB
Action
Write
- To NumberRequired
  Enter the recipient's number
- FromRequired
  Please select a number to text from. You can add new numbers from JustCall.io web portal.
- BodyRequired
  Add the contents of your text message here.
Action
Write

- Contact ID
  Unique id of the contact
- phone
  Phone number of the contact
- email
  Email address associated with the contact
Action
Search
- No Team Drive
  If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
Trigger
Instant
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
- Trigger Column
  Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Trigger
Scheduled
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
  Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
  If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
- Background Color
  Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
- Text Color
  Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
- Text Bold
  True if the text is bold.
- Text Italic
  True if the text is italicized.
- Text Strikethrough
  True if the text is strikethrough.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.
- Lookup ValueRequired
- Supporting Lookup Column
  Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet?
- Row Count
  Number of rows to return. Max is 500.
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- ColumnsRequired
  Let us know which columns to return. e.g. A:Z
- Row CountRequired
  Number of rows to return. Max is 500.
- First Row
  Number of the first row to return (1 is the header)
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- TitleRequired
  Value of the Worksheet Title to match exactly. Search is case-sensitive.
- Headers
- Overwrite?
  If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
Action
Search or write

Call Ended
Triggers when a call ends and gets logged in your JustCall call logs. (For voicemails use New Voicemail trigger)
Trigger
Scheduled
Try It
New Text
Triggers when a new text is sent from (or received on) your JustCall numbers
Trigger
Scheduled
Try It
Call Updated
Triggers when you add/update notes and disposition codes for a particular call
Trigger
Instant
Try It
- Customer/Client NumberRequired
  The number from which you are expecting replies. This is generally your customer's number.
- JustCall Number
  One of your SMS enabled numbers on JustCall. If present, JustCall will only check for replies received on this number of yours.
- Country Code
  If your customer/client numbers are not in international format, use this field to send country code. For example US for United States, GB for United Kingdom etc.
Action
Write
- Campaign IDRequired
- PhoneRequired
Action
Write
- To NumberRequired
  Enter the recipient's number
- FromRequired
  Please select a number to text from. You can add new numbers from JustCall.io web portal.
- BodyRequired
  Add the contents of your text message here.
- Date & TimeRequired
  Your text message will go out on this date and at a particular time
- Offset (in minutes)
  Offset value is related to Date/Time. A positive offset value will add itself to scheduled date and time. Similarly, a negative value will subtract itself from schedule date and time. Ex - A value of +15 will send this text message 15 minutes after the scheduled date and time.
Action
Write
- Contact idRequired
  Unique id of the contact
- First NameRequired
  First name of the contact
- Last Name
  Last name of the contact
- Phone NumberRequired
  Phone number of the contact
- Email
  The email address associated with the contact
- Company
  Company with which this contact is associated
- Notes
  Custom information that you need to associate with this person
- Other Phone Label
  Custom name of the number
- Other Phone Number
  Phone number of the contact
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
Trigger
Scheduled
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Trigger
Scheduled
Try It
- No Team Drive
  If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers
- Trigger Column
  Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Trigger
Instant
Try It
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
  The column position (zero-based) to insert. If not set, append to the right by default.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
  Create a duplicate of an existing spreadsheet.
- Headers
  These Headers are ignored if a "Spreadsheet to Copy" is selected.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  Use a search step before this to get the row to delete.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
  If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
Action
Write
- Api Docs Info
  API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- TitleRequired
  Value of the Worksheet Title to match exactly. Search is case-sensitive.
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  Specify the column we should search for cells which match the Lookup Value.
- Lookup ValueRequired
- Supporting Lookup Column
  Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet? In other words, pick the most recent match?
Action
Search
- Drive
  The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
- SpreadsheetRequired
- WorksheetRequired
  You must have column headers. See here for more information.
- Lookup ColumnRequired
  Specify the column we should search for cells which match the Lookup Value.
- Lookup ValueRequired
- Supporting Lookup Column
  Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
- Supporting Lookup Value
  An example value might be me@example.com or 555-5555
- Bottom-Up
  Search from bottom of the sheet? In other words, pick the most recent match?
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.

Learn more

Related categories

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

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

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Google Sheets + JustCall

Add rows to Google sheets for new calls in JustCall

New Appointment

New Contact

New Voicemail

Add to Sales Dialer Campaign

CampaignRequired

PhoneRequired

First Name

Last Name

Email

Create Contact

firstnameRequired

lastname

phoneRequired

email

company

notes

Agent ID

Send a Multimedia Text Message

To NumberRequired

FromRequired

Body

Media LinksRequired

Send a Text Message

To NumberRequired

FromRequired

BodyRequired

Find Contact

Contact ID

phone

email

New Spreadsheet Row

No Team Drive

SpreadsheetRequired

WorksheetRequired

New or Updated Spreadsheet Row (Team Drive)

Drive

SpreadsheetRequired

WorksheetRequired

Trigger Column

New Worksheet

Drive

SpreadsheetRequired

Create Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

Copy Worksheet

Drive

Spreadsheet Containing the Worksheet to CopyRequired

Worksheet to CopyRequired

Copy To

Create Worksheet

Drive

SpreadsheetRequired

TitleRequired

Headers

Overwrite?

Format Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

Background Color

Text Color

Text Bold

Text Italic

Text Strikethrough

Update Spreadsheet Row(s)

Drive

SpreadsheetRequired

WorksheetRequired

Lookup Spreadsheet Rows (output as Line Items)

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column