Recipes

Each recipe is a schedule, one data query, and a place to send the result. Each recipe works in n8n, Make and Zapier, with the REST API and an API key.

On the Automations tab of the AI tools page, each recipe has a Set up in button for each platform. The steps there contain your team ID and one of your accounts.

Weekly ad spend to Slack

Every Monday, post last week's spend, clicks and conversions for each campaign.

1. Schedule: every week, on Monday, at 9:00.
2. Query: send this body to POST /v1/teams/<your-team-id>/data/run-query:

   {
     "accounts": ["gadw_1234567890"],
     "dimensions": ["campaign_name"],
     "metrics": ["amount_spent", "clicks", "conversions"],
     "dateRange": "last_7_days",
     "sort": [{ "fieldId": "amount_spent", "direction": "desc" }]
   }
   

3. Destination: a Slack message to your channel, with the campaigns from the response's rows.

Use an ad account: Google Ads, Facebook Ads, LinkedIn Ads, Microsoft Ads or TikTok Ads.

Daily GA4 into Google Sheets

Every morning, add yesterday's sessions, new users and key events as a row.

1. Schedule: every day, at 8:00.
2. Query:

   {
     "accounts": ["ga4_123456789"],
     "dimensions": ["date"],
     "metrics": ["ga4_sessions", "ga4_new_users", "ga4_key_events"],
     "dateRange": "yesterday"
   }
   

3. Destination: a new row in Google Sheets, with date, sessions, new users and key events in your columns.

Alert when spend is high

Every morning, check yesterday's spend. Send a message only when it is more than your limit.

1. Schedule: every day, at 9:00.
2. Query:

   {
     "accounts": ["gadw_1234567890"],
     "metrics": ["amount_spent"],
     "dateRange": "yesterday"
   }
   

3. Filter: continue only when the amount spent in the response is more than your limit. In n8n, use an If node. In Make, add a filter after the request. In Zapier, use Filter by Zapier.
4. Destination: a Slack message or an email with the amount spent.

Field names in these recipes

• amount_spent, clicks, conversions, campaign_name and date are common fields. They work for all ad connectors. Use amount_spent for spend. There is no cost field.
• ga4_sessions, ga4_new_users and ga4_key_events are GA4 fields. They have the ga4_ prefix.

To find other fields, see the Field Explorer.