Automate User Invitation to n8n from Google Sheets

• 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

1. 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.

2. 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.

3. 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).

4. 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.

5. 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.