Step 2: Connect Google Sheets

Configure the spreadsheet nodes used for reading invite codes and writing updates and logs.

1. Open Read Invite Codes and set Document ID to [YOUR_ID].
2. Choose the Sheet Name list value for the invite code table.
3. Credential Required: Connect your googleSheetsOAuth2Api credentials in Read Invite Codes.
4. Open Update Status Flag, Append Join Log, and Update Failure Flag and set their operation values to update, append, and update respectively.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Status Flag, Append Join Log, and Update Failure Flag.

Step 3: Set Up Batch Processing and Field Mapping

Limit the batch size, iterate records, and map the required fields for downstream operations.

1. In Limit Unprocessed Batch, keep the JavaScript code as // On garde uniquement les 50 premiers non traités return items.slice(0, 50); to cap processing at 50 records.
2. Open Batch Iterator and keep default options to iterate the list from Limit Unprocessed Batch.
3. In Map Record Fields, set assignments to map the fields using expressions: row_number = {{ $json.row_number }}, Invitation Code = {{ $json['Invitation Code'] }}, and Groupe id = {{ $json['Groupe id'] }}.
4. Confirm the flow Read Invite Codes → Limit Unprocessed Batch → Batch Iterator → Map Record Fields.

Step 4: Retrieve Group Details and Combine Streams

Fetch group data and merge it with the mapped records before validation.

1. Open Retrieve Group Details and confirm resource is groups-api and operation is fetch-groups.
2. Set inviteCode to the expression {{ $('Batch Iterator').item.json['Invitation Code'] }}.
3. Credential Required: Connect your evolutionApi credentials in Retrieve Group Details.
4. Open Combine Streams and set mode to combine and combineBy to combineByPosition.
5. Map Record Fields outputs to both Retrieve Group Details and Combine Streams in parallel.

Step 5: Configure Join Logic, Status Updates, and Delay Cycle

Validate group size, join the target group, and record success or failure with logging and throttling.

1. In Conditional Size Check, set the condition to leftValue {{ $json.data.size }} is greater than 50.
2. Open Join Target Group and set resource to groups-api, operation to join-group, and inviteCode to {{ $('Map Record Fields').item.json['Invitation Code'] }}.
3. Credential Required: Connect your evolutionApi credentials in Join Target Group.
4. Confirm success path: Conditional Size Check → Join Target Group → Update Status Flag → Append Join Log → Delay Cycle → Batch Iterator.
5. Confirm failure path: Conditional Size Check → Update Failure Flag → Delay Cycle → Batch Iterator.

Step 6: Test and Activate Your Workflow

Run a manual test to verify the join, logging, and batch cycling before going live.

1. Click Execute Workflow to run a manual test from Scheduled Run Trigger.
2. Check that Read Invite Codes pulls rows, Join Target Group executes, and Update Status Flag or Update Failure Flag writes back to the sheet.
3. Verify Append Join Log adds a new log row and Delay Cycle loops back to Batch Iterator.
4. When satisfied, toggle the workflow to Active so the schedule runs automatically.