How to create an opportunity in Affinity from an Airtable base?

Help me Build my Workflow
,
1

Hi there!

I’ve been trying to build a workflow which create an opportunity in Affinity from data in an Airtable table.

  • Node “New Airtable row” : sucessfully take the data I entered in Airtable
  • Node “HTTP request” : goes into affinity through the API key to see if the opportunity already exists by looking if the website is matching
  • Node “Error branch” : if the opportunity already exists, it goes back to the airtable to check a box “Already exists in Affinity”
  • Node “Create an opportunity” : create an opportunity if it does not already exist → not working

Capture d’écran 2025-12-02 à 15.34.27
Capture d’écran 2025-12-02 à 15.34.271548×872 56 KB

Here are the details of the nodes :

Capture d’écran 2025-12-02 à 15.37.48
Capture d’écran 2025-12-02 à 15.37.481268×1276 133 KB

Capture d’écran 2025-12-02 à 15.38.14
Capture d’écran 2025-12-02 à 15.38.142592×1298 486 KB

Capture d’écran 2025-12-02 à 15.38.37
Capture d’écran 2025-12-02 à 15.38.371820×1278 323 KB

Capture d’écran 2025-12-02 à 15.38.54
Capture d’écran 2025-12-02 à 15.38.542612×1260 249 KB

Any advice is very welcome!