Skip to main content

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

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

8 comments

  • A J
    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
  • ilyas el megarbi
    ilyas el megarbi OP

    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
  • A J
    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
  • ilyas el megarbi
    ilyas el megarbi OP

    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
  • A J
    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
  • ilyas el megarbi
    ilyas el megarbi OP

    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
  • A J
    A J

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

    0
  • ilyas el megarbi
    ilyas el megarbi OP

    it worked perfect

    0

Please sign in to leave a comment.

Sitemap