Sendy logo
Google Sheets logo

Workflow template

Log Sendy unsubscriptions in an automatically created Google Sheet

Log Sendy unsubscribe events in a spreadsheet created automatically. A matching manual Sendy Rule delivers each opt-out, with subscriber and list details appended as six literal values.

How it works

From a Sendy unsubscribe Rule to an event-log row

1 Trigger · 2 Actions
Sendy1 · Trigger

Subscriber Unsubscribed

Receive new unsubscribe events through the private callback URL you configure in the matching Sendy Rule. Optionally restrict the source to one List ID; historical opt-outs are not imported.

Google Sheets2 · Action

Create the event spreadsheet once

Create Sendy unsubscriptions with an Events worksheet and six prepared headers on first use. Later events reuse the same spreadsheet for this workflow copy.

Google Sheets3 · Action

Add the Sendy unsubscription

Append event type, subscriber name, email, list ID, list name and list URL into A–F of the created worksheet, using RAW and INSERT_ROWS rather than spreadsheet formulas.

The result

An append-only record of newly received opt-out events

The creation step prepares these six headers automatically.
EventNameEmailList IDList nameList URL
unsubscribeFICTIONAL Examplefictional@example.comFICTIONAL_LIST_IDFICTIONAL listhttps://sendy.example.com/subscribers?i=1&l=1

Fictional event. This logs an unsubscribe that occurred in Sendy; it does not perform an unsubscribe action, delete the subscriber or modify a separate subscriber-register sheet. No email is sent by this workflow.

Before activation

Set up your workflow

  1. Configure the Sendy unsubscribe Rule

    Connect your Sendy installation using its URL and API key. Copy the private webhook URL from trigger Setup into a Rule for the matching unsubscribe event and list. Keep it secret and optionally set a trigger List ID restriction.

  2. Connect the Sheets account for the new log

    Select Google Sheets and review the prepared file title, Events worksheet and six headers. No existing file is needed. Use an account and destination access appropriate for subscriber names, emails and list information.

  3. Generate a fictional unsubscribe after activation

    Activate and unsubscribe a fictional test subscriber from the Rule’s selected list. Check the automatically created spreadsheet and its unsubscribe row, then confirm later events reuse that file.

Details and limitations
  • This records opt-outs rather than performing them. The source event comes from a Sendy unsubscribe Rule. The action appends history only; it does not unsubscribe other systems, delete contacts or remove rows from another subscription register.

  • Rule setup and shutdown are manual. Match the Rule’s event and list to the source and keep its private URL secret. Pausing stops FastHook processing; disable the Rule in Sendy separately when no longer needed. Historical opt-outs are not imported.

  • Repeated deliveries can append again. Sendy Rules provide no event ID. Repeated HTTP deliveries or manual replays can produce duplicate rows. RAW keeps mapped fields as literal text, and gravatar is not included.

  • Creation persists for this workflow copy. Each copy creates its own spreadsheet. A creation-action test creates the file too; later runs reuse it. Changed creation settings require a new creation step after first use, and a deleted file is not silently replaced.

Questions about this template

Does this unsubscribe people or only record an opt-out?

It records an unsubscribe event delivered by the Sendy Rule. It does not perform another unsubscribe, delete the subscriber or update a separate subscriber-register sheet.

Do I need to prepare the spreadsheet or headers?

No. First use creates Sendy unsubscriptions, an Events worksheet and six headers. Each workflow copy has its own file; testing creation also creates it and later runs reuse it.

Will historical or repeated opt-outs be handled once?

Historical opt-outs are not imported. Sendy Rules provide no event ID, so repeated HTTP deliveries or manual replays can append duplicate rows rather than guarantee once-only output.

What happens when I pause or delete the spreadsheet?

Pausing stops FastHook processing; disable the manual Rule separately in Sendy. A deleted file is not silently replaced, and changing creation settings after first use requires a new creation step.

Explore connected apps