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
- When Called by Another Workflow (n8n-nodes-base.executeWorkflowTrigger)
- Run Once to Create Table (n8n-nodes-base.manualTrigger)
- Try It: Call API With Token (n8n-nodes-base.manualTrigger)
- Token Settings (n8n-nodes-base.set)
- Route by Trigger (n8n-nodes-base.switch)
- Create Token Table (n8n-nodes-base.dataTable)
- Check Settings (n8n-nodes-base.code)
- Find Token Table (n8n-nodes-base.dataTable)
- Table Found? (n8n-nodes-base.if)
- Stop: Table Missing (n8n-nodes-base.stopAndError)
- Load Token Row (n8n-nodes-base.dataTable)
- Row Exists? (n8n-nodes-base.if)
- Create Token Row (n8n-nodes-base.dataTable)
- Reload Token Row (n8n-nodes-base.dataTable)
- Check Token (n8n-nodes-base.code)
- Token Still Valid? (n8n-nodes-base.switch)
- Claim Refresh Lock (n8n-nodes-base.dataTable)
- Read Locked Row (n8n-nodes-base.dataTable)
- Decide After Lock (n8n-nodes-base.code)
- Next Step (n8n-nodes-base.switch)
- Wait 1 Second (n8n-nodes-base.wait)
- Read Row While Waiting (n8n-nodes-base.dataTable)
- Check Other Execution (n8n-nodes-base.code)
- Wait Result (n8n-nodes-base.switch)
- Release Lock (n8n-nodes-base.dataTable)
- Stop: Other Execution Failed (n8n-nodes-base.stopAndError)
- Refresh Access Token (n8n-nodes-base.httpRequest)
- Read Refresh Response (n8n-nodes-base.code)
- Refresh Worked? (n8n-nodes-base.if)
- Log In for New Token (n8n-nodes-base.httpRequest)
- Read Login Response (n8n-nodes-base.code)
- Login Worked? (n8n-nodes-base.if)
- Build Token Record (n8n-nodes-base.code)
- Save New Token (n8n-nodes-base.dataTable)
- Return Token (n8n-nodes-base.code)
- Save Failure (n8n-nodes-base.dataTable)
- Alert Due? (n8n-nodes-base.if)
- Email Login Failure (n8n-nodes-base.emailSend)
- Save Alert Time (n8n-nodes-base.dataTable)
- Stop: No Token (n8n-nodes-base.stopAndError)
- Try It Settings (n8n-nodes-base.set)
- Get Access Token (n8n-nodes-base.executeWorkflow)
- Call API (n8n-nodes-base.httpRequest)
- Got 401? (n8n-nodes-base.if)
- Get Replacement Token (n8n-nodes-base.executeWorkflow)
- Retry API Call (n8n-nodes-base.httpRequest)
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.