Google API Credentials: Failing on n8n v1.1.1

Good morning!

I have been using n8n via Railway for a number of months and recently did a redeployment to work into v1.xxx. After the redeployment, the system was DOA. Railway logs showed that the command n8n was invalid and I did a quick rollback. Who knows what the issue is there? Not a game over scenario.

I created a new Railway project and used the n8n template and got a fresh install of v1.1.1. Everything works fine until I try to add my Google API credentials (Drive, Sheets, Gmail). The normal process works until I have to click SIGN IN WITH GOOGLE. I go through that process, after I reach the screen where I acknowledge the access that n8n wants from my account… I click submit and find myself with this…

Error: invalid input syntax for type integer: “NaN”

More details

Failed to connect. The window can be closed now.

There are no extra details available in the “more details” tab.

I’m puzzled and that error doesn’t give a lot of search engine results.

My original instance of n8n (pre-v1.0) adds these credentials just fine.

Hi @nso :wave: Sorry you’re running into this!

Can you fill out this template:

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

Can you also let us know what your env file configuration is like?