Skip to main content
Solved

SendGrid To Airtable Webhooks

  • January 30, 2025
  • 1 reply
  • 1 view
M

Hi Everyone,

I need access to 30 days of email data in SendGrid, and one approach I’m exploring is using webhooks. However, I haven’t been able to set it up successfully in Airtable.

A few months ago, I successfully sent webhooks from MS Planner, and it worked fine. One key difference is that the payload from Planner was not nested, whereas the JSON from SendGrid is. Interestingly, when I sent a test request via Airtable's webhook trigger, I received a positive response—again, with non-nested JSON.

I also tested this in Zapier, and it worked without issues. This leads me to believe that Airtable webhooks may not support nested JSON structures.

Has anyone encountered this before or found a workaround? Would love to hear your thoughts!

Thanks!

 

Best answer by Avis682Holmes

Hello!

Airtable webhooks may not support nested JSON structures. To work around this, you can pre-process the JSON using a service like Zapier or Integromat to flatten it before sending it to Airtable. Alternatively, write a custom script to convert the nested JSON or use other tools that handle nested JSON better. Since Zapier worked for you, you can choice advantages use it to capture and process the webhook from SendGrid, then push it to Airtable.

View original
Did this topic help you find an answer to your question?

1 reply

A
  • Avis682Holmes
  • New Participant
  • 1 reply
  • Answer
  • January 31, 2025

Hello!

Airtable webhooks may not support nested JSON structures. To work around this, you can pre-process the JSON using a service like Zapier or Integromat to flatten it before sending it to Airtable. Alternatively, write a custom script to convert the nested JSON or use other tools that handle nested JSON better. Since Zapier worked for you, you can choice advantages use it to capture and process the webhook from SendGrid, then push it to Airtable.

M
1 person likes this
  • M
    MPruthi97

Reply


Most helpful members this week

Terms & Conditions