Develofly Autopilot
Templates › Social & Content › Hashtag / trend collector

Hashtag / trend collector

Pull top posts for a hashtag into a sheet.

Social & ContentDaily

Download the app, freeOpen in Autopilot

Hashtag / trend collector: what it does, step by step, with its sample data

What it does

Collects posts for each hashtag in your list into a sheet: author, text, likes, reposts, replies and link, from Mastodon (any public server, no account needed) or Reddit (top posts for the period). Filter by a minimum number of likes, and keep only posts not seen before to build a running log. Sort the sheet by likes for the top posts.

How it works

  1. Picks out the values
  2. Decides what to do next
  3. Calls the service's API
  4. Goes through each item
  5. Adds rows to your sheet
All 27 steps (as they appear in the app)
  1. Find /^#?\s*(\S+)/ → _tag
  2. If source equals Mastodon
  3. GET {{mastodon_instance}}/api/v1/timelines/tag/{{_tag:url}}?limit={{limit}}
  4. For each m in {{_posts}} (3 steps)
  5. _likes = {{m_favourites_count|0}}
  6. _k = mastodon:{{m_url}}
  7. If _likes less {{min_likes}}
  8. If _k seen in past runs
  9. _old = yes
  10. _old =
  11. If new_only equals yes
  12. If _old empty
  13. Add row: source, posted, author, text, likes, reposts, replies, link
  14. Add row: source, posted, author, text, likes, reposts, replies, link
  15. If source equals Reddit
  16. GET {{reddit_url}}?q=%23{{_tag:url}}&sort=top&t={{period}}&limit={{limit}}
  17. For each r in {{_posts}} (3 steps)
  18. _likes = {{r_data_score|0}}
  19. _k = reddit:{{r_data_id}}
  20. If _likes less {{min_likes}}
  21. If _k seen in past runs
  22. _old = yes
  23. _old =
  24. If new_only equals yes
  25. If _old empty
  26. Add row: source, posted, author, text, likes, replies, link
  27. Add row: source, posted, author, text, likes, replies, link

Sample data included

The template comes with sample rows like these, so you can see it work before using your own list.

hashtag
#python
#opensource

Get this template

1. Download Develofly Autopilot: free, for Ubuntu and other Linux desktops.

Download Develofly Autopilot

2. The app comes with every template, so this one is already in your library. Click below to open it (or find it under Templates).

Open in Autopilot

What you need

  • A spreadsheet (CSV or Excel) — a sample is included

You fill in: Where, Mastodon server, Reddit: top of the, Posts per hashtag, Minimum likes, Only posts not collected before, Reddit search (advanced).

Make it yours

Every step is editable in the app: change the site, the columns, the schedule, or chain it with other bots. Run it once, on a schedule, or sell it as your own bot.

More Social & Content templates

Image bulk downloaderDownload images from a list of URLs into a folder.Content calendar posterPublish queued posts across platforms on schedule.Social mention monitorWatch for new brand mentions across sites and log them.YouTube channel stats trackerLog views and subscribers for your and rivals' channels.