Google Sheets
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 Sheets + Google Forms and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
New Spreadsheet Row

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

Create Worksheet

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

New or Updated Spreadsheet Row

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

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

New Response in Spreadsheet

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

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 Response

Create a new response/entry (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).

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

Become a Zapier Integration Partner

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

Learn More

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!

See Google Forms Integrations