Back to Templates

OAuth Token Management System with Airtable Storage

Created by

Created by: Nazmy || islamnazmi

Nazmy

Last update

Last update 20 hours ago

Categories

Share


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

  1. Webhook node receives client_id and client_secret.
  2. Validator (Code node) checks:
    • Body contains only client_id and client_secret.
    • Rejects missing or extra fields.
  3. Airtable search:
    • Looks up the client_id.
    • Rejects if not found.
  4. Secret validation (If node):
    • Compares provided client_secret with stored value.
    • Rejects if incorrect.
  5. Token generation (Code node):
    • Generates a 128-character secure token.
  6. Airtable create:
    • Stores token, client ID, creation date, and type.
  7. 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