[Tips & Scripts] Google Sheets Integration


#1

Note from Unbounce:
This script + tutorial will allow you to send your leads directly from your Unbounce page into a Google sheet via webhook – without the need for an additional service. This nifty script was created by Community rockstar **Hristian Kambourov **to showcase some of the awesome third-party Unbounce features he’s been developing.

DISCLAIMER:
This is not an official Unbounce feature. This functionality is based entirely on third party code, and has only been tested in limited applications. Since this isn’t a supported Unbounce feature, our support team will be unable to assist if things go awry. If you have any questions about this script, please reach out to our Unbounce Expert  Hristian Kambourov


Why would I want to push my leads to a Google Sheet?
Well, you don’t have to since Unbounce offers a perfectly good way to export a list of your leads. 

However, you have to do it manually.

  • Pushing leads to a Google Sheet is almost instantaneous and in real time.
  • You can further use Google Sheets to create automatic reports for you or your clients through the help of a free Zapier plan. (Ex. Email me when I get X amount of leads in a particular sheet)
  • You can share Google Sheets within your company. This way your whole marketing or sales team can have a real-time view of how your Unbounce campaigns are performing

How does it work?
Google Sheets has a handy little feature that allows you to write scripts that interact with your sheets.  Furthermore, the script can also have a public facing URL (web address) that you can use as a webhook. 

When you combine the above two features with the ability to push Unbounce form data through a webhook, you’ve got yourself a free Unbounce to Google Sheets integration. 

No need to host scripts. Just 5min. of your time to set it up.

Plus, you can use it on as many pages/sheets you want and push practically unlimited amount of leads to your Google Sheets. 

Can I see it?
You can see the script working on this Unbounce page. Just click on the “Click me to test this script”, fill out the form and you’ll be redirected to a Google Sheet where you’ll find the form data you just submitted. 

How do I implement this for my pages?

  • On the example page, there is a link to download the detailed instructions and script.
  • Alternatively, you can go directly here and download it. 

How much does it cost?
It’s free. I’ve intentionally set the price on the download page to “0+”. Meaning you can enter 0 and get it for free. However, if you think it’s worth a coffee, couple of beers or a nice lunch, you can enter any amount you want. 

Why is this free?
It’s my way to thank the Unbounce Community members and also a way for you to stay informed about the awesome Unbounce premium scripts my company would be releasing soon.


The Ultimate List of Unbounce Tips, Scripts & Hacks
Search all pages by Lead Email
#2

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


#3

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


#4

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


#5

Hristian,

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

Much Appreciated,

Lenny


#6

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. 


#7

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


#8

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


#9

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


#10

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


#11

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


#12

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