YouTube channel parser - TrendWatching - integration Make + Apify
It is necessary to set up the TrendWatching system: regularly or manually upon launch to collect new videos/posts from selected YouTube channels and Instagram accounts, and record the result in Google Sheets in the specified format.
2) Goal / Result
We add links to the channels/accounts we want to monitor.
We run the script:
manual launch (button in Make)
or automatically once a week
As a result, we get an updated Google Sheets table with a list of content and metrics. (details in the table)
Filter: content no older than 90 days
First “historical” export: up to 100 content items from each channel (YouTube; for Instagram - agreed similarly “up to 100”, or “last N content”)
3) Sources / Platforms
YouTube:
Channels (channel URL or handle)
Need to collect: list of videos, dates, links, metrics. (short to be separated or marked)
Instagram:
Accounts (profile URL)
Need to collect: Reels + Posts (minimum Reels; preferably both), dates, links, metrics.
4) Where to write the result
Google Sheets (I will provide access). Here is a file with an example of how it should look in the output
Table (working): https://docs.google.com/spreadsheets/d/1ZhbD6EHgPQXglhhpjuPCNCsyYsmj1Zd0PZM2wPYG_sc/edit?usp=sharing
There are test developments (Make + API/Apify), it needs to be brought to a working stable solution, there is no time to implement it independently. I used this apify https://apify.com/streamers/youtube-channel-scraper
if there are clarifying questions, feel free to ask, I will respond
I am looking for a person for ongoing collaboration on similar tasks, automation on make + AI, etc. so after this task, if everything goes well, there will be others.
-
Good day!
I have practical experience in building TrendWatching systems using Make + Apify + Google Sheets, including for YouTube and Instagram. I work not with "demo scenarios," but with stable solutions that can be scaled and handed over to the team.
How I see the implementation of the task:
1. Solution architecture
Make — orchestration of scenarios (manual + scheduled).
… Apify — parsing YouTube and Instagram (through verified actors).
Google Sheets — final storage with a clear column structure.
Filtering and deduplication logic — at the Make level.
2. YouTube
Support for channel URL / handle.
Collection:
video title;
publication date;
link;
views, likes, comments;
content type (Shorts are marked separately).
Filter:
no older than 90 days;
first historical export — up to 100 videos from the channel.
3. Instagram
Collection of Reels + Posts (minimum Reels).
Data:
date;
link;
likes, comments, views (where available).
First export — up to 100 content items / or the last N (to be agreed upon).
Preparation for possible Instagram limitations (fallback logic).
4. Google Sheets
Recording in the specified format (according to your template).
No duplicates.
Updates:
manual launch by button;
automatically once a week.
Careful work with API limits.
5. Result
Fully functional scenario.
Comments in Make (to clarify what and where to change).
Test run + data verification in the table.
Cost
Fixed price for the task: 12,000 UAH
The price includes:
• refinement of existing developments
• stabilization of the scenario
• integration with Google Sheets
• testing
Further refinements / new sources — separately by agreement.
Terms
5–7 working days, depending on:
the number of channels/accounts;
selected Apify actors;
Instagram limitations.
Long-term
Open to ongoing collaboration:
automation on Make;
integration with AI (content classification, tagging, scoring);
expanding TrendWatching to other platforms.
Ready to quickly get involved, review your test scenarios, and propose the optimal final architecture.
-
Hello, Maxim!
I am in 2nd place on the platform and specialize in developing chatbots and automating business processes. I work with services like n8n/Make.com.
Just the other day, I implemented automation for parsing YouTube/Instagram/TikTok, where we collect all possible metrics for videos and record them in Google Sheets.
I will tell you more and show you in private messages.
You can familiarize yourself with similar works in my portfolio:Freelancehunt
Feel free to reach out, I would be happy to discuss your project in more detail.
-
3858 11 0 Hello! I have extensive experience in building automated data collection systems (scraping) and their synchronization through Make. Your task is completely clear to me, and I am ready to bring your developments to a stable result.
How I will implement this project:
Reliable scraping: I will fine-tune the integration with Apify for YouTube and Instagram. This will ensure stable uploads even of large amounts of content (up to 100 items) without the risk of blocks.
Flexible filtering logic: I will set up an automatic "90 days" filter and content tagging (separating YouTube Shorts from regular videos).
Working with Google Sheets: I will configure the system so that the table not only gets filled but also correctly updates metrics (likes, views) for already existing entries, avoiding duplicates.
…
Scalability: Since you are looking for a long-term person, I will build the script architecturally correctly so that in the future it will be easy to add new platforms (TikTok, Twitter, etc.) or connect AI for analyzing the collected content.
Experience:
I have developed lead and content collection systems from various sources through Make/n8n.
I have worked with the APIs of most popular platforms and scraping tools (Apify).
I can integrate AI (GPT-4) for classifying and summarizing the collected data (which could be the next step for your TrendWatching).
-
432 1 0 Hello, Maxim!
I can implement a TrendWatching system for collecting content from YouTube and Instagram with automatic recording in Google Sheets based on Make.com.
I would be happy to discuss the details to propose the optimal solution.
-
1744 10 0 Good day
I am engaged in automations through the service Make.com
I can refine your already developed solution or create a new one according to your requirements.
Implement a scenario that will automatically go through the specified YouTube channels and Instagram accounts at the scheduled time (or upon manual launch) and input data for the last 90 days or however many you specify regarding the necessary metrics, and automatically mark whether it is a Video or Shorts. If the video or shorts are new, record them in a new row and calculate all metrics; if existing, update all metrics to the date of the scenario launch, without duplicating entries.
I will also create logic for two scenarios to ensure there is enough time to process all data across all channels and prevent the scenario from encountering an error.
Contact me to discuss the details)
-
747 2 0 Good day!
I have experience working with Make and automations of various levels of complexity. Previously, I set up scenarios for data collection from different platforms, integrations with Google Sheets, and processing metrics. With your task regarding TrendWatching, I can implement:
automatic and manual content collection from YouTube channels and Instagram accounts;
content filtering up to 90 days;
the first historical export of up to 100 units of content;
recording results in Google Sheets in the specified format;
tagging Shorts and processing Reels and Posts for Instagram.
… I can use existing Apify developments and bring the solution to stable operation, with the possibility of further support and automation of other tasks.
I am ready to start immediately and ensure a quality result.
-
172 1 1 Good day! I am ready to complete this project as I have extensive experience in application development.
-
326 Good day!
I can set up a scenario in Make using the Apify API to collect data from YouTube and Instagram and record the results in Google Sheets in the required format.
I will do:
– manual and automatic launch of the scenario
– content filtering (up to 90 days, no duplicates)
– correct table structure
– stable operation through Make + Apify API
…
I have experience working with Make, Apify, Google Sheets, and APIs.
After completion, I will be able to explain the logic of the scenario so that you can maintain it independently.
-
395 2 0 Good day, Maxim. I can set up data collection through Make + Apify. I specialize specifically in Make automations and have already set up the Apify scraper maps.
-
217 Good evening!
I am interested in this task, and right now I am studying Make and have familiarized myself with the table and your service Apify.
I am a junior, and in 7 days I will definitely bring my knowledge up to the required level and will be able to complete the assigned task. In the process, I will definitely test everything and provide you with a ready result that will satisfy you 100%. I will be waiting for your response, and have a good evening.
-
3099 31 0 Hello. I work with Zennoposter, I can implement this task. If you are interested - write to me.
-
Доброго дня, ютуб канали і акаунти інстаграм будуть запускатись одні і ті ж заново, і + нові додаватись, чи тільки нові будуть додаватись в таблицю по яким треба провести дослідження?
-
Просто саму систему не важко налаштувати, але підібрати правильний скрейпер на apify, щоб враховувати всі ваші вимоги, чи будуть перзапуски наприклад через тиждень по вже запущеним раніше каналам і тут вам може видати 90 відео з яких 5 буде нових, і 85 що вже в таблиці, тільки метрики хіба оновити по них, цю логіку теж треба враховувати)
-
Current freelance projects in the category Bot Development
Software maintenance
111 USD
It is necessary to make adjustments to the software and maintain it in the future; the software places orders based on specified parameters and sends them to a Telegram bot. Python, Bot Development ∙ 4 hours 47 minutes back ∙ 47 proposals |
Telegram bot
269 USD
It is necessary to completely replicate the interface and functionality, but without the payment platform. It needs to be done in a short time. Bot Development ∙ 1 day 2 hours back ∙ 102 proposals |
Automatic video posting on social media according to a scheduleTechnical Assignment (TA) Automatic video publication on social media according to a scheduleProject Description A script/bot (Python preferred, or any other solution of your choice — the main thing is stability and ease of maintenance) is needed, which automatically publishes… Python, Bot Development ∙ 1 day 4 hours back ∙ 54 proposals |
Bot for receiving/searching applications
28 USD
In short: Create a bot where users can create and find profiles, the bot should have referral links, etc. Everything is detailed below. Client-side bot: Before the /start button, text in the center of the chat: What can this bot do? Welcome to Sugar Secret Agency! -Premium… Python, Bot Development ∙ 1 day 6 hours back ∙ 59 proposals |
Signal bot with automation in Google SheetsA bot is needed that will accept an application and automatically place it in Google Sheets, for example: store1, 26.06, 500kg or 200kg, and it will automatically mark 500 or 200 in the cell of the date on the store's line in the table. Bot Development ∙ 1 day 6 hours back ∙ 61 proposals |