Track Competitor Ad Changes with Adyntel & Google Sheets Automation

Track Competitor Ad Changes with Adyntel & Google Sheets Automation

Stay ahead of your competition with the ultimate automation solution that monitors and analyzes changes in your competitor's advertising strategies. Leverage the power of Adyntel, Google Sheets, and OpenAI to gain critical insights into your competitors' current advertising messages and strategic shifts, all seamlessly integrated with Slack alerts for real-time decision-making.

What this workflow does

• Runs on a predefined schedule to scan competitor domains marked as Pending in Google Sheets.
• Utilizes Adyntel to fetch active ads from Meta (Facebook Ads), Google Ads, and LinkedIn Ads, merging them for a comprehensive view.
• Processes the extracted ad content by deduplicating titles and body copy, consolidating insights into a competitor-specific context for this week.
• Compares this week's data to the previous week's snapshot stored in Google Sheets to identify updated or new ad messaging.
• Records any competitor that no longer has visible ads with a "gone dark" marker in the messaging_deltas sheet.
• Employs OpenAI to generate a week-over-week analysis, parsing changes for strategic insights and updating Google Sheets.
• Updates ad records this week for ongoing tracking and sends Slack alerts if significant shifts in messaging are detected.

Use cases

• Marketing teams can monitor competitor ad strategies to adjust their campaigns dynamically.
• Business analysts can utilize automated insights to recommend strategic pivots based on competitor changes.
• SaaS operators can streamline competitive analysis, saving countless hours of manual tracking and analysis.

Technical details

• Integrations: Google Sheets, Adyntel API, Slack, OpenAI.
• n8n Nodes Used: If, Code, Merge, n8n-nodes-adyntel, Sticky Note, Google Sheets.
• Requirement: Connect Google Sheets OAuth2 credentials and update your spreadsheet/document ID and specific sheet tabs used for competitors, ad_copy_snapshots, and messaging_deltas.