Skip to content

Populates a Google Sheet with Single Product Ad Groups for Google Shopping campaigns using a list of product IDs.

License

Notifications You must be signed in to change notification settings

fredericharnois/build-spags-google-apps-script

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Building Single Product Ad Groups

This script was built to quickly build single product ad groups for use in Google Shopping campaigns.

Setup

You'll first want to create a new Google Sheets file, adding build-spags.js, interface.js, send-csv.js, and sidebar.html under Tools > Script editor.

After refreshing the page, a new SPAG Builder menu option should appear:

Alt text

In that menu, select Create Product ID Sheet, which will add a sheet for you to paste your product names and ids in:

Alt text

The Settings option will open the sidebar, where you will set the necessary parameters for a Google Shopping Campaign:

Alt text

Once that's filled, choose Run. You can then either copy and paste the output in Google Ads Editor or use the Email CSV option to send yourself a CSV file of the output.

About

Populates a Google Sheet with Single Product Ad Groups for Google Shopping campaigns using a list of product IDs.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published