Automate n8n user invitations from a Google spreadsheet
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Google Sheets.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Edit Fields (Edit Fields (Set)): sets 1 field: n8n_url
- Get all rows (Google Sheets): uses Google Sheets
- Get all Users (HTTP Request): calls an HTTP API
- Get non-users (Merge): merges the data from its input branches
- Combine all paginated results (Code): runs custom JavaScript code
- Create users list (Edit Fields (Set)): sets 2 fields: email, role
- Invite Users (HTTP Request): calls an HTTP API (POST)
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code
From the author
This workflow retrieves all users from n8n, compares them against entries in a Google Sheets spreadsheet, and automatically creates new users when needed. Once new users are created, invitation emails are sent automatically. You can trigger the workflow…