How-To: Google Sheets > Youtube > Slack

So you want to create a Youtube Video-Ads Bulk Sheet?

Overview:

Download csv from google sheet
Create Video Ads Bulk Sheet
Send Bulk Sheet to Slack channel or DM
ManuallyUpload Bulk Sheet CSV to Google Ads

Create a copy of Google Sheet & Populate Fields:

Make a copy of this Google Sheet LINK

Understand Google Sheet Input Columns & Populate Accordingly:

a. Approved: Specifies whether the ad should be included in the bulk sheet
b. Campaign Inclusion: Regex pattern used to match ads to specific campaigns
c. Ad Group Inclusion: Regex pattern used to match ads to specific ad groups
d. Ad Name: The display name of the generated ad in the bulk sheet
e. Video Link: The URL of the video creative used for the ad
CTA: Message: The call-to-action text displayed on the ad (e.g., Learn More, Shop Now).
Headline: The short headline text shown in the ad.
Long Headline : An extended headline version used in placements where more characters are available.
Description: Supporting ad text that provides more context or details about the offering.
Final URL: The destination URL users are sent to when they click the ad.
Tracking Template: The tracking URL template that appends parameters for performance measurement (e.g., UTM tags).

Tip: Additional Notes Regarding Google Sheet Input:

Either Campaign Inclusions or Ad Groups Inclusion MUST be filled (both cannot be empty).
Required columns that must be populated: "Ad Name", "Video Link", "Long Headline", "Description"
Matching logic documentation LINK
Must share the google sheet with the service account with ‘edit’ access LINK

Use the Google Sheet - Download Sheet to Workflows Template

Youtube - Create Video Ads Bulk Sheet

Use the Youtube - Create Video Ads Bulk Sheet template.

Slack - Send Message

This is not meant to be an exhaustive guide, you can customize your workflow by adding new tasks - like sending your CSV Bulk Sheet to somewhere other than slack like Email or Google Drive - that’s the fun part!

Workflows is designed to be mix-and-match to meet your needs, you can explore all the available templates in the Template Library, or in the Explore Existing Templates area of our documentation.

Use the Slack - Send Message With File template.

Or if you’d rather keep your message static, and upload the contents of the file directly into slack, or even the csv you downloaded from Google Sheets, you can use the Slack - Send Message With File template!

Tip: Add the Alli - Workflows bot to your channel

Either: /invite @Alli - Workflows
Or: Channel Settings → Integrations → Add Apps → Alli - Workflows
the ‘SLACK_SOURCE_FILE_NAME’ MUST match the Output File Name in Youtube Task.

4. Uploading Bulk Sheet to Platform

Sign in to google ads https://business.google.com/us/google-ads/
On the left-hand side: click on tools > bulk actions > uploads
Click on the + New Upload button, upload file and click apply

Tip: Uploading the Bulk Sheet is Manual Process and is not done in the Workflow

Arcade Demo - Building the end-to-end Workflow 🎥

Youtube Video Ad Bulk Sheet Automation Demo Link