How to schedule & send your reports using Zapier & Gmail

How to schedule & send your reports using Zapier & Gmail

Since the development of our own solution for automated email reporting is still in progress, here’s a quick and simple workaround by using Zapier & Gmail.

Feel free to watch our video on how to create this Zap or rather follow along the steps in this article. 

Go to Zapier and create a new zap. 

As a Trigger App, find and choose “Schedule by Zapier”.

Click on it and select the trigger time.
By default, reporting is done once a month, so in this guide, we will be choosing Every Month as trigger time. 

Click on Continue and proceed with setting up for which day of the month you want your report to be sent.
In this particular case, we’ve set up the report to be sent on the 25th at 3 PM.

Click on Continue, skip testing this step/sample, and click on Continue again.

Now proceed with connecting your Gmail account.

Create a new Zap and select Gmail as your Action App.

Under “Create” actions choose “Send Email.” 

Click on Save + Continue and select the account from which you want your emails to be sent.
If you don’t have an account connected previously, you can connect one by clicking on Connect an Account.

After you’ve finished connecting and selecting the account, click on Save + Continue.

Now it’s time to set up the template which you’ll be using for sending the email. 

In the first box add your client’s email address. 

If there’s somebody else who should be included in your reporting activities, you can add them in the CC or BCC boxes.

In the “From” box select the email address you’ve previously connected with Gmail.

Type your name in the “From Name” box.

Add a subject, for example: “Your monthly report”

We prefer using Plain as a Body Type, but if you wish to add some custom HTML feel free to do so :)

In the Body field, you should set up a functional copy that you don’t have to change on a monthly basis. 

IMPORTANT NOTICE: When you paste your Reportz dashboard URL, don’t copy it from the view mode, instead just copy the URL from the edit mode without predefined date ranges.

The right way:

The wrong way:

DO NOT place the URL as:  
https://app.reportz.io/dashboard/5c98f3ef765b3?startDate=2019-03-01&endDate=2019-03-24

DO SEND the URL as: https://app.reportz.io/dashboard/5c98f3ef765b3/ 

The same method works if you have your own white-label subdomain.

The proper setup should look something like this:

If you’re using custom labels in your inbox, be sure to mark these emails in the Label/Mailbox segment.
If you wish to provide your client with more attachments you can upload them directly in the Attachments segment. 

Click on continue & if you wish to, you can test out this step.
But, all in all, if you’ve followed the steps from this article carefully, you should be good to go

We’ve marked the 4 most important steps by a square you’re required to set up in the Template.
To (your client’s email address)
From
(your own email address)
Subject
(the subject line for the emails)
Body
(the text where you should place the URL of the dashboard, along with some additional information)

 Test, or skip the Test, & click on Finish to save your Zap. 

Name it, set it live & hop on to your Zapier dashboard to clone this report and set up a new one for each of your clients.  

Happy (automated) Reporting!

    • Related Articles

    • How to schedule and automatically send your reports

      If you wish to send your reports to your clients at a specific time of the month or week you can do so by scheduling it within your dashboard. You can access this feature by clicking on the share button located in the upper right corner of your ...
    • How many referral invites can I send?

      You can send an unlimited number of invites and get an unlimited number of free dashboards for your account. To get free dashboards, your referrals need to do the following: They need to add at least 2 integrations, create at least 1 dashboard with ...
    • Benefits of a "Live Dashboard" and How to Send it to Your Client

      The biggest value of live dashboards is that they are much easier to set up and are extremely time-frugal, especially in the long run. PDFs and automatic emails are cool, but live dashboards are a much faster solution as the only thing you need to do ...
    • Where can I see which data the widget is using?

      Just click on the information icon in the upper right corner of any widget and you will see the details of that widget. To close the Info view of the widget, click on the Back button in the upper right corner. It's as simple as that! Go to Reportz ...
    • How To Create Custom Date Range For My Reports

      Reportz is a live reporting tool that allows you to see current data for the period you've selected. Besides the predefined time periods: Monthly Weekly, Last 30 Days, Last 7 Days, Last Month, Mid-Monthly, and Daily ... you can also select Custom ...