The DataHero Blog

Google Sheets Productivity Hacks: Going Beyond the Basics

January 15th, 2015


Google Sheets have long since proven their usefulness for personal and business tasks and a score of articles (like this one) have been written exploring and illustrating tips and tricks for how to make this tool work for you. At this point, it’s possible you’ve mastered this functionality, so here are a few tools you can use in conjunction with your spreadsheets to do things you haven’t thought of before.

Visualize Your Business Data

You can use Google Sheets to make charts, but they leave room for improvement to say the least. Use DataHero to quickly and easily take information on a Google Sheet and turn it into a clean and easy-to-read chart in a matter of seconds. Combine data from Google Sheets with other datasets to get new insights into analytics.

DataHero also has the ability to connect with over two dozen different services, services that you already use every day. Connect Salesforce and DataHero to create dynamic pipeline charts. Pair DataHero with Pardot to see which campaigns are driving conversions. For a complete list of services, look here.

Creating beautiful charts with DataHero is easy, but what if you want to manipulate the data in different ways to get different insights? Let’s take a look at a set of data provided by Quandl, a service DataHero can connect to. The data set, called “countries, GDP, Unemployment, and Interest Rates, 1960-2018,” can be accessed after signing up for an account. Here’s the GDP by date chart without any filter.


This looks good, but if you want to get different insights that require pivot tables in Google Sheets, DataHero helps you do that easily and quickly. Seeing the sum of GDP by date and by country, for example, is just a matter of dragging and dropping the country filter as shown below.

GDP Drag

Here you can see that the view has changed; now you can see what the GDP was by date as well as which countries made up which percentage of total GDP. Easy.

GDP Country

You don’t need to know what a pivot table is or how to perform functions to get the kind of chart you want; DataHero does it all for you, quickly. Take a look at this article for more information.

Save Gmail Attachments to Google Drive Automatically

Zapier is a tool that lets you easily connect the web apps you use to automate tedious tasks that otherwise interrupt your workflow and productivity. Maybe you receive lots of emails with important text and image attachments and you need a way to quickly find those attachments later without spending valuable time sifting through your emails manually. This Zapier integration allows to save any attachment you want to Google Drive and removes the hassle of having to dig in order to retrieve old files.

Save Gmail

Save Tweets to a Spreadsheet

Looking for new Twitter influencers to reach out to? Or maybe you’re interested in a certain hashtag and want to see how it’s used and by whom. Use Zapier to put all mentions into a Google Spreadsheet the moment someone tweets about it. Customize your apps with Zapier and have it do the work for you.

Twitter Mentions

Save Orders and Receipts

IFTTT, pronounced like “gift” without the “g,” is a tool that lets you make connections to automate different processes, leaving you more time to devote to your business. Create recipes based on triggers and actions, like turning on your lights automatically when the sun sets.

Don’t spend your time doing the tedious but still necessary parts of your business; instead, have them done for you automatically. Perhaps you have sales orders coming in from customers or clients, or maybe you have business-related outgoing orders conducted through email; with IFTTT, create a recipe that will add these orders and receipts from your emails in Gmail to a Google Spreadsheet. IFTTT makes it simple and easy by automating the process as you fill in the following categories.


Fill Out a Timesheet for Work

Don’t let clocking in or out get in the way of you or your employees getting stuff done. Create a recipe that fills out a work timesheet using iOS location and Google Sheets. When you get to work, the GPS on your phone or other device will recognize where you are and automatically fill out the next row or column on your Google Sheet. The same will happen as you leave. You can also create a recipe that will send an email to your employees mid-month to remind them to check or fill out their own timesheets.


Make the most of Google Sheets by having them work for you. You’ll find that incorporating the above tools will automate tasks that are otherwise redundant and tedious, leaving you time to step up your game where it matters most.


By Paxton Gray

Create my Free DataHero Account

Get the fastest, easiest way to understand your data today.