How to connect Google Forms
Alex avatar
Written by Alex
Updated over a week ago

In this tutorial we will show you how to connect Google Forms to your Analysis to automate the data ingress.

  1. You can use an existing Analysis, or create a new one. Select "App Integration" when setting-up the Analysis. When you arrive to the following screen, you are ready to go:

  2. Set up your Google Form. In this example we use a NPS survey that looks like this:

  3. At this stage, we recommend to add a response to your Form, such that you have some test data for the connection with Zapier.

  4. Log in to Zapier and create a new Zap. Use Google Forms as a Trigger

  5. Use the "New Form Response" Trigger

  6. Select the Form that you want to connect. In our case it is the "NPS evaluation" Form.

  7. If you have added a test response as suggested earlier, you will get some test data when testing the Trigger:

  8. We continue with this selected record. Use Deep Talk as the Zapier Action:

  9. Select the "Add Text Document to Analysis Action"

  10. Connect your Deep Talk account to Zapier by pasting your API key:

  11. Then, we need to configure how we want Deep Talk to use the information of the Google Form. First, select the Analysis that you want to use.

  12. Then, select the Text Field that you want to use. In our case this is "What are your reasons for this evaluation?"

  13. Then, select the "Create Time" as the Date Field

  14. Then, select the NPS column, if you have one. In our case we do:

  15. Use the "Response ID" as external reference. This will allow you to know in the Deep Talk dashboard from which response a certain text originated.

  16. Then we can add metadata to our Analysis. For this we need to know three things: the type of the metadata that we are dealing with, how we want to name the metadata and its value from the user response. In general we can say that:

    1. A Multiple Choice Question of a Form is "Categorical Metadata"

    2. A Question that asks the user to enter a specific number is "Numerical Metadata"

    Let's go through three examples:

  17. On our Form we ask for the Gender of the person. This is a multiple choice question and as such we treat it as categorical metadata. The value of the user response in our case is "Male". The name is something that we can chose now. In Deep Talk, a filter will show up on the dashboard with the name that we now chose. The final configuration looks as this:

  18. We repeat the same task for the "How did you hear from us" question. In this case we name the field "Origin Lead"

  19. For the "How old are you" question, we use numerical metadata. The setup is similar.

  20. This is all. Click continue and check to see something similar to this:

  21. Test the action

  22. If you navigate back to your Analysis, the dashboard will show up once the response was processed. (This usually is quick, but may take up to one minute). You can see the metadata filters having the names that we chose in the Zapier Form

  23. That's all. Every new Form response will now be added to your dashboard and analyzed automatically!

Did this answer your question?