Automating Conference Organization Processes with n8n 🙋‍♀️
Tags: nocode, conference, api, tutorial
Published: 2020-06-02 14:58:34

---
title: Automating Conference Organization Processes with n8n 🙋‍♀️
published: true
date: 2020-06-02 09:33:58 UTC
tags: nocode,conference,api,tutorial
canonical_url: https://n8n.io/blog/automating-conference-organization-processes-with-n8n/
---

Organizing conferences is hard. Recently, I was chatting with [Nicolas Grenié](https://twitter.com/picsoung) about the manual processes that conference organizers have to deal with. The automation of these processes can save them time and effort as well as improve the conference experience. Inspired from this brainstorm, we ended up creating this tutorial using tools like [n8n](https://n8n.io/), [Typeform](https://www.typeform.com/), [Bannerbear](https://www.bannerbear.com/), [Airtable](https://airtable.com/), and [Trello](https://trello.com/).

![](https://cdn-images-1.medium.com/max/1024/1*ZFwXkS1T1CYrRdXHjSeubg.png)<figcaption>Automating conference organization processes with n8n</figcaption>

In this tutorial, we’ll store the speaker submissions coming via Typeform to Airtable. Then, the reviewers will do a blind review of the submissions and score them in Airtable. The submissions receiving a score greater than 15 (could be anything else) will be added to Trello for a final review. The workflow will also generate promotional assets for your team and add them to the Trello cards.

After the final review, the speakers whose cards will be moved over to the next column, will receive an acceptance email along with the various promotional assets. We’ll accomplish this through three workflows (these workflows were built using n8n@0.111.0) in this tutorial:

1. Workflow 1 — Gathering speaker data for a blind review
2. Workflow 2 — Proposal rating and final review
3. Workflow 3 — Notifying accepted speakers

## Workflow 1 — Gathering speaker data for a blind review

In this workflow, we’ll collect the speaking proposals from Typeform and save them to Airtable. The reviewers will be able to perform a blind review of the submissions in Airtable.

Let’s get started with the nodes of the first workflow. I have also submitted [Workflow 1](https://n8n.io/workflows/384) on n8n.io, in case you’d like to skim through this workflow. Please note that you’ll still need to configure a couple of things like your credentials as well as the settings of the nodes. You can find information on how to setup n8n in the [documentation](https://docs.n8n.io/#/setup). Alternatively, you can sign-up for [n8n.cloud](https://n8n.cloud) to get access to our hosted service.

### 1. Typeform Trigger node: Get data from Typeform

First of all, we need to pull in the new submissions from Typeform. To do that start n8n with the tunnel parameter (if you're hosting n8n on your server):

`n8n start --tunnel`

> **Note:** Make sure that you don’t forget to add the `--tunnel` parameter.

Add a new node by clicking on the '***+***' button on the top right of the Editor UI. Under the ***Triggers*** section, select the _Typeform Trigger_ node.

You’ll need to create a new form in Typeform, unless you already have one that you’d like to use. I used the Online Event Registration Form Template to get started. I asked the following information in the form:

1. Full name (_Short Text_)
2. Bio (_Short Text_)
3. Email (_Email_)
4. URL of a profile picture (_Website_)
5. Twitter username (_Short Text_)
6. Abstract title (_Short Text_)
7. Abstract (_Long Text_)

Now, head back to the n8n Editor UI and enter the credentials for the Typeform Trigger node. You’ll need to enter your access token. You can follow this [guide](https://docs.n8n.io/credentials/typeform/) to generate personal access tokens for Typeform.

Once you have done that, select your form from the dropdown menu for the ***Form*** field. Clicking on the ***Execute Node*** button would activate the test webhook. Now, if you submit the form, you’ll see the data in the Node Editor. Here’s what my first submission looked like.

![](https://cdn-images-1.medium.com/max/1024/1*7OANmfYsjLwQlaRsgaUaFg.png)<figcaption>Data from the Typeform submission in the Typeform Trigger node</figcaption>

> **Note:** Test webhooks (which get created when you click on Execute Node) are active only for 120 seconds. For activating the production webhooks, you’ll have to save and activate the workflow. Remember that the Node Editor won’t show any data flowing through the node with a production webhook.

Here’s a video of me following the steps mentioned above.

{% youtube Gngobhhl5X8 %}

### 2. Airtable node: Push data to Airtable

Head over to Airtable and create a new table. Create the fields for the questions that you asked in Typeform. I added a column named Serial No. (type _Autonumber_) to be the table’s primary field. This is what my table looked like.

![](https://cdn-images-1.medium.com/max/1024/1*_ME9elFoezn_acO_MPb8fQ.png)<figcaption>Table on Airbase for storing data from Typeform</figcaption>

Once you have the table ready, we’ll create the Airtable node on n8n. Go back to the n8n Editor UI. Click on the '***+***' button on the top right and select the *Airtable* node. You’ll have to enter the credentials (API Key) for the Airtable API. You can follow this [guide](https://docs.n8n.io/credentials/airtable/) on how to obtain your API Key.

Now, we’ll select ‘Append’ as the ***Operation***. For obtaining the Base ID, head over to their [API page](https://airtable.com/api) and select the correct base. You’ll find the Base ID there.

Once you enter that, put in the name of the table in the ***Table*** field. For me, it was `Main`. Now, click on the ***Execute Node*** button, and it will push all the data that was received by the Typeform node to the specified Airtable.

Here’s a video of me following the steps mentioned above.

{% youtube GyDLBvEHNPQ %}

A lot of conferences conduct blind reviews to eradicate the unconscious biases of the reviewers. To support that methodology, I went ahead and marked all the columns other than the Abstract Title and Abstract Description as hidden.

I added the following additional columns:

1. **Score 1**  — This is a column (type _Number_) for the first reviewer (hint: it’s me).
2. **Score 2 ** — This is a column (type _Number_) for the second reviewer (it’s my friend John Doe).
3. **Total Score**  — This is a column (type _Formula_) which computes the score of the previous two columns.

Here’s what it looks like after I followed the steps mentioned above (I took the liberty of scoring the talks).

![](https://cdn-images-1.medium.com/max/1024/1*VyDMDCJPFzacKhlt9HeP-Q.png)<figcaption>Blind review of speaker submissions on Airtable</figcaption>

## Workflow 2 — Proposal rating and final review

In this workflow, we’ll automate the export of all the submissions which have a total score greater than 15 for a final review on Trello. The workflow will also generate social media assets for the organizers and add them to the Trello card.

I have also submitted [Workflow 2](https://n8n.io/workflows/385) on n8n.io, in case you’d like to skim through this workflow. Please note that you’ll still need to configure a couple of things like your credentials as well as the settings of the nodes.

### 1. Airtable node: Pull specific data from the table

Create an *Airtable* node and select the credentials that you entered in the previous workflow. For the ***Operation*** field, we’ll select ‘List’. For the ***Base ID*** and ***Table*** fields, you can enter the same information that you entered in the previous workflow.

Here, we only want to retrieve the proposals where the total score was greater than 15. Click on the ***Add Options*** button under the ***Additional Options*** section, select ‘Filter by Formula’, and enter the following:

`{Total Score} > 15`

Now, click on the ***Execute Node*** button, and it should retrieve the records that we want. Here’s a video of me following the steps mentioned above.

{% youtube t5QuqA5wnc0 %}

As an exercise, you can add an [*IF*](https://docs.n8n.io/nodes/n8n-nodes-base.if/) node (instead of using the Filter by Formula option) to segregate the records based on the total score. Sessions with a score greater than 15 will be passed on through the workflow. Sessions (people) with a score less than 15 will be sent an email thanking them for their submission and informing them that this particular session was not accepted as a talk.

### 2. Bannerbear node: Generate promotional banners for the organizers

Bannerbear is a simple REST API that auto-generates social media visuals, e-commerce banners and more. First of all, create a free [Bannerbear](https://www.bannerbear.com/) account. Now, create a new Project. I named mine ‘Speaker Promotion’. Each project in Bannerbear can house many templates. Select an existing template by clicking on the ***Browse Template Library*** button. Next, select ‘Wikipedia Tutorial’ as your template.

You can click on ***Edit Template*** to open the template designer. I made some edits to the template to make it a bit more customized. It’s also a good idea to rename the layers so that it’s easy to remember which layer points to which piece of information when you are in the n8n Editor UI.

![](https://cdn-images-1.medium.com/max/1024/1*CWpVDZ_hc35HTFlgQ-S3jQ.png)<figcaption>Editing a template on Bannerbear</figcaption>

Before switching back to the n8n editor, click on the ***Settings / API Key*** button in Bannerbear and copy the _Project API Key_. Back in the n8n editor, we will add a Bannerbear node to automate creating variations of our template.

In the Bannerbear node, add a new credential and paste the _Project API Key_ there. Select ‘Speaker Promotion’ as the ***Template ID*** from the dropdown. Now, click on the ***Add Field*** button, select ‘Wait for Image’, and toggle the button to activate it. Since Bannerbear takes a few seconds to generate the image, this option makes sure that the node waits until the image has been created and passes the image URL in the result.

Now, under the ***Modifications*** section, click on the ***Add Modification*** button. We’ll have to add multiple layers and the corresponding data for that layer. For the ***Name*** field, select the ‘talk title’ layer. In the ***Text*** field, click on the gears icon next to the field, and click on _Add Expressions_ button to open the _Variable Selector_. Now, select the following variable:

`Current Node > Input Data > JSON > fields > What's the title of your talk?`

Similarly, go ahead and add the other modifications as well. While specifying adding a modification for the profile image, make sure to add the expression in the Image URL field and not the text field. Click on the Execute Node button and it should generate the images for you.

Here’s a video of me following the steps mentioned above.

{% youtube b-loLkTvd-Y %}

### 3. Trello node: Conduct a final review

Finally, we want the shortlisted speakers to get added to a column on the Trello board. This will enable the organizers to learn more about the speakers and their experiences and help them make an informed final decision on the sessions.

I created a Trello board that looks like the following.

![](https://cdn-images-1.medium.com/max/1024/1*SMjPYXAHq9lEdNvpTzG6Mw.png)<figcaption>Trello Board for the shortlisted conference submissions</figcaption>

In the n8n Editor UI, add a *Trello* node. For the credentials, you will need to enter the API Key, API Token, and the OAuth Secret. You can obtain all these details from this [page](https://docs.n8n.io/credentials/trello/).

Now, we need to enter the ***List ID***. This is the ID of the list (column) where the new cards will be added. For us, that’s the _Shortlisted Sessions_ column. Go to the URL of the current page, add `.json` at the end of the URL, and press enter. For example, the URL of the Trello board for me is [https://trello.com/b/HLj5y1gc/conference-cfp](https://trello.com/b/HLj5y1gc/conference-cfp). I would then add .json at the end of the URL and open [https://trello.com/b/HLj5y1gc/conference-cfp.json](https://trello.com/b/HLj5y1gc/conference-cfp.json).

Press ‘Ctrl (command) + F’ and look for the phrase ‘Shortlisted Sessions’. Copy the corresponding ID and paste that in n8n.

For the name of the card, I added the talk title (using the Variable Selector) and added the following expression as the description of the Trello card.

```
Abstract: {{$node["Airtable"].json["fields"]["Please share the abstract of your talk."]}}


Name: {{$node["Airtable"].json["fields"]["Great, can we get your full name?"]}}

Bio: {{$node["Airtable"].json["fields"]["Please share a bit of information about you."]}}

Email: {{$node["Airtable"].json["fields"]["And what's your email address?"]}}

Twitter: {{$node["Airtable"].json["fields"]["Your twitter handle"]}}
```

It would also make sense to attach the promotional banner that was generated by Bannerbear. Click on the ***Add Field*** button under the ***Additional Fields*** section, and select ‘URL Source’. Click on _Add Expressions_ and select the following in the _Variable Selector_:

`Current Node > Input Data > JSON > image_url`

Now, click on the ***Execute Node*** button, and it will create the cards on Trello, ready for the organizers to make their final selection. Here’s a video of me following the steps mentioned above.

{% youtube 1Kn43sPzQl0  %}

## Workflow 3— Notifying accepted speakers

As an exercise, you can create another workflow with the [*Trello Trigger*](https://docs.n8n.io/nodes/n8n-nodes-base.trelloTrigger/) node, which starts the workflow when a card gets moved to the _Final Sessions_ list. The workflow can then generate additional promotional banners (for different social media channels) for the speakers to share, as an attachment to the acceptance email.

## Conclusion

In this tutorial, we discussed how to automate the tasks related to the speaker submissions before the conference. You can also automate a lot of manual tasks during and after the conference to save time and improve the conference experience. Which other processes would you automate in your conference or meetup? Which nodes would you use for your workflows? I’d love to check out what you create. Please consider [sharing](https://n8n.io/workflows) your workflows with the community.

In case you’ve run into an issue while following the tutorial, feel free to reach out to me on [Twitter](https://twitter.com/tanay1337) or ask for help on our [forum](https://community.n8n.io/) 💙



> This [post](https://n8n.io/blog/automating-conference-organization-processes-with-n8n/) originally appeared on n8n.io [blog](https://n8n.io).