Skip to main content
Siddique2020
Contributor I
Contributor I
July 26, 2023
Solved

Klaviyo popup and Google sheet integration

  • July 26, 2023
  • 1 reply
  • 327 views

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 

    This topic has been closed for replies.
    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

     

    1 reply

    Omar
    Partner - Platinum
    OmarAnswer
    2025 Champion
    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

     

    Helping E-commerce brands maximize Lifetime Value & Profits with Klaviyo, CRO & CVO - Get your free Audit - https://link.polarisgrowth.com/free-audit