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
- Picks out the values
- Decides what to do next
- Calls the service's API
- Goes through each item
- Adds rows to your sheet
All 27 steps (as they appear in the app)
- Find /^#?\s*(\S+)/ → _tag
- If source equals Mastodon
- GET {{mastodon_instance}}/api/v1/timelines/tag/{{_tag:url}}?limit={{limit}}
- For each m in {{_posts}} (3 steps)
- _likes = {{m_favourites_count|0}}
- _k = mastodon:{{m_url}}
- If _likes less {{min_likes}}
- If _k seen in past runs
- _old = yes
- _old =
- If new_only equals yes
- If _old empty
- Add row: source, posted, author, text, likes, reposts, replies, link
- Add row: source, posted, author, text, likes, reposts, replies, link
- If source equals Reddit
- GET {{reddit_url}}?q=%23{{_tag:url}}&sort=top&t={{period}}&limit={{limit}}
- For each r in {{_posts}} (3 steps)
- _likes = {{r_data_score|0}}
- _k = reddit:{{r_data_id}}
- If _likes less {{min_likes}}
- If _k seen in past runs
- _old = yes
- _old =
- If new_only equals yes
- If _old empty
- Add row: source, posted, author, text, likes, replies, link
- 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 Autopilot2. 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 AutopilotWhat 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.