Export subscriptions every day automatically or export to google sheets

Hi!
just a theoretical question on how to approach sth. I would like to automatically export all new subscriptions, like on a daily basis.  I see 2 options-
1. export on a daily basis , let’s say at midnight
2. Maybe a better option- on active subscription (there is an event that does that), export data and send to google sheet… 

I just don’t know how to approach that. Especially that automated export bit… any suggestions? I will ask my developer to do that, just need to know on a high level go to approach that and which route would be the easiest and most effective. 

have a nice day!
justyna 

Hello

I would say that go with on active subscription approach would be easier to handle. You can just need to write a plugin for Membership Pro which handle onMembershipActive event to submit data to Google Sheets. See membershipprodoc.joomservices.com/develo...n#onmembershipactive

There are many plugins come with Membership Pro by default which can be found at plugins/osmembership . You can look at one of these plugins to see how we handle that event

Tuan