A creator database built from keywords, filtered by the numbers

The scenario searches videos for your keywords, collects creator channels with their stats and keeps only the ones that pass your criteria.

  • Creator discovery runs itself, on schedule
  • Channels arrive with stats, not just names
  • Small and dead channels are filtered out
  • Keywords are processed in order, with no duplicates
Google Sheets

How it works

To create Google Sheets records from aqara without manual input, use a ready-made scenario.

  1. Starts when: Schedule Trigger
  2. Then: List of Target Keywords
  3. Then: Get the first keyword
  4. Then: Update Keyword Status -> Processing
  5. Then: Search Videos based on Keywords
  6. Then: Extract Channel Ids from the Video Results
  7. Then: Get Channel Stats
  8. Then: Filter based on Criteria
  9. Then: Append or update row in sheet
  10. Then: Run an Actor and get dataset
  11. Then: Code in JavaScript
  12. Then: Append or update row in sheet1

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.