10 Made-For-Marketing Google Sheets Add-Ons

Posted by in PPC Tools
10 Made-For-Marketing Google Sheets Add-Ons

As a marketer, you probably spend so much time in Google Sheets you’ve been caught whispering it in your sleep. Don’t be embarrassed; you’re not alone! There are tons of advantages to using G-Sheets: it’s free (unless you need the business subscription, but even then, $5 isn’t bad), you can easily collaborate with teammates, and saving is automatic with accessibility from anywhere.

But perhaps the best thing about Google Sheets is that you can customize add-ons to meet your exact needs. The fact there are hundreds of add-ons, and dozens specifically for marketing shows you just how much you can personalize a Sheet. We previously covered 21 Google Sheets Add-Ons That Will Make You A Better Marketer, and below you’ll find 10 additional add-ons to try out:

More Marketing-Friendly Add-Ons to Try

1. Anyleads API

A lead generation tool that allows you to get all emails related to a domain.

With the Anyleads API add-on, you can easily and automatically find business and personal emails for sales and marketing, find employee emails by company, get all emails related to a domain in bulk, and verify the validity of a list of emails. When might this come in handy? There are many possible applications, but one of the strongest is account-based marketing, which we covered in our post on how to use social research to succeed in account-based marketing.

2. Document Studio

Use Document Studio to create sophisticated and professional-looking documents.

Branded PPC reports and other business collateral make your company look professional every step of the way. With Document Studio, you can create documents like personalized business letters, customer invoices, vendor contracts, purchase orders, and sales pitches from your G-Sheets data. You can also send the generated documents to one or more recipients in personalized emails.

Google Sheets Add-Ons

3. Fedger.io

Discover, identify and research any company on the web.
Another great add-on for account-based marketing. Fedger.io uses advanced algorithms and machine intelligence to collect, structure, enrich and contextualize web data on demand.

So how could you use it? Discover companies based on location or category. Identify company employees for new leads. Perform automated company research based on other team’s details.

4. Form Workflow Plus

A multi-level approval workflow in Google Sheets.

This add-on takes collaboration to the next level. Each workflow owner, reviewer, or requester has access to his personalized dashboard with his ongoing requests and approvals. Owners can specify as many reviewers and approval steps as needed, and each approval step can include specific conditions. Workflow owners can check on the status of all the requests in their dashboard and send auto-reminders to reviewers.

google sheet add-ons for marketers

5. GA Bulk URL Builder

With this Add-on you can build 100s of URLs in one click!

We know a typical digital campaign requires several URLs and several UTM tags for each URL. Usually, URL-building tools only allow one URL to be created at a time. With GA Bulk URL Builder, marketers can create 100s of UTM tagged URLs in one click. What will you do with all that extra time?!

6. instagReader

The instagReader add-on helps you extract data from any Instagram account for free.

Anyone who’s worked on an Instagram campaign or set up an influencer campaign knows how time-consuming and manual research on Instagram is. This add-on does the work for you. Hallelujah! It can also extract posts within a specific period, which is super helpful for campaigns, or seasonal activations.

marketing add-ons for google docs

7. Odge

Odge enables better decisions with fresh data: anything from finance and sports to real estate and weather.

This add-on is another layer that provides helpful context to creative and targeting. Let’s say you’re running a campaign for solar-powered heated gloves. You can set up a channel alerting you to upcoming cold weather around the nation and use Facebook targeting to hit customers with a relevant offer.

8. Remove Duplicates

Quickly find, move, delete, or highlight duplicates.

Are duplicates not just the most annoying hiccups when it comes to spreadsheets? Especially when you’re working with tabs and tabs and rows and columns of data. This add-on helps you find and delete duplicates and quickly compare data from two columns for repeated values. If you’re worried about automatically deleting important data, Remove Duplicates lets you choose how to deal with the results: highlight or remove duplicate lines, copy or move them to another Google Spreadsheet, or clear duplicate entries leaving the cells intact. Once you run the add-on, it will display a summary of the results found.

9. TowerData

Add demographics to your email list to understand who your customers are so you can personalize your marketing messages.

Every good marketer drools over the prospect of adding more demographic information to any campaign. TowerData Email Intelligence provides demographic, interest, and purchase data on 80% of email or postal addresses in batch or via a real-time API. Within minutes, you can learn who your customers are, what they’re interested in, and their preferred point of contact.

marketing add-ons google

10. AdStage

Get all your paid search and social advertising data into Google Sheets.

