Skip to main content

Creating a Connection to Google Sheets (12.2)

Lesson 92 from: Facebook Chatbots: Generate Leads and Sales Effectively

Isaac Rudansky

Creating a Connection to Google Sheets (12.2)

Lesson 92 from: Facebook Chatbots: Generate Leads and Sales Effectively

Isaac Rudansky

buy this class

$00

$00
Sale Ends Soon!

starting under

$13/month*

Unlock this classplus 2000+ more >

Lesson Info

92. Creating a Connection to Google Sheets (12.2)

Lessons

Class Trailer

Chapter 1: Introduction to Facebook Messenger Marketing

1

Welcome to Facebook Messenger Chatbot Masterclass

08:17
2

What is Messenger Marketing

09:07
3

Advantages to Using Facebook Messenger Marketing

14:17
4

How is Chatbot Marketing Different Than Other Marketing Channels

07:08
5

Who Can Use Messenger Bots to Their Advantage

04:43
6

Quiz - Chapter 1

Chapter 2: Example Use Cases for Facebook Messenger Chatbots

7

Ecommerce Chatbot Strategies

09:59
8

Webinar - Event Registrations Using Chatbots

04:13
9

Lead-gen Chatbot Strategies

09:10
10

Using Chatbots to Promote Educational Resources

09:42
11

Using Chatbots to Stay in Touch With Your Customers

07:45
12

Calculating LTV and CAC to Formulate Incentive Plans

11:06
13

Ideas for Incentive Structures to Promote Through Facebook Chatbots

08:31
14

Quiz - Chapter 2

Chapter 3: Psychological Principles of Persuasion in Effective Bot Design

15

Commitment and Consistency in Chatbot Design

14:55
16

Increasing Customer Value With Reciprocity

14:25
17

Using Social Proof to Build Trust and Identity

11:41
18

Likability - Your Secret Weapon to Successful Bot Marketing

11:07
19

Using Scarcity to Drive Your Customers to Convert Faster

08:42
20

Understanding the Fogg Behavior Model and How to Use It to Your Advantage

15:53
21

Quiz - Chapter 3

Chapter 4: Building Killer Chatbots With Mobile Monkey

22

What is Mobile Monkey

04:12
23

Creating a Mobile Monkey Account and Connecting Your Facebook Page

05:41
24

Viewing Active Bots and Adding Users

02:42
25

Create Your First Chatbot

03:22
26

Quiz - Chapter 4

Chapter 5: Learning All About the Mobile Monkey Chatbot Builder

27

Widgets, Page Flow and Organization

08:20
28

Understanding Q&A and What They're Used For

02:07
29

Adding Q&A Items

05:45
30

Understanding Unanswered Questions

03:56
31

Configuring and Editing Bot Builder Settings

03:31
32

All About the Text Widget

06:45
33

All About the Image Widget

00:55
34

All About the Form Widget

09:47
35

All About the Quick Question Widget

07:21
36

All About the GIF Widget

02:40
37

All About the Attachment Widget

02:07
38

All About the Attribute Widget

01:30
39

All About the Connection Widget

03:10
40

All About the Email Widget

03:06
41

All About the Gallery Widget

06:02
42

All About the List Widget

02:32
43

All About the Navigate Widget

03:03
44

All About the Typing Widget

03:03
45

All About the Video Widget

02:37
46

Quiz - Chapter 5

Chapter 6: How to Wield the Mobile Monkey Chat Blaster Like a Jedi Master

47

What's a Chat Blast Anyway

03:14
48

A Few Useful Chat Blaster Use Cases

05:32
49

Chat Blasting Vs. Drip Campaigns

05:46
50

Planning Four Chat Blast Ideas - Part 1

10:11
51

Planning Four Chat Blast Ideas - Part 2

12:08
52

Organizing Our Chat Blast Pages in the Mobile Monkey Page Builder

04:48
53

Building Our Coupon Chat Blast

10:47
54

Testing Our Chat Blast Before Blasting

04:43
55

Launching Our First Chat Blast- Naming, Audience, Page and Purpose

08:30
56

Building a Chat Blast to Drive Phone Calls

13:55
57

Building Our New Product Line Chat Blast

15:44
58

Building Our Competitive Advantage - Awareness Chat Blast

18:42
59

Analyzing Chat Blast Results

01:47

Chapter 7: Understanding Lead Magnets and Using Them to Build Your Contact List

60

Why Are Lead Magnets Important

05:05
61

Installing Your Chat Widget on a WordPress Site

06:05
62

Installing Your Chat Widget on a Shopify Site

01:17
63

58: Installing Your Chat Widget Through Google Tag Manager

04:53
64

Link to Messenger and Adding It to Emails and Blogs

09:29
65

Adding the Checkbox Plugin to Your Web Forms

03:10
66

