Step 2: Connect Google Sheets and Define Input Variables

This step prepares input parameters and loads existing ad IDs for de-duplication.

1. Open Define Input Fields and set the assignments: ad_active_status to active, search_page_ids to [YOUR_ID], ad_reached_countries to US,AU,NZ,CA, keywords to an empty string, and access_token to [CONFIGURE_YOUR_TOKEN].
2. Note the parallel split: Define Input Fields outputs to both Retrieve Stored IDs and Route Pages or Terms in parallel.
3. Open Retrieve Stored IDs and select the target spreadsheet: documentId [YOUR_ID] and sheetName gid=0, with range set to J:J.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Stored IDs.
5. Ensure Retrieve Stored IDs connects to Compile ID Registry.

Step 3: Configure Ad Fetching and Pagination Logic

Set up the routing and API calls to pull ads by page or keyword and handle pagination.

1. In Route Pages or Terms, confirm the rule that checks {{$json.search_page_ids}} and routes to the “pages” output when not empty.
2. Open Fetch Ads by Page and set the url to =https://graph.facebook.com/v22.0/ads_archive?ad_active_status={{ $json.ad_active_status }}&search_page_ids={{ $json.search_page_ids }}&ad_reached_countries={{ $json.ad_reached_countries }}&fields=ad_creation_time,ad_creative_bodies,ad_creative_link_captions, ad_creative_link_descriptions,ad_creative_link_titles,ad_delivery_start_time, ad_snapshot_url, languages, page_name,publisher_platforms&limit=50&access_token={{ $json.access_token }}.
3. Credential Required: Connect your httpHeaderAuth credentials in Fetch Ads by Page.
4. Open Fetch Ads by Keyword and set the url to =https://graph.facebook.com/v22.0/ads_archive?ad_active_status={{ $json.ad_active_status }}&search_page_ids={{ $json.search_page_ids }}&ad_reached_countries=US,CA&fields=ad_creation_time,ad_creative_bodies,ad_creative_link_captions, ad_creative_link_descriptions,ad_creative_link_titles,ad_delivery_start_time, ad_snapshot_url, languages, page_name,publisher_platforms&access_token={{ $json.access_token }}.
5. Credential Required: Connect your httpHeaderAuth credentials in Fetch Ads by Keyword.
6. Confirm Normalize & Pagination Check runs after both fetch nodes and that it outputs to Next Page? and Combine Existing IDs in parallel.
7. In Next Page?, ensure the condition checks {{$json.next_url}} for not empty. If true, it flows to Prepare Next Link, which sets url to {{$json.next_url}} and then triggers Paginated Ads Request.
8. In Paginated Ads Request, keep the url value as {{$json.url}} to retrieve subsequent pages.

Step 4: Deduplicate Ads and Append to Google Sheets

This stage merges stored IDs with new results, isolates fresh creatives, and writes them to your sheet.

1. Verify Compile ID Registry receives data from Retrieve Stored IDs and outputs to Combine Existing IDs.
2. Ensure Combine Existing IDs uses mode combine and combineBy combineAll.
3. Check Isolate Fresh Creatives follows Combine Existing IDs and retains only ads whose IDs are not in existingIds.
4. Confirm Expand Items splits fieldToSplitOut to data and includes include set to allOtherFields.
5. Expand Items outputs to both Append to Sheet and Count New Records in parallel.
6. Open Append to Sheet, set operation to appendOrUpdate, and map columns using the existing expressions like {{$json.data.id}}, {{$json.data.page_name}}, and {{$json.data.ad_snapshot_url}}.
7. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append to Sheet.

Step 5: Configure Notifications for New Ads

When new ads are found, the workflow sends alerts to Telegram and Slack.

1. Open Count New Records to ensure it returns newCount based on items.length.
2. In Check for New Ads, confirm the condition is {{$json.newCount}} gt 0.
3. Validate the parallel branch: Check for New Ads outputs to both Telegram Notification and Slack Channel Alert in parallel.
4. In Telegram Notification, set text to =Hello! {{$json.newCount}} of ads were found today! You can see full list here — [YOUR_ID] and chatId to [YOUR_ID].
5. Credential Required: Connect your telegramApi credentials in Telegram Notification.
6. In Slack Channel Alert, set text to =Hello! {{$json.newCount}} of ads were found today! You can see full list here — [YOUR_ID] and choose the target channel.

Step 6: Test and Activate Your Workflow

Run a manual test and then enable the workflow to monitor ads on schedule.

1. Click Execute Workflow to run from Scheduled Starter and watch data flow into Append to Sheet and notification nodes.
2. Confirm successful execution by checking that new rows appear in the Google Sheet and that Telegram Notification or Slack Channel Alert fires when newCount is greater than 0.
3. Once validated, toggle the workflow to Active so it runs on the configured schedule.