OAuth Token Management System with Airtable Storage

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

OAuth Token Generator and Validator

This n8n template helps you generate, validate, and store tokens for your customers securely using:

n8n** as your backend automation engine
Airtable** as your lightweight client and token store

🚀 What It Does

Accepts client_id and client_secret via POST webhook. Validates client credentials against Airtable. Generates a long token on success. Stores the generated token in Airtable with metadata. Responds with a JSON containing the token, expiry, and type. Returns clear error messages if validation fails.

How It Works

Webhook node receives client_id and client_secret. Validator (Code node) checks: Body contains only client_id and client_secret. Rejects missing or extra fields. Airtable search: Looks up the client_id. Rejects if not found. Secret validation (If node): Compares provided client_secret with stored value. Rejects if incorrect. Token generation (Code node): Generates a 128-character secure token. Airtable create: Stores token, client ID, creation date, and type. Webhook response: Returns JSON { access_token, expires_in, token_type } on success. Returns appropriate JSON error messages on failure.

Related Workflow

You can also use it with the published Bearer Token Validation workflow:

👉 Validate API Requests with Bearer Token Authentication and Airtable

to securely validate tokens you generate with this workflow across your protected endpoints.

Why Use This

Provides OAuth-like flows without a complex backend. Uses n8n + Airtable for client management and token storage. Clean, modular, and ready for your SaaS or internal API automations. Extendable for token expiry, refresh, and rotation handling.

Enjoy building secure token-based APIs using n8n + Airtable! 🚀

Built by: Nazmy