Activepieces is a versatile tool to automate workflows between Formbricks and numerous applications. Here’s how to set it up.

Ensure your survey is finalized before setting up Activepieces. Any changes in the survey will require additional adjustments in the workflow.

Step 1: Setup your survey incl. questionId for every question

Set up the questionIds of your survey questions before publishing.

Update the Question ID field in every question card under Advanced Settings.

Already published? Duplicate survey You can only update the questionId before publishing the survey. If already published, simply duplicate it.

Step 2: Setup Activepieces

Visit Activepieces to start a new Flow.

Search for Formbricks and choose the event to trigger the flow, we will choose Response Finished here

Step 3: Connect Formbricks with Activepieces

Click on Create connection:

Enter the Formbricks API Host and API Key. API Host is by default set to https://app.formbricks.com but can be modified for self-hosting instances. Learn how to get an API Key from the API Key tutorial.

Step 4: Select Survey

Choose from your created surveys:

Step 5: Send a test response

You need a test response for Activepieces setup. Click on Test trigger and submit a test response in the connected Formbricks survey to see the data in Activepieces.

If the test response is successful, you will see the data in Activepieces.

Step 6: Set up Google Sheet

Decide on the desired action for the data. Here, we’ll send submissions to a Google Sheet. Add Google sheet step to your flow and configure it as follows: Choose “Add a Row” for the action. Authenticate with Google and select the spreadsheet you want to add the data to.

Specify the fields you want to add to the spreadsheet.

A new row gets added to the spreadsheet for every response: