Google Sheets and AdWords now magically work together by importing Google Sheets external data into Google ads business data . So, what does this dynamic duo mean for you? It means limitless options for serving automated and dynamic search ads.

Business data is where you provide and manage data sources for ads, extensions, and targeting. Business data lets you review the upload history and the status of your ads at a glance. You can also view the overall clicks, impressions, and campaigns associated with your business data feeds.

google sheets and google ads work together like batman and robin

When you go to the Business data section of your Google Ads account, you’ll see a table with the data associated with your account. Ad customizer, ad extension, location targeting and dynamic display ad data can appear here.

Google Sheets and AdWords

Google previously introduced different versions of dynamic ad capabilities, but not to this level. Sure, we had Dynamic Keyword Insertion (DKI) which automatically pulled in a user’s search query into an ad. We even had AdWords Business Data which allowed us to utilize ad customizers; these little buggers use a parameter that automatically leveraged information from Business Data in ads such as promotional prices.

Today, we were at the mercy of manually uploading Business Data, meaning, if you had a promotional price change, you’d still have to update it in Excel, then re-upload. For some of us, promotions needed to be changed daily, making this a time-consuming task.

In comes the dynamic duo game changer…

As Google Sheets and AdWords work together to allow automation of the import process (every 6 hours if you want), you no longer need to lift a finger to change prices and more. Instead, whomever is responsible for updating product prices can do so directly within a Google Sheet or link Google Sheets to the source document used for updating prices.

ad customizers

The beauty of Google Sheets is that it comes built with a plethora of Excel based formulas and functions, as well as Google Scripts, which allow us to build custom functions. These capabilities enable us to do fancy things like connect external APIs, internal CRMs, scrape our own website data, and much more! Limits are only bound by your imagination.

Changing promotional prices in ads is only one example among countless others. Here’s another example of capabilities we can explore.

Imagine you own an international donation website called “” that provide food for those more in need around the world. Below is an ad that is fully automated and dynamic.

search ad copy example

Searchers see this ad, but don’t know or realize the magic happening behind the curtain:

  • We’ve used a countdown parameter and set it to finish at a designated date
  • We’ve scraped our donation page and used an Excel formula to get our percentage-to-goal
  • We’ve connected to’s API to convert our minimum donation ($5 USD) to Euros and customized this ad to adapt messaging to the country people search from
  • We also imported our Google Analytics data into Google Sheets to see how many unique donations we’ve accumulated thus far

The implementation of this dynamic update can be as simple or complex as you want. At its crudest form, you can just use Google Sheets and AdWords to change one simple element within your ad. If you want to get fancy, you can run wild using formulas and Google Scripts to make a truly dynamic and automated ad.

Get more information on:

Share This