Building a dashboard using Google webhooks

Building a dashboard using Google webhooks

Dux-Soup recently introduced the Dux-Dash for Turbo users - an app where you can manage your Dux subscription, access the Dux-Store, track your campaign funnel performance and instantly connect to your CRM system.

If you haven't done so already then click on the Dux-Dash button today and check it out!

 

Fantastic as this is, we know that some of you might still want to build a dashboard in Google Sheets - so you can share it with other team members and monitor your lead funnel from any device! 

In the first part of this series, we published a blog Connecting Google Sheets to Dux-Soup without Zapier. This showed you how Google Sheets natively supports Webhooks, meaning you don’t need Zapier or Integromat to integrate Dux-Soup - and it also covered a basic script to record Dux-Soup visit events. 

After reading this, many of you got in touch with our Support team, asking if there is a way to build a dashboard using Google script code and cover more Dux-Soup events such as Action and Message. 

We accepted this challenge and have written the code for you!

In this blog, we’ll show you how to use JavaScript to integrate Dux-Soup with Google Sheets directly. You won’t need programming skills as our tech team has done the hard part. All that you have to do is to follow these steps and copy the script!  

Note: you’ll need Dux-Soup Turbo for this to work.


Getting Google Sheets ready


The first thing you have to do is to name the columns in your Google Sheets. These names are just for your convenience, so you know what data you’re looking at. These names aren’t used by the script, so changes them won’t affect its operation.:

A- ProfileID

B - First Name

C - Last Name

D- Title

E - Company

F - Email

G - Connection Message

H - Connection Accepted Time

I- Sent Message 

J- Sent Message Time

K- Responded Message

L- Responded Message Time




Second, name the Google Sheet (Sheet1) as Dux-Soup Dashboard:



Note: if the code isn’t working for you, it’s very likely that the Sheet name does not exactly match. Unlike with the column names, the script does rely on the Sheet to have this exact name. 


Dux-Soup + Google Sheets: Step by Step Guide

In Google Sheets, you can deploy your script as a web app that generates a unique URL - that you can then make requests to by pasting it to Dux-Soup Options, Connect tab - to initiate your script. 

In order to connect the visit event from Dux-Soup to Google Sheets, follow these steps:

1. Open a new Google Sheets form.

2. Go to the Tools menu and select Script Editor.

3. Copy this script and paste it into the script code editor and click on the Save button.

4. From the Publish menu, select Deploy as a Web app.

5. Select to execute the app as Me, and allow Anyone, even anonymous to execute the script. 



6. Then, click Deploy

7. You will be asked to review permissions now. Click on Review Permissions and select your account. Then, choose Advanced and Go to the Webhooks, click Allow.

8. The URL that you get will be the webhook URL that you need to copy and paste to the Dux-Soup Options, Connect tab.

9. Afterwards, tick Visit, Action and Message events, click on “Send Sample”:


You should now be able to see a cell in your spreadsheet populate:


Here it is, the Dux-Soup Dashboard without relying on a 3rd party services such as Zapier or Integromat. How cool is that!

Once you visit the profile on LinkedIn, Google Sheets will record profile ID, first name, last name, company and email (columns A-F).  Columns G-H will populate when you send a connection request. I and J - when you send a direct message or the follow-up to your 1st-degree connections. And finally, you can see and track your responded messages (columns K-L).

Note: please keep the Message Bridge enabled at all times so Dux-Soup can process sent and responded messages, and add a system tag.




Join our free webinar on the 4th of August to see this in action 

Join Giles Garnett, Head of Professional Services as he demonstrates live the tools and knowledge to build a dashboard in Google sheets without having to rely on a third-party tool, such as Zapier or Integromat.

He'll demonstrate basic Javascript and build a dashboard using data that you can collect via a Webhook (for instance visit data / messaging data) and export data to third party CRM tools.

Plus Q&A!

Register here.

If you are reading this after August 4th then watch the recording here.


Summary


Sometimes lead tracking can seem overwhelming, especially if you work in a distributed team. 

But it’s also extremely important to keep tabs on where you are with prospects and to know the status of your lead gen funnel. That’s why building a simple dashboard might be the right solution for you!

In this blog, we have shown you how you can build a dashboard in Google Sheets without having to rely on a third-party tool. So why don’t you give it a try!

If something was unclear or you have any questions, let us know at info@dux-soup.com and we’ll be more than glad to help you out!


Arrow to discover more

See all blogs

Latest blogs

Dux-Soup News

Influential Entrepreneur Ashley Monk interviews Will van der Sanden about the best approach to drip campaigns and the secret behind Dux-Soup’s most effective marketing campaigns.

October 14, 2021
linkedin icon
Dux-Soup Product Tips

Automate your workflows and transfer LinkedIn profile data directly into your CRM with the latest Dux-Soup updates in Integromat

October 5, 2021
linkedin icon
Dux-Soup News

Keep up with the latest in lead-gen automation news, with our October Quacks roundup - hot off the press!

October 1, 2021
linkedin icon
Lead Generation Insights

Make sure your outreach is going to the right people. In this blog we look at how Integrating tools, can keep you ahead of the game when it comes to data accuracy!

September 28, 2021
linkedin icon
Growth Hacking

In this blog, we’ll take a deep dive into the Dux Dabble affiliate platform. Read on to learn more about Dabble and how to become a Dux affiliate!

September 24, 2021
linkedin icon
Dux-Soup Product Tips

Dux-Soup can help you to capture email addresses for your 2nd and 3rd-degree connections and bypass the '100 connection limit' weekly LinkedIn restriction. Learn how in this blog!

September 15, 2021
linkedin icon
Dux-Soup Product Tips

In this blog, we’ll show you how you can trigger different LinkedIn events in Zapier and how you can set Dux to run a certain action on LinkedIn from a different app, like CRM.

September 7, 2021
linkedin icon
Dux-Soup News

August saw yet more tips, tricks and features to help your business work for you, plus a brilliant guest webinar for those launching a career in digital sales.

September 3, 2021
linkedin icon
Lead Generation Insights

Learn how a lower cost per sale and faster expansion of your business can be achieved using Dux-Soup Turbo.

September 1, 2021
linkedin icon