I’m trying to set up an automated system for creating trending short-form videos, but I’ve hit a snag. I’m using Make.com and Rapid API to grab YouTube transcripts and put them in Google Sheets.
The good news is I can get video IDs and titles without any problem. However, the transcripts are not showing up in my spreadsheet, and the short summary isn’t being created as expected.
I’ve reviewed the tutorial and my setup several times, but I just can’t pinpoint the issue. Has anyone experienced something similar or have any ideas on how to fix this?
Any advice or tips would be greatly appreciated!
hey mate, i had the same issue last week. turns out the problem was with the API endpoint i was using. double-check ur API settings and make sure ur using the correct endpoint for transcripts. also, try adding some error handling in ur Make.com scenario. it helped me figure out where things were going wrong. good luck!
Have you checked if the YouTube videos you’re targeting actually have transcripts available? Not all videos come with transcripts, especially if they’re user-generated content. Another potential issue could be rate limiting on the API side. If you’re making too many requests in a short time, some might fail silently.
It might be worth implementing error logging in your Make.com scenario to catch any issues that are occurring during the API calls or data processing steps. This could provide valuable insights into where exactly the process is breaking down.
Also, ensure that your Google Sheets permissions are set correctly to allow external services to write data. Sometimes, this can be overlooked and cause silent failures in automation workflows.
I encountered a similar problem when setting up my automation for pulling YouTube transcripts. After some investigation, I discovered that issues with API calls or data parsing were frequently at fault. It helped to verify that my API key had the proper permissions and to confirm that the video IDs I was using actually had transcripts available. Checking the raw API response for error messages was also crucial. Trying out one video manually allowed me to isolate the issue, whether it was with the API response or the Google Sheets integration. I hope this offers a useful direction for resolving your issue.