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, 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.
-
We have begun cross-posting to Instagram reels and want to set up a comment-to-DM link automation for these videos, to route the commentors to the TikTok shop product affiliate link
Here is the problem:
- She has thousands of videos, reviewing hundreds of products (meaning hundreds of affiliate links).
- Each video comment has a unique codeword and affiliate link
- Setting up a new automation for each of these manually would take years
The goal:
I have an Airtable sheet that lists each Instagram Post ID, Product Name, Keyword, and cooresponding Affiliate link. For example, when someone comments “lashes” on the “lashes” video, they instantly get the correct DM with the link to that product. 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.
I’ve tried setting up a “universal” automation for all videos and any comment as a trigger, with an external HTTP request, but it will not allow me to map to Instagram Post ID, Instagram comments, or User ID. It also will not map to my airtable, as far as I can tell.
Does anyone know a workaround for this? Is there another solution I am not thinking of?
Thanks in advance!