Automate n8n user invitations from a Google spreadsheet
This workflow retrieves all users from n8n, compares them against entries in a Google Sheets spreadsheet, and automatically creates new users when needed. On...
🔌 Nodes & Integrations Used (2)
📖 Implementation & Setup Guide
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 manually or set it to run on a schedule to ensure continuous synchronization.
Spreadsheet Template This workflow is designed to work with a Google Sheets structure inspired by Squarespace's newsletter block connection. You can modify the node settings to adapt to a different column format.
**Suggested columns:** - Submitted On - Email Address - Name
Requirements ### Credentials To use this workflow, you need:
- n8n API Key – to update users from n8n.
- Google Sheets API credentials – Required to get data from a spreadsheet.
- ### Configure Your n8n Instance
- To make this workflow work with your n8n instance, update the API endpoint:
🔧 **Edit Global node 👇** Change `n8n_url` to match your instance URL: [Authentication Guide](https://docs.n8n.io/api/authentication/#call-the-api-using-your-key)
---
Explore More Templates
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Automate n8n user invitations from a Google spreadsheet.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related DevOps & GitHub Workflows
View All in DevOps & GitHub →Generate Google Doc Proposal
Production-ready n8n automation template for Generate Google Doc Proposal built by AhiXLight. Seamlessly connects Execute Workflow Trigger, Google Drive, OpenAI with 7 configured nodes.
Add a new lead to Pipedrive once GitHub repo is forked
This workflow automatically adds a new lead to Pipedrive once someone forks your GitHub repository. Prerequisites - Pipedrive account and Pipedrive credentia...
Add the affiliate to a program automatically
This workflow allows you to create an affiliate, add metadata, and add the affiliate to a program. !workflow-screenshot Tapfiliate node: This node allows you...
Add a note to Pipedrive s contact once PR is added on GitHub
This workflow automatically adds a note of the PR from GitHub to the Pipedrive contact if their GitHub email matches a Person in Pipedrive. Prerequisites - P...