Automated Upload of Video & Image Ads to Meta from Google Sheets

This n8n workflow automates the process of uploading video and image advertisements to Meta Ads Manager using data from Google Sheets and assets from Google Drive. It simplifies campaign management by streamlining media uploads, creative creation, and ad setup in Meta. The process begins with a manual trigger or Google Drive update, fetching media files from Google Drive, and retrieving metadata via HTTP requests. Depending on whether the media is a video or image, the workflow dynamically processes each type, creates ad assets on Facebook, and then sets up ads accordingly. It also saves ad details back to Google Sheets for tracking. Practical uses include digital marketing campaigns that require regular ad uploads and updates without manual intervention.