The Scenario
You're the network affiliate manager at a company that just launched an MLM-style referral tier. The mechanics: top affiliates recruit sub-affiliates, earning a percentage of their recruits' commissions. You designed the hierarchy. You have a spreadsheet with 90 rows — each one a child affiliate ID paired with the parent who recruited them.
Tapfiliate needs to know about every one of these relationships before the program goes live next Monday.
The bad version:
- Open Tapfiliate, search for the first child affiliate ID, open their profile, find the parent affiliate field, enter the parent ID, save.
- Do it 89 more times.
- Discover on row 30 that two parent affiliate IDs in your sheet don't match any accounts in Tapfiliate — they were entered as email addresses instead of IDs.
- Pause the whole operation to figure out the correct IDs, then re-enter the rows you skipped.
The program launch announcement is already out. Partners are expecting their referral links and commission tracking to be live on Monday. You have 90 relationships to register and a whole weekend between here and there.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the parent-child mapping and registers each relationship in Tapfiliate through its built-in integration — no manual profile visits.
For each row in this sheet, set the Tapfiliate parent affiliate relationship — column A is the child affiliate ID and column B is the parent affiliate ID
What You Get
- Each parent-child relationship registered in Tapfiliate for every row in the sheet.
- Column C populated with the result: "linked," "child not found," "parent not found," or "already linked" — so you know exactly which rows need follow-up.
- Any rows where the IDs don't match existing Tapfiliate accounts flagged specifically, rather than causing the entire batch to fail.
- 90 relationships registered in one operation.
What If the Data Is Not Quite Ready
Some parent entries are email addresses, not affiliate IDs
Your sheet was built from two sources and the older entries used emails instead of IDs for parents.
For each row in this sheet, set the Tapfiliate parent-child relationship with child ID from column A and parent from column B. If column B contains an email address instead of an ID, look up the affiliate by email to get their ID before making the link. Write the resolved parent ID and result status to columns C and D
The hierarchy has three tiers (grandparent → parent → child)
Your program has a three-level structure. Some affiliates are children of parents who are themselves children of top-level recruiters.
Register the parent-child relationships in this sheet — column A is child affiliate ID, column B is immediate parent affiliate ID. For rows where column C contains a grandparent ID, also set the grandparent-to-parent relationship if it isn't already registered. Write the result of each operation to column D
You need to verify current parent assignments before overwriting them
Some affiliates may already have a parent assigned from a previous program structure that shouldn't be overwritten.
For each row in this sheet, fetch the current parent affiliate ID for the child in column A from Tapfiliate and write it to column C. If column C already has a different parent, skip the update and write "conflict — manual review" to column D. Only update affiliates that currently have no parent assigned
Full hierarchy migration with audit trail
For all 90 rows in this sheet: fetch the current parent assignment for each child in column A and write it to column C. Skip rows where the current parent already matches column B. For all remaining rows, set the parent in column B. Write the update result to column D. Summarize the total linked, skipped (already correct), and errored at the bottom of column D
One prompt handles the pre-check, the migration, and the summary.
Try It
Get the 7-day free trial of SheetXAI and open your hierarchy mapping sheet — then ask it to register all 90 parent-child relationships in Tapfiliate before your program goes live. For the next step, see bulk assigning affiliate groups to tier affiliates by their position in the hierarchy.