How to seperate tiktok leads data to excel couple of sheet by tiktok formID(form name)


I’m working on a project where I need to manage multiple TikTok lead forms organized by campaigns and automatically send SMS notifications to designated clients for each form submission.

Here’s the workflow I’m trying to set up:

  • Form A submissions → Data is stored in Sheet 1.
  • Form B submissions → Data is stored in Sheet 2.
  • Form C submissions → Data is stored in Sheet 3.

The data should be processed and stored sequentially in the respective sheets based on the form ID.

However, I’m encountering an issue. While mapping TikTok Lead Forms data to Excel, the mappable fields (answers), such as 2.mappableAnswers.age or 2.mappableAnswers.phone_number, are no longer appearing as expected. Previously, these fields were available for mapping (as seen in the black-highlighted list in the sidebar), but now they are missing.

I’ve tested the Webhook connection and ensured that the forms are set up correctly in TikTok Ads Manager. The forms are receiving submissions, but the detailed form field values are not appearing during data mapping in Make.

Could someone advise why these mappable fields might be missing and how I can resolve this issue? Are there additional steps I need to take to ensure the TikTok Lead Forms data is correctly passed through Make? Any tips or suggestions would be greatly appreciated!

I see it’s been a while since this topic was discussed, but I’m curious—did you find a good solution for separating TikTok leads into different sheets in Excel? I know Make has some great filtering options, but I wonder if using a combination of routers and variables would make things easier. Has anyone tried a setup where you dynamically create sheets based on the form name?