Product Video Ads

Product Video Ads is an open-source solution that builds videos at scale, by reading product data from Google Sheets or Google Merchant Center and generating videos with product information (name, image, price) automatically. These videos are automatically uploaded to Youtube or Drive, and can be configured to Google Ads campaigns.

The integrated installer will setup the project on Google Cloud so you are up and running right away.

Requirements

You will need a new Google Cloud project and a user with at least Editor (or Owner) role to do the install.

Also ensure that 'Google Apps Script API' is ENABLED for this user. You can enable it at: https://script.google.com/home/usersettings

This user will be the owner of the newly generated Sheet and Drive folders. You can share these with other users after the installation is complete.

How to install

Installation is in 2 parts:

1. Setup the Authorization keys from the GCP UI
2. Run the installer

Setup the Authorization Keys

You will need to create the following keys from the GCP dashboard:

1. An OAuth Client Id for Web
2. An OAuth Client Id for Desktop
3. An API Key

Instructions are as follows.

1.Create an OAuth Client ID for a 'Web Application'

1. Go to 'APIs and Services' > 'Credentials'
2. Click 'Create Credentials' > 'OAuth Client Id'
   • If you are asked to configure the 'OAuth Consent Screen' follow the steps below. Otherwise continue with Step 3.
     • Enter an ‘App Name’ and a ‘User Support Email’.
     • Skip the optional fields and Save.
     • Go to ‘Apis & Services’ > ‘OAuth consent screen’ and set the following:
       • Publishing Status: Testing
       • User Type: Internal
     • Consent screen configuraiton is now complete. Go to 'APIs and Services' > 'Credentials' > 'Create Credentials' > 'OAuth Client Id' to continue configuring the client.
3. Configure your OAuth Client Id for Web as follows:
   • Application Type: Web Application
   • Name: Web Client 1 (or anything you prefer)
   • Click 'Save'

2.Create an OAuth Client ID for a 'Desktop app'

1. Go to 'APIs and Services' > 'Credentials'
2. Click 'Create Credentials' > 'OAuth Client Id' and configure as follows:
   • Application Type: Desktop app
   • Name: Desktop Client 1 (or anything you prefer)
3. Click 'Create'

3.Create an API key

1. Go to 'APIs and Services' > 'Credentials'
2. Click 'Create Credentials' > 'API Key'
3. Click 'Close'

Run the Installation Script

1. Open your project's Cloud shell.
2. Run the following:

   git clone https://github.com/google/product_video_ads.git
   cd product_video_ads
   ./install.sh

3. Follow the on-screen instructions to complete the install.
4. STOP: Before you click on the AppEngine URL, add the URL to the authorized URIs section in the Web OAuth Client ID as follows:
   1. Go to 'APIs and Services' > 'Credentials'
   2. Click on the name of your client under 'OAuth 2.0 Client IDs'
   3. Add the URI to Authorized redirect URIs and Authorized Javascript Origins
      • Your URL will be like this: PROJECT_ID.REGION_ID.r.appspot.com (Ref).
   4. Click 'Save'
5. Installation is complete! Click on the AppEngine URL to run your app.
   • IMP: Ensure cookies and pop-ups are allowed. Ref: Allow pop-ups in Chrome

Optional: Check that your Spreadsheet has access to Google Merchant Center as follows:

1. [Optional] Navigate to Tools > Script Editor > Settings (gear icon)
   1. Update the GCP Project ID
   2. Test the Google Merchant Center connection by
      1. Add an ID on "Prices" tab in the format <Google Merchant Center id>:<product id>
      2. Click Merchant Center > Run Now