Skip to main content

Article 1 min read

Community tip: connecting Zendesk and Google spreadsheets

Last updated January 24, 2022

At Control Group, we’re constantly reevaluating our own internal workflow to be more productive using the tools we already have. We create working prototypes like this as a research lab of sorts to see what potential gaps and technical debt can be removed with creative applications of technology.

Our need for a tool like this came out of being fans of two great products we use all the time: Google Apps and Zendesk. Beyond the obvious benefits of using Google for all of our email communications, we greatly benefit from shared document creation. Zendesk helps us measure our success in providing dedicated support to our variety of clients ranging from The Daily Show here in New York, to the Gagosian Gallery, with locations spanning 6 time zones.

Since our IT support doesn’t limit itself to one particular team, our use case evolved beyond the typical when it came to monitoring warranty expiration. We’ve been using Google spreadsheets to keep track of purchased items for ourselves and clients, but without some kind of automated monitoring system in place, we realized there was unnecessary reliance on someone checking the spreadsheet for warranties nearing expiration.

Hence, an idea for a tool I like to precociously refer to as Magic Ticket was born!

The latest Community Tip was brought to us by Rachel Cantor, Web Developer at Control Group, and was written based on content from their blog.

Related stories

4 min read

Unlocking Sentry's success: Insights from David Cramer's unconventional journey to successfully raising $217 million

The founder shares why it pays to stop convincing prospects and instead focus on finding the ones who inherently understand and appreciate your vision.

2 min read

Customize your forecast analysis period

You can now tell your forecast to ignore data before a specific date that you define by workstream to remove outliers and up your forecast accuracy.

2 min read

Introducing tailored staffing parameters by channel type

Increase your forecast's accuracy by tailoring it specifically to the channels you and your teams use.

2 min read

Introducing the newest way to keep track of your agents' activity

Agent Activity provides real-time Intraday monitoring that showcases what agents have been working on throughout the day as well as their current activity.