How to automatically sync music streaming metrics from Google Sheets to Memberstack custom fields using Zapier?
Hi guys! Through Google Sheets -> Zapier I can automate the upload of data in the custom fields of Memberstack so that it will be automatically transferred to my web app, right?
And can I manage the automation for different users? Custom dashboard style?
Comments
5 comments
Hey Boggan null, if you want any addition or updates done on google sheets data to reflect on Memberstack via a zapier workflow; yes it is possible. Provided you have the member email / member ID in google sheets for which you want to update a custom field in MS, you can link any database and perform updates in MS via an automation using zapier.
Aj! How are you? Ok!
The question is this:
My web app is a music distribution company and I want to show each user how their metrics are coming along:
I have 5 custom fields (spotify, amazon music, youtube music, etc) and what I want is to update how each shop comes. at the moment I do it manually from memberstack but I would like that once I edit the google sheet, each custom field does it too.
All good Boggan. How are you?
And yes if you need a sync between Google Sheets and Memberstack custom field, it must be possible via zapier in your case. You can set the trigger to listen to updates made in the respective google sheet and assign the value from google sheets to the relevant custom field for the user.
read perfectly the hook between google sheets and memberstack, the only thing that doesn't classify well the google shets seldas, I don't know how to do so that it can identify which is the value to take.
Hmm, ideally the field value should be visible in the trigger that you have setup (in this case it might be new / updated rows in that particular sheet), so once the hook receives any update done on the sheet, it will provide you the entire row with all the fields that particular sheet has.
And with the output of this step, you could map the relevant field from the google sheet and pass it on to the custom field in MS. In case you are facing any issue in that aspect, screenshots of what the zap looks like and the output you are receiving would help in troubleshooting.
Please sign in to leave a comment.