Hi all
We use Flexmail and Zapier. I’d like a Google Sheet that’s automatically updated for each email campaign with: campaign category, campaign name, message name, sent date, sent, delivered, bounces (hard/soft), unique/total opens, unique/total clicks, and not opened.
I see the Flexmail Zapier app mainly has contact triggers. I’ve read that opens/clicks can be captured via webhooks and sent into Zapier. What’s the simplest way to set this up so the sheet keeps one row per campaign and updates over time (instead of creating a new row for every event)?
Questions:
-
Which Zapier trigger should I start with (e.g., Webhooks by Zapier → Catch Hook) and what’s the basic flow to Sheets?
-
Do I need separate events for sent/delivered/opened/clicked, or is there an easier pattern?
-
Any example Zaps or screenshots for this use case?
Thanks for any guidance!
