(5/5)

Online Marketing Weekly Report

Automated workflow: Online Marketing Weekly Report. This workflow integrates 17 different services: stickyNote, httpRequest, facebookGraphApi, telegram, code. It contains 68 nodes and follows best practices for error handling and security.

Integrations Used (7)

Workflow Structure (46 nodes)

100%

Schedule Trigger

Execute Workflow Trigger

No Op

OpenAI Chat Model

Google Analytics

Call Google Analytics data: Last 7 days

No Op

Analytics_Domain_1

Set

Assign Google Analytics data input (current year)

No Op

Analytics_Domain_2

No Op

Weekly Report Agent

No Op

Analytics_Domain_3

Summarize

Summarize Google Analytics input (current year)

No Op

Analytics_Domain_4

Code

Calculation same period previous year1

No Op

Analytics_Domain_5

No Op

Google_Ads

Google Analytics

Call Google Analytics data: Last 7 days (previous year)

No Op

Meta_Ads

Set

Assign Google Analytics data input (previous year)

No Op

Processing for Telegram Report

Summarize

Summarize Google Analytics input (previous year)

No Op

Processing for Google Analytics Report

Email Send

Send mail report

Send Telegram report

Code

Calculate date format for Google Ads request (last 7 days)

Code

Calculate date format for meta ads request s

Http Request

Call Google Ads Data: Last 7 days

Facebook Graph Api

Call Meta Ads Data: Last 7 days

Code

Format data input (current year)

Set

Assign Meta data from input (current year)

Set

Assign data from input (current year)

Summarize

Summarize Meta input (current year)

Summarize

Summarize input (current year)

Facebook Graph Api

Call Meta Ads Data: Last 7 days (previous year)

Code

Calculation same period previous year

Http Request

Call Google Ads Data: Last 7 days (previous year)

Set

Assign Meta data input (previous year)

Code

Format data input (previous year)

Set

Assign input (previous year)

Summarize

Summarize Meta data input (previous year)

Summarize

Summarize input (previous year)

Code

Format all Meta data for LLM

Code

Format all Google data for LLM

No Op

Calculator

No Op

Processing for Google Ads report

No Op

Processing for Meta Ads Report

No Op

Calculator1

No Op

Calculator3

Node Types:

trigger

default

action

code

transform

http

Requires credentials

Prerequisites

Required Credentials (7)

Facebook

Used by: Call Meta Ads Data: Last 7 days, Call Meta Ads Data: Last 7 days (previous year)

Docs

Google Ads

Used by: Call Google Ads Data: Last 7 days, Call Google Ads Data: Last 7 days (previous year)

Docs

Google Analytics

Used by: Call Google Analytics data: Last 7 days, Call Google Analytics data: Last 7 days (previous year)

Docs

Google OAuth2

Used by: Call Google Ads Data: Last 7 days, Call Google Ads Data: Last 7 days (previous year)

Docs

OpenAI

Used by: OpenAI Chat Model, Processing for Google Ads report +3 more

Docs

Smtp

Used by: Send mail report

Docs

Used by: Send Telegram report

Docs

Multiple services required

This workflow needs 7 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~1 hour

Score: 80/100

Custom Code

9 Integrations

When to Use This Workflow

Email Automation

Automate email responses, forwarding, or organization based on rules.

Handle routine email tasks automatically and focus on what matters.

Scheduled Operations

Run automated tasks at specific times - daily reports, weekly cleanups, monthly backups.

Set it and forget it - reliable automation that runs on your schedule.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

workflow.json

{
  "id": "knmxcsujuHmViJl4",
  "meta": {
    "instanceId": "workflow-cd2ee5c6",
    "versionId": "1.0.0",
    "createdAt": "2025-09-29T07:07:57.779992",
    "updatedAt": "2025-09-29T07:07:57.780004",
    "owner": "n8n-user",
    "license": "MIT",
    "category": "automation",
    "status": "active",
    "priority": "high",
    "environment": "production"
  },
  "name": "Online Marketing Weekly Report",
  "tags": [
    "automation",
    "n8n",
    "production-ready",
    "excellent",
...