Step 2: Connect Manyreach Campaign Retrieval

Pull the campaign list and split each record into individual items.

1. Open Retrieve All Campaigns and set URL to https://app.manyreach.com/api/campaigns.
2. Under Query Parameters, add limit with value 100.
3. Credential Required: Connect your httpQueryAuth credentials.
4. Open Separate Campaign Records and set Field to Split Out to data.
5. Ensure Retrieve All Campaigns outputs to Separate Campaign Records.

Step 3: Set Up Filtering and Batch Iteration

Filter to only active, completed campaigns and process them in batches.

1. Open Filter Active Completed and set conditions: active equals true and campStatus equals completed.
2. Verify the left values use expressions {{ $json.active }} and {{ $json.campStatus }}.
3. Open Iterate Campaign Batches and keep default batch settings unless you need throttling.
4. Confirm the flow: Separate Campaign Records → Filter Active Completed → Iterate Campaign Batches.

Step 4: Set Up Campaign Analysis with AI

Retrieve each campaign’s details and generate a markdown report using the AI agent.

1. Open Retrieve Single Campaign and set URL to =https://app.manyreach.com/api/campaigns/{{ $json.campaignID }}.
2. Credential Required: Connect your httpQueryAuth credentials for Retrieve Single Campaign.
3. Open Campaign Analysis Agent and keep the Text field as provided (the long template with campaign metrics).
4. Open GPT-4.1 Chat Model and select model gpt-4.1.
5. Credential Required: Connect your openAiApi credentials in GPT-4.1 Chat Model. This model powers Campaign Analysis Agent, so credentials belong on GPT-4.1 Chat Model, not the agent.

Execution note: Retrieve Single Campaign → Campaign Analysis Agent → Convert Markdown to HTML.

Step 5: Build and Upload the Google Doc, then Post to Slack

Convert the report to HTML, package it for Google Drive, upload it, and share the link in Slack.

1. Open Convert Markdown to HTML and set Mode to markdownToHtml with Markdown set to ={{ $json.output }}.
2. Open Assign Document Details and set document_name to dfdfdfdf (replace with your desired file name logic).
3. Set html_content to ={{ $json.data }} and leave drive_folder_id blank if uploading to root.
4. Open Format HTML Payload ✨ and keep the jsCode as provided to build the multipart payload.
5. Open Upload Document File, set URL to https://www.googleapis.com/upload/drive/v3/files, Method to POST, and Body to ={{ $json.rawData }}.
6. Set Raw Content Type to multipart/related; boundary=divider and query parameters uploadType=multipart and supportsAllDrives=true.
7. Credential Required: Connect your googleDriveOAuth2Api credentials.
8. Open Post Document Link and set Text to =Campaign: {{ $('Retrieve Single Campaign').item.json.data.name }} Report Link: https://docs.google.com/document/d/{{ $json.id }}.
9. Credential Required: Connect your slackOAuth2Api credentials and select the channel ID.
10. Confirm the loop: Upload Document File → Post Document Link → Iterate Campaign Batches.

⚠️ Common Pitfall: If document_name stays as dfdfdfdf, every report will overwrite or create confusing files. Replace it with a dynamic name (for example, using campaign name and date).

⚠️ Common Pitfall: Post Document Link includes a placeholder channel ID [YOUR_ID]—you must pick a real Slack channel.

Step 6: Test and Activate Your Workflow

Run a manual test to confirm the entire flow generates a report and posts it to Slack.

1. Click Execute Workflow from Scheduled Weekly Trigger to run a test.
2. Verify Retrieve All Campaigns returns data and Filter Active Completed passes only active, completed campaigns.
3. Confirm Upload Document File returns a Google Drive file ID and Post Document Link posts a clickable link in Slack.
4. Once validated, toggle the workflow to Active so it runs every week.