Save time by creating Ads, Keywords or entire Ad Groups straight from a Google Spreadsheet.
The flexibility of spreadsheets coupled with the power and speed of the AdWords Editor. Sounds good? Let’s go.
We’ve found it most useful when splitting out campaigns into separate AdGroups (SKAGs, anyone?), but it’s just as handy for creating campaigns from scratch.
This script works with a single Campaign at a time, for mass-campaign creation we recommend setting up a template campaign. Once setup simply copy it each time a new Campaign needs creating, it will take seconds and you can be sure all of the settings will be correct.
Make a copy of this Spreadsheet (File > Make a copy…) and enter your details:
- The campaign name (cell B2)
- Any settings, including what you would like to be created (Cells B3-B6 and C5)
- The bids to set for the keywords (Cells D2 – D4). To skip creating keywords for a particular match type, simply set to zero or leave blank
Here are the settings and information we’ll be using in this example. The spreadsheet template contains comments on all key cells.
If you haven’t already, copy the script from GitHub
Create a new AdWords Script (Bulk Operations > AdWords Scripts) and paste in the Script. There are only two things you’ll need to change:
- Spreadsheet URL – your copied spreadsheet
- Sheet Name – whatever you called your new sheet, e.g. “Sheet1”
Once the script has been authorized, preview it and on the “Changes” tab you’ll be able to see which changes will be made when the script runs.
Once you’re happy, hit “run” and you’ll quickly be able to see all of your AdGroups, along with ads and keywords, within AdWords.
A few notes on workflow.
As with Bulk Uploads and the AdWords Editor, this tool is best used when creating in bulk. Although it’s worth noting, by using sheet-based methods like this (including bulk uploads) it can minimise the chance of error thanks to the birds-eye view of everything which will be added.
When creating campaigns, we recommend setting up an empty Template campaign with your perfect settings then copying and pasting it to create a new campaign whenever required. If you’ll be creating multiple campaigns (say, more than five) try the AdWords Editor as it’s likely a better option.
You’ll notice it’s only possible to create a single Ad per row, to create multiple Ads just create a new row with the same Ad Group name.
Don’t worry if the keywords are the same, it won’t them add twice.
Another option is to first create the Ad Groups, then change the ad text accordingly and run the Script again.
Spreadsheets allow rapid Ad writing thanks to a familiar interface, functions and quick duplication. Be warned, when writing ads in a spreadsheet it’s easy to swap time for creativity and thorough testing.
We’ve updated the script and template to include a negative keyword column, this was designed specifically for sculpting Ad Groups during creation – it’s much easier and quicker this way Vs using AdWords itself.
Found this Script useful?
Let us know!
Equally, any ideas on how we can improve scripts are always welcome – just leave a comment below.
Custom Scripts – Hire Us
We’ve had dozens of agencies hire us on the back of this script alone, agencies that saw the potential to further automate their way with bespoke solutions.
If you’d like to do the same, you can contact us here.
Update – Version 1.5.0
I’ve added lots of lovely error handling and generally tidied things up.
Now instead of just failing it should tell you why in the logs.
If you’re having issues please try this version – comment below if you have any trouble.
Note this update requires the newest version of the spreadsheet too. The link is the same.