How to sync Memberstack custom fields with Google Sheets using Make.com automation? Answered

Post author
ilyas el megarbi

i have some custom fields in memberstack and yes they are active but in make.com memberstack connection doesn't show these custom fields, such their phone number title and so on, i'm building an automation to send the data to a google sheet

Comments

8 comments

  • Comment author
    A J

    Hey ilyas el megarbi, are all the custom fields filled via the signup form?

    Chances are that you have a signup form with name, email and password and redirect the user to onboarding form where they update the other custom fields. Since the make module is 'Watch new members' it only has information filled during signup.

    Could you try using 'Get a member' module later on in the make flow and see if it has all custom fields of the user where the fields are filled out?

    0
  • Comment author
    ilyas el megarbi

    A J it doesn't show, i've read the article memberstack published and it said to pull the custom fields you need to add fake or real data first in order to show up in make, and it worked now one of the important things that we need to have is when the member Date Created but it doesn't show in make how i can work around this?

    0
  • Comment author
    A J

    ilyas el megarbi, 'Get a member' module shares the member created date information. You can run that module with the member ID and you should see 'createdAt' information. Hope this helps.

    0
  • Comment author
    ilyas el megarbi

    still didn't show, is this the right structure?

    Output when run the 3rd module

    When I right click the 3rd module and select 'Run this module only' and pass on a member ID that I have to see the output
     
    0
  • Comment author
    A J

    ilyas el megarbi, yes provide any valid member ID of a member that you can see in memberstack dashboard and click on 'OK'. You should see an output like I shared in the screenshot above with the createdAt info.

    If you want to update the row that you created in the second module of the workflow, you could pass on 'Row number' field and it should work.
    0
  • Comment author
    ilyas el megarbi

    A J it worked perfect, quick question in the update row it doesn't allow me to specify a row based on the member ID

    like this or should i remove the memberstack member ID
    0
  • Comment author
    A J

    Yes, you can remove the member ID and just keep the row number.

    0
  • Comment author
    ilyas el megarbi

    it worked perfect

    0

Please sign in to leave a comment.