Skip to main content

404 error in Airtable module in Make.com

  • January 21, 2025
  • 9 replies
  • 59 views
D
Forum|alt.badge.img+3

I am very new and only working on a free account and have run out of free ai chat credits.

 

I am trying to follow a youtubers work flow to create blog articles and post to my wp site. workflow is as follows

Webhook-->Airtable-->Claude-->claude-->JSON-->Cluade-->Tools-->OpenAI-->Openai-->markdown-->Google Doc-->Google doc-->Airtable-->wordpress.

some of the double cluade and openai were create prompt then create article/image.

Webhook

https://hook.us2.make.com/134uosndzo3nh3oq497hxq0hbjfv8js3

Airtable layout

Blogs Posts

 RecordID | Main Keyword | Generate | Outline | Complete Google Doc | Google doc image | Status

Webhook in Airtable ( generate tab )


 
RecordID tab 
RIGHT("000000" & RECORD_ID(), 6)
 
nothing in Main Keyword tab.
 
so work flow is  click new row in airtable = generates new RecordID and a "Generate" button I add in the "Main Keyword" and then sent to Claude to create my prompt, then Claude to "JSON Create" then JSON markdown --> back to Claude to create article, then open ai to create image prompt, then open ai dalle3 to create image, -->markdown then into a google doc, and image into a google doc, to airtable and then to wordpress. 
 
Sorry if it is drawn out but just copying from youtube.
 
I have reconnected my account in airtable, redetermined data structure and a few other things but cannot get past the 404 error in the airtable module.
 
Thank you for any help.
 
Dan

 

9 replies

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6454 replies
  • January 21, 2025

Hm for the RecordID field, try using 'RECORD_ID()' instead of 'RIGHT("000000" & RECORD_ID(), 6)'?  Think that should help

Adam, Airtable Consultant - thetimesaving.company
D
Forum|alt.badge.img+3
  • dancarl
  • Author
  • New Participant
  • 4 replies
  • January 21, 2025

would i need to change the field in the "Generate" tab?

D
Forum|alt.badge.img+3
  • dancarl
  • Author
  • New Participant
  • 4 replies
  • January 21, 2025

i did change the record id field but still had the 404

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6454 replies
  • January 21, 2025

would i need to change the field in the "Generate" tab?


Ah sorry about that, yeap, you need to update the button formula to be the following:

'https://hook.us2.make.com/134uosndzo3nh3oq497hxq0hbjfv8js3?RecordID=' & {RecordID}

 

Adam, Airtable Consultant - thetimesaving.company
ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9808 replies
  • January 21, 2025

@dancarl 

Some top Make tips for you here:

While it is often desired to trigger a Make automation through a button in Airtable, that always opens up an extra browser tab that you need to close afterwards, either manually or through a JavaScript.

Now the advantage to this is that you can control the contents of that browser tab by using Make’s webhook response module.

But if you just want the automation to run without taking the user out of Airtable, you can trigger your Make automation using Airtable’s automations. I discuss how to use this technique in this thread.

I’ve also assembled a bunch of additional Make training resources in this thread.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

D
Forum|alt.badge.img+3
  • dancarl
  • Author
  • New Participant
  • 4 replies
  • January 21, 2025

Ah sorry about that, yeap, you need to update the button formula to be the following:

'https://hook.us2.make.com/134uosndzo3nh3oq497hxq0hbjfv8js3?RecordID=' & {RecordID}

 


now i don't get my unique "RecordID" in the row i just get ( RECORD_ID() ) in each row and still get the 404 error.

thank you

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6454 replies
  • January 22, 2025

now i don't get my unique "RecordID" in the row i just get ( RECORD_ID() ) in each row and still get the 404 error.

thank you


Hmm, weird!  I tried it out and it seems to be working fine.  Could you have a look at the base and try to see what's different from your own set up?

To do that, you'll need to duplicate the base into your own workspace with instructions on how to do that here: https://support.airtable.com/docs/creating-a-new-empty-base#duplicating-bases-in-airtable

 

Adam, Airtable Consultant - thetimesaving.company
D
Forum|alt.badge.img+3
  • dancarl
  • Author
  • New Participant
  • 4 replies
  • January 23, 2025

Hmm, weird!  I tried it out and it seems to be working fine.  Could you have a look at the base and try to see what's different from your own set up?

To do that, you'll need to duplicate the base into your own workspace with instructions on how to do that here: https://support.airtable.com/docs/creating-a-new-empty-base#duplicating-bases-in-airtable

 


your example it's passing on the unique Record id in the webhook formula. I need it to pass on the Main Keyword. 

so I must be missing something simple? So will go over what I'm trying to do again. 

so airtable has 3 columns so far, first one is RecordID then Main keyword and the last is Generate.

When I click a new row it automatically generates a new unique RecordID of 6 characters  and the blue generate button appears. I manually add in the Keyword and hit generate and it sends the keyword to the Make.com workflow. 

my formula in the "RecordID" looks fine it generates a unique code and the formula is 

RIGHT("000000" & RECORD_ID(), 6)

The Generate formula is 

 
but i get the 404 error in the airtable module in Make.com, in the error code the input shows this..

 

Input

 

  • Bundle 1Collection
    • Record ID
      {RecordID}
    • Base
      appQfFK7uuDJVWEe5
    • Table
      tblzsWFSwUclJzhla
    • Use Column ID
      false

The process makes it way all the way to the air table module then stops with the error, the first webhook module runs fine. and it's webhook address is. 

https://hook.us2.make.com/134uosndzo3nh3oq497hxq0hbjfv8js3

 
 
TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6454 replies
  • January 26, 2025

your example it's passing on the unique Record id in the webhook formula. I need it to pass on the Main Keyword. 

so I must be missing something simple? So will go over what I'm trying to do again. 

so airtable has 3 columns so far, first one is RecordID then Main keyword and the last is Generate.

When I click a new row it automatically generates a new unique RecordID of 6 characters  and the blue generate button appears. I manually add in the Keyword and hit generate and it sends the keyword to the Make.com workflow. 

my formula in the "RecordID" looks fine it generates a unique code and the formula is 

RIGHT("000000" & RECORD_ID(), 6)

The Generate formula is 

 
but i get the 404 error in the airtable module in Make.com, in the error code the input shows this..

 

Input

 

  • Bundle 1Collection
    • Record ID
      {RecordID}
    • Base
      appQfFK7uuDJVWEe5
    • Table
      tblzsWFSwUclJzhla
    • Use Column ID
      false

The process makes it way all the way to the air table module then stops with the error, the first webhook module runs fine. and it's webhook address is. 

https://hook.us2.make.com/134uosndzo3nh3oq497hxq0hbjfv8js3

 
 

Hmm, yeah, I reckon it might be faster if we get on a call to do this.  I do free half hour calls and we should be able to get you sorted within that time and you can grab a time here!  https://calendly.com/adamc_airtable/30min

Adam, Airtable Consultant - thetimesaving.company


Terms & ConditionsAccessibility statement