Skip to main content

Hi

I am trying to make a scenario in Make.com which should retrieve the profile count from a segment and insert it in a google sheet. The scenario should repeat every week. 

I have made the connections, and am able to send data to the sheet, just not the correct data. I simpley cannot find out how to send the segment count (population) as one number to the sheet.

Have anyone made a scenario like this in Make.com?

Hi ​@Kristian L,

Are you using the Get Segment API to accomplish this? If so, you can add a field to get the profile count. The URL would look like this, as an example:

https://a.klaviyo.com/api/segments/SEGMENT_ID?fieldslsegment]=profile_count

Replace SEGMENT_ID with the ID of your segment. Let me know if this works!


Hi ​@Byrne C 

Thanks for the quick reply. Have you made this scenario yourself? If so, can you help me with which modules you use in what order in the scenario? My case is that I need to pull the segment count from an Klaviyo account and insert that count to a google sheet.


@Kristian L, While I haven’t used Make.com, I can send over what the header and the API request should look like. I unfortunately don’t have information on how to use the Make.com interface to accomplish this, but I can definitely provide the API call!

This is the request you’d make:

curl --request GET \
--url 'https://a.klaviyo.com/api/segments/SEGMENT_ID?additional-fieldslsegment]=profile_count' \
--header 'Authorization: Klaviyo-API-Key your-private-api-key' \
--header 'accept: application/vnd.api+json' \
--header 'revision: 2025-07-15'

Replace SEGMENT_ID in the URL with the 6 character ID of the segment, and replace your-private-api-key with the private API key you set up to make this call.