you might have heard of Google Sheets it's a free online spreadsheet program that's very similar to Excel and is very easy to use but did you know that you can make between $700 and $1,000 per day using Google Sheets right now I'm going to show you a stepbystep strategy that you can use to do this even if you have zero experience with Google Sheets or anything like this here's a video of my teenage daughter me driving her home after she made her first money using this strategy and here's the payment that she got from doing this so let's dive right into it now before we get into chat GPT and Google Sheets I have to take you first to a tool called D7 lead finder and some of you guys may have seen this tool before but stick with me this is going to be different than what I've shown you before and basically what D7 lead finder does is it scans the internet for all kinds of local businesses and brings some really interesting data about them let me show you here I'm just going to do a search here for towing service in Baltimore Maryland and I'm going to click get leads right here and you can see it's brought up a huge list of all the different towing services in Baltimore Maryland and here's the cool thing if you see these little columns right here you can actually sort by different pieces of information about those businesses and so for example this column shows if those businesses have a Facebook page or not this column shows if they have an Instagram or not this column shows if they have a Twitter or not and there's a whole bunch of different information about them but what I want to focus on is the social media and if you click here if we sort in these columns here I'm going to sort by Facebook page and I'm going to sort by Instagram I'm going to sort by Twitter page and now we have a huge list of businesses look at all these businesses that are towing services in Baltimore Maryland that don't have a Facebook page don't have an Instagram don't have a Twitter in other words they don't have any social media setup at all you can actually contact these businesses and offer to do their social media setup for them now but what I want to tell you to do is I want you to offer to set up their social media for free now why would you do that this is crucial to making money off of this specific technique because it's going to be very simple for you to set up their social media to set up a Facebook page is very simple an Instagram a Twitter very very simple to set up but obviously these business business owners don't know how to do it so if you offer to set it up for free you're really going to get their attention where you're going to make the money is you're going to tell them I'll set up your social media for free as long as you pay me a fee to keep the social media updated in other words to post regularly on these various social media platforms to get them new customers now I'm going to show you later in the video specifically how to get these businesses to get give you money for this so you don't have to worry about that part but first let me show you how to set up the system so that all the social media posting will be done automatically by Google Sheets and chat GPT now you can see a business right here who's doing this exact service they're charging between $147 per month up to almost $500 per month to do these social media posts for businesses that gives you an idea of the kind of money that you can make doing this first you're going to need go to Google Sheets I'm just going to click right there and we're going to click sign in and then what we're going to do right here is we're going to click this plus right here and create a blank spreadsheet you're not going to have to know anything about Google Sheets to do this all you need to know you need to type the word news Link in that first box there in the sheet and that's going to be really important later you'll see why and then then depending on the industry that you're in I want you to do some searches in Google for news articles about that specific industry so let's say you were doing this for an electrician you would type in electrician news into Google news or let's say you were going to do this for a plumber you would type in Plumber news and get a bunch of news articles about plumbing and you're going to make a big list of it now just for the sake of this video I'm only going to put one article in there just just so you just so you guys can get an idea of how this works I'm just going to paste this article right in there and after you put a bunch of news articles in your Google sheet then you're going to go over here to make. com and you're going to set up an account by pressing this pink button right here get started free once you've created your make. com account you can just go up to the top here and click create new scenario now the first thing that we're going to set up is a trigger and this trigger is what's going to start the whole automated process of posting on the social media pages so in our scenario the first tool that's going to trigger our automation is a Google sheet so that's the Google sheet that I just showed you how to make and on the first row I type in news link then I'm going to go here and I'm going to press the plus button here and then I'm going to search for Google sheet sheets and after selecting Google sheets I'm going to select watch new rows now this function will trigger the automation to retrieve values each time I put a new row into my spreadsheet so each time there's a new article in the spreadsheet it's going to trigger this whole automation to automatically start for first time users you're going to be asked to create a connection so you just click that and you sign in in via Google then you choose the file name of your pre-made Google Sheets under spreadsheet ID and then your sheet name and since I wanted to write only one article at a time I'm going to change the limit to one cuz I only want to do one social media post at a time not a whole bunch of them then you just press okay and at the bottom left of the page we can change the scheduling setting um by default it's going to run every 15 minutes um but I'm going to change this interval to every day because basically what we want is we want this automation to run once per day and do a post once per day on the business's social media we don't want it to run and do a post every 15 minutes that's kind of like overkill for somebody like a plumber or an electrician um so now that we've set up the trigger the next thing we have to do is to have ai go and read the article that's in the sheet so this is where we use a tool called perplexity and perplexity is basically like a competitor to a chat GPT open AI or claw but what it does better than those other two language models is it can actually access the web and return information about different articles in real time and it's also a little better at writing human sounding Snippets cuz we want this automation to write little AI Snippets to go on Twitter to go in Facebook and so on and we really want it to sound like a real person and complexity is really good with that so we're just going to click the plus button here and search for perplexity then we're going to select create a chat completion and it's going to ask to create a connection and then you just click okay and so for the next step we're going to be needing what's called a complexity API and don't worry it sounds highte but it's basically just a way for make.
com to talk to perplexity in computer language so we're going to go over to perplexity doai and we're going to create an account just click on the gear icon here and go to the API Tab and then just scroll down and click generate then we're going to copy that API key that we just made and we're going to go back over to make. com just going to paste it right there into make. com okay so the next step is under message we're going to click add item and in the content field we're going to type summarize this article because basically what we want perplexity to do is we wanted to go and read the article and then we wanted to make a little summary like a little couple sentence summary of the article and that's what's going to be posted on your business client's social media so we're going to click newslink or column A and that's remember that's the column where I said type in newslink at the top make.
com is going to go and look for that column in the spreadsheet and it's going to look for the specific column called newslink that's why we had to name it that so that's the column where our news articles are all going to be located under roll here you're going to click user and then you're going to click okay all right so the next step is adding a router so I want you to click the plus sign and then add a module search and select router then click here for the third router to appear and now we're going to click a plus sign on the first router at the top here and select claw and then we're going to select create a prompt so now we have to add another API key cuz we're using a couple different AIS here and and so we're going to go over to the anthropic Claud website here and under settings then API keys and then you're going to click create key then you're going to copy the API key there and you're going to paste it under connection as shown earlier okay I'm going to set the max token to 350 right here and then under messages I'm going to click add message and then select user under roll then I'm going to click add content and select text and then in the text box I'm going to paste a pre-written prompt and you can just pause and copy my exact prompt because it works really good um basically this prompt is going to tell the perplexity AI to summarize um what it's read so it's going to go read the article and you're going to tell it to summarize it into a Facebook post so you can just copy exactly the same prompt that I have here um then under choices you're going to click message and you're going to select content and then you're going to click okay all right and I'm just going to rightclick to rename this module as Facebook so we can easily distinguish which module handles Which social media here all right so the next part we're going to set up is Instagram and we're pretty much going to follow the same steps um but in this case we're going to use open AI to write the Instagram post instead of Claude and open AI is the same thing as chat GPT so you're going to search and choose open Ai and then you're going to select create a completion and if this is your first time connecting to open AI you need to click add at the top and you need to put your API key here and if you don't have an API key which I'm assuming probably you don't you can just go to the open AI website then click on the API key Tab and then create a new secret key and then you're going to copy and paste it to the API key field in make. com okay going back here we're going to select which model we would like to use and I'm going to choose chat gp40 here which is the latest model at the time of recording this video and under messages I'm going to click add message and the rooll is user and then I'm just going to use another pre-written prompt here again you can pause this video and use my exact prompt because it works really good and we're going to click on choices and messages and we're going to select content and right here I'm just going to set the max tokens to 350 and click okay and I'm just going to rename this module as Instagram just so we kind of know what we're what the different modules are if you ever have to come back we'll know what these different things are now that we have our Instagram and our Facebook modules set up we're going to create one for X also and it's the same process as the first one that we created using Claude the only thing that's different about this process is the prompt prompt is going to be a little bit different this time for Claude so again right here we're going to choose Claude and we're going to click create a completion and we're going to set the tokens to 350 and I'm going to enter a pre-written prompt here again you can paste and use my exact prompt you can just uh pause the video and paste the exact prompt in for yourself um this is specifically for x or Twitter and then again you're going to click choices under message and you're going to click content uh to populate the summary of the article and then you click okay and we're going to rename the module to X or Twitter just so later on we know what this is if we have to come in and adjust it there's a lot of different things connecting here right um all right so then in the next step we're going to actually generate an image for our Instagram post um because in Instagram you can't just post text like in the other ones you can just po post text but we have to actually generate an image for Instagram so we're going to make this automation also o do an Instagram image as well all automatically press the plus sign next to our Instagram module here and we are going to use open AI to make the image select generate an image as a function and we're going to use doll E3 model here and then we're going to enter a prompt and what your prompt is is generate a photo realistic image of and then we're going to select choices message and then content and then click okay now to save the scenario click the save button here and click run and then we're just going to wait for make.