I created a workflow to sync a Notion database to Airtable. When I manually execute the workflow, it runs successfully. However, when it’s triggered by a schedule, it gets stuck at the step of fetching data from Notion, except for one successful run.
Information on your n8n setup
- n8n version:0.233.1
- Database (default: SQLite):SQLite
Running n8n via (Docker, npm, n8n cloud, desktop app):Docker
In your workflow have you set that notion node to only run once? If you haven’t it is going to try and get all the database pages 157 times which isn’t ideal.
I had a similar issue before and for me that was how I got it working.
The notion node set to only once.
I modified the workflow, now the problem never occur, although i do not know the reason.
No problems is always a good thing
I am not sure what the split in batches node is doing down there though as you are never actually looping the data.