OAuth Token Generator with Airtable Storage

This comprehensive n8n workflow automates the process of generating, validating, and storing OAuth-like tokens for secure API authentication. It begins with a webhook that receives client credentials (`client_id` and `client_secret`) from an external request. The workflow then validates the received data to ensure only the required fields are present, enhancing security and data integrity. Next, it searches for the `client_id` in an Airtable database to verify the client’s existence. If found, it compares the provided `client_secret` with the stored secret to authenticate the client.

Upon successful validation, the workflow generates a secure, long token using a custom JavaScript function. This token, along with associated metadata such as creation date and token type, is stored in Airtable for future validation and management. The system then responds with a JSON containing the `access_token`, its expiration time (`expires_in`), and token type (`token_type`). If any validation step fails, appropriate error responses are returned, such as invalid client ID or secret.

This workflow is ideal for developers implementing OAuth-like authentication flows, managing API security, or creating token-based access systems for SaaS products or internal APIs. It leverages n8n’s automation capabilities combined with Airtable’s lightweight data management to orchestrate a secure, scalable token issuance process.