ntfy logo
Google Sheets logo

Workflow template

Log ntfy messages in Google Sheets

Log new cached ntfy messages in Google Sheets. Watch your chosen topic and append message ID, topic, message body and Unix time after an initial silent baseline.

How it works

From a new cached topic message to a Sheets row

1 Trigger · 1 Action
ntfy1 · Trigger

New topic message

Poll the topic you configure on the connected ntfy server. The first poll is a silent baseline; later new cached messages are eligible for delivery.

Google Sheets2 · Action

Append notification to worksheet

Append the message ID, topic, message text and source Unix time to A–D of your selected worksheet. RAW and INSERT_ROWS preserve the mapped message as data.

The result

A four-field topic-message register

Suggested A–D headers in the prepared mapping order.
Message IDTopicMessageUnix time
sample123exampleFictional alert1700000000

Fictional message. Unix time is preserved as seconds from the source, without a date-format conversion. Notification titles, tags, priorities and attachments are not mapped into the row.

Before activation

Set up your workflow

  1. Connect ntfy and enter the watched topic

    Select the ntfy server connection and configure the source topic. Confirm the connection can read its cached messages and review which message contents should be copied to a sheet.

  2. Choose the message-log worksheet

    Connect Google Sheets and select an existing spreadsheet and worksheet. Reserve A–D for ID, topic, message and Unix time. Optionally add the displayed headers, and keep RAW and INSERT_ROWS enabled.

  3. Publish a new fictional message after the baseline

    Activate and wait for the initial silent poll, then publish a fictional cached message to the watched topic. Compare its ID, text and Unix time with the appended row.

Details and limitations
  • The source reads cached messages. The first poll establishes a baseline rather than importing a backlog. Messages that are not cached, or expire before polling can retrieve them, should not be treated as covered by a durable archive guarantee.

  • Only four source fields are mapped. The row uses message ID, topic, message body and Unix time. Titles, tags, priorities and attachment data are not copied. The time stays in source seconds rather than a formatted calendar date.

  • The destination is append-only. RAW prevents formula-looking message text from being evaluated. The action does not create headers, update earlier rows or look up an existing message ID; manual reruns can append another row. Review sheet access for topic-message contents.

Questions about this template

Will existing messages be imported on activation?

No. The first poll silently establishes a baseline. Later new cached messages on the configured topic are eligible for the log.

Will it record messages that are not cached by ntfy?

This polling source reads cached messages. Uncached messages and messages that expire before retrieval are not covered by a durable archive guarantee; review the cache behavior of your chosen server.

Does the row include the notification title or attachments?

No. It contains message ID, topic, message body and Unix time only. Titles, tags, priorities and attachment data are not mapped.

Why is the time a number instead of a date?

The source Unix time is appended unchanged in seconds. There is no date-formatting step, and RAW input keeps mapped values as data rather than spreadsheet formulas.

Explore connected apps