# Capture Typeform responses using Glide API
### A quick recap
In [my previous post](https://hellosambhavi.com/integrate-typeform-with-your-glide-app) we looked at length on creating the most basic version of a Udemy type Glide app. We then created a feedback form using [Typeform](https://www.typeform.com/). As a next step, we invoked an email on a user action in the Glide app that had the Typeform link. Once the user submits the form, we used Airtable (integrated with Typeform) to capture the responses. As a final step, we created a table in [Glide](https://www.glideapps.com/) that used the [Airtable's](https://airtable.com/) table as the data source, that way the sync happened automatically. This is one way to bring back the responses.
In today's post, we shall explore another method to perform the same. One primary reason why I wanted to look out for another option is because of the lag it took for the responses to show up in Glide. The secondary reason was to avoid another tool in the ecosystem.
The route I took this time was to make use of [Glide API](https://www.glideapps.com/docs/getting-started-with-the-glide-api) to add a row in the Feedback table which was stitched together through a [Zap](https://zapier.com).
### Introducing Glide APIs
The introduction of APIs in Glide has been a game changer as that's the route in order to add/edit/delete data in Glide tables from outside the Glide app.
Let's look at few quick key pointers when it comes to Glide APIs.
* Basic APIs are available in Team and above plans only
* It allows 3 types of action:
* Add a row
* Edit a row (or) Set columns in a row
* Delete a row
* With Business plan and above, Fetch rows is also possible. Just that conditions cannot be added with Glide tables
* In order to perform SQL type queries, Big Tables should be used as the database
In order to get started, let's get familiar with how the APIs look like and how to access them. For the sake of explaining, let me show the API for one of the table we created in our [SkillSprout](https://hellosambhavi.com/integrate-typeform-with-your-glide-app) app.
Go to the Data editor and right click on a table. You should see a menu **Show API**
![](https://cdn.hashnode.com/res/hashnode/image/upload/v1710341266136/c90bd372-8adf-41f5-9dd7-a10c1ad170af.png align="center")
There are 3 options that Glide provides, one using Javascript, the second using Python and the third using curl for each of Add row, Set columns in a row, Delete row and Get rows.
![](https://cdn.hashnode.com/res/hashnode/image/upload/v1710341474095/a269e754-3576-421c-b886-0db27d2a52c1.png align="center")
Depending on where one uses the APIs and the tech they are comfortable with, that particular option can be chosen. Likewise, depending on the action we decide to perform we choose that particular piece of code.
That's all as far as setting up of APIs are concerned.
### Let's bring in Zapier
Now that we have a decent idea about Glide APIs and how to access/use them, let's now move on to the next component [Zapier](https://zapier.com/).
Zapier is an automation tool that connects multiple tools together. In any business, tools like GMail, Google Sheets, Hubspot, Mailchimp, Calendly, Slack and similar ones are extremely common.
In order for these tools to talk to one another, we need a binding component which is handled by Zapier. You name a tool and it be connected using a Zap. [Zap](https://zapier.com/workflows) is Zapier's term of a workflow. There has to be a trigger that can be followed by any number of steps/actions connecting any tool to any other tool, as long as it supported by Zapier.
Let's look at our use case now and see where Zapier kicks in:
* A student clicks on the Typeform link that is embedded in an email
* The student fills in the form and submits it
* The zap that we create will kick in the moment a new Typeform entry is created. Thus a new Typeform entry is the trigger
* It reads the responses and passes it to the next step which is a Zapier Webhook that takes in a custom request. As part of the request, we add details about the URL that is to be invoked (which is nothing but the Add row API), the data that needs to be passed (which is the Typeform responses) and the header information (Content type and a Authorization token)
That is all. Once these two steps are configured in Zapier, every time a user submits a response, our feedback table is automatically updated. The lag in this case is less than a second most of the time.
π‘
You need to be on a paid plan in order to create multi-step zaps. In this case, since it's just two steps, a free plan would suffice.
### Steps to configure
We perform the following steps in order to see the magic happen π¦ΈββοΈ
1. Refer to [my earlier post](https://hellosambhavi.com/integrate-typeform-with-your-glide-app) to set up the Glide App and the Typeform form
2. Instead of the **Feedback** table that was pointing to Airtable, we create a new table **Response** with the same structure, but as an usual Glide table
3. Sign up with Zapier if you do not have an account. Else, Sign in
4. Create a new Zap and add Typeform as the trigger. Typeform has only one type of action that can be assigned, which is **New Entry**
![](https://cdn.hashnode.com/res/hashnode/image/upload/v1710337037584/8f5d333a-3be9-4247-8ac2-177a8f07c06d.png align="center")
5. Click on Continue and connect your Typeform account
6. Once connected, it will list the forms in your account. I chose the Skill Sprout feedback form that I created earlier
![](https://cdn.hashnode.com/res/hashnode/image/upload/v1710337260845/59e68660-eb58-49ef-acab-d745885c08ad.png align="center")
7. On selecting the form, it will ask to test the trigger by selecting an existing record. If your form has responses, then they will be shown automatically. Else you may want to manually submit a response and come back to Zapier and refresh to select the newly submitted response
8. As a next step, select [Zapier Webhooks](https://zapier.com/features/webhooks) and Custom Request
![](https://cdn.hashnode.com/res/hashnode/image/upload/v1710337446883/073214ca-ba16-4363-acc5-6c0c8697f60e.png align="center")
9. Before we show the step where we configure the API, let's take a look at the API definition in Glide for the newly created **Response** table
![](https://cdn.hashnode.com/res/hashnode/image/upload/v1710390969895/8c86b41c-994d-4488-bb24-d1114ba74e65.png align="center")
π‘
Only basic columns are allowed to be manipulated using Glide APIs. Computed columns are not part of the game π, logically it does make sense, is it not?
10. We set Student ID and Course ID as hidden fields in the Typeform so that we know which student submitted the feedback for which course
11. Let's now see the setup in Zap. We set the method as **POST**, the URL as [https://api.glideapp.io/api/function/mutateTables](https://api.glideapp.io/api/function/mutateTables), the data is what appears beside data-raw between the single apostrophes. Under header section, we add the **Content-type** and assign it the value **application/json** and **Authorization** with the value **Bearer followed by the secret code.**
π‘
In order to find out the secret code, click on Copy Secret Token
![](https://cdn.hashnode.com/res/hashnode/image/upload/v1710345913715/43551df1-4fa4-4bef-b7d9-a34095ca88b7.png align="center")
![](https://cdn.hashnode.com/res/hashnode/image/upload/v1710387936189/bbad5d27-680e-477e-8211-d7cb96a7b3f2.png align="center")
π‘
The key point to note here is assigning the value from Typeform responses matching the appropriate field in Glide Table. Only if this mapping happens will the values go back to the appropriate columns.
![](https://cdn.hashnode.com/res/hashnode/image/upload/v1710345964584/963b4bed-a807-4a6c-ac7a-a9056652e1f7.png align="center")
π‘
I have shown the secret code as ******* just for explanation purpose. You need to paste the actual secret code beside Bearer
12. Time to publish the Zap. In order to do that, just click on **Publish** on the right corner of the navbar
π‘
If any case for some reason your zap fails, the first place you want to check is the Zap history that appears in your Zapier dashboard. It'll clearly show each step's input and output that'll be the starting point for any error.
### Time to see it in action
Quickly I did a [screen recording](https://www.loom.com/share/c6bfe515032b4e228e69ed6e7a02b5a8?sid=27035386-9c80-458b-b21c-5a5e91114b0c) showing the work in action. If you happen to watch the recording, you will know how seamless it is, the whole process of a response from another tool coming back to Glide in a snap of a finger.
It's a very simple method but super powerful. From an end user perspective, there'll be no difference at all in the way things are stitched. Isn't that great?
### Conclusion
In this post, we saw an alternate method to capture Typeform responses and bring them back to a Glide table using Glide API and Zapier.
I find this method to be a better one in comparison with the earlier approach of integrating with Airtable. Mainly for the immediate refresh that happens on Glide table and thus the usability of the app is more seamless β¨
[Make](https://www.make.com/en) is another automation tool that is similar to Zapier. One can use Make as well to perform the same step of steps instead of Zapier. Probably in a future post I shall write about using Make for this use case π
If you have other methods in which you integrate, feel free to share your approach. Let's learn together π€
### References
[Glide API Docs](https://www.glideapps.com/docs/getting-started-with-the-glide-api)
[Using Glide API](https://www.glideapps.com/docs/using-glide-tables-api)