Http Request Access Token Auto Refresh With Data Tables

    What this workflow does

    The workflow contains these steps: When Called by Another Workflow → Run Once to Create Table → Try It: Call API With Token → Token Settings → Route by Trigger → Create Token Table → Check Settings → Find Token Table → Table Found? → Stop: Table Missing → Load Token Row → Row Exists? → Create Token Row → Reload Token Row → Check Token → Token Still Valid? → Claim Refresh Lock → Read Locked Row → Decide After Lock → Next Step → Wait 1 Second → Read Row While Waiting → Check Other Execution → Wait Result → Release Lock → Stop: Other Execution Failed → Refresh Access Token → Read Refresh Response → Refresh Worked? → Log In for New Token → Read Login Response → Login Worked? → Build Token Record → Save New Token → Return Token → Save Failure → Alert Due? → Email Login Failure → Save Alert Time → Stop: No Token → Try It Settings → Get Access Token → Call API → Got 401? → Get Replacement Token → Retry API Call.

    What you need

    • An n8n instance to import and run the workflow.
    • StickyNote access for the StickyNote steps listed in this workflow.
    • ExecuteWorkflowTrigger access for the ExecuteWorkflowTrigger steps listed in this workflow.
    • ManualTrigger access for the ManualTrigger steps listed in this workflow.
    • Set access for the Set steps listed in this workflow.
    • Switch access for the Switch steps listed in this workflow.
    • DataTable access for the DataTable steps listed in this workflow.
    • Code access for the Code steps listed in this workflow.
    • IF access for the IF steps listed in this workflow.
    • StopAndError access for the StopAndError steps listed in this workflow.
    • Wait access for the Wait steps listed in this workflow.
    • HTTP Request access for the HTTP Request steps listed in this workflow.
    • EmailSend access for the EmailSend steps listed in this workflow.
    • ExecuteWorkflow access for the ExecuteWorkflow steps listed in this workflow.

    Workflow nodes

    1. When Called by Another Workflow (n8n-nodes-base.executeWorkflowTrigger)
    2. Run Once to Create Table (n8n-nodes-base.manualTrigger)
    3. Try It: Call API With Token (n8n-nodes-base.manualTrigger)
    4. Token Settings (n8n-nodes-base.set)
    5. Route by Trigger (n8n-nodes-base.switch)
    6. Create Token Table (n8n-nodes-base.dataTable)
    7. Check Settings (n8n-nodes-base.code)
    8. Find Token Table (n8n-nodes-base.dataTable)
    9. Table Found? (n8n-nodes-base.if)
    10. Stop: Table Missing (n8n-nodes-base.stopAndError)
    11. Load Token Row (n8n-nodes-base.dataTable)
    12. Row Exists? (n8n-nodes-base.if)
    13. Create Token Row (n8n-nodes-base.dataTable)
    14. Reload Token Row (n8n-nodes-base.dataTable)
    15. Check Token (n8n-nodes-base.code)
    16. Token Still Valid? (n8n-nodes-base.switch)
    17. Claim Refresh Lock (n8n-nodes-base.dataTable)
    18. Read Locked Row (n8n-nodes-base.dataTable)
    19. Decide After Lock (n8n-nodes-base.code)
    20. Next Step (n8n-nodes-base.switch)
    21. Wait 1 Second (n8n-nodes-base.wait)
    22. Read Row While Waiting (n8n-nodes-base.dataTable)
    23. Check Other Execution (n8n-nodes-base.code)
    24. Wait Result (n8n-nodes-base.switch)
    25. Release Lock (n8n-nodes-base.dataTable)
    26. Stop: Other Execution Failed (n8n-nodes-base.stopAndError)
    27. Refresh Access Token (n8n-nodes-base.httpRequest)
    28. Read Refresh Response (n8n-nodes-base.code)
    29. Refresh Worked? (n8n-nodes-base.if)
    30. Log In for New Token (n8n-nodes-base.httpRequest)
    31. Read Login Response (n8n-nodes-base.code)
    32. Login Worked? (n8n-nodes-base.if)
    33. Build Token Record (n8n-nodes-base.code)
    34. Save New Token (n8n-nodes-base.dataTable)
    35. Return Token (n8n-nodes-base.code)
    36. Save Failure (n8n-nodes-base.dataTable)
    37. Alert Due? (n8n-nodes-base.if)
    38. Email Login Failure (n8n-nodes-base.emailSend)
    39. Save Alert Time (n8n-nodes-base.dataTable)
    40. Stop: No Token (n8n-nodes-base.stopAndError)
    41. Try It Settings (n8n-nodes-base.set)
    42. Get Access Token (n8n-nodes-base.executeWorkflow)
    43. Call API (n8n-nodes-base.httpRequest)
    44. Got 401? (n8n-nodes-base.if)
    45. Get Replacement Token (n8n-nodes-base.executeWorkflow)
    46. Retry API Call (n8n-nodes-base.httpRequest)
    StickyNoteExecuteWorkflowTriggerManualTriggerSetSwitchDataTableCodeIFStopAndErrorWaitHTTP RequestEmailSendExecuteWorkflow
    54 nodesOther
    View on GitHub

    Need this workflow customized or debugged? Book a 30-min scope call →

    Want this set up for you? Book a 30-min scope call

    I build and fix n8n workflows for agencies and SaaS teams. 30-minute scope call — bring the problem, leave with an estimate.

    Related workflows