Google Sheets + Ubiqod by Taqt + Formatter by Zapier + Filter by Zapier

Track working time in Google Sheets when new Ubiqod by Taqt QR codes are scanned

This integration can save you a ton of manual data entry work. If you want to track worker arrival and departure times in the field, this Ubiqod by Taqt-Google template automatically adds a RAW file at arrival and updates the file at departure.

This integration can save you a ton of manual data entry work. If you want to track worker arrival and departure times in the field, this Ubiqod by Taqt-Google template automatically adds a RAW file at arrival and updates the file at departure.

  1. When this happens...
    Ubiqod by TaqtUbiqod by Taqt
    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...
    Filter by ZapierFilter by Zapier
    Only continue if...

    Set up rules to specify when this Zap can continue running.

    ActionFilter
  4. then do this!
    Google SheetsGoogle Sheets
    Update Spreadsheet Row

    Update a row in a specific spreadsheet with optional formatting.

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

Supported triggers and actions

  • Ubiqod by Taqt triggers, actions, and search

    Get Sites

    Get all sites on an account

    Trigger
    Polling
    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 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
ubiqod-by-taqt logo
ubiqod-by-taqt logo

About Ubiqod by Taqt

Ubiqod by Taqt is a connector that allows you to seamlessly send real-time field data collected via QR codes, NFC tags, or Taqt devices into your Zaps.

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 more

Related categories

  • Documents
  • Zapier
filter logo
filter logo

About Filter by Zapier

Only allow a Zap to proceed when a certain condition is met. For example, if you're sending a text message when you receive a new email, you could use a Filter that only sends a text message when the email received is from a certain address.
Learn more

Related categories

  • Developer Tools
  • Zapier