Automate n8n User Invitations From Google Sheets
detail.loadingPreview
Effortlessly invite new users to your n8n instance by syncing with a Google Sheet. This workflow automates the process of identifying new users and sending invitations, saving you valuable time.
About This Workflow
This n8n workflow streamlines the process of onboarding new users to your n8n instance. It pulls user data from a Google Sheet, compares it against existing users in n8n, and automatically invites any new individuals found in your sheet. This is perfect for managing access and ensuring that everyone who needs to be part of your n8n workspace is invited promptly and efficiently. The workflow supports on-demand execution or can be scheduled for regular intervals, ensuring your user list is always up-to-date.
Key Features
- Automated User Identification: Compares Google Sheet entries with existing n8n users to find new additions.
- Seamless Invitation Process: Automatically sends invitations to new users identified from your sheet.
- Flexible Triggering: Run the workflow manually or schedule it for automated, recurring execution.
- Customizable Data Mapping: Easily adapt to different Google Sheet column formats.
How To Use
- Configure Google Sheets Node: Connect your Google account and select the spreadsheet and sheet containing your user list. Ensure columns like 'Email Address', and 'Name' are present.
- Configure n8n API Credentials: Set up your n8n API credentials to allow the workflow to interact with your n8n instance.
- Update n8n Instance URL: In the 'Edit Fields' node, replace the placeholder
{{n8n-url}}with the actual URL of your n8n instance. - Map User Data: The 'Create users list' node maps the 'Email Address' from your Google Sheet to the 'email' field for invitation. You can adjust the 'role' parameter as needed.
- Set Trigger: Choose between the 'When clicking ‘Test workflow’' manual trigger or the 'Schedule Trigger' to automate the execution.
- Run and Monitor: Execute the workflow and check the 'Invite Users' node for successful invitations. Review logs for any errors.
Apps Used
Workflow JSON
{
"id": "a76f1991-d5ef-4f93-83a5-19391cc5f04d",
"name": "Automate n8n User Invitations From Google Sheets",
"nodes": 21,
"category": "Operations",
"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: a76f1991-d5ef...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.