Skip to main content
Solved

Klaviyo popup and Google sheet integration

  • July 26, 2023
  • 1 reply
  • 217 views

Siddique2020
Contributor I
Forum|alt.badge.img+2

Hi Dear Experts,

I have a problem in my klaviyo account, in that users are writing themselves inside u pop up and I would like to get their data on my email in real time and at the same time they fit inside a sheets in drive. Could you please help me with that?

What should I do to solve this issue?

Kind regards,

Siddique 

Best answer by Omar

Hi @Siddique2020,

Maybe you can elaborate a bit on what you're trying to accomplish as well.

As for getting an notification if or when someone signs up, I would either create a flow that triggers on subscribing to the list and adding a notification action in that flow.

Add notification


Within that notification you can then send yourself a message with email address or any other variable for that specific person that signed up. i.e. email is {{ person.email }}. You can learn more about variables here: https://help.klaviyo.com/hc/en-us/articles/4408802648731


Now for adding emails to a spreadsheet, if you're a developer you could potentially work with the webhooks api action in Klaviyo to send data to the Google sheets API and get this working, but using Zapier for this might be a much easier solution. Take a look at Zapier which has a plug and play solution: https://zapier.com/apps/google-sheets/integrations/klaviyo/475706/create-google-sheets-rows-for-new-klaviyo-events

 

Hope this helps!

 

Omar Lovert // Polaris Growth // Klaviyo Master Platinum Partner

We help with e-commerce growth through CRO, Klaviyo and CVO

 

View original
Did this topic or the replies in the thread help you find an answer to your question?

1 reply

Omar
Partner - Platinum
Forum|alt.badge.img+46
  • 2025 Champion
  • 494 replies
  • Answer
  • July 26, 2023

Hi @Siddique2020,

Maybe you can elaborate a bit on what you're trying to accomplish as well.

As for getting an notification if or when someone signs up, I would either create a flow that triggers on subscribing to the list and adding a notification action in that flow.

Add notification


Within that notification you can then send yourself a message with email address or any other variable for that specific person that signed up. i.e. email is {{ person.email }}. You can learn more about variables here: https://help.klaviyo.com/hc/en-us/articles/4408802648731


Now for adding emails to a spreadsheet, if you're a developer you could potentially work with the webhooks api action in Klaviyo to send data to the Google sheets API and get this working, but using Zapier for this might be a much easier solution. Take a look at Zapier which has a plug and play solution: https://zapier.com/apps/google-sheets/integrations/klaviyo/475706/create-google-sheets-rows-for-new-klaviyo-events

 

Hope this helps!

 

Omar Lovert // Polaris Growth // Klaviyo Master Platinum Partner

We help with e-commerce growth through CRO, Klaviyo and CVO