Invite new team members straight from a Google Sheet and skip manual account setup. Ideal for admins and IT teams who collect emails in a sheet and want fast onboarding without CSV uploads or repeated checks.

Two triggers let you run it on demand or on a schedule. The flow sets your n8n API URL, pulls all current users from your n8n instance with cursor based pagination, and combines all pages. It also reads rows from your Google Sheet. A merge step compares sheet emails with existing users and keeps only the people who are not in your workspace. The next step builds a clean payload and sends a POST request to the n8n API to send invite emails.

To set it up, you need a Google Sheets account and an n8n API key. Update the URL in the Edit Fields node to match your n8n domain. Make sure your sheet has an Email Address column, plus any extra fields you want to pass. Run a test with a few rows to confirm the match logic. Expect faster onboarding, fewer mistakes, and a repeatable process for training cohorts, client access, and project teams.

• Manual and scheduled runs so you can test or run on a timer
• Google Sheets read to pull all rows from a chosen sheet
• HTTP request to the n8n API to list users with cursor pagination
• Code step to combine all paginated user results into one list
• Merge step to keep only emails that are not already users
• Set nodes to format clean invite payloads from sheet fields
• HTTP POST to send invite emails through the n8n API

• Reduce manual onboarding from 30 minutes per batch to 3 minutes
• Automate up to 90 percent of repetitive invite work
• Improve email list accuracy by comparing against live user data
• Connect Google Sheets to your n8n workspace with no CSV steps
• Scale to hundreds of invites by handling paginated user lists

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create an n8n API credential: double click the Get all Users node, choose the 'Credential to connect with' field, click 'Create new credential', and follow the on screen steps to add your n8n API key.
4. Create a Google Sheets OAuth2 credential: open the Get all rows node, pick 'Credential to connect with', click 'Create new credential', and follow the on screen Google sign in steps.
5. Open the Edit Fields node and replace the n8n_url value with your domain, for example https://your-domain/api/v1/users.
6. Open the Get all rows node and confirm the Document ID and Sheet name point to your sheet. Make sure the sheet has an Email Address column.
7. Check the Create users list node and map Email Address to the email field. Add role or name if your invite payload requires it.
8. In the Invite Users node, confirm the HTTP method is POST and the credential is your n8n API credential. Keep the JSON body as the item data.
9. Click Test workflow to run once. In the Get non-users node, verify that only new emails are present. If it is empty, all emails already have accounts.
10. If you see an authentication error, verify the n8n API key and that the URL points to your instance. Also confirm the user tied to the key has permission to invite users.
11. Enable the Schedule Trigger and set an interval if you want invites to run automatically. Watch the executions list to confirm success and check invite emails are received.