Automated User Invitation Sync with n8n and Google Sheets

somdn_product_page

This n8n workflow automates the process of syncing user data from a Google Sheets document with a n8n-based user management system and sending invitations to new users. The workflow is designed to run on a schedule, retrieve current users from n8n, compare them with a list of potential users from Google Sheets, and invite new ones via an API call.

The process begins with a schedule trigger that starts the workflow automatically at defined intervals, or can be manually triggered for on-demand execution. It then fetches a list of existing users from the n8n API, paginating through results to ensure all data is retrieved. Simultaneously, it pulls user data from a specified Google Sheets document which contains potential new users.

Using a merge node, the workflow identifies email addresses present in Google Sheets but missing from the existing n8n users. It compiles a list of these non-users, for whom it prepares user creation data such as email and role. Subsequently, it sends POST requests via an HTTP request node to invite each new user, using an API endpoint defined in the workflow.

This setup is particularly useful for onboarding workflows, where repetitive manual effort of adding users and sending invites can be eliminated, ensuring timely engagement with new users based on entries in a shared spreadsheet. It facilitates scalable management of user invitations, suitable for newsletters, memberships, or team onboarding scenarios.

Node Count

11 – 20 Nodes

Nodes Used

code, googleSheets, httpRequest, manualTrigger, merge, scheduleTrigger, set, stickyNote

Reviews

There are no reviews yet.

Be the first to review “Automated User Invitation Sync with n8n and Google Sheets”

Your email address will not be published. Required fields are marked *