Google Forms
When this happens...
Google FormsNew Response in Spreadsheet
do these tasks!
BigMLCreate Anomaly Score
Google SheetsCreate Spreadsheet Row(s)

If you use Google Forms to survey your customers, you could want to spot those responses that look "anomalous" to you, according to your own definition of what an anomalous response is. Even better, if you label past responses you received as "normal" or "anomalous", you can train a BigML model that is able to automatically spot "anomalous" responses for you. This integration allows you to automatically assign an anomaly score to all new responses you get and update your forms data with that anomaly score.

Note: This Zapier integration does not provide a ready-to-use anomaly detector. You can train one using the BigML Dashboard with your own data.

How this Google Forms-BigML-Google Sheets integration works

  1. A customer sends in their responses to a Google Form
  2. Zapier uses BigML to associate an anomaly score to it
  3. The anomaly score is stored in a Google Sheets spreadsheet

Apps involved

  • Google Forms
  • BigML
  • Google Sheet

Why Zapier?

Free

Get started for free—14 day trial of premium features and apps.

Easy

No coding required—automate any of 1,500+ apps in minutes.

Secure

Enterprise-level security—connect mission-critical apps.

It's easy to connect Google Forms + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
New Response in Spreadsheet

Triggered when a new response row is added to the bottom of a spreadsheet.

Create Response

Create a new response/entry (row) in a specific spreadsheet.

New or Updated Response in Spreadsheet

Triggered when a new response row is added or modified in a spreadsheet.

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Update Spreadsheet Row

Update a row in a specific spreadsheet.

New Spreadsheet Row (Team Drive)

Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.

Create Spreadsheet Row(s)

Create one or more new rows in a specific spreadsheet (with line item support).

You use lots of apps to get stuff done. Zapier creates more time in your day by helping you automate those apps, so they work for you in the background.

Use our free platform to build a single Zapier integration and instantly connect your app with 1,500+ others.

Become a Zapier Integration Partner

Google Forms is an easy way to collect data from the web with a simple UI and powerful editor. Works hand-in-hand with Google Sheets!

Learn More

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

See Google Sheets Integrations

Connect Google Forms + Google Sheets

Connect the apps you use everyday and find your productivity super-powers.

By signing up, you agree to Zapier’s Terms of Service.