Tracking competitors' new ads — into a sheet and chat

On a schedule the scenario pulls fresh ads from the ads library via aqara, keeps the new ones, appends them to таблица, and notifies мессенджер.

  • Competitors' new angles, first
  • Only what's new, no duplicates
  • Ad history builds up in a sheet
  • A ping only when there's something to show
Google SheetsSlackTelegramGet TT Ads through Apify
Connect aqara and goScriptera

How it works

To get aqara notifications in Google Sheets, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Schedule Trigger
  2. Then: Set Parameters
  3. Then: Convert Dates to Unix
  4. Then: Build Apify Body
  5. Then: Get TT Ads through Apify
  6. Then: Prepare Data for Sheets
  7. Then: Read existing IDs
  8. Then: Collect ID list
  9. Check: Attach existing ids
  10. Then: Filter new creatives
  11. Then: Append or update row in sheet
  12. Then: Count new ads
  13. Check: Any new ads?
  14. If yes: Send a text message
  15. If yes: Send a message

You can launch this aqara + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios