Automate Shopify Product Creation: Grabbing Data from Google Sheets with Zapier & ChatGPT
Let's build with Zapier and AI (100+ videos)📅 2023-08-21
Transcript
[00:00] going back to webcam AI where we do daily artificial intelligence videos for your personal and business life in today's video we're going to take a user's suggestion here as you see we want to take the ability for uploading a spreadsheet and then grabbing all the data from the spreadsheet and automatically pushing it towards shopify's front end for product listings now more specifically in this context as you see we want to fill in all relevant variables when it comes to uploading this spreadsheet so when we do the automation process it has everything that is needed in order to create a
[00:30] Shopify listing now in this video I'm going to go ahead and start from start to finish so I'm going to show me building out the spreadsheet for the automation so if you don't want to see that you can go ahead and skip to the zapier automation part but I thought it'd be pretty powerful to see how we build out a spreadsheet in chair gbt for the purposes of this video so let's go ahead and start off jump into 10gbt and let's build out our spreadsheet we're going to use for this automation before we dive in any further for that jdbt plugin here we're going to go ahead and grab the relevant variables we're going
[01:01] to need for this spreadsheet so we know we're going to need a title product type a vendor we'll go ahead and create a product description here we're going to need um a price a image URL if possible and then we need a published and that should be it that should be sufficient so we're gonna need these columns when creating a spreadsheet so it's going to do that in Chad gbt I'm only going to do three rows here as we're going to be pushing towards our Marketplace and I wouldn't want to create like 20 of these different products here let's go ahead
[01:31] and go and proceed all right so as you see we went ahead and grabbed all the relevant variables that we're going to care about when pushing this towards automatically it's title product site vendor product description price image URL and is published from here we're gonna go ahead and say we are going to want to fill in the data for each of these columns let's go ahead and create you know what let's open up to 10 products 10 rows
[02:02] we may need to structure this a little bit different let's go ahead and see what this first output will be all right so I went ahead and gave me sample Data before it pushes us out to the CSV so I'm going to go ahead and change a couple things here first thing I want to do is make sure all the product types are uh actually we can leave it the same let me see this can make the vendor the same we'll see the vendor for all products will be test store and then we're going to save for the product description please input and
[02:34] example description for each product Max one sentence and then for the image URL for the image URL just give a description of how the product looks and the reason I'm doing that is because we're going to push that towards an open AI image generator and we're going to use that for the underlying image for the product
[03:05] obviously in this context if you were to do this in reality for that image URL you'd want to input probably a Google drive file URL so whatever context that may be we're going to say just give description of how the product looks and then for the title Give an example real title let's go to see what this looks like so as you see here uh we got what we wanted here so we got all the different titles product types uh we wanted the
[03:36] vendor to say consistency so we got test store we got a product description here that's pretty short um prices are all different an image your row just a description visual Outlook and then we got is published yes or no I like this because this is going to show you the capabilities of an automation flow where essentially you can indicate whether you want it to be pushed forward or not the data underlying it forward so we're going to go ahead and just say generate CSV here it's going to generate CSV we're then going to grab this CSV and we're going to push it towards a Google drive folder
[04:07] for Google Sheets purpose of this is so we can access the API calls within Google Sheets when we build out this flow all right so watch this I click it it doesn't work so it seems like this plugin doesn't work here so what I'm going to do though is I'm going to go ahead and reformat the data here found in this table I'm going to grab it and let's try to use a different plugin here okay so I finally found a plug-in that went ahead and worked for this I try to use a plus doc did not work try to use the other one it did not work a lot of these plugins seem to be having a lot of Errors I finally found when that works literally just called CSV Creator I went
[04:39] ahead and just said create CSV from this data provided the data click download let's go to check it out and as you see here we got the data Associated of what we're going to be using today so we got the title product type and so on let's go ahead and upload this to Google Sheets now instead of uploading it we might as well just copy and paste I'm going to Simply go right here command C come over here command V there we go so we got the relevant data that we are worrying about today I'm
[05:10] going to rename this to Auto product upload perfect I'm going to go ahead and just reformat this a little bit all right perfect so we got the data that we created from strategy BT obviously you would probably use live data here if you wanted to grab real images rather than the open AI images you're about to see You'd put in Google Drive links here that are accessible and from here we can go ahead and start building up the automation for the Shopify from CSV or Google Sheets to automatic upload let's go ahead and
[05:40] create a new zap here we're going to call it auto uploader products from here we're going to use a manual trigger due to the fact that we wouldn't want this skinny sense off at any time we want to you know we got a new Google Sheets we want to go ahead and manually upload or manually set off the automation task so we're gonna use a manual trigger a Basecamp which is going to be new to do you're going to continue choose your account you choose a project plus we have a
[06:12] project that's called Auto Tasker that's used for this purpose for any manual trigger we use Basecamp as our major trigger for any type of automation we're trying to run where the discretion of when it runs is ours The Next Step we're going to do here is going to be Google Sheets we're going to do Google Sheets here and we'll be doing look up spreadsheet rows output as line items let me go ahead and choose our courses account here at webcast AI we're going to hit continue here and then let's go ahead and proceed let's go ahead and
[06:42] enter all the relevant variables that we care about here so for our spreadsheet we're gonna do auto product upload for our worksheet it's going to be sheet1 for our lookup column this is going to be the column of whether we want to publish or not let's say is published and then for our lookup value our lookup value is going to be yes or no so for us it's going to be yes essentially what this does is that this is going to look up this column here and it's going to basically ask okay if it says yes we're going to grab that data if it says no we
[07:13] are not going to grab that data so this is going to be useful in certain context where some of these rows may not be fleshed out to the point of where it's ready to be automatically uploaded for now we're just going to go ahead and Target the ones that we deemed already to be published so from here we're going to go ahead and add our next variable to be the row count the number rows return here in that spreadsheet we had 11 so I'm going to put 11 here and we go ahead and continue and let's go ahead and test this action all right so as you see here we got a return of five different rows come back here we have one two three four five so that is correct we have the
[07:45] right amount of data that's been provided here so our next step here is we're going to create a loop so we're gonna do a loop because of the fact that since we're dealing with multiple rows and each row is going to have to create a product in Shopify we're going to need to create a loop in order to go through all the rows and all the data associated with it so I'm going to do create loop from line items let me continue here and then we do all the relevant variable data that we found in that Excel sheet so this is going to be all the information that is going to be want to be pushed for every single uh variable
[08:17] found in that Shopify so we're going to do Title Here and do add one I'm going to go ahead and do product type let me go ahead and make sure we grab the data here so for title we're going to go to look up spreadsheet row here and then as you see here these are the titles just roll column A then we're going to do product type and then we're going to go ahead and just find our product type here which is row column B let's go ahead and add another variable here
[08:50] we do product description the reason we're going to skip Bender is as you see here all these are the exact same so when we do our creation of the Shopify product we can just do test store we don't need to make a variable now in the context that maybe the vendor is different this is where you would essentially add this to this zapier step here but we don't need to in this context we're going to do product description grab that row I'm not sure why it keeps glitching like that it's kind of annoying we're going to do call D all right and then we're going to go ahead and do price
[09:20] here can be column e and then we do one more which is going to be the image URL put that there so in this context we are doing uh open AI images in your context this would be actual URLs probably so from here we have all the relevant information that we want to push and make sure that it goes through every single time when uploading a product so this sets the amount of Loops that it
[09:51] can do so in this context would be you know 500 rows from here we'll do continue I'm going to test a section and there you go so I went ahead and grabbed Loop iteration one and then all the relevant information within that Loop that it found for each one of those columns and then it kind of proceeds from there so from here we're going to go ahead and start building out the flow that's going to automatically upload products onto our Shopify so the first thing I want to do here is I'm going to go ahead and set up the valet prompt here which is going to do generate image now obviously we could format this a lot better but through this tutorial you've
[10:22] basically figured out how to automatically create a ton of Dolly images if you choose to do so for the underlying data you provide so what we're going to do in this context is always make sure you'll create loop from item when I'm doing it from here and then essentially what we're going to be grabbing here essentially we're going to be grabbing here is we're going to be looking for image URL we're not going to want it where essentially the preview Loop value images gives all the data associated with your rows you're going to want to grab it specifically from just the
[10:53] singular URL here just want to go ahead and proceed here I mean this is not even optimized for a daily prompt so I doubt this is gonna look great but for now we're going to test this action okay not bad I mean these are gadgets and this is you know what it came up with not bad so we can go ahead and proceed with this all right so the next block here we're going to do is just going to be for the product description now one thing I want to point out is if you notice the data we're grabbing here there are certain variables that we may want to add more information for using AI so for example
[11:24] that's why we kind of did the image URL here for price we can keep consistent uh product type we can keep consistent title we can keep consistent but maybe for the product description we want a little bit more information based off contextual value um and then maybe for um you know other stuff maybe for the title you wanted to add some type of parameter that made it more optimized for XYZ like more SEO optimized title right for now we're just going to do product description and add a little bit of AI to it
[11:54] we're going to choose our chat DBT account here and continue here and then let's go ahead and enter some variables here I'm going to my model 2gbt4 this can still be done with 3.5 it's just going to be a little bit harder for the prompt structuring and then for the memory key let me go ahead and say prod o this is a random string of 32 characters from here let's go ahead and provide as much information as possible so we're going to say paste on this product information
[12:27] we need an optimize product description I'm going to say product title the price that's kind of all we have actually we can do the obviously the product description that we have currently so we can do that new semicolon and then let's go ahead and enter the data for all these relevant information when using jgbt blocks it's always a good idea to do parentheses in order to maintain consistent data here let's go ahead and find what we're looking for
[12:58] so we got a title here let's go ahead and put the price actually we're just going to do type price is not too relevant when it comes to description so when you product type here now right there let's go ahead and put it right there and the product description is that one sentence that we currently have so we're going to basically base off our new output here on the input that we got from that Excel sheet our Google sheets I'm going to say generate a product description
[13:29] use bullet points and HTML this could probably be a lot more advanced but for the purposes of this tutorial you've got a really good understanding now of how to run multiple open AI prompts multiple chat gbt prompts when uploading a product you know we can link a database to this we can link a lot of other information to this to really Proctor it to the exact way you'd want a product description to look like on your Shopify store or any type of e-commerce store at that point but for now you have an understanding of essentially how fundamental the loop block is in this context so let's go and see what the
[14:00] output will look like here here we go all right perfect so we got our description and we got our bullet points here and here we this is going to be an issue though it says please inquiring price so we don't want any of that so let's go ahead and just do a little bit more formatting here your parameter generate just a paragraph and four or say four bullet points
[14:31] no text before or after I'm going to continue here let's go ahead and retest this action add a one to the number key let's refresh it start on a clean slate send it I can hit retest action perfect this is what we want here so we just wanted one paragraph and then we want four bullet points obviously you do have all the contacts you would want in your area when you're uploading this your Excel sheet right from here though we can go ahead and do a Shopify method here so we do Shopify and we're gonna go ahead and do an event of create a
[15:01] product and then continue here choose your Shopify store then we're gonna go ahead and enter all the relevant information so first off for the title here we're going to do Looper I'm gonna just type in title so we can find the exact one so this is going to be the title here for the product type let's go type and type and as you see here it's product type here um for the vendor since it was consistent with all the Excel sheet we're gonna go ahead and just put in the vendor here's test store like we had before and that ran down accident for product description we're gonna go ahead and
[15:32] grab this one so I'm going to do this right here and oh actually I have the right one oh I guess they call it reply now so that's different uh for tags you could add tags to the Excel sheet if you wanted to or not uh published at price that is what we care about here so we're going to add price there we go 10. and then image URL is going to be this open AI image URL and then for here
[16:02] published so this is going to be either true or false so in this context because we already vetted it with that one column as you see here we can automatically say okay well this is going to be published anyways because we've added the Excel sheet anyways so this should be good here I'm going to continue and I'm actually going to skip this action because we're gonna do this live so we're gonna go ahead and go to Basecamp we're gonna publish this we're going to automatically generate five different product listings using this method all right so we jumped over to base camp here is our manual trigger let's make
[16:33] sure we are green lighted we are green lighted let's go ahead and proceed so essentially what's going to happen right now is when this flow occurs it's going to search this Google Sheets here it's going to identify whether to grab the data or not if it says yes it's going to grab the data from there once it grabs the data it's going to generate an image according to every single one of the relevant data points in image URL then it's going to proceed to create a product description based off the relevant data found for each one of those lines and then it's going to push it forward as a Shopify product we are
[17:04] green lighted let's go ahead and say proceed so in this context this could be any words you could have a filter here in theory but for now proceed and let's see it live see if it's working here let's go over to history all right it's proceeding as you see here it is playing perfect so as you see here we have all of the runs are successful and as you'll notice um whatever your run is every single run obviously will be associated with task so keep that in mind jump over to our
[17:34] web Cafe Marketplace here I'm gonna go ahead and reload this real quick and let's see there we go so we got the uh individual products made I'm gonna go ahead and filter this real quick I went ahead and filtered by vendor which would be test store and there we go we got our five different products here so if I go ahead and click into one we have our HTML based product description we have the title here and we have an image that was created based off the image URL we have the associated price uh one thing that we didn't mess with variable wise
[18:05] was a stock so we could have added um sorry SKU we could have added SKU we could have added a lot of other information but as you see it works I'm going to go ahead and delete all those do the fact that we do not sell gadgets on webcafe a Marketplace we do sell pre-built automation Solutions so if you're interested in learning more about that go ahead and check that out in the description down below but I'm going to delete those for now as always you'll be able to find the automation we just created here in the description down below now what I'll point out is that a manual trigger can be in multiple things we just use our CRM here as our manual
[18:37] trigger manual triggers essentially play around with it this could really be anything uh for example a new manual trigger could be in a Google sheet when this row has a new piece of data added into it it shoots off the entire flow so don't think it just has to be Basecamp we just use that here personally at web Cafe AI but as you saw at the beginning of this tutorial we are listening and we are watching our comments and this was a suggestion from one of our subscribers here at webcaf AI I thought it was super cool I thought the idea of essentially creating a loop on an Excel sheet for
[19:08] data in this specific context would be kind of like a very useful skill to learn and just kind of a cool idea overall so knowing this let me know down in the comments down below if there's a specific flow that you would want created or you thought would be a cool idea when it comes to lowering uh manual labor in that context if you feel like you learned something make sure to like the video it's completely free and it helps us hear web Cafe AI if you want to learn more about Ai and Automation and how to leverage that for your personal or business live check out the playlist at the end of this video so we're diving into all 5000 apps on zap your store but honestly let's go and switch it up here
[19:38] we're actually going to link our Ai and e-commerce playlist on this specific video do the fact that it does have to do Shopify and this is a very Niche thing for e-commerce so in reality actually we're going to go ahead and Link our e-commerce playlist at the end of this video but if you are interested in learning about other applications of a automation we do have another playlist on this channel called zappy for AI you can go and check that out as well make sure to subscribe for daily artificial content but without further ado see you in the next video thanks for tuning in and yes surprise
[20:10] I'm an AI Avatar make sure to explore more here at web Cafe where we demystify AI for your personal and business life until next time foreign