Best Thursday ever! Wohoo! Thank you so much for this.

can this feature be used to compile leads from multiple unbounce pages onto the same spreadsheet?

Thanks!

Hi Lenny, 

Yes, you can use the integration on multiple Unbounce pages. 

You just use the same webhook URL on all the pages but make sure you push the page name so you can distinguish the leads on the Google Sheet. 

Best,

Hristian

Hristian,

Thanks so much I assumed it would work for multiple pages but I just wanted to double check.

Much Appreciated,

Lenny

Wow, I am very grateful. I’m a big fan of Unbounce, but I needed to find a simple way to transition some of my landing pages without getting into complicated and heavy integrations with other 3rd party platforms/CRMs. This is the solution I was hoping to find. There must be a reason why Unbounce does not integrate this option like all of the others (I trust they know much more about this stuff than I do), but this is an excellent option. I’m crossing my fingers that this works as well as it seems to. 

Hi Charles, 

Thank you for the kind words and for giving it try.

I’m the creator of the script and can tell you that over 35 marketers and companies are using it on their pages. 

Please do let me know if you run into trouble setting it up.

Best,

Hristian

@Hristian I am unable to access the google sheet in the downloaded guide (It’s not clickable, I tried typing it out too 😓). Could you share the link here? Unless I get it, I am unable to follow the remaining steps on the guide.

Hi @pritha_aash,

The documentation adds an empty space on the second line of the link for some reason.

Just copy/paste the link and make sure there is no empty space in it.

Best,

Hristian

UPDATE

Recently, one of the users of my script alerted me to the fact that the script wasn’t working and Google was giving out an error when you try to run it.

In the last few weeks, there seems to have been an update on part of Google that “broke” the script.

• 
  

  If your script is running fine and receiving data from Unbounce - there is no need for you to do anything. It should continue to work as expected.

  
  


• 
  

  If you need to setup a new integration between Unbounce and a new sheet, please re-download the documentation. Inside of it, you’ll find a link to the updated and working version of the script.

  
  

Best,

Hristian

Is it possible to create a webhook that will work on a sheet that has two edit#gid= but only change data on one of them because what is happening now is unbounce cannot find the url

Hi @Admin_iLogic,

Are you referring to a Google Sheet with more than 1 sheet in the same document?

If so, the current script only works with a single sheet documents. It can be adjusted to work with multiple sheets but that would require re-writing the script.

Alternatively, you can store the webhook/values into one and use part of it to do calculations in another.

Best,

Hristian

Hi,

I have a checkboxes field with 7 choices. When the data gets transferred to google sheet, only the first selected choice is being recorded. Do you happen to know how we can possibly resolve this so that all the checked fields will be copied over as well?

Hi @nbanda,

This is unfortunately a limitation of my script at the moment.

The script can be modified to accomodate your particular use case but you would have to be comfortable writing code.

Alternatively, you can use Zapier to accomplish your task.

Best,

Hristian

Is there a way to “reverse” this script? Have a prepopulated google sheet that will push back into unbounce? That way I can personalize the fields to individual. I would rather not use utms to push data.

Thanks

Lenny

Hi @Lenny_Cagno,

It should be possible in theory. I’ve seen a few projects where Google Sheets is used as a crude database.

Best,

Hristian

Hi Everyone, I just wanted to jump in and ask if this script still works properly. i need to use this as of Jan 1. 2020. Thanks

Yes, the script still works.

Just make sure you follow the instructions exactly.

Best,

Hristian

Hi Hristian,

it seems like there’s a problem with the authorisation of the script. It says that the google log in is not approved for the app. Do you have any idea what to do?

Best,

Stefan

Hi @Stefan_Mitmansgrbuer,

The script worked as of a few days ago so based on your comment, I would assume there might be some internal Google Apps policies for your account that might be preventing the proper running of the script.

As a way to troubleshoot this, try running the script with a personal account. If that works, the issue must surely be with the security policies of your Google Apps account.

Best,

Hristian

Hi Hristian,

thanks for the ultra-quick reply. We tried some different accounts so far - none of them worked.

Best,

Stefan

Hi @Stefan_Mitmansgrbuer,

Just tested the script with a new Google sheet and it works as expected.

Make sure you follow the instructions fully.

Best,

Hristian

HI [Hristian]

I have set up according to instruction but it shows error (Unauthorized).

Hey @Ramprasanth_Alagar,

I would suggest to start from scratch and make sure you follow the instructions exactly as outlined in the implementation guide.

Based on your short comment, it seems you might have missed when authorizing the script.

Best,

Hristian

Hi [Hristian]

I did it once again according to instruction. but not fixed.

Hey @Ramprasanth_Alagar,

I don’t have access to your account so it’s kind of impossible to troubleshoot this based on a single screenshot.

The error you are seeing is probably because you’ve used the wrong URL for the webhook or because the script wasn’t set up properly.

Best,

Hristian