Create Ads From a Spreadsheet - User Guide

This Enhanced Script automatically creates ad groups, ad texts, keywords and labels based on a spreadsheet with your data. It can be used to turn a product database into an AdWords account or it can be used as an alternative to the AdWords interface or the AdWords Editor for creating new ads at scale. 


How to set it up?

Before you can start using the script, you need to create the settings for the account where the script will run. 

Setting up the spreadsheet

When creating the settings, the Google Spreadsheet URL you'll use to feed data to the script must include all the columns required to create keywords, ads, and ad groups. If the spreadsheet is blank, the script will display an error.

If you click on the question mark next to each setting, you'll find more details about the information you need to include/choose. 

Also, if you need help with the spreadsheet format, you can download our Create Ads from Spreadsheet sample.xlsx


Create ad groups and ads

After you put in the spreadsheet URL, the system automatically pulls the different column headers and shows them on the right side of the screen.

Ad Groups

Existing Campaign Name

Enter the name of the campaign in which the script will create the ad groups, ads, and keywords. The campaign needs to exist in your account as the script doesn't create campaigns.

Ad Group Details

You can dynamically insert the data from the spreadsheet into the ad template. To insert it, select the columns from the right by clicking on them.

  • Parameters: enable the dynamic update of numerical information within an ad, without having to update the number manually. Mention which column in the sheet {param1} and {param2} should correspond to.

Ads

When creating an Ad Template, you can also dynamically insert the ad data from the spreadsheet to create different templates. 

Inserting the column headers will ensure the script picks up the corresponding value from the spreadsheet.

Important: The Display URL must always include www, http, or https. Otherwise, the script will fail.

Default Ad

Create a default ad with no dynamic insertion parameters to make sure that all ad groups will have at least one ad that fits within the characters limits.

Keyword Template

You can:

  • Use dynamic insertion parameters in the keywords you create
  • Use different match types by adding the different notations like:
    • [ ] for exact match (e.g. [[Brand]]
    • + for broad
    • - for negative

The script automatically checks if the same keywords and ads have already been created in the ad groups, so it doesn't create duplicates.


Install script

You can learn how to install the script in AdWords here.


Demo Video



Can’t find what you’re looking for?

Our award-winning customer care team is here for you.