02Geek HTML5 and JavaScript, TypeScript, React, Flash, ActionScript online School
Previous VideoNext Video

Importing users from Google Forms to MailChimp

It might sound simple but when working with two data sources many times issues will arrise. As such in this video we cover both the steps involved with uploading users ontop MailChimp but also the steps involved with reformatting your data using Google Forms and Documents

Video Transcript

00:00Although there's many other ways to import lists, the basic idea is very similar.
00:04So we're only going to show you one more, and that is working with Google Docs.
00:08Many of you, I'm sure, or if you haven't, then I strongly encourage you to send them
00:15once in a while forms to your users, ask them questions, see if they interact with you,
00:20and make sure that you write in those forms by submitting the form that they're willing
00:25for you to continue sending communication to them and that you'll never send their
00:28information to anyone else. All right, so with that said, how do you import those lists?
00:33If you've done that using Google Docs, which is a very popular way of doing it because it's free,
00:38you'll see that in your import option, you do have that option of importing directly from Google Docs.
00:44When you click into the import from Google Docs, first of all, it's going to ask you to
00:48authorize your Google Docs account. So before we could import, they want to connect our
00:54Google account. To do that, we will click on to authorize connection, and when we click on
01:01to authorize connection, it's going to ask us to gain access to our contacts, to our documents,
01:06to our Gmail, to our Docs. Now, if you don't want to do that, you might want to click on
01:11that back button, deny that and just manually upload it using the actual upload tool that
01:19you had uploading files that is absolutely up to you. But if you do, if you are willing,
01:25basically Google, it says that it's not affiliated, they could do with it, whatever they want,
01:28but truthfully, as long as you're managing your, your Mailchimp correctly, Mailchimp is not going
01:33to automatically just add things without your permission. But with that said, they gain access
01:37to a lot of insight in your accounts, such as your analytics, your contacts, your documents,
01:43and so on and so forth. But that might be a good idea because then you'll gain more
01:47knowledge inside of your Mailchimp, it will enable Mailchimp to be able to connect the
01:51dots between what users are actually doing. Oopsie, about that.
01:58All right, so that's a choice that you want to make. So by the way, when you're approving it,
02:01you're not only approving that docs, you're actually approving all the different tools
02:04that Google has. And you don't really have that flexibility of choice. In our case,
02:09we're going to approve it, because we want to showcase it to you. But with that said,
02:12in the future, we may be starting to get analytics directly from Google and so on and
02:16so forth without asking for permission again. And this is going to be the only time where
02:21we actually approach Google for permission to authorize the tool to gain access to that
02:25insight. So we're going to click on that grant access. Once we grant that access,
02:31we'll be back into our zero to deal site. And in this case, we're going to be ready to
02:37start importing. So now success, we've connected Mailchimp to Google Analytics and so on and so
02:42forth. Can I disable it? You sure can. If you open it up in a new tab, and in your account
02:51settings, just go directly to security. And in security, just scroll down and go to connected
02:57applications and sites notice how hard it is to find. But security, connected applications and
03:03site click on review permissions. And in your review permissions, you could then revoke access
03:08to different applications. So for example, in this case, what we want to revoke access to,
03:13if we wanted to, is to revoke access to Mailchimp. So let's look for Mailchimp. So here we go,
03:20Mailchimp admin, and we could revoke access as soon as we're done. So we could leave this open
03:24right now. And once we're done, just immediately revoke access, because there's no need for them
03:28to continue going into our accounts currently, because there's nothing that we have configured
03:32that makes them need to have access to all this information. All right, so it's telling us that
03:39now that we've imported, now that we are connected with Google Docs, all that's left for us now is
03:44to go back into this Google Docs option, click on it. And once now that we click on it, we
03:50could then basically go through the list and then select the document that we want to import.
03:55In our case, we want to import the zero to geek feedback response.
03:58So I'm going to go to zero to geek feedback responses. And we could select which sheet we
04:05want. Do we want the first sheet or the second sheet? In this case, we're happy with the first
04:09sheet. So that's fine with us. My cell data has new lines in it. What is this? Let's see what
04:15that is. Oops, basically, if we have enters in our document, which we don't. So this is going
04:21to make sure we don't have to worry about that, because in our case, we don't. And all that's
04:25left next is to make sure that we merge the two together again. We click on the import list.
04:31And then again, it's going to take us into a similar window that we saw earlier,
04:35only this time around, we don't have that same level of control as we did when we didn't import
04:41it directly with Google Docs. So in our case, I'm going to actually cancel that and I'm not
04:45going to upload the document using Google Docs. And personally, I'm going to click on that revoke
04:49access and I'm going to manually upload the information because I don't feel like there's
04:54actually a need to connect that linkage between the two. All right, so I've revoked
05:00that flexibility, because in this case, what I really want to do is I want to copy these files
05:05into a local file, update the information, I'm just going to paste it right in. And
05:09that's what I'm going to do. And in the next video, we'll continue once I've done that.

Ready to Level Up Your Skills?

Join thousands of learners on 02GEEK and start your journey to becoming a coding expert today!

Enroll Now for Free!