Skip to content
Notis

Keep Beaconstac places current with Sheets

Log a location change in Sheets and have Notis update the matching Beaconstac place.

Trigger

New Rows in Google Sheet

Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.

Action

Update Place

Tool to update the specified place by id. use after retrieving the place to modify its details, such as name, address, or coordinates.

Why this helps

Address and location corrections can stay trapped in a spreadsheet while Beaconstac continues to show old details.

  • Move location corrections from a sheet into existing places.
  • Update place details such as name, address, or coordinates.
  • Reduce drift between location records and Beaconstac.

Setup

Build it in a few focused steps.

  • 1Connect Google Sheets and Beaconstac once in the Notis portal.
  • 2Create an automation in Automations, New Automation, and give it a name.
  • 3Describe in one instruction how to identify and update the existing Beaconstac place for each new change row.
  • 4Pick the New Rows in Google Sheet trigger and choose where run reports go.
  • 5Test with one real location change for a confirmed place.

Questions about this workflow

Does this create a place for a new location?

No. This workflow updates an existing place. Use a separate place creation workflow for new locations.

Which details can it update?

The action can modify place details such as name, address, or coordinates.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

Notis builds workflows that link Google Sheets to Beaconstac. A trigger fires from one place; an action lands in another.

Google Sheets triggers

Beaconstac actions

Recurring trigger

Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.

TriggerScheduled

Create Place

Tool to create a new place for location-based assets. use when you need to register a new physical place under an organization.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

Create QR Template

Tool to create a new qr code template. use when you need reusable design presets for qr codes.

ActionInstant

Aggregate Metric Changed

Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.

TriggerPolling

Create Tag

Tool to create a new tag for organizing qr codes and other objects. use when you need to categorize qr codes under a specific organization.

ActionInstant

Cell Range Values Changed

Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.

TriggerPolling

Create User

Tool to create a new user. use when onboarding a new user under your organization (reseller plan and above).

ActionInstant

Conditional Format Rule Changed

Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.

TriggerPolling

Delete QR Code

Tool to delete a qr code by its id. use when you need to remove an existing qr code after validation.

ActionInstant

Data Validation Rule Changed

Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.

TriggerPolling

Delete QR Code Template

Tool to delete a qr code template by its id. use when you need to permanently remove a qr code template that is no longer needed.

ActionInstant

Developer Metadata Changed

Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.

TriggerPolling

Delete Tag

Tool to delete a tag by its id. use when you need to remove an existing tag after validation.

ActionInstant

Filtered Range Values Changed

Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.

TriggerPolling

List Bulk QR Code Collections

Tool to list bulk qr code collections. use when you need to filter, search, or order your bulk qr code collections.

ActionInstant

Connect any two apps with Notis in the middle.

Google Sheets and Beaconstac, or any other combination from 1,000+ integrations.

When this happens · Trigger

Do this · Action

Save your first hour today.

7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Beaconstac.