Workflows / Email, From Sign-Up To Nurture

Click Tracking And Interest Scoring

Mail apps preload images, so open rates say little about what a reader actually wants.

On every clickGoogle Sheets

How It Runs

TRIGGERClick WebhookLOGICConfigLOGICVerify SignatureSHEETRead SubscribersLOGICScore ClickSHEETUpdate ScoresLOGICEvent RowSHEETLog EventLOGICRedirect DataTRIGGERRespond

Steps

  1. Click WebhookTrigger
  2. ConfigLogic
  3. Verify SignatureLogic
  4. Read SubscribersSheet
  5. Score ClickLogic
  6. Update ScoresSheet
  7. Event RowLogic
  8. Log EventSheet
  9. Redirect DataLogic
  10. RespondTrigger

Control Sheet Tabs

EventsSubscribers

Accounts To Connect

Google Sheets

Run It Yourself

n8n

  1. In n8n, open Workflows, then Import from URL
  2. Paste https://raw.githubusercontent.com/archanacontent/content-marketing-automation-workflows/main/n8n/09-click-tracking-interest-scoring.json
  3. Fill in the Config node and connect the accounts listed above
  4. Activate the workflow

Google Apps Script

  1. Set up the control sheet with the steps on the main page
  2. Runs on its own: On every click