Reconcile blended ROAS, MER and CAC with Meta, Google, TikTok and Claude

by Nocode Expert ✓ · 12 views · created 2026-07-11 · Market Research, AI Summarization

What this workflow does

This workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Facebook Graph API. It also calls business-api.tiktok.com, oauth2.googleapis.com and api.anthropic.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Set config: store revenue, new customers, extra platforms (Code): runs custom JavaScript code
2. Fetch Meta spend & revenue (Meta) (Facebook Graph API): uses Facebook Graph API
3. Fetch TikTok spend & revenue (HTTP Request): calls business-api.tiktok.com
4. Get Google access token (HTTP Request): calls oauth2.googleapis.com (POST)
5. Fetch Google Ads spend & revenue (HTTP Request): calls an HTTP API (POST)
6. Assemble platform table (Code): runs custom JavaScript code
7. Reconcile blended ROAS, MER & platform over-claim gap (Code): runs custom JavaScript code
8. Build AI efficiency brief prompt (Code): runs custom JavaScript code
9. Write marketing-efficiency brief with Claude AI (HTTP Request): calls api.anthropic.com (POST)
10. Show blended ROAS / MER scorecard (Code): runs custom JavaScript code

Services it uses

Facebook Graph API

HTTP calls to: business-api.tiktok.com, oauth2.googleapis.com, api.anthropic.com

Before you upgrade to n8n 3.0

Nodes used (4)

• Manual Triggern8n-nodes-base.manualTrigger
• Coden8n-nodes-base.code
• Facebook Graph APIn8n-nodes-base.facebookGraphApi
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview This workflow pulls ad spend and platform-reported revenue from Meta (with placeholders for Google Ads and TikTok), combines it with your actual store revenue and new-customer count, calculates blended ROAS/MER and blended CAC plus…

View the original on n8n.io → Check your own copy