Hi all—hoping someone here has tackled something similar or can steer me in the right direction. I’m trying to build an automated reposting and messaging agent for my wife’s affiliate videos using Make, Manychat (or alternatives), and a few AI tools.
Here’s the setup:
- My wife creates ~5 TikTok videos per day, each promoting one product from the beauty/health space.
- Each TikTok video includes a link to the TikTok Shop product. If someone buys through it, she earns a commission.
- She uploads the video files daily to a specific Google Drive folder.
- I have Make trigger when a new video is added. It:
- Pulls the video,
- Extracts/condenses it,
- Uses Whisper + ChatGPT to transcribe and determine the exact product,
- Assigns a keyword (e.g., “lashes”, “shorts”, “vitamin”),
- Writes an Instagram caption like: “This product is a game-changer. Comment ‘lashes’ for the link in your DMs!” with relevant hashtags,
- Stores all this in Airtable or Google Sheets.
- My wife manually pastes the correct TikTok affiliate link into the {affiliate link} field and changes the status to “approved.”
- When approved, Make posts the video to Instagram Reels with the AI-generated caption.
Here’s where I’m stuck:
I want to automate the DM flow. I am attempting to use Manychat for this portion, since it connects with Make.
Goal: When someone comments “lashes” on the “lashes” video, they instantly get the correct DM with the link to that product.
Each video has its own product, its own keyword, and its own affiliate link.
But in Manychat, I haven’t found a way to dynamically create new flows per video or use a data source to automatically map video ID + keyword + DM content. I’ve only been able to do this manually per post—thumbnail selection, keyword input, message creation, etc.—which is not scalable.
So my question is:
- Has anyone successfully automated this kind of Manychat flow where the keyword and DM content are set dynamically per new Reel?
- If Manychat can’t do this, is there another tool that can (preferably one that plays well with Make)?
- Would something like Meta’s API (comment webhooks + DM API) be more appropriate, and is there a middle layer that could simplify this?
- Open to any platform suggestions, creative workarounds, or flow architecture that avoids creating 150+ separate manual automations per month.
- I have asked ChatGPT for guidance already. It suggested creating a “universal” automation for all videos, then have Manychat make an external HTTP request, pulling in the Instagram Post ID, Comment Keyword, and User ID. Then, it would send that person a DM in Instagram with the corresponding affiliate link. However, Manychat is not allowing me to map any of those, so I am at another roadblock.
Thanks in advance—really hoping someone out there has figured this out or can point me toward something that’ll save my wife (and me) a ton of time.