Hello Community, I am having a difficult time setting up my automation. I will make a google sheet that has all the video names I have and have not yet posted
, the headers could potentially look like the attached screenshot. Each video belongs to a different social media platform therefore I need to retrieve the right video for the correct platform that has not been posted. I think that to be able to post that video I also have to download it from the google drive? I also intend to generate a caption from it with a prompt I have already written that is somewhat generic. How should I go about this scenario? Also is it possible to randomize the video names I retrieve? Thanks.
sorry but what exactly is the issue you are facing? What you are describing is entirely doable, so can you share some screenshots of the scenario you have and what you are struggling with?
Hi. I am actually struggling with the whole scenario to be honest. I keep overthinking and deleting what I have. I cannot wrap my head around a workflow that will do what I want.
Google App script that watches when a new row is added → Calls a Make webhook with the data in the row to trigger the scenario → Takes Title, Description, Tags and URL of the photo/video from the google sheet and forwards it to the respective social media platform for posting (have a router that splits with filters after it so each different platform has its own path) → updates the sheet with the ID of the post if you need it, or just sets the Status as Posted.
If you need to download the photo/video, add the URL to the sheet and add a module to download it in the respective place. If you don’t need to download it, then just forward the URL.
This is what I am attempting to do. A scenario automates the retrieval and organization of social media data using Google Sheets and Google Drive, without directly connecting to any social platforms yet.
Trigger: It starts by watching a Google Sheet for new rows.
Search by Channel: When a new row is added, the system searches for corresponding rows related to four social media channels—Facebook, Instagram, YouTube, and TikTok. Currently, I’m only retrieving Facebook rows, but the intent is to eventually fetch one row per channel.
Locate Assets: For each matched row, the workflow searches Google Drive to find the relevant file or folder by name and retrieve its File ID.
Log Results: Finally, the collected data is logged in another Google Sheet called “Upload”. This acts as a simulation for the upload process, helping me verify and validate what’s being retrieved—before actually integrating with any social media APIs.
