I’m working on a scenario that automates the retrieval and organization of social media-related data using Google Sheets and Google Drive—without directly integrating with any social platforms (yet). Here’s what I’m trying to achieve:
What the Scenario Does (or Should Do)
Trigger: The workflow begins by watching a Google Sheet for new rows.
Search by Channel: Once triggered, I want the system to retrieve one row for each of four channels: Facebook, Instagram, YouTube, and TikTok. → this is where I am really struggling. Currently, it’s only returning rows for Facebook.
Locate Assets: For each row found, I search Google Drive by name to get the corresponding File ID.
Log the Results: Then, I add a new row in another sheet called “Upload”. This helps me simulate and validate what’s being retrieved, before I eventually connect it to real social media APIs.
What I Need Help With
Right now, I’m stuck at the part where I want to retrieve one row per social media channel I feel like this may have to do with the google drive or something in between. I’m not sure how to structure the logic or filters so that I get exactly one row for each channel.
It seems you must be having multiple bundles in first module and then for each bundle your next modules are running multiple times. Still your problem is not clear to us. What is in the first module sheet?? @V_S
Hi, the first module sheet is identical to the second one—it includes the Song Name, Status, and Channel columns. Make requires a trigger, so I’ve added a basic one for now.
In the module where I’m searching through rows, my goal is to retrieve only one row per social media channel (which currently I do not know how to do. Once I have those rows that include video information, I want to search for the corresponding videos in my Google Drive.
To confirm that I’ve successfully found the correct files, I record their FileIDs in a separate sheet called “Upload.”
if you are getting rows but only want, you can use limit to 1. Is that what you are lookign for?? If still not, then I apologize, and request you to share a loom video on that. @V_S
What the Scenario Does (or Should Do)
What I Need Help With
