Google Forms Zap for Viable

Creating a Zap that connects Google Forms to Viable

You can instantly analyze open ended survey responses collected via Google Forms by sending them to Viable for analysis using Zapier.

In Zapier, click Make a Zap and follow the steps below.

Setting up the Trigger

Choose Google Forms as the trigger >> app event
Then choose New Response in Spreadsheet (or New or Updated Response in Spreadsheet if you'd like to analyze updated responses too) as the trigger event

Click Continue and then sign into your Google Forms account
Under Set up trigger, select the spreadsheet, worksheet, and trigger column you'd like to analyze. Click Continue.

Test your trigger

Setting up the Action

Select Viable as the Action app

Setting up the ActionSelect Viable as the Action app

Then select Ingest Datapoint as the Action Event

Continue to sign into Viable. You’ll need your Viable API key (in Viable it’s in Admin >> Integrations tab).

Under Set up action choose the fields you want to analyze. We recommend you set up a separate Zap for each free text question/response you want to analyze for a survey. (We do not recommend setting up a Zap for multiple choice or single choice questions.)

Sending all questions via a single Zap will likely result in more generic answer results in Viable.

For Text, Fchoose the open ended question you’d like to analyze. First type in the question, and then choose the field. That way, the question shows up in Viable alongside the analyzed answer, so you have the context. In the example below, You’d type in What made you choose our product today? And then Choose the What made you choose our product today? field option
For Created at, choose Timestamp
For End user email, choose the email address field or other user identifier (in this example, it’s Work email). If there’s none, enter Anonymous.