AI-Summarize Every PostgreSQL Row and Send to Airtable
An AI step reads each new PostgreSQL row, writes a short summary, and n8n has Airtable create a new record in Airtable — so your team gets the gist without reading the whole thing.
- 1
Fetch PostgreSQL data
Add an
HTTP Requestnode (or the native PostgreSQL node if you have credentials set up) and point it at the PostgreSQL API. Poll PostgreSQL for new rows. Add aSchedule Triggerbefore it if this recipe runs on a timer, or aWebhooknode if PostgreSQL can push events directly. - 2
Shape the data with a Set node
Add a
Setnode after the fetch step to pull out the fields you need — e.g.id,title(orname),status, andupdated_atfrom the PostgreSQL row. This keeps the rest of the workflow clean and readable. - 3
Send it to Airtable
Add an
Airtablenode set to operationCreate. Connect your token, pick theBaseandTable, and map fields from the Set node. - 4
Activate and test
Click
Activatein the top-right corner. Trigger a real row in PostgreSQL (or run the workflow manually against existing data) and confirm it lands correctly in Airtable. Once verified, this runs hands-off.
Frequently asked questions
Do I need to code anything?
No. n8n is a visual, drag-and-drop builder. You connect your PostgreSQL and Airtable accounts, map the fields, and activate — no code required.
Where do I get my PostgreSQL API credentials?
In your PostgreSQL account settings, look for "API", "Developers" or "Integrations" and generate an API key or token. Paste it into n8n's HTTP Request node (as a header or credential) or the native PostgreSQL node if one is available.
Can I filter which items trigger this workflow?
Yes. Add an `IF` node after the Set node with a condition on any field (status, amount, tag, etc.). Wire the TRUE branch to the Airtable step and leave FALSE empty to skip the rest.
Keep every recipe free
FlowRecipesHub is free and always will be. If a workflow saved you time, chip in what you like — it helps us keep the lights on and build the next batch of automations for everyone.
Secure checkout via Paddle · one-time, no account needed
