Try It

Assign BigML anomaly scores to new Google Forms responses and store them in Google Sheets

  1. When this happensStep 1: New Response in Spreadsheet

  2. Then do thisStep 2: Create Anomaly Score

  3. Then do thisStep 3: Create 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
Try It

Connect Google Forms + Google Sheets in Minutes

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

All Triggers & Actions

New Response in Spreadsheet

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

Create Spreadsheet Column

Create a new column in a specific spreadsheet.

Create Spreadsheet Row(s)

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

Create Worksheet

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

Update Spreadsheet Row

Update a 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 Spreadsheet Row

Create a new row in a specific spreadsheet.

Create Spreadsheet

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

Delete Spreadsheet Row

Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.

Find Many Spreadsheet Rows (With Line Item Support)

Finds many matched rows (10 max.) by a column and value.

Connect the apps you use every day

Get started with a Free account

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