Search
Close this search box.

How Zapier Works: Sending Voicemail Data to Google Sheets

Share This Post

How Zapier Works: Sending Voicemail Data to Google Sheets

Zapier Tutorial - Voicemail Received to Google Sheets - Call Log ExampleDo you need a better way to track the dozens of voicemails left for your business every day? We’ll show you how to automate the process of logging all your voicemails so you can track and reply to them easily.

This quick tutorial will show you how Zapier works alongside our Business Phone Plans by providing you with a useful example: linking the VirtualPBX Zapier App with Google Sheets.

With only a few minutes of setup, you can log every message that’s left on your company voicemail boxes. Then you can take action on them, for instance, by marking them as answered or creating reports to view trends about voicemails left during certain times of year.

Zapier uses an Action-Reaction format. In this Zap:

  1. Action: Your VirtualPBX account receives a voicemail
  2. Reaction: Zapier prints that voicemail’s data into a Google Sheet

You can follow along in this tutorial by starting from the top or moving to the individual sections below:

  1. Common Use Cases
  2. Preparation of Materials
  3. Start a Zap (Configure VirtualPBX)
  4. Choose Zap Output (Configure Google Sheets)

Common Use Cases

Easily View the Count of Messages Left After Hours

See if Repeat Callers Are Missing Your Team

Show Sales the Frequency of Messages Left

Find Most Popular Voicemail Boxes


Preparation

You will need to create a Google Sheet that’s labeled to accept voicemail data like Call ID and Timestamp. The quickest way to do this is by copying our Google Sheet template.

Open the file linked above. Then click File in the menu at the top of your screen. Click Make a copy in the following drop-down menu to save the Sheet to your own Google Drive.


Action

On your Zapier home screen, you will first need to select the Make a Zap button to create a new project.

Zapier Tutorial - Voicemail Received to Google Sheets - Start a Zap

A new screen will load. This is where you begin working through the steps of your Zap. As your first step, you can select the VirtualPBX Zapier integration.

Zapier Tutorial - Voicemail Received to Google Sheets - Zap Step 1

Make sure you select the VirtualPBX 1.0.6 integration version. The Choose App & Event section of this step can always be changed.

Zapier Tutorial - Voicemail Received to Google Sheets - Change App and Event

Your Trigger Event in this Zap will be the New Voicemail option. This selection will tell your Zap to trigger a reaction when a caller leaves a voicemail on your account.

Zapier Tutorial - Voicemail Received to Google Sheets - Select Voicemail Received

Then enter your VirtualPBX Account credentials and hit Continue to proceed to the next step (adding your Google Sheet).

Zapier Tutorial - Voicemail Received to Google Sheets - Select VirtualPBX Account


Reaction

As your second step – your Reaction – click the plus sign on your screen and choose your App (Google Sheets) and Action Event (Lookup Spreadsheet Row).

Your selection of Lookup Spreadsheet Row here will allow you to search for existing data and complete new lines if that data isn’t found. Here, you will search for an existing call by its unique ID. If that call isn’t listed in your spreadsheet log, Zapier will output the new call’s data in your Sheet.

Zapier Tutorial - Voicemail Received to Google Sheets - Lookup Spreadsheet Row

Just as you did with the VirtualPBX integration, you will need to select your Google Sheets account before you can access an individual spreadsheet.

Zapier Tutorial - Voicemail Received to Google Sheets - Select Google Account

Next, select your Spreadsheet and Worksheet (the individual tab inside the chosen spreadsheet) you want to use.

Zapier Tutorial - Voicemail Received to Google Sheets - Select Spreadsheet and Worksheet

The Lookup Value you select should be the Call ID option. In the drop-down menu for this selection, Zapier will list the VirtualPBX app and all the data options available for an inbound call. Call ID works well here because you will search your Google Sheet for that unique identifier which accompanies every call associated with your VirtualPBX account.

Zapier Tutorial - Voicemail Received to Google Sheets - Select Lookup Value

Make sure you check the box labeled Create Google Sheets Spreadsheet Row if it doesn’t exist yet. Your window will load with the options similar to those shown here.

Zapier Tutorial - Voicemail Received to Google Sheets - Mapping of Variables

The options loaded in this window will be titled with the same column headlines you placed in Row A of your spreadsheet. As seen in the screenshot above, the call data of Call ID is mapped to the Call ID spreadsheet column. You can change the mapping by clicking on any of the drop-down menus. Zapier will output any of the inbound call data you select into the columns you specify.

If you add new headlines, be sure to check your mapping in Zapier. As you get more comfortable with how Zapier works, one particularly useful data field you can configure is Voicemail Box ID, which lets you log the voicemail box that received a particular message. This field is included in our Google Sheet Template in the Preparation section of this tutorial.

Zapier Tutorial - Voicemail Received to Google Sheets - Change Mapping of Variables

Now you can Test & Continue to send sample data to your spreadsheet.

Zapier Tutorial - Voicemail Received to Google Sheets - Test Your Zap

When you’re ready, you can turn on your Zap and begin processing your voicemails.

More To Explore on the VirtualPBX Blog