Automatically create Facebook ads from Google Sheets

Who is this for?

This template is designed for Marketing Managers, Performance Marketers, and Ad Ops professionals who want to automate Facebook ad creation using structured data in Google Sheets. It’s ideal for teams running multiple creatives or testing ad variations without having to manually use Meta Ads Manager.

> ⚠️ Important Note: This is not a plug-and-play workflow. It requires: - A configured Facebook Business account - A valid Facebook App, Page, and Ad Account - Access tokens and the correct Facebook Graph API credentials - A basic understanding of the Meta API and JSON to tweak ad set parameters like demographics, optimization goals, or sales objectives

Additionally, launching Facebook ads will incur real advertising costs, so this template is best suited for users willing to make a time investment to set things up properly and test responsibly. Expect to spend time customizing targeting and budget strategies based on your campaign needs.

What problem does this solve?

Manually uploading creatives, setting up ad sets, and creating ads in Meta’s Ad Manager is time-consuming, repetitive, and error-prone—especially at scale. This workflow eliminates the manual work by pulling data from Google Sheets and using it to automatically:

- Generate Facebook Ad Sets - Upload creative images - Build and launch Ad Creatives and Ads - Update your source spreadsheet with generated Ad IDs  What this workflow does

Using a trigger from a Google Sheets row update, this workflow: