Checkout Toolbox

Flex Theme Sections

Linear Shopping Experiences

Connecting Shopify Flow to Google Sheets without Middleware


Hey, Scott Austin here from JadePuma. In this video, I'm going to show you how you can connect Shopify Flow, which is a free app from Shopify, which is really useful to Google Sheets, right? If you look at the documentation on flow, whether it's on the Shopify site or in a lot of the other, you know, best practices and blogs and videos that are talking about using flow, one of things you talk about a lot is, hey, you can connect to the Google Sheets.

So for example, if you had an order come in or a new customer or somebody you know, completed a form, you could take information from that order, customer form in it, add it to an existing Google Sheet that you're using for whatever purposes you're using that for. And if you search on the internet for help on how to do that, unfortunately, one thing is it's bubbled to the top a lot.

Is the third party apps they get in the middle, right. So there's a lot of apps out there that connect things together in case in connection doesn't already exist. But in this case there's already a connection between Shopify Flow and Google Sheets. So you don't need another app. Just those two things alone are all you need. So let's talk about how we're going to connect those two up.

Here I am in a dev store that I just spun up. It's completely empty store. And you know, Shopify flow is already added to this store. And here I am in Shopify Flow. So what I'm going to do is I'm going to create a workflow. And for my trigger, I'm just going to select, customer. And let's just say it when a new customers added.

So customer created is our trigger. And then we're going to add an action to that. And that action is going to be to add the row in Google Sheets. Now in Shopify Flow by default it shows you all your installed apps, you know, connections. And this is a completely empty store. So I have no apps. There's just Shopify and there's flow.

so there's no Google Sheets connector app, right? So if I click the X on this installed apps now, it's going to show all of the possible connectors that exist out there. And if you scroll down you're going to see Google Sheets for Shopify flow. And I gotta warn you that the way this works is kind of kludgy.

It's not elegant at all, which is why I'm walking you through this. Right? So I'm going to click on that. And before you click on it, what you're gonna want to be in your browser session is already logged in to, you know, I use Chrome, so I'm logged into Chrome with the email address that has access to Google Sheets.

Right. So what I'm going to do here is I'm going to click on Google Sheets for Shopify Flow. And I'm going to connect. So when I click on connect let me get this authorization thing. It says you know which. And this is coming from Google right. So now we're talking to Google and I'm going to use my email address.

And I want to continue. And I'm going to allow these permissions. So this is authorizing Shopify Flow to talk to your Google Drive in your Google Sheets. And then I do that. And now it says connected. You can close this page and one of the things is when I close this, there's no real good indicator that it worked right.

Except for on my phone right now I just heard it ding. So I just got a notification from Google that a new app has been authorized and given access to my Google Drive data. So that's that's the confirmation for me that this actually work. Because now when I close this right, you see here, this looks exactly the way it did a second ago.

There's nothing here that says you're connected. No, like little green light or anything. And let's just close that out and let's go back to the action here. We're going to add an action. And remember what if all on my installed apps I don't see my Google Sheets connector here. Right. but if I click on this show them all go down to my Google Sheets connector, which is you know, exactly what we did before.

Bring it up. Now, like I said, there's no indicator that you're connected. It just says connect. But I'm confident right now that I'm already been connected because I went through that process we just walked through. So now I'm going to select the action I want, which is add a row to spreadsheet. So that comes up. And what I'm going to do now is I'm going to add a row to the spreadsheet from when a customer is created.

So let's start off with the row contents and let's add a variable of customer display name. And then we'll do customer email.

And we'll just add one more of shop name.

All right. So that I've added those three things in. Now if we go to our Google Sheets right. You'll see the next field up right was Tablename. So here you can see my tab name is sheet one. And I just created a sheet with those three fields. We just talked about display name email address and store. So we're going to go here and we're going to say sheet one for a tab name.

And now it wants your spreadsheet URL. And what you're going to have to do for your spreadsheet in Google is you have to make sure that every body on the internet that has access to the link has access to edit. Right? So if you just take the URL and you know this URL up here and just plug it in, it's not going to work for you.

What you got to do is go over to your share right here, and you want to give access by default. This usually says restricted or Jade Puma. So I've already said it to anyone with a link. Is an editor, so they can write and read data from it. Because if you give them viewer access, they will be at a row to which you got an editor access, right?

And then once you do that, you want to copy that link. We'll see. Done. Now we'll go back to Shopify Flow, take that URL we just copied and put it in there. So now we've added the information it wants. You can see just saved it. We're going to turn this work flow on.

All right. So that workflow is on. We're going to exit out of it. And now what we're going to do is we're going to open up our customer tab in the Shopify admin. We're going to add a new customer. So we're just going to add a customer whose name is Testi tester. And their email address is

And I'm going to save that. So now we've done the action create new customer. That is the trigger for our flow. So now we go back to our flow. And what we should see happen is you know it'll show up down here. Sometimes you have a refresh.

So you can see it ran it and it's succeeded. So I'm going to click on this element here and it'll show you the things that happened. Customer test tester started your workflow out of the data. Right now if you have a setting issue like you haven't connected properly between Flow and Google Sheets, or you the URL or permissions wrong, you might see this here where the status has failed and we'll give you more information about that.

but here we can see that it worked. So now if we go to our spreadsheet, you can see there's testing tester and all that information we did. So this is how you could connect Shopify Flow to Google Sheets without any third party apps. I hope this helps.

JadePuma is a certified Shopify Expert. If you need any help with your Shopify store, we can help.