Refound your company for the AI era at ZapConnect 2026. Save your spot →
Google Sheets + Ubiqod by Taqt + Formatter by Zapier + Filter by Zapier
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.
- When this happens...New Data [UBIQOD V1]Triggers when an IoT button is pressed or when user submit data from a Qod.
- automatically do this...Date / TimeWork with dates and times to change formatting or add/subtract time (with line-item support).
- then do this...Only continue if...Set up rules to specify when this Zap can continue running.
- then do this!Update Spreadsheet RowUpdate a row in a specific spreadsheet with optional formatting.
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with these apps
Discover other triggers and actions you can use with Ubiqod by Taqt, Formatter by Zapier, and more
- Dispatch Group NameRequired
Try ItTriggerInstant- Dispatch
Try ItTriggerInstant- LabelRequired
- LatitudeRequired
- LongitudeRequired
- Site Geofencing Distance Margin
- Trackers List
ActionWrite- LabelsRequired
- Site
- Interface
- Dispatches
ActionWrite
- Get Sites
Get all sites on an account
Try ItTriggerPolling - Get Trackers
Get all trackers on an account
Try ItTriggerPolling - LabelRequired
- Site
- Interface
- Dispatches
ActionWrite- Site IDRequired
ActionSearch
Related categories
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.
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.
Related categories


![New Data [UBIQOD V1]](https://zapier-images.imgix.net/storage/services/6a78b17b045bd2960be45a58c24541f8.png?auto=format&ixlib=react-9.11.0&q=50&fit=crop&h=60&w=60)





