Skip to main content

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!

@devries.devon you won’t be able to do it with comments, since Manychat does not give us the post id on the automation.

However, if you do it with sending keywords with DM’s, then it’s possible.

You pick up the keyword in the Last Text Input, query your Airtable, and then you can trigger the right automations, or setup your ‘wireframe’ automation with the right custom fields to send the right info to the specific user.

I’ve done automations like this before where we have dynamic content based on external information. It’s tricky, but doable… Feel free to reach out if you’d like to discuss best strategies to get this going ;)

 


Reply