Airtable or Notion behind a simple automation: tokens, sharing and limits

Airtable and Notion work well as a small “database” that your team sees and edits, and that an automation (n8n, a PHP script, a cron job) reads and writes. Both have an API and both ask the same: a token with the smallest permissions possible, and explicit sharing of what the automation may touch. Almost every error comes from one of those two.

What each one asks for

Airtable Notion
The key A personal token, for which you choose what it can do and which bases it can see. An internal integration, which gives a secret token.
Sharing You grant access to the base when creating the token. You must connect the integration, page by page or database by database. Without that it sees nothing.
The data Tables with fields of set types. Pages and databases with properties.
Requests An authorisation header with the token. An authorisation header, and a header with the API version the documentation names.

Setting up the connection

1 Create the token with the minimum. Read-only if the automation only reads; write only on the tables it needs. A token with too much power hurts most when it leaks.
2 Share only what is needed. In Notion, open the database and connect the integration to it. In Airtable, pick the base when you create the token.
3 Make a test read request, for example with the n8n node or with curl, and see whether the right rows come back.
4 Check the field names. The automation writes by name. If someone renames a column or a property, the automation starts failing.
5 Keep the token as a credential, never inside the workflow or the code. See securing n8n: access, credentials and exposed webhooks.
6 Take a copy of the base from time to time, using each service’s export function.

What the errors mean

Reply Likely cause
401 or 403 Wrong token, expired, or no permission for that operation.
404 in Notion, with the page existing The integration was not connected to that page or database.
422 or a field error The field name or type does not match what you sent, for example text in a numeric field.
429 Too many requests in a short time. Space them out or send in batches.
Do not use either as the database of a whole business. They have limits on requests and on records, which change and depend on the plan you hold with them: see each one’s site. For critical data or large volumes, use a proper database on your own server.
Write the date and the source on every row the automation adds. When something looks odd, you know where it came from and when.

Want a server to run your automations and your own database? See the VPS plans.

See the VPS servers

SEE ALSO

Connecting n8n to Google Sheets

n8n and your database: the MySQL and PostgreSQL nodes

Getting an API key for an AI model, and keeping it safe

VPS servers

RECOMMENDED PRODUCT

Web hosting with cPanel

Domain and SSL included, daily backups and the panel you already know. from $6.59/mo (3-year plan, with coupon)

See plans
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Cron jobs: what they are for and how to create one A scheduled task, or cron job, is an instruction the server runs at set times, whether you are there or not, whether the...
Swapping WP-Cron for a real server cron job WordPress has a scheduler of its own, WP-Cron, which handles scheduled posts, update checks, emptying the bin and the e-...
cPanel API tokens: automating without handing over your password Sooner or later somebody asks you for your cPanel password: the developer building an integration, the offsite backup se...
What n8n is, and what you can automate with it n8n is a program that connects applications to one another through workflows: when something happens in one application,...
Do you need a VPS for n8n? What shared hosting cannot do Yes: to run n8n on a server of your own you need a VPS (or a dedicated server) with root access. It cannot be done on a...
n8n workflow failed: reading the error, retrying and getting an alert When an n8n workflow fails, the executions list shows which one and at what node. From there you have three tools to mak...