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.
Workflow template
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
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.
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
| Message ID | Topic | Message | Unix time |
|---|---|---|---|
| sample123 | example | Fictional alert | 1700000000 |
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
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.
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.
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.
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.
No. The first poll silently establishes a baseline. Later new cached messages on the configured topic are eligible for the log.
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.
No. It contains message ID, topic, message body and Unix time only. Titles, tags, priorities and attachment data are not mapped.
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.