tactiq.io free youtube transcript
Building AI Tools With Google Sheets
https://www.youtube.com/watch/_dPM5FA4i64
tactiq.io free youtube transcript
How I Built an AI Tool in 24 Hours and Sold It (No Coding Skills)
https://www.youtube.com/watch/RpdF-BtMtI4
00:00:00.080 I built an AI tool that could be worth
00:00:03.040 thousands in just 24 hours without
00:00:05.879 coding skills using only Google Sheets
00:00:09.000 and code which cat GPT wrote for me but
00:00:12.320 the best part is it’s a copy and paste
00:00:14.559 process anyone can follow to build their
00:00:16.920 own AI tool that could be worth
00:00:19.240 thousands of dollars in the next 24
00:00:21.439 hours this works even without any
00:00:24.439 technical knowledge or coding skills I
00:00:28.080 still couldn’t write a single line of
00:00:30.519 code but when I showed my AI tool to a
00:00:33.320 leading AI business Expert she said I
00:00:36.600 think this is a great product that can
00:00:39.000 make you a lot of money it’s all because
00:00:41.800 of my unique copy and paste strategy I
00:00:44.800 will reveal in this video the biggest
00:00:46.840 myth that keeps most people from
00:00:48.480 building their own AI tool is they think
00:00:51.320 they need to be a programmer or hire one
00:00:53.760 or I learn how to code first what I’m
00:00:56.399 about to show you is perhaps the fastest
00:00:58.960 and easiest way to build a working AI
00:01:01.760 tool I’ve not seen anyone talk about
00:01:04.879 this because you only need these three
00:01:07.520 things a Google account a cat GPT
00:01:10.560 account and an open AI account these
00:01:14.240 things are easy to get and don’t require
00:01:17.240 any technical knowledge to set up you
00:01:19.640 can even get those for free and I’ve
00:01:21.320 shared all the links you need to do that
00:01:24.000 Below in the description of this video
00:01:26.200 What If you don’t know what AI tool you
00:01:28.720 should build the the best selling AI
00:01:31.200 tools solve problems for people faster
00:01:34.920 and better automating tasks and saving
00:01:38.399 them a lot of time so my idea was to
00:01:41.040 solve a specific problem I faced
00:01:43.600 regularly sending more frequent emails
00:01:46.079 to my list so they don’t forget me and
00:01:48.439 buy my offers but I often don’t know
00:01:50.920 what to write and have no ideas for
00:01:52.719 emails and even if I get one it takes me
00:01:55.680 too long to write a single email then I
00:01:58.399 had some uup moment
00:02:00.479 I already have an infinite source of
00:02:02.640 proven email ideas right under my nose
00:02:05.880 my
00:02:06.880 overcrowded email inbox so why not build
00:02:10.318 an AI tool that takes those emails from
00:02:13.879 my inbox and perfectly adjust them for
00:02:17.080 my topic and writing style to create a
00:02:19.599 unique email that sounds like me my
00:02:22.480 problem will be solved for good so
00:02:24.720 that’s the tool I built if you want
00:02:26.599 access to this powerful tool click the
00:02:28.519 link in the description below this video
00:02:30.480 often the best ideas for AI tools are
00:02:33.519 right in front of you they are the
00:02:35.360 problems you have like this one how
00:02:37.920 often and at which time should I send my
00:02:40.200 emails to get the best results how about
00:02:43.319 an AI tool that analyzes the sending
00:02:46.440 times from other people and tells me
00:02:49.400 exactly when I should send mine once you
00:02:51.519 got the idea for your AI tool type
00:02:53.720 sheet. new in your browser which will
00:02:56.599 create a new Google sheet and let’s
00:02:58.599 prepare the columns we need for this
00:03:00.400 tool I’m building together with you so I
00:03:02.680 will have a column called email senders
00:03:06.159 then I have a column called
00:03:08.480 selected email senders and then I have
00:03:11.720 the email timing anales let’s call it
00:03:15.519 the email timing analyzer now let’s turn
00:03:19.319 this simple Google sheet into an highly
00:03:21.760 effective AI tool by using the most
00:03:24.480 powerful thing that you get with a free
00:03:26.799 Google account it’s called Apps scripts
00:03:30.120 with it you can make Google Sheets or
00:03:31.879 any other Google application do anything
00:03:34.599 you want even if it’s not part of a
00:03:36.400 standard functionality that’s how you
00:03:39.000 can extract information from emails and
00:03:41.640 save them in documents you can
00:03:43.680 automatically attach slides as a PDF to
00:03:46.840 an email and send them and you can
00:03:49.040 easily connect it to any Ai and turn a
00:03:52.159 simple Google sheet into a really useful
00:03:54.599 and valuable AI tool here’s my
00:03:57.319 three-step copy and paste process to
00:03:59.879 build AI tools number one tell chbt
00:04:03.720 exactly what you want your tool to do I
00:04:06.239 want my AI tool to list all email
00:04:08.840 senders in column A of my Google sheet
00:04:11.239 that have sent me an email in the last
00:04:12.680 14 days then I want my I tool to analyze
00:04:16.560 the send times of all emails that I copy
00:04:18.759 and paste here into this list and the
00:04:21.160 analysis should be stored in column C
00:04:24.080 and performed by an AI and I want to
00:04:26.160 trigger the analysis from an extra
00:04:28.080 custom menu that should appear here here
00:04:30.160 and that’s what I paste into cat GPT and
00:04:32.840 I’ve also added an AI connection example
00:04:35.479 where I will teach cat GPT how to
00:04:37.080 properly connect my choose an AI which
00:04:39.440 in this case is the open AI GPT 40 model
00:04:42.400 to my Google sheet if you want access to
00:04:44.360 this exact prompt click the link in the
00:04:45.840 description below and then I will just
00:04:47.400 click and submit the prompt to chat gbt
00:04:50.199 step two copy and paste the code into
00:04:53.360 the appscript editor once chbt is
00:04:55.800 finished we can start copy and pasting I
00:04:58.320 click here on copy code on the first
00:04:59.919 code block then I go here on my sheet to
00:05:01.880 extensions and click appscript then I
00:05:04.039 will just copy a code I’ve just pasted
00:05:06.280 and click save now I will scroll down to
00:05:09.080 the bottom there’s a second block of
00:05:10.440 code and here jpd tells me exactly where
00:05:13.120 to put it I need to go to Project
00:05:14.919 settings by clicking on a gear icon
00:05:17.240 which is this then I grab the second
00:05:19.000 block of code I copy it and I paste it
00:05:21.160 in here and I click save now there’s one
00:05:22.639 small thing for me to do I key I need to
00:05:24.919 place my own open a API key into this
00:05:27.759 placeholder this is really easy to get
00:05:29.680 you just go to platform. open.com if you
00:05:32.600 don’t have an account you can set up one
00:05:33.960 for free and then you can go to your
00:05:36.520 settings and there under building you
00:05:38.039 will need to add $5 openi the company
00:05:41.560 that provides you with artificial
00:05:43.479 intelligence charges you a very small
00:05:45.919 amount to use it you can see even in my
00:05:48.759 sophisticated II tool it only costs me a
00:05:51.680 few cents to generate a ready to send
00:05:54.360 email with the $5 credits I could
00:05:57.160 generate over $250,000
00:05:59.800 words that is like a th000 book pages
00:06:02.759 for my tool it means I can generate over
00:06:06.400 200 emails which just $5 and this is
00:06:10.240 insanely cheap after you’ve added your
00:06:12.440 $5 credits you can go back to your
00:06:14.520 dashboard then you go to API Keys you
00:06:17.120 click here on create a new secret key
00:06:18.759 and then you just click here create key
00:06:20.919 then you copy the key and go back to
00:06:22.280 your appscript editor and there you will
00:06:24.080 see we have a placeholder where we need
00:06:26.759 to put our API key and then we can set
00:06:29.840 the maximum tokens this is the maximum
00:06:32.000 output you want the lower the shorter my
00:06:35.039 analysis will be and 100 tokens is
00:06:37.280 around 75 words so with 400 tokens I
00:06:40.360 should get around 300 words as an output
00:06:42.560 result of my analysis we can now save
00:06:45.000 our tool and we can then go back and
00:06:47.080 reload it there should appear a new menu
00:06:49.360 as you see here it’s called email
00:06:50.840 analysis when I click it the first thing
00:06:52.599 I have to do I have to authorize my
00:06:54.000 scrip this is what you always have to do
00:06:55.840 when you make changes or add new
00:06:57.199 functions now I have to click list email
00:06:58.919 senders again it has listed all the
00:07:00.800 email senders that have sent me an email
00:07:02.599 in the last couple of days and now I can
00:07:05.240 copy and paste the senders I want to
00:07:07.960 have analyzed into this tool then I can
00:07:10.840 click here and analyze selected senders
00:07:12.720 so it analyzed all the emails I’ve got
00:07:14.759 the timing the frequency and it gives me
00:07:17.319 the patterns so it tells me three emails
00:07:19.800 sent on Friday and at these times this
00:07:22.520 indicates that the emails are sent in
00:07:24.080 early morning or afternoons on Fridays
00:07:26.000 then two emails sent on Thursday and
00:07:27.840 here the email times and it also did
00:07:29.280 that for the other email sender so it
00:07:32.479 shows and if I want to optimize my
00:07:34.280 analysis I will just go back to app
00:07:36.160 scripts then I could make a few
00:07:37.479 adjustments to the prompt you find it
00:07:39.400 here then I would say provide this the
00:07:42.280 analysis results in three bullet points
00:07:46.520 then I will click save go back and run
00:07:48.560 the analysis again and now you see it
00:07:50.720 looks much clearer step three check the
00:07:53.560 execution log for errors and if you get
00:07:55.960 some copy and paste them back into chat
00:07:58.120 gbt and tell it to them so if you find
00:08:00.680 an error appearing in your AI tool just
00:08:03.919 go back to executions and there you can
00:08:06.840 find the detailed error log so in this
00:08:08.919 case it shows me an error then I just
00:08:10.840 grab this copy it and paste it back into
00:08:13.720 chat gbt and on top of the error I will
00:08:16.000 write something like this a random
00:08:17.440 function in the log I got this errow
00:08:18.720 please fix it then chbd will tell me
00:08:21.240 what could be wrong so it tells me
00:08:22.840 number one there could be an error at
00:08:24.639 the I I go back here into my editor look
00:08:27.960 at the API key and then I could either
00:08:30.120 go back here copy it again and paste it
00:08:32.559 in here and then save it and then I
00:08:34.599 could even run the code from here I
00:08:36.320 click the function I want to run in this
00:08:37.839 case analyze selected senders then I can
00:08:39.599 run in from here and see if there are
00:08:41.559 still any errors or if the error is
00:08:43.320 resolved and in this case the arrrow
00:08:45.160 seems to be fixed it’s really that
00:08:47.160 simple tell tgbt what you want a i tool
00:08:50.399 to do copy and paste the code into the
00:08:52.760 appscript editor run the code if you get
00:08:55.399 an error copy and paste the error back
00:08:57.200 into jgpt and tell it to fix it use see
00:08:59.880 just copy and paste that’s how I built
00:09:03.360 my first working AI tool in a day which
00:09:06.320 a leading AI business Expert who runs
00:09:09.519 several paid memberships regarded as I
00:09:13.320 think this is a great product that can
00:09:15.760 make you a lot of money with this
00:09:18.160 validation I knew my tool had real
00:09:21.279 potential and I spent another two weeks
00:09:23.560 polishing the tool adding new features
00:09:25.839 based on feedback and making it more and
00:09:28.959 more valuable and finally I launched it
00:09:32.240 and already got my first sales if you
00:09:34.680 want to see more videos about how I
00:09:36.560 build these AI tools without needing to
00:09:38.680 know any coding please like And
00:09:40.760 subscribe and hit the notification Bell
00:09:43.079 so you don’t miss any of my next videos