How to return Klaviyo Profile ID to Google Sheets by email

Questions
, , , ,
1

Hi everyone!
I’m trying to build a scenario where I want to automatically insert a Klaviyo profile ID into my Google Sheet, based on the email address that already exists in the sheet.

So basically:

  • My Google Sheet has columns: Email and ID

  • I want Make to search Klaviyo for that email

  • Then return the Klaviyo profile ID

  • And update the same row in Google Sheet with that Klaviyo ID

Has anyone here set up this flow? What’s the correct way to query Klaviyo profiles by email and update Google Sheets with the Klaviyo ID?

Thank you in advance!

Lita

3

Hi @Lita and welcome to the Make Community!

There is a “Get Profiles” call for Klaviyo that’s documented here:

https://developers.klaviyo.com/en/reference/get_profiles

From the docs, you should be able to search by email and get profiles that match that email back.

So if th Klaviyo module has a get profiles action, you should be able to use that.

I don’t have a Klaviyo account so I can’t test to confirm.

If that doesn’t work, you can try using a straight HTTP call using the HTTP module and following the API documentation.

L