Search
Close this search box.

Automate Weekly Email Reports With This Zapier Path Tutorial

Share This Post

Automate Weekly Email Reports With This Zapier Path Tutorial

Zapier PathsNot getting enough visibility into your business’s call activity? Take 10 minutes to create a weekly email report for yourself with this basic Zapier path that uses a timer and Google Sheets to send call data to your Gmail inbox.

Here, we’ll show you how to report the number of calls you received each week and customize your Gmail delivery to reflect that number. No more forgetting to check your call logs.

Other paths in Zapier you can take are shown in our additional tutorials — including Sending Voicemail Data to Google Sheets and Sending Call Data to Google Sheets, which link the VirtualPBX Zapier Integration with Google. This tutorial also directly references our instructions about Using Google Sheets Formulas to Count Calls.

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

  1. Action: Zapier is scheduled to send an email report each week
  2. Reaction: Zapier retrieves data from a Google Sheet
  3. (2nd) Reaction: Zapier delivers the data through Gmail

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 Zapier Timer)
  4. Update Google Sheet Data
  5. Send Email Through Gmail

Common Use Cases

Update VPs About Department Performance

Automate List of Morning Calls to Return

Keep an Email Record of Inbound Call Volume

Create Dynamic Team Briefing Notes


Zapier Path Preparation

In order to process information for your report, you will need to create a Google Sheet that accepts call data. You can make a copy of our Sheet template for this project before moving to the steps outlined below.

Sheet templates are also linked as starting points within our other tutorials.


Action

You will first need to select the Make a Zap button at the top of your Zapier home screen.

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 Schedule by Zapier option.

Zapier Tutorial - Send Weekly Email Report - Zap Step 1

Your Trigger Event in this Zap will be the Every Week option. This selection will tell your Zap to take further actions every week.

Zapier Tutorial - Send Weekly Email Report - Select Every Week Option

You can set your preferences for day of the week and time of day when you want your Zap to work.

Zapier Tutorial - Send Weekly Email Report - Day and Time Preferences


Zapier Path Reaction 1: Update Google Sheet Data

As your second step – your first Zapier step taken and first Reaction to the Schedule trigger – click the plus sign on your screen and choose your App (Google Sheets) and Action Event (Update Spreadsheet Row).

Your selection of Update Spreadsheet Row here will inform Zapier about the contents of your Google Sheet.

Zapier Tutorial - Send Weekly Email Report - Choose Google Sheets App

Now choose the account where your calls are logged in a Sheet.

Zapier Tutorial - Send Weekly Email Report - Select Google Account

Next, select your Spreadsheet, Worksheet (the individual tab inside the chosen spreadsheet), and Row of data you want to retrieve.

Send Weekly Email Report - Select Spreadsheet, Worksheet, and Row

The Column headlines shown in the Google Sheet screenshot at the beginning of this tutorial match the options shown here in the second step of the Zap.

Zapier Tutorial - Send Weekly Email Report - Spreadsheet Columns in Zapier

Now we will update a field in our Sheet by rewriting the formula it already uses. In this case, the formula calculates the number of rows that meet a specific condition. You can learn more about this process by referring to our other tutorial about using Google Sheets to count the number of weekly calls a VirtualPBX account received.

Send Weekly Email Report - Update Formula in Google Sheet Cell

The result of this process is an up-to-date count of the number of calls received within the past week. Updating the Google Sheet cell here lets us reference that cell properly in the next step where Gmail will send an email that reflects the count.

Note that the changes you make to cell formulas in a Zap will affect what’s shown in Google Sheets. Make sure your formulas are the same.


Zapier Path Reaction 2: Send Email Through Gmail

Click the plus sign again in your Zap to add another Zapier step. Select your App (Gmail) and Action Event (Send Email), and select your Gmail Account from which you will send the email.

Zapier Tutorial - Send Weekly Email Report - Select Gmail App

Customize your email options by choosing recipients

Send Weekly Email Report - Choose Email Recipients

Enter the Title and Body of your email. Dynamic values are available for inclusion here by clicking on the right-hand side menu of each bar. So in this case, you can see the dynamic value from our Google Sheet that shows how many calls were received this week.

Zapier Tutorial - Send Weekly Email Report - Enter Email Title and Body

Your report will change weekly as new data is sent from the VirtualPBX Zapier App into your Google Sheet. So the second step of this Zap, where your Sheet cell is updated, ensures that the data Gmail grabs will reflect current statistics.

Finally, you can send test data to Gmail to make sure your Zap is working properly.

Send Weekly Email Report - Send Test Email

More To Explore on the VirtualPBX Blog