Google Forms + Google Sheets + BigML

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

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 easily update your forms data with that anomaly score.

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 easily update your forms data with that anomaly score.

  1. When this happens...
    Google FormsGoogle Forms
    New Form Response

    Triggers when a new form response is received.

    TriggerInstant
  2. automatically do this...
    BigMLBigML
    Create Anomaly Score

    Calculates the anomaly score of a data instance.

    ActionWrite
  3. then do this!
    Google SheetsGoogle Sheets
    Create Multiple Spreadsheet Rows

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

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • FormRequired

    Trigger
    Instant
    Try It
    • HTTP MethodRequired

    • URLRequired

    • Query String Parameters

    • Headers

    • Additional Request Headers

    • Body

    Action
    Write
    • ResourceRequired

    Action
    Write
    • ResourceRequired

    Action
    Write
    • FormRequired

    Trigger
    Instant
    Try It
    • Resource Type

    • Project Name

    • Resource Name

    • Resource Tag

    Trigger
    Scheduled
    Try It
    • ResourceRequired

    Action
    Write
    • ResourceRequired

    Action
    Write
google-forms logo
google-forms logo

About Google Forms

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

Related categories

  • Forms & Surveys
  • Google

Similar apps

Zapier Interfaces integrationsZapier Interfaces integrations

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier
google-sheets logo
google-sheets logo

About Google Sheets

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

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
bigml logo
bigml logo

About BigML

BigML is a Machine Learning platform to solve and automate Classification, Regression, Time Series Forecasting, Cluster Analysis, Anomaly Detection, and Topic Modeling tasks. BigML seamlessly transforms data into actionable models that are used as remote services or, locally, embedded into applications to make predictions.

Related categories

  • Developer Tools