How to Use Facebook Comment Guards

16:33
67

Creating Facebook Messenger Landing Pages

13:09
68

Quiz - Chapter 7

Chapter 8: Facebook Messenger Ad Campaigns Using Your Mobile Monkey Chatbots!

69

What Are Facebook Messenger Ads

05:31
70

Messenger Ads Best Practices and Sample Strategies

12:14
71

Creating a New Messenger Ad Campaign in Facebook

08:35
72

Designing a Messenger Ad

13:26
73

Completing Messenger Campaign Creation in Facebook Ads Manager

06:37
74

Drafting Our Mobile Monkey Messaging Campaign Blueprint

06:30
75

Creating and Naming All Our Pages in Mobile Monkey

03:32
76

Building Our Messenger Landing Page in Mobile Monkey

04:21
77

Finishing All the Other Facebook Messenger Bot Pages

13:54
78

Duplicating Your Ad Groups to Try Different Targeting Settings

07:45
79

Setting Up Mobile Monkey Q&A and Other Loose Ends

06:28
80

Quiz - Chapter 8

Chapter 9: Understanding Audiences in Mobile Monkey and Using Them to Your Advantage

81

What Are Audiences in Mobile Monkey

07:54
82

Creating an All Contacts and Gender Based Audience

04:12
83

Timezone and Last Active Based Audiences in Mobile Monkey

06:33
84

Creating an Audience Based on a Custom Variable

06:26

Chapter 10: Building Our First Mobile Monkey Drip Campaign!

85

What Are Drip Campaigns and Drip Campaign Best Practices

06:53
86

Practical and Useful Drip Campaign Ideas

06:43
87

Building and Reviewing Our Drip Pages in Mobile Monkey (10.3)

07:53
88

Creating and Launching Our First Mobile Monkey Drip Campaign

08:39

Chapter 11: Using the RSS Blaster in Mobile Monkey

89

RSS Feed Step by Step and Best Practices (11.1)

09:56
90

Quiz - Chapter 11

Chapter 12: Becoming a Mobile Monkey Power User With Advanced Integrations and Connections

91

What Are Connections and When Would You Use Them

02:49
92

Creating a Connection to Google Sheets (12.2)

14:18
93

Creating a Connection to Gotowebinar

09:37
94

Send New Leads to Your CRM - Hubspot

07:26
95

Send an SMS to Your Sales Team When a Contact Requests a Callback

09:59
96

Quiz - Chapter 12

Chapter 13: Understanding Your Mobile Monkey Audience Insights

97

Contacts - Searching, Exporting and Deleting

02:32
98

Audiences in Mobile Monkey

02:04
99

Forms - What They Are and How to Use Them

01:42
100

Bot Analytics - How to Find Useful Information Using Mobile Monkey Analytics

02:45

Chapter 14: Staying on Facebook's Good Side: Chatbot Compliance

101

What You Need to Know About Staying Compliant With Facebook (14.1)

04:10
102

Getting Approved for Subscription Messaging (14.2)

08:43

Chapter 15: Conclusion ... Goodbye for Now but Stay in Touch!

103

Thank You, Getting Help, Final Thoughts

04:16

Final Quiz

104

Final Quiz

Lesson Info

Creating a Connection to Google Sheets (12.2)

howdy chatbots, fans and welcome back in this lecture, I'm going to teach you step by step how to create a connection in mobile monkey that sends form submission data to a google sheet. Very, very powerful connection. Very commonly used. Once you have data in google sheets, you can do all sorts of things with it, it might be connected up with other systems, it might be used to log daily performance, it might be used to figure out marketing costs from other channels, whatever it may be. A lot of times you want to get that information into google sheets and I'm gonna show you how to do that with mobile monkey. So let's go jump in into the mobile monkey dashboard and we'll walk through this step by step. So first things first, what data am I sending to google sheets. So I went to my page builder and I created a connections group which is just a test. And I just and I just labeled this page the e book form for google sheets, for the sake of illustration. So for example, let's say we have a...

