Hello n8n lads,
I’m trying to understand what should be the easiest way to track all of the activities from my outreach campaign using their API.
This API allows me to set up webhooks for each type of email (sent/opened/bounced/replied) and I would like to pipe the data in a gsheet in order to generate some KPI’s reporting using Google Data studio.
I tried to use this call api to get the past 100 activities from a campaign using a cron node to refresh data one, two or three time a day according the activity volume of a campaign.
It did worked but obviously, I got some duplicate data and it need some reprocessing in order to be relevant.
My guess was to use vlookup gsheet nodes to filter the data with three variables (creation time, account name, activity type) to check if the data was already in the google sheet.
It was a fail due to the fact that the triple check wasn’t simultaneous. It triggered some data from past activities (n.g an opening activity from another prospect or at an other time)
My second try was then to set up 4 webhook for each campaign, one for each type of event which can occur. Less smooth and heavier to set up at a long term but I wanted my MVP working!
However, an error occured with a red sign in my workflow menu, saying that my workflow couldn’t run. But when I tried to see what was causing it in the workflow, I couldn’t get any details on it.
Is there a way to filter out new data that has already passed through the workflow before? (solution #1)
Can a workflow be triggered by more than one webhook? (solution #2)
Would you have a smarter way to deal with this usecase ?
Thanks a lot for reading and for your assistance, this community is really impressive and I love be a part of it.
I hope someday I could be able to give advices or solutions to some newcomers!