Of course, we want to highlight this one. It’s our favorite! Don’t waste time manually exporting data from your ad networks. AdStage for Google Sheets lets you instantly add your paid performance data into G-Sheets. That includes data from Google Adwords, Facebook Ads, Bing Ads, Twitter Ads, LinkedIn Ads and Google Analytics. Take it one step further with our A/B Testing template to find your best campaigns, ad group or ads. You must be an AdStage customer to use this add-on. Start your free AdStage trial.

adstage google sheets addon

Seeing as how G-Sheets are as important to you as say, oxygen, you probably have a love/hate relationship with them. Hopefully, the above add-ons help those feelings skew more toward love than hate.

advertising data integration

27 of the Best PPC Tools You Have to Use

27 of the Best PPC Tools You Have to Use

There’s nothing quite like the feeling of running an ad campaign that generates gigantic returns. It’s what PPC pros thrive on. But let’s be honest, most of our days are spent doing repetitive, monotonous tasks – perfecting that campaign build, crafting variations of copy, or diving face deep into pivot tables.

Talk to any old timer, and they’ll reveal a collection of shortcuts, tools, and hotkeys to get the job done faster and efficiently. Discovering a new, useful tool provides a similar sensation as my grandma coming up big at a yard sale – pure joy.

Sharing the elation, I’ve included below my list of free PPC tools gained from mentors, blogs, and forums over the years. Hope you find some gems and may they aid your workflow.

Search PPC Tools

Keyword Research

In 2007, Google revealed that 20 – 25% of search queries they see are new. Let that sink in. Testing long tail keywords can provide additional conversions, at attractive costs. However, pondering all the different variations by yourself can prove limited. Tools can help reveal new opportunities for keyword portfolio growth.

1. Übersuggest

Google autocomplete reveals popular variations to anchor search queries. However, running through the variations can be timely. Übersuggest will take a root query and will run through the entire alphabet, revealing Google autocomplete data for each letter variation. Pick the ones that best fit, and you can easily copy or download the search queries (keywords) in bulk.

2. WordPress’s Keyword Niche Finder

There are some keywords and verticals on Google or Bing that are just outright expensive. The Keyword Niche Finder can provide keywords with great opportunity, and ideas into new ad group themes.

3. Soolve

Search queries can vary between different properties. Soolve provides insights into to search results across Google, Bing, YouTube, Yahoo, Wikipedia, Amazon, and Answers.com, in one central view.

4. Google Trends

Trends reveal the popularity of a search query over time, and can divulge any signs of seasonality. Especially useful for short-window B2C products, such as snowblowers.

5. Keyword Typo Generator

Most of us can’t watch a TV show without scanning our tablet or mobile phones simultaneously. Typing mistakes happen, especially being distracted while typing on tiny mobile keypads. Use this to your advantage by finding common misspellings, testing them as phrase and exact match keywords. This is especially lucrative for emergency service based businesses. A desperate searcher is likely to click on the first ad they see in the case of an A/C outage on a clammy summer day.

6. Visual Thesaurus

Can we all have a moment of silence for Google’s Wonder Wheel. Deprecated along with Google Labs, advertisers used to be able to discover new root keywords using this visual model – jumping from spoke to spoke. Visual Thesaurus provides a similar experience and pairs well with brainstorming ad group structures.

Keyword Wrapping

Separating high volume keywords into ad groups by match typecan greatly decrease CPA (cost per converted click). However, the process is often grueling to do. Luckily, there’s MergeWords.

7. MergeWords

MergeWords is a clean and fast interface to match wrap a long list of keywords. In addition, it can be used to build keyword variations quickly.

Ad Copy Tools

The largest component calculated into Quality Score is click through rate. A high CTR indicates your ad is relevant and helpful to the user’s search, and the advertiser is rewarded by paying a discount for an ad position. Meticulously testing ad copy is one of the biggest factors to improving CTR.

8. Google Ad Preview Tool

Do you have keyword bleed? Are your ads compelling? How does it render on different devices? What position do you show for in this geo? All these questions can be answered with Google’s ad preview tool. Quite possibly the most emailed link by agency staff to a client; in attempts to keep impression counts down when the client is searching for their own ad visibility.

PPC Testing

9. Perry Marshall’s SplitTester

Just because you receive performance data back, doesn’t mean it’s conclusive. Often, digital marketers will get trigger happy in attempts to irk out gains. The SplitTester calculator can be used to understand if your ad copy A/B test results actually yielded statistically significant outcomes.

10. Broken URL Checker

Ensure your ad’s destination URL is pointing to a live page. Do this across your entire site, using Xenu Link Sleuth and the AdWords Link Checker script.

PPC Competitor Tracking

While most of these tools are freemium models, they do give you an initial glance on how your advertising campaigns stack up against your top competition. Learn baselines for bidding, high conversion volume keywords, and examples of competitor ad copy.

