Loading

Google Sheets + Ubidots

Log new Ubidots events as rows on Google Sheets

IoT is not only about pretty charts; it is also about acting on your data, even while you're away. Ubidots Events allow you to trigger notifications based on data from your IoT devices, but keeping a log of who received the alert - and whether the proper action was taken- is just as important as the alert itself. With this integration you can log Ubidots Events as rows on Google Sheets, where you can add custom columns like who acknowledged an incident, and how it was resolved, making sure you - and your customers - are turning data into action.

IoT is not only about pretty charts; it is also about acting on your data, even while you're away. Ubidots Events allow you to trigger notifications based on data from your IoT devices, but keeping a log of who received the alert - and whether the proper action was taken- is just as important as the alert itself. With this integration you can log Ubidots Events as rows on Google Sheets, where you can add custom columns like who acknowledged an incident, and how it was resolved, making sure you - and your customers - are turning data into action.

  1. When this happens...
    UbidotsUbidots
    Event Is Triggered

    Triggers when an Event is triggered.

    TriggerScheduled
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Spreadsheet Row

    Create a new row in a specific spreadsheet.

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

Supported triggers and actions

What does this mean?
    • DeviceRequired

    Trigger
    Scheduled
    Try It
    • DeviceRequired

    • VariableRequired

    Trigger
    Scheduled
    Try It
    • DeviceRequired

    • Variable 1Required

    • Value For Variable 1Required

    • Timestamp

    • Context For Variable 1

    • Variable 2

    • Value For Variable 2

    • Timestamp

    • Context For Variable 2

    • Variable 3

    • Value For Variable 3

    • Timestamp

    • Context For Variable 3

    Action
    Write
    • No Team Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Instant
    Try It
    • DeviceRequired

    • VariableRequired

    • ValueRequired

    • Timestamp

    • Variable Context

    Action
    Write
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Scheduled
    Try It
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 moreHelp

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
ubidots logo
ubidots logo

About Ubidots

Rapidly assemble and launch Internet of Things (IoT) applications without having to write code or hire a software development team.

Related categories

Similar apps

Zapier Interfaces integrationsZapier Interfaces integrations

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier