Save new Typeform form submissions to Microsoft 365 Excel and create a task in Asana

First, we need to connect Typeform, Microsoft Excel and Asana to Make.com.

• 

  Create Make.com account.

  Create Make.com account if you don't have one.

• 

  Connect Typeform to Make.com.

  Give Make.com access to your Typeform account, using Typeform credentials.

• 

  Connect Microsoft Excel to Make.com.

  Give Make.com access to your Microsoft Excel account, using Microsoft Excel credentials.

• 

  Connect Asana to Make.com.

  Give Make.com access to your Asana account, using Asana credentials.

Next, we need to create a workflow automation scenario using graphical no-code web interface of Make.com.

• 

  Set up a Trigger action for Typeform

  Choose the following trigger: Watch Responses (Triggers when a new response is submitted.).

• 

  Then set up an Action for Microsoft Excel

  Choose this action: Add a Worksheet Row (Adds a new worksheet row.).

• 

  Then set up another Action for Asana

  Choose this action: Create a Task or a Subtask (Creates a task or a subtask.).

Finally, we need to test this automation and publish it.

• 

  Customize data flow

  Configure the data that is exchanged between Typeform, Microsoft Excel and Asana.

• 

  Test the workflow and turn it on for production use

  Test your scenario and publish to production. Now you have an automatic workflow, that will Save new Typeform form submissions to Microsoft 365 Excel and create a task in Asana!