Connecting Airtable Submissions to Discord via Zapier Embedded Messages

Other Questions Airtable
1

Hey everyone! I’m trying to figure out how to send Airtable form submissions to Discord as embedded messages using Zapier. I’ve got the basic connection working, but the output is just plain text. I want it to look nicer with an embedded format, you know?

Here’s what I’ve done so far:

  1. Set up an Airtable form to collect data
  2. Created a Zapier workflow to send that data to Discord
  3. Successfully got the info showing up in my Discord channel

But now I’m stuck. How can I make the Discord message look fancier with an embedded format? I’m hoping for something with a colored sidebar, maybe a title, and the form fields neatly organized.

Has anyone done this before? Any tips or tricks would be super helpful! I’m new to all these tools, so explain it like I’m five, please. Thanks in advance!

2

I’ve actually tackled this exact problem before, and I can tell you it’s definitely doable with Zapier! The key is to use Discord’s webhook functionality and format your message as a JSON payload.

In your Zapier workflow, after the Airtable trigger, add a ‘Formatter’ step. Choose ‘Utilities’ and then ‘JSON’. This is where you’ll structure your embedded message.

The JSON should look something like this:

{
  "embeds": [{
    "title": "New Form Submission",
    "color": 5814783,
    "fields": [
      {"name": "Name", "value": "{{name}}"},
      {"name": "Email", "value": "{{email}}"}
    ]
  }]
}

Replace {{name}} and {{email}} with your Airtable field names. You can add as many fields as you need.

Then, in the Discord webhook step, paste this JSON into the ‘Message Content’ field. Make sure to select ‘JSON’ as the content type.

It took me some trial and error, but once you get it right, it looks really slick! Let me know if you need any more help!

3

hey john, i’ve done this before! u need to use discord’s webhook and format ur message as JSON. in zapier, add a ‘formatter’ step after airtable trigger. choose ‘utilities’ then ‘JSON’. structure ur embed there. in discord webhook, paste the JSON and set content type to ‘JSON’. it looks awesome when done right!

4

I’ve implemented a similar setup and can offer some insights. The key is leveraging Discord’s webhook API to format your messages. In Zapier, after your Airtable trigger, add a ‘Code’ step using Python. This allows you to construct a more complex payload.

Here’s a basic script to get you started:

embed = {
    'title': 'New Form Submission',
    'color': 3447003,  # Blue color
    'fields': [
        {'name': 'Name', 'value': input_data['name']},
        {'name': 'Email', 'value': input_data['email']}
    ]
}

output = {'embeds': [embed]}

Adjust the field names to match your Airtable columns. In the Discord webhook step, use the output from this Code step as your payload.

This approach gives you more flexibility in customizing your embedded messages. You can add timestamps, footers, or even dynamic colors based on form data. It takes some experimentation, but the results are worth it.