AutomationMart
Home/Browse/Register users and authenticate with magic links using Google Sheets
n8n

Register users and authenticate with magic links using Google Sheets

n8nn8n30 modulesv1.0
GmailGoogle Sheets

This workflow implements a lightweight authentication system for n8n web portals using Google Sheets as a simple user and session store. It supports email-based registration, username and password login, one-click magic link authentication, and cookie-based session management. How it works 1. Users register with an email address through a form. 2. The workflow generates a password and a one-time authentication token. 3. User credentials and token are stored in Google Sheets. 4. An email is sent

At a glance

Register users and authenticate with magic links using Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets
Modules
30
Price
Free
Version
v1.0
Register users and authenticate with magic links using Google Sheets workflow diagram

About this workflow

This workflow implements a lightweight authentication system for n8n web portals using Google Sheets as a simple user and session store. It supports email-based registration, username and password login, one-click magic link authentication, and cookie-based session management. How it works 1. Users register with an email address through a form. 2. The workflow generates a password and a one-time authentication token. 3. User credentials and token are stored in Google Sheets. 4. An email is sent with login credentials and a magic link. 5. Users can log in with username and password or click the magic link. 6. The /auth endpoint validates the token, creates a session id (sid), sets it as an HttpOnly cookie, and invalidates the token. 7. The /profile endpoint reads the sid cookie, verifies the session in Google Sheets, and displays a protected profile page. Set up steps - Create a Google Sheet with columns: username, password, role, token, sid. - Replace YOURSPREADSHEETID with your Google Sheet ID in all Google Sheets nodes. - Replace YOURDOMAIN with your n8n instance domain in redirect URLs and email links. - Configure Gmail or SMTP credentials in the email node. - Ensure your n8n instance is served over HTTPS so Secure cookies function correctly. This template is suitable for small internal portals, admin dashboards, or proof-of-concept authentication systems built entirely within n8n.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Send a message to Discord for every new row in Google Sheets

Automatically send a Discord message for every new row added in Google Sheets, keeping your team updated with real-time data changes.

Free

Save Strava Ride Activities to Google Sheets

This scenario will watch for new ride activities on your Strava "My Activities" feed and transfer the activity data to a Google sheet.

Free

Send new email summaries to Google Sheets with ChatGPT

Automatically log new email summaries in Google Sheets using ChatGPT. Streamline email management and response creation effortlessly.

Free

Add new Shopify events as rows in Google Sheets

Streamline your e-commerce operations by automatically logging new events from your Shopify store into Google Sheets. This template ensures that every time a new event occurs in Shopify, such as a sale or customer interaction, the details are instantly recorded in a Google Sheets spreadsheet. This allows for easy tracking and analysis of your store's performance, helping you make informed business decisions. No more manual data entry—let automation do the work for you.

Free

Add new Zendesk tickets to a Google Sheets spreadsheet as new rows

Every time a new ticket is opened in Zendesk, Make will automatically add the ticket information to a Google Sheets spreadsheet. The template uses this [example spreadsheet](https://goo.gl/3orf3G).

Free

Export Gravity Forms entries to Google Sheets

This template helps you export all entries from a specific Gravity Form to Google Sheets. The template use [this example spreadsheet](https://docs.google.com/spreadsheets/d/1x6PxBJctqsPVk2_cUspzVcDTLsFz2i-ksMceVElQEdQ/edit?usp=sharing).

Free

Send YouTube video summaries to Obsidian via Dropbox

( --- How it works This workflow runs on a schedule you set (default is every 10 minutes). It fetches all videos from a specific YouTube playlist, retrieves details and transcripts for each video using RapidAPI, cleans the transcript text, and then uses OpenAI (GPT models) to generate detailed notes, YAML frontmatter, and internal links formatted for Obsidian. Finally, it assembles everything into a Markdown file, saves it to your designated Dropbox folder, and removes the processed video from t

Free

Analyze domain threats via Telegram with VirusTotal, AbuseCH, and Gemini AI

Domain AI Analysis via Telegram, AbuseCH and VirusTotal Workflow Description This workflow allows Telegram users to submit a domain for quick threat intelligence analysis. It queries VirusTotal, AbuseCH URLHaus, and AbuseCH ThreatFox, then uses Gemini AI to generate a formatted summary with key findings, assessment/analysis, and actionable recommendations. Note: Currently supports domains only. VirusTotal is widely known, so there’s no need for further explanation. AbuseCH, on the other hand, is

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free