Automate User Invitation to n8n from Google Sheets

Name: Automate User Invitation to n8n from Google Sheets
Rating: 5 (5 reviews)
Author: Free N8N

Intermediate

14 nodes connected

detail.loadingPreview

Free N8N Temples

125 views

0 downloads

User Managementautomationgoogle sheetsn8n apiuser invitation

Automatically invite users to your n8n instance from a Google Sheet.

About This Workflow

This workflow automates the process of inviting new users to your n8n instance. It reads user data from a Google Sheet, checks if they already exist in n8n, and then invites the non-existent users. This is useful for onboarding new team members or managing external collaborators efficiently.

Key Features

Google Sheets Integration: Reads user email addresses and names from a Google Sheet.
n8n User Management: Fetches existing users from your n8n instance.
User Comparison: Identifies users from the Google Sheet who are not yet in n8n.
Automated Invitations: Sends invitations to new users via the n8n API.
Trigger Options: Can be run manually via 'Test workflow' or scheduled using a scheduleTrigger.

How To Use

How to Use

Prepare Your Google Sheet:
- Clone the sample sheet.
- Ensure your sheet has at least the following columns: Email Address, Name.
- The Submitted On column is optional but present in the sample.
Configure n8n Credentials:
- Ensure you have configured Google Sheets account credentials for accessing your Google Sheet.
- Ensure you have configured n8n account credentials for interacting with your n8n API. This usually involves an API key.
Set Your n8n Instance URL:
- Locate the Edit Fields node (ID: dd453b5b-f238-43b1-8c44-2c3ed3a3d7ba).
- Update the n8n_url assignment to point to your n8n instance's API endpoint for users (e.g., https://your-n8n-instance.com/api/v1/users).
Adjust User Role (Optional):
- In the Create users list node (ID: 2bfb10b6-220b-4c73-a15f-190412f2dda2), the role is set to global:member. You can change this to another role if needed, following n8n's role conventions.
Run the Workflow:
- Manually: Click the 'Test workflow' button on the top right.
- Scheduled: Configure the Schedule Trigger node (ID: 195d0c33-611a-4a16-b62c-8ba1f4f31e19) to run at your desired intervals.

Apps Used

automation

google sheets

n8n api

user invitation

Workflow JSON

{
  "id": "e66800ae-ab64-4b39-ac8a-f8c32a2d552e",
  "name": "Automate User Invitation to n8n from Google Sheets",
  "nodes": 14,
  "category": "User Management",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.

Get This Workflow

ID: e66800ae-ab64...

About the Author

DevOps_Master_X

Infrastructure Expert

Specializing in CI/CD pipelines, Docker, and Kubernetes automations.

Statistics

Downloads0

Rating5/5

Get Custom Workflow

Need a specific automation? Our experts can build it for you.

Trusted by top companies
7+ years experience

Related Workflows

Discover more workflows you might like

Intermediate

User ManagementZammadRolesUser Management

Update Zammad Roles to Default

Automate the process of updating all Zammad user roles to a predefined default set and optionally export current roles.

18 nodes

View Workflow

How to Use

Prepare Your Google Sheet:

Clone the sample sheet.
Ensure your sheet has at least the following columns: Email Address, Name.
The Submitted On column is optional but present in the sample.

Configure n8n Credentials:

Ensure you have configured Google Sheets account credentials for accessing your Google Sheet.
Ensure you have configured n8n account credentials for interacting with your n8n API. This usually involves an API key.

Set Your n8n Instance URL:

Locate the Edit Fields node (ID: dd453b5b-f238-43b1-8c44-2c3ed3a3d7ba).
Update the n8n_url assignment to point to your n8n instance's API endpoint for users (e.g., https://your-n8n-instance.com/api/v1/users).

Adjust User Role (Optional):

In the Create users list node (ID: 2bfb10b6-220b-4c73-a15f-190412f2dda2), the role is set to global:member. You can change this to another role if needed, following n8n's role conventions.

Run the Workflow:

Manually: Click the 'Test workflow' button on the top right.
Scheduled: Configure the Schedule Trigger node (ID: 195d0c33-611a-4a16-b62c-8ba1f4f31e19) to run at your desired intervals.

{ "id": "e66800ae-ab64-4b39-ac8a-f8c32a2d552e", "name": "Automate User Invitation to n8n from Google Sheets", "nodes": 14, "category": "User Management", "status": "active", "version": "1.0.0" }