Skip to content
Notis

Anonymize sensitive text in new Google Sheets rows

Keep new submissions useful for analysis while concealing the sensitive text you specify.

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

Anonymize Value

Tool to anonymize a string or array of string values. use when you need to conceal sensitive text before storage or transmission. example: `anonymizevalue().execute(anonymizevaluerequest(data=['secret']))` limitations: only supports list of strings, not nested structures.

Why this helps

Copying each submission into a separate anonymization tool adds busywork and makes it easy to expose private details.

  • Anonymizes specified string values in newly added rows.
  • Reduces manual handling before sharing data with AI tools.
  • Keeps the workflow focused on new entries.

Setup

Build it in a few focused steps.

  • 1Connect Google Sheets and Anonyflow once in the Notis portal.
  • 2Create an automation in Automations, New Automation, or tell Notis in plain language from any channel.
  • 3In one instruction, name the sheet context and the sensitive string values in each new row to anonymize.
  • 4Pick New Rows in Google Sheet as the trigger and choose where run reports go.
  • 5Test with one real example row containing only string values.

Questions about this workflow

Can this anonymize an entire nested row object?

Anonyflow's Anonymize Value action supports a list of strings, not nested structures. Ask Notis to use the specific sensitive string values from each row.

When does this workflow run?

It runs when the Google Sheets New Rows in Google Sheet trigger detects a new row.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

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

Google Sheets triggers

Anonyflow actions

Recurring trigger

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

TriggerScheduled

Anonymize Value

Tool to anonymize a string or array of string values. use when you need to conceal sensitive text before storage or transmission. example: `anonymizevalue().execute(anonymizevaluerequest(data=['secret']))` limitations: only supports list of strings, not nested structures.

ActionInstant

Webhook trigger

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

TriggerInstant

Deanonymize Packet

Tool to deanonymize a json data packet using your private key. use after receiving an anonymized packet to recover specific fields.

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

Deanonymize Value

Tool to deanonymize one or more anonymized string values. use when you need to recover the original plaintext values after encryption-based anonymization. example: `deanonymizevalue().execute(deanonymizevaluerequest(data=["<anonymized string>"]))`

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

Test Connection

Tool to test the connection to the anonyflow api. use when verifying that the anonyflow service is reachable and operational before performing anonymization tasks. example: `testconnection().execute(testconnectionrequest())`

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

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

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

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

Connect any two apps with Notis in the middle.

Google Sheets and Anonyflow, 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 Anonyflow.