Monitor agency profitability with Facebook Ads, Shopify, Stripe, Clockify, Google Sheets, Slack and Gemini
Ready for 3.0What this workflow does
This AI workflow has 17 nodes and runs on a schedule (cron 0 8 * * 1). Along the way it connects Clockify, Stripe, Shopify and Facebook Graph API and 4 more.
How it runs
Trigger: On a schedule (cron 0 8 * * 1).
- Facebook Graph API: uses Facebook Graph API
- Get a campaign (Google Ads): get
- Get many orders (Shopify): get many
- Get a time entry (Clockify): get (time entry)
- Get a balance (Stripe): uses Stripe
- Facebook ads (Edit Fields (Set)): sets or maps fields
- Google ads (Edit Fields (Set)): sets or maps fields
- Shopify (Edit Fields (Set)): sets or maps fields
- Stripe (Edit Fields (Set)): sets or maps fields
- Clockify (Edit Fields (Set)): sets or maps fields
…plus 5 more steps. See the full node list below.
Services it uses
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 (13)
- Clockify
n8n-nodes-base.clockify - Stripe
n8n-nodes-base.stripe - Shopify
n8n-nodes-base.shopify - Facebook Graph API
n8n-nodes-base.facebookGraphApi - Google Ads
n8n-nodes-base.googleAds - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - Slack
n8n-nodes-base.slack - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
From the author
Overview Stop guessing your agency's actual margins. This workflow acts as a centralized financial brain for digital marketing agencies. It aggregates real-time data from your time-tracking, ad platforms, and payment processors to calculate precise…