Automatic WhatsApp Group Joiner from Spreadsheet List - n8n Workflow

• Users managing large community networks who need to join multiple WhatsApp groups efficiently.


• Marketers and sales teams seeking a scalable way to automate group outreach.


• Developers and technical users looking for reliable n8n templates integrating Google Sheets and messaging APIs.


• Organizations requiring an automated n8n solution for managing bulk WhatsApp group invitations.

Manually joining dozens or hundreds of WhatsApp groups from a spreadsheet list is time-consuming and prone to errors. This efficient n8n workflow completely automates this process. The automation starts with a scheduled n8n trigger, systematically reads invitation codes from a Google Sheet, and utilizes the Evolution API to validate and join each group. Crucially, this n8n automation template includes built-in rate limit handling by processing only 50 codes per execution and introducing a wait period before restarting. By continuously updating the Google Sheet with the resulting status (success or failure), the n8n workflow maintains a reliable, real-time log of your group membership efforts.

This n8n workflow operates on a preset schedule to ensure continuous, background automation:

1. Scheduled Start: The process begins with the Schedule n8n trigger, which runs multiple times a day (e.g., 6 AM, 12 PM, 8 PM) to check for new groups to join.


2. Data Fetching: The 'Lire invitation code' Google Sheets n8n node reads the entire list of WhatsApp invitation codes from the specified spreadsheet.


3. Rate Limit Prevention: A Code n8n node, '50 premiers non traités', limits the current run to processing only the first 50 unprocessed codes, mitigating potential API rate limits.


4. Iterative Processing: The 'Loop Over Items' node initiates an iterative loop, processing each of the 50 codes individually.


5. Data Mapping: The 'Mapper données' Set n8n node extracts and sets key data points, including the row number and the 'Invitation Code'.


6. Group Validation: The 'Fetch groups' Evolution API n8n node attempts to validate the invitation code and retrieve preliminary group details.


7. Merge & Decision: The data is merged, and an If n8n node checks specific criteria (in this case, if the group size is greater than 50). If the condition is met (Success Path), the workflow proceeds to join the group.


8. Joining the Group: The 'Join group' Evolution API n8n node attempts to use the invitation link to join the WhatsApp group.


9. Status Update (Success): If the join is successful, the 'Mis a jour statut' Google Sheets n8n node updates the row status in the source sheet to 'Joined'. The 'Remplir liste' node logs the successful join into a tracking sheet.


10. Status Update (Failure): If the join is unsuccessful (or if the initial If condition is not met), the 'Mis a jour statut1' Google Sheets n8n node updates the status to 'Failed' or 'Processed'.


11. Pause and Repeat: A 'Wait' n8n node introduces a delay before looping back to the 'Loop Over Items' node, ensuring the overall n8n workflow is paced correctly before processing the next invitation code.

To deploy this powerful n8n workflow, follow these setup steps:

1. Import the n8n Workflow: Copy the provided JSON code and import it directly into your n8n instance (Cloud or Self-Hosted).


2. Google Sheets Credentials: Configure the Google Sheets n8n nodes ('Lire invitation code', 'Mis a jour statut', 'Remplir liste', 'Mis a jour statut1') with your OAuth2 API credentials. Ensure the service account has read/write access to your spreadsheet.


3. Google Sheets Configuration: Update the 'Document ID' and 'Sheet Name' parameters in all Google Sheets n8n nodes to point to your specific sheet containing the invitation codes and the logging sheet.


4. Evolution API Credentials: Set up the required Evolution API credentials for the 'Fetch groups' and 'Join group' n8n nodes. This usually requires an instance ID and API key.


5. Adjust the Schedule Trigger: Modify the 'Schedule Trigger' n8n node parameters to define your preferred execution frequency (e.g., hourly, daily).


6. Activate: Once all credentials and parameters are configured, activate the n8n workflow to begin automatic processing.

This n8n template relies on several key n8n nodes to achieve robust automation:

Schedule Trigger: Function: The initial n8n trigger that dictates when the automation runs. Key Configuration: Set to run three times per day (6:08, 12:13, 20:17).
Google Sheets Node (Lire invitation code): Function: Reads the invitation codes list from the primary Google Sheet. Key Configuration: Document ID set to the source spreadsheet ID.
Code Node (50 premiers non traités): Function: Acts as a safety measure and rate limiter, restricting the processing batch to the first 50 items received from the sheet. Key Configuration: return items.slice(0, 50);
Evolution API Node (Fetch groups): Function: Validates the invitation code against the WhatsApp API to fetch group details before attempting to join. Key Configuration: Operation set to fetch-groups, using an expression to pull the Invitation Code.
Evolution API Node (Join group): Function: Executes the primary action, attempting to join the specified WhatsApp group using the invitation link. Key Configuration: Operation set to join-group.
Google Sheets Node (Mis a jour statut / Mis a jour statut1): Function: Updates the status column of the source row based on whether the group joining attempt succeeded or failed.

• Wait Node: Function: Introduces a necessary delay in the loop to prevent rapid API calls, ensuring the n8n workflow respects rate limits before processing the next item.