chat bot flow that is getting people to download an e book and we want to collect information through a form. So we have a very simple text widget um that asked that prompts the user to answer a few questions and then we have a form widget keep in mind you don't have to have a form to send data to google sheets, you could send any attributes, any characteristics from any audience to google sheets. I'm just using the form widget to illustrate this to show you how it might look in the real world. So I have a form widget that asks for email, I have a and then the next question asks for job title and the next question asks for a company name and we're just going to assume that those are the important metrics that we want to get into google sheet along with first name and last name. So I need to first. So the next step is to go ahead and actually create a google sheet that we're going to use with the proper column setup. So I'm gonna go over to google sheets. So I'm going to go over to a blank google sheet that I have set up and I'm gonna title this sheet and I'm gonna call it mobile monkey connections, e book data. Okay. And obviously you would name your sheet. Something different. So I'm gonna set up some columns. I'm gonna have first name, last name, email, job title and company name. Is that the last one we had in the double check the data. I want company name. Okay, so first name, last name, email, job title, company name. And again remember we could have any other custom attributes be sent over that we've been collecting through mobile monkey. As long as it's in the contacts database. As long as an attribute in the contacts database, we could send that to google sheets through a connection. The next thing we're gonna do is create a zap. Your account or you're going to log into your zap your account if you already have one. I'm just gonna continue and Isaac and I'm just gonna log into my zap your account here and I'm gonna go ahead and click make a zap and now I am in my zap zap setup, workflow zap here works through choosing a trigger app and choosing an action app. Most of the time people use app to send data from let's say hubspot to google sheets or whatever. But we're gonna be using a custom web hook which is what we're gonna be using to send data through from mobile monkey into a google sheet. So our trigger app is going to be a custom web hook. So first I'm gonna name this app just so I can remember what this app is for. And I'm gonna call this mobile monkey e book form to google sheets. Let's say I'm gonna click search hundreds of apps. I'm just gonna search for web hook. Okay And I'm gonna click web hooks by zap here. We want to choose a catch hook. Okay because we're sending information to this web hook as opposed to the web hook, sending information to us. So it's gonna be called a catch hook, Save and continue this. Next step. We could skip we don't need to pick off a child key. Just ignore that completely click continue. And now we could pull in some samples and they give us a U. R. L. To copy to clipboard. So copy this U. R. L. To our clipboard. And now let's go back into mobile monkey. Now we're back in mobile monkey and we want to go to our connections dashboard under our marketing automation tools. And click the yellow button in the upper right hand corner to add a new connection and select web hook which is the only option. I'm gonna toggle it, I'm gonna name this, send e book form to google sheets or send data to google sheets. I could add a description if I need to but I don't want to and I have the option to continuously send contact data from an audience or send contact data whenever a widget is reached. These are two distinct options and you should figure out which one is best in which scenario. So in this specific scenario that we're talking about. So if you only wanted to send data to google sheets or to whatever program you're sending that data to For a specific thing like a specific bot flow, then you might want to choose send contact data whenever a specific widget is reached. In our example case and what I do, 99% of the time as I continuously send contact data from an audience. I love basing things off audiences. It just makes more sense to me and it's more easy to organize and to remember what connections are doing what. So I could create an audience of people who fill out this form, right? And just use that, I could choose any of my pre built audiences or any of your pre built audiences. I'm just gonna choose all contacts. And what that will do is whenever somebody is added to the all contacts audience, if the web hook is set up properly, that information will be pushed into google sheets automatically behind the scenes without us having to do anything to make that happen. And then we can let our google sheet act as a central database for all of our contacts being generated through our messenger marketing efforts. We're gonna pace the U R. L. We have in our clipboard into the U. R. L. Field and we're gonna keep the request type as post because we're posting this data to the web hook that is catching the data and then sending into google sheets. Now we need to add the attributes and the values that we need to send into google sheets and this is based on how we had our google sheets set up over here. So I'd like to send first name and the value is going to be the attribute first name, I'm going to add an attribute called last name and the value is going to be last name, I'm going to add an attribute called email and the value is going to be email and this is a list of values that are available through mobile monkey and I can search for it. And I'm going to add an attribute called job title and the value is going to be job title, which is that custom attribute I have in that form and I'm going to add a value called company name and that value is going to be company name, which is another custom attribute which I created in that form. All right, okay. I'm gonna leave safe response at the contact attributes unchecked. And we're going to click test connection and we're gonna click test connection and send a test connection by just putting in some sample stuff here so we can do Isaac Radinsky email is Isaac job title is Ceo company names, Adventure Media Group. And I'm gonna send the test Alright, As long as we have a response success, that means our test worked. But that doesn't mean that this information is going to be in google sheets yet. That's not gonna happen. All we did was test the U. R. L. Of that zap, your web hook that they gave us. Now we need to go back into zap here and configure our google sheets part of the zap. So back in zap here, we're gonna click OK. I did this to move to the next step and zap here is looking for the hook and telling us that it might take a second. So nothing's gonna happen yet we need to go ahead and and set up the action part of this app. So we're gonna click set up this step and we're gonna choose an app, click choose app. And we're gonna look for google sheets, select google sheets. And we're going to create a spreadsheet row, that's the action. We're gonna want save and continue and we have to connect to an account. Isaac school sheets account, select that save and continue. And we're gonna have to find our spreadsheet. So we have the name of our spreadsheet which is mobile monkey connections, e book data And it's right here, 2nd 1 down. And the worksheet. Okay, so the worksheet is what this is called sheet one. So we're gonna select sheet one which is right over here and google sheets, pulls in the names of our columns for attributes. So now that we've established a connection to google sheets, we want to go back into pulling samples of the trigger part of this app. And we're gonna go ahead and test this web hook. What we need to do first is click Ok, I did this and now go back into mobile monkey while they're searching for new information to be sent through this web hooks. We're gonna go to mobile monkey. We can go back to our pages, we're going to test our e book, download and you could test any page that collects the variables that you're sending. But this is the only page on my mobile monkey account that's collecting company name and job title which is an attribute that I want to send. So I'm gonna go and click just bear in mind if you yourself are a contact or if the person who's doing this test is a contact in the mobile in the mobile monkey database. You should first go delete yourself and then test this page just to make sure there are no bugs or glitches. So before I test this page and messenger I want to go back and make sure that I toggled my connection to be active. If it's not active, mobile monkey will not send that data to the web book and zap here will not be able to find the test submission. So we're gonna go back to connections. I'm gonna edit this connection which is in draft bone. I'm gonna toggle it too active and wait until it saves. Great. It saves and now I can go back to my pages. Go back to this google sheets e book form. Now I could test this page and open it up a messenger and to see if this connection is working. Please have your email to get my free book. I'm gonna tap my email asked me what's your job title Ceo hit enter what's your company name? Adventure Media group. It enter and it should say thanks Isaac here's your e book and of course this is not a live chat bot flow so it's not gonna send me the book right now. But the point is we want to see if all this is working. If the web book is working. So let's go back to my zap and see what's happening. So I'm gonna open up happier. Fantastic test was successful so everything is in place right now with regards to the web hook, Mobile monkey is collecting the data properly through the chatbot flow. That contact is being added to my all contacts audience and my connection in Mobile monkey is working to push that data to the U. R. L. Now we need to complete our setup where we're going to send that data through the web hook into google sheets. I'm gonna go back to the edit template part of the action set up. I'm now going to be able to configure these custom fields so I'm going to I'm gonna so I'm gonna click into each one of these custom fields and find the right variable from the test. So first name was Isaac Last name was Radinsky, email was email, job title what's ceo beautiful and company name was Adventure Media Group. Everything is in perfect working order. I'm gonna click continue and I'm getting a warning that there's an unfinished step in the zap. Please finish or delete before completing this step. Step one needs attention edit here let's see what this is. Catch hook that should be working, pick that, skip that, continue pulling samples, okay lets see edit template. That's all good. Test this step. We're gonna send this test now to google sheets. So I just had to run through that one more time to make sure everything was fine and it looked like everything was okay. Um and when I click this blue button, if and when I click this blue button, send text to google sheets. If everything has worked and configured properly, we should get this information from superior into google sheets. So let's see what happens. Send test to google sheets. A test spreadsheet row was sent to google seats just now. Let's take a look and look at that guys. Absolutely amazing. I really love this stuff because it's so complex and so simplified through the use of these software tools. So I'm gonna delete or let's say let's leave this row here. And let's do an actual test not through zap here. So now I'm gonna click finish, we're gonna keep this zap, make sure to toggle the zap on. If you don't tackle that. If you do not toggle the zap on the zap won't work. All we just did was a test. Okay, my zap is on. I can now go back to my dashboard, I could leave zap here and I could try this again. So I'm gonna just delete this conversation and Messenger. I am going to go to contacts in mobile monkey. Delete myself as a contact. So this works well, I'm gonna go back to my page, I'm gonna go to the google sheets, e book form. And I'm going to test this page again in Messenger and I'll put in some different data to make sure that this zap is working. So let's see what happens here. It's gonna be the same email of course because that's the email my job title I'm gonna do I'm gonna write president or let's say vice president because I'm in the mood to write vice president. It was my company name is Microsoft. Okay. Actually no I don't like me and I'm gonna write and for company name I'm gonna write Nikon camera company L. T. D. Enter thanks Isaac here's your e book. Okay now let's go and see how this zap is working in the real world. If I go now for Messenger to google sheets, look at that, I have a second row Isaac Jablonski. Vice President. Nikon camera L. T. D. Instantaneously right. That happened within seconds so that zap is working beautifully and every single time somebody gets added to this all contacts audience. Mobile Monkey's gonna push that data through the web hook into zap zap here will take that information and push it into google sheets. It's a beautiful thing and it all happens behind the scenes. I hope this was a helpful step by step instruction on how to set up connections using zap here. And as you set up more zaps and more connections. This whole process will become much, much easier for you. In the next lecture, I'm gonna show you how to sign up seminar attendees through mobile monkey messenger marketing and send that information through a connection through zap here into go to Webinar. I look forward to seeing you guys very soon in the next lecture chat for now.

Class Materials

Bonus Materials with Purchase

MobileMonkey Support
Facebook Chat Bot Marketing Mastery