Google Sheets + Ubiqod + Formatter by Zapier

Add rows in Google Sheets when new Ubiqod IoT-devices or QR codes are used

If you're collecting data from IoT-devices or QR codes, you may want to store that information. This Ubiqod-Google Sheet integration automatically adds a new row in a specified Google Sheets spreadsheet when someone engages with a Ubiqod IoT-device or scans a Ubiqod QR code.

If you're collecting data from IoT-devices or QR codes, you may want to store that information. This Ubiqod-Google Sheet integration automatically adds a new row in a specified Google Sheets spreadsheet when someone engages with a Ubiqod IoT-device or scans a Ubiqod QR code.

  1. When this happens...
    UbiqodUbiqod
    New Data [UBIQOD V1]

    Triggers when an IoT button is pressed or when user submit data from a Qod.

    TriggerInstant
  2. automatically do this...
    Formatter by ZapierFormatter by Zapier
    Date / Time

    Work with dates and times to change formatting or add/subtract time (with line-item support).

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

    Create a new row in a specific spreadsheet.

    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?
    • Dispatch Group NameRequired

    Trigger
    Instant
    Try It
    • Dispatch

    Trigger
    Instant
    Try It
    • LabelRequired

    • LatitudeRequired

    • LongitudeRequired

    • Site Geofencing Distance Margin

    • Trackers List

    Action
    Write
    • LabelsRequired

    • Site

    • Interface

    • Dispatches

    Action
    Write
  • Ubiqod triggers, actions, and search

    Get Sites

    Get all sites on an account

    Trigger
    Scheduled
    Try It
  • Ubiqod triggers, actions, and search

    Get Trackers

    Get all trackers on an account

    Trigger
    Scheduled
    Try It
    • LabelRequired

    • Site

    • Interface

    • Dispatches

    Action
    Write
    • Site IDRequired

    Action
    Search
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
ubiqod logo
ubiqod logo

About Ubiqod

Ubiqod is a traceability platform for tracking field activities with IoT, static and dynamic QR codes.
Help

Related categories

  • Devices
formatter logo
formatter logo

About Formatter by Zapier

Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.
Learn moreHelp

Related categories

  • Documents
  • Zapier