Real-World Education for Modern Marketers

Join Over 600,000 Marketing Professionals

Start here!
Text:  A A

Three Awesome Google Spreadsheet Hacks for Marketers

by Ann Smarty  |  
March 8, 2012

In this article, you'll learn...

  • Google Spreadsheets tips all marketers should know
  • How to use Functions and Scripts, the Scraper tool, and RSS feeds in Google Spreadsheets

Among the best Google products I love playing with are Google Docs, especially Google Spreadsheets. They are feature-rich, highly flexible, reliable, and, on top of that, absolutely free.

I've been using Google Spreadsheets for ages... for campaign tracking, reporting, automating, and aggregating some of the most complex search engine optimization (SEO) and social media tasks.

In this article, I'll share the three most useful, yet easy-to-implement, Google spreadsheet tips any online marketer would find useful.


1. Google Spreadsheet Functions and Scripts

The beauty of Google Spreadsheets is its flexibility. You can be as creative as you want (or, at least, as "your geekiness" permits). If you are not ready to spend hours trying to figure out Google functions and Google scripts, here's a quick look at the three most interesting ones:

Script* / function

Sign up for free to read the full article.Read the Full Article

Membership is required to access the full version of this how-to marketing article ... don't worry though, it's FREE!


We will never sell or rent your email address to anyone. We value your privacy. (We hate spam as much as you do.) See our privacy policy.

Sign in with one of your preferred accounts below:


Ann Smarty is founder of ViralContentBee, a Web-based platform that uses a crowdsourcing model to facilitate the generation of real "social buzz" on quality content. She also offers guest-blogging services at SEO Smarty.

LinkedIn: Ann Smarty

Twittter: @seosmarty

Rate this  

Overall rating

  • This has a 5 star rating
  • This has a 5 star rating
  • This has a 5 star rating
  • This has a 5 star rating
  • This has a 5 star rating
2 rating(s)

Add a Comment


  • by Amy Thu Mar 8, 2012 via web


  • by Ann Smarty Thu Mar 8, 2012 via web

    Thanks, Amy! I am glad to hear you like it!

  • by stlubahn Thu Mar 8, 2012 via web

    Amazing, was not aware you could do all this with Google Apps!

  • by Corey Mon Mar 19, 2012 via web

    Ann, you are a rock star. Thanks for the post.

  • by Ann Smarty Tue Mar 20, 2012 via web

    Thanks, Corey! I am happy to hear it looks useful!

  • by Bill Thu Feb 20, 2014 via web

    Amazing, Ann. Thanks for sharing. Look forwards to your other helpful sharing stuffs.

MarketingProfs uses single
sign-on with Facebook, Twitter, Google and others to make subscribing and signing in easier for you. That's it, and nothing more! Rest assured that MarketingProfs:
  • will not provide your social data to 3rd parties
  • will not contact friends on your network
  • will not post messages on your behalf
  • will not interact with your social accounts
Your data is secure with MarketingProfs SocialSafe!