Youtube - Create Video Ads Bulk Sheet

Overview

This task takes an input CSV (with your ad details), retrieves Ad Groups from Google Ads and generates a ready-to-use YouTube Video Ads bulk sheet as an output CSV. You can then: - Send the CSV directly in Slack - Manually upload it into Google Ads Popular Workflow: Google Sheets + YouTube + Slack link: https://agencypmg.atlassian.net/wiki/spaces/PTD/pages/4530241545/Popular+Workflow+Google+Sheets+Youtube+Slack?utm_source=chatgpt.com

Variables

Name	Reference	Type	Required	Default	Options	Description
Input File Name	INPUT_FILE_NAME	Alphanumeric	✅	-	-	Name of the .CSV file to read from with .csv extension (ex.: input.csv). Must match the file downloaded from Google Sheets.
Output File Name	OUTPUT_FILE_NAME	Alphanumeric	✅	-	-	Name to save the .CSV file locally with .csv extension (ex.: output.csv).
Output Folder Name	OUTPUT_FOLDER_NAME	Alphanumeric	➖	-	-	Optional folder path to save the file. If empty, defaults to the root of your workspace.
Google Ads Login Customer ID	GOOGLE_ADS_LOGIN_CUSTOMER_ID	Alphanumeric	✅	-	-	Enter your Google login customer ID (MCC level). Where to find it: Sign in to Google Ads → Top right corner (account dropdown). You’ll see the 10-digit Login Customer ID (e.g., 123-456-7890).
Google Ads Account ID	GOOGLE_ADS_ACCOUNT_ID	Alphanumeric	✅	-	-	Enter your specific Google Ads Account ID. Where to find it: While in Google Ads, look at the top right corner next to your account name, or check the URL after ?customerId=XXXXXXX. It will appear as a 10-digit number (e.g., 012-345-6789).

YAML

Below is the YAML template

YAML


source:
  template: Youtube - Create Video Ads Bulk Sheet
  inputs:
    INPUT_FILE_NAME:
    OUTPUT_FILE_NAME:
    OUTPUT_FOLDER_NAME:
    GOOGLE_ADS_LOGIN_CUSTOMER_ID:
    GOOGLE_ADS_ACCOUNT_ID:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101