11. SpyFu

12. SEMRush

13. iEsponiage

PPC Ads Editors

Our VP of Product, Paul Wicker, famously says, “there are 3 types of advertisers – U/I, editor, and bulk spreadsheet people”. I’m an editor guy. Editors allow you to quickly edit, copy, or replace campaign, ad group, or ad entities in bulk. Often using hot keys; swoon.

14. Google AdWords Editor

The first native PPC editor to be released. Still the staple for power and functionality.

15. Bing Ads Editor

2016 is rumored to be the year that they release a mac version (finally). If not, I fear the 2,919 upvoters may picket.

PPC Automation Tools

Optimization time stretches thinner with every new campaign or ad group addition. Automation acts as a way to sequence tedious tasks, and lift performance with frequent, real-time adjustments.

16. Google Scripts

Scripts empower marketers with the flexibility to manage their campaigns like a programmer running an algorithm. Set the parameters, test the code, and automate the function.

Being honest, many PPCers can barely change HTML, let alone design a script from scratch. Luckily, there’s the Free AdWords Scripts blog with plug and play scripts to test.

PPC Reporting Tools

17. Google Sheets

While not as advanced and powerful as Excel, GSheets offer some great features to aid your PPC reports – such as team collaboration, add-ons, and cloud storage space.

BONUS: AdStage Google Sheet add-on

  • Import your AdWords, Google Analytics, or Facebook Insights metrics into Google Sheets and easily segment by data type.

18. Return on Ad Spend Calculator (ROAS)

Simply tracking cost per lead or cost per sale is only half the picture. PPC campaigns can’t survive long-term if they are not profitable. This calculator helps keep track of your campaigns’ impact on the bottom line.

Social PPC Tools

Audience Research

Unlike Search which is intent based, social requires a bit of a different approach. As an advertiser, you’re revealing your message to an audience who isn’t actively looking for your product or service. Instead, you’re hoping to introduce your offering to a pinpointed audience serendipitously. This means your audience targeting is key to success.

19. Neilson’s PRIZM®

Neilson has been the central point of authority for demographic information in broadcast buys. Their PRIZM tool allows you to understand household and income make ups by zip code, helping you to refine your base level targeting.

20. Tagboard

This search engine reveals beautiful results for conversations related to your query across Facebook, Instagram, Twitter, Google+, and Vine. It’s a great tool for understanding trending topics, audience behavior, and sentiment.

Ad Copy

21. CoSchedule’s Headline Analyzer

It’s likely that your prospect won’t read the full body copy in your Facebook ad or sponsored tweet. Headlines and images are the main elements that drive killer CTRs. This tool provides insight into how strong your proposed headline will resonate.


22. Canva

In an ideal world, digital advertisers would have a plethora of creative to choose from; designed in every format and dimension size. The harsh reality is that you may need to reformat creative in a bind, or suffer waiting on going through a design team – who often view ad creative as lowest on the totem pole. Canva provides an easy, yet flexible way to create beautiful ads without dealing with Photoshop’s complexity. I love Canva, and use it religiously to quickly kick out creative (to my design team’s dismay).

23. 20% Rule Tool

In efforts to provide a better user experience, Facebook limits image creative to only reveal up to 20% of the total size in text. This helps to safeguard from spammy, click-bait CTAs that take up the screen. Unfortunately, this makes legitimate advertisers’ lives hard. 20% is not a lot of reality, and the bane to creative types who don’t like restrictions. Using this tool will save later headache of your ad getting rejected. I find it faster to find than fumbling for Facebook’s tool directly.

24. Free Stock Photo Sites

OK, I got a bit meta there. That’s a link to a blog containing a rich variety of royalty free stock photos to be used in your Facebook or Twitter Ads. It’s worth the look.

25. Catvertiser

If you’re in a very time sensitive bind, this tool can adapt your display creative to meet Facebook dimension requirements.

Social Ad Editors

26. Facebook Power Editor

Power Editor is revolutionary in that it’s not a desktop standalone app. Instead, it’s an editor within a browser environment. Outside of ad management, it can also schedule and create organic posts.

27. Twitter Ads Editor

This is for your bulk sheet Excel types. After logging into your Twitter Ads dashboard, find the CTA to download the bulk sheet. Populate the cells you’d like changed and upload it back into Twitter. It’s quite handy for campaign duplication with slight targeting variations to test.

Wrap Up

It’s likely I only grazed the surface in potential free PPC tools to add to your arsenal. Am I missing any tools worth mentioning? Please let me know in the comments below. I’ll add it to the list and give you kudos!

PPC Show Podcast