Hello n8n community,
I’d just like to start off by thanking you for all of your amazing work, we absolutely love working with n8n.
Regarding our problem - we are working on using n8n as an ETL, to transfer data from all of our data sources (HubSpot, our webapp, emailing tools, etc.) into Google Big Query tables.
However, we are encountering a problem with the Refresh Token. We are using OAuth2 with the following setup:
After an initial connection, we are able to stream data into the Big Query tables for about an hour before the workflow starts failing for the following reason:
ERROR: Error: No refresh token
Error: Error: No refresh token at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/HttpRequest.node.js:806:27) at processTicksAndRejections (internal/process/task_queues.js:93:5) at async /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/src/WorkflowExecute.js:416:47```
Opening the credentials and reconnecting will give us a new valid token for another hour.
Has anyone else encountered a similar issue?