Specifics about Notion Vs Airtable for automations

Hello everyone, this is my first post here and a question that has greater implications than I expected.

As I am just starting to learn automation from Stephen one question got bigger as I tried to advance in the exercises. (thank you for the attention in the chat mr!)

Should I use Notion or Airtable to run my automations?

Currently I'm a partner in a digital marketing agency and we specialize in the health care services industry. We focused a lot on AI the last 12 months and managed to build some very useful tools for content, management, strategy, sales and customer support.

We use no automations except running AI in their native UI (claude, gpt, midjourney etc...)

Even so we managed to push out more than 200 content pieces a week divided between 7-10 clients.

These range from Scientific Articles to IG Reels.

My goal now is to learn automation and save time money and human mistakes in this whole system.

In our team we have:

-Copywriter

-Ads manager

-Video editor

-Designer

-Digital Strategist

-Project Manager

-Product Owner

-AI Developer

-Public Relations Agents

+ Other on demand freelancers for project specific tasks ( customer support, SEO, e-commerce launch...)

To assist all of them we have 2 full time VAs just to copy and paste items, notify people, update records, link database items and many more of these micro tasks that take time from the senior staff.

This whole thing is run inside notion.

My databases there store everything we have made since the beginning.

Everyone knows how to work with the tool and bringing people in is quick and easy since notion is more widely know\used in my country (Brazil).

Now I finally get to the point of this post: