FM
FlowMarket
DevOps & GitHub Intermediate ⚡ 11 n8n Nodes

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)

HTTP Request Google Sheets

📖 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:

  1. Click the Direct Download JSON button above to save Automate n8n user invitations from a Google spreadsheet.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related DevOps & GitHub Workflows

View All in DevOps & GitHub →