n8n Workflow: Create Meta Facebook Ads from Google Sheets

Create Meta Facebook Ads automatically from your Google Sheets queue

This n8n workflow watches a Google Sheets “ad generation” queue and, when a row is flagged, uses the Meta (Facebook) Graph API to create a new ad set, upload your image, build the ad creative, and create a paused Facebook ad—then writes the resulting Ad ID (or an error) back to the sheet.

What this workflow does

• Polls Google Sheets every 5 minutes and triggers when a row is updated.
• Checks the updated row’s “Generate Ad” column. Only rows set to generate are processed; all others are skipped.
• Reads the row’s Hooks and Render URL and combines them with your preset Meta Ads configuration (e.g., account, campaign, budget, targeting, CTA, and status).
• Creates a Meta (Facebook) ad set in the configured ad account under the specified campaign.
• Uploads the ad image to Meta using the provided Render URL, then uses the returned image hash to create an ad creative for your configured Facebook Page and destination URL.
• Creates the Meta (Facebook) ad inside the new ad set and sets its status (default is PAUSED).
• Updates the same Google Sheets row with the created Ad ID on success, or writes an error message if any Meta API step fails.

Use cases

• Marketing teams generate Facebook ads in bulk by adding rows to a Google Sheets spreadsheet.
• SaaS operators test new creatives by providing a Render URL while keeping targeting and CTA consistent.
• Automation engineers manage controlled, paused ad launches and record outcomes directly back in Sheets for review.

Technical details

• Google Sheets trigger + two Google Sheets update steps (OAuth credentials required).
• Meta (Facebook) Graph API integration for ad set creation, image upload from a URL, creative creation, and ad creation (ads_management permission).
• n8n logic nodes such as if, set, no op, merge, plus a sticky note for workflow documentation.

Result: reliable Meta Facebook ad creation from a Sheets-driven queue, with full status feedback written back to your spreadsheet.