Plan campaign targeting and pre-vet ad variants with Spendict, OpenAI, Slack and Google Sheets
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs when someone submits an n8n form (“Campaign brief”). Along the way it connects Google Sheets. It also calls spendict.com, hooks.slack.com and api.openai.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Campaign brief”).
- Spendict: strategize_targeting (HTTP Request): calls spendict.com (POST)
- Format the plan (Code): runs custom JavaScript code
- Slack: post strategy (HTTP Request): calls hooks.slack.com (POST)
- OpenAI: draft ads from strategy (HTTP Request): calls api.openai.com (POST)
- Split into variants (Code): runs custom JavaScript code
- Spendict: assess_ad_creative (HTTP Request): calls spendict.com (POST)
- Gate on verdict (Switch): routes items into 2 branches
- Row: vetted variant (Code): runs custom JavaScript code
- Killed drafts (logged) (Aggregate): combines items into one
- Google Sheets: append
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: spendict.com, hooks.slack.com, api.openai.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- n8n Form Trigger
n8n-nodes-base.formTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate
From the author
Quick Overview This workflow collects a campaign brief via an n8n form, uses Spendict to generate a targeting strategy, uses OpenAI to draft platform-specific ad variants, then has Spendict score and gate each draft before logging vetted variants to Google…