Collaborate on Create Invoice in Google Sheets for Inventory with Ease Using airSlate SignNow

Create invoice in google sheets for Inventory

hey guys Stuart here welcome back to another Google Sheets CRM tutorial today I'll be diving into Gemini AI inside Google Sheets and how you can leverage AI inside Google Sheets to generate a CRM Inventory management system or task list as well as other Dynamic tables and tools that you can create with AI this is by simply adding a prompt inside Gemini which is now built into Google Sheets now in order to access Gemini AI inside your Google workspace account you do need to subscribe to the add-on inside your admin account and that's going to allow you to leverage Gemini AI throughout all your different Google apps today I'll be showing you how to leverage Gemini AI inside my Google Sheets CRM called sheify CRM however you can do this inside any Google Sheets template and after this walkthrough of Gemini AI if you find that Gemini AI is not right for you when it comes to generating different tools spreadsheet templates and tables for your business then I'll touch on our sheety CRM which is an allinone CRM and business toolkit that allows you to manage your contacts customers your sales pipeline client tasks your inventory as well as tickets and how you can leverage email marketing activities inside this all-in-one Google Sheets CRM template okay so to leverage Gemini AI let's go ahead and open up a new sheet and let's go ahead and rename this sheet I'm going to rename this to inventory because I'm going to use this sheet as well as AI to generate an inventory management table let's do that by simply navigating up to AI in the top right hand corner then navigate down and add a prompt down here for me I'm going to add please create an inventory management table for a sushi restaurant hit enter give Gemini a moment and as you can see we now have an inventory table that we can use we can also edit this table further by leveraging AI for example I want to change the currency to euros simply navigate down to the prompt and add please change the currency to and as you can see all currency has changed to EUR and again before we insert the this table what we can do is navigate across and if we want to add another specific column we can always navigate down to the prompt and ask Gemini to add another column this could be a specific column that you want to show inside your inventory system for now I'm happy with this inventory management system I'm going to go ahead and click on insert and now what we can do is add our own values let's Now quickly create a CRM using Gemini AI simply navigate down and create a new sheet and this time what we can also do is navigate up to this table icon help me organize and this is another way that we can quickly create a template using AI this time I'm going to add and continuing with my theme what I want to do is create a CRM system for tracking dinein and takeaway customers for a sushi restaurant let's go ahead and click on create hey just quickly before you get back into this tutorial if you're getting value from this video please drop a like And subscribe this means a lot to me and ultimately helps us reach and help more small business owners across YouTube thank you in advance and with quick note let's jump back into this video give Gemini AI a moment to develop your CRM and as you can see we now have a CRM system built inside our Google sheet CRM in just a matter of seconds leveraging AI you can see we have these columns up here that we can customize the way that we like and then over here we have dine in or takeaway you can see that this element inside our CRM is what we added inside our prompt if we want to customize this CRM template further we can leverage AI or we can simply navigate down to insert and then we can manually make changes to these different values if we navigate over to this drop- down option we can choose if the contact or customer is D in or takeaway and we also have this loyalty program member column over here and then notes okay let's navigate down and rename this sheet I'm going to call this CRM system and finally what we're going to do is navigate across add a new sheet and this time let's create a task list navigate over to help me organize and to add please create a checklist for tasks related to day-to-day operations of running a sushi restaurant again we're continuing with this theme and as you can see if we navigate over here we have the tasks then the priority status the due date assigned to status and notes now you can see we don't have a physical checklist I want to add that so I'm going to navigate up here please add a checkbox for completed items let's see what Gemini AI is going to generate for us and as you can see again we have the task here priority deadline now we have staff responsibility notes and a completed checklist let's come down and click on insert and again navigate across and you can see we now have this checklist next to each item again we can build off this using AI if we like let's navigate down to this sheet go ahead and rename this tasks and just like that in a matter of minutes we created an inventory sheet an inventory management platform using Google Sheets and Gemini AI we also created a CRM system for managing contacts and customers and we also have a tasks checklist for managing day-to-day operations inside our sushi restaurant pretty cool huh and that is how you can simply create anything with Google Sheets and Gemini AI now if you want a more advanced Google Sheets CRM task list Inventory management platform and communication toolkit that allows you to send messages as well as email marketing campaigns then my Shafi CRM toolkit may be for you if you're interested in learning more about our sheify CRM and bookkeeping toolkit that I built with Google Sheets and appscript I will add the appropriate tutorials and resources Down Below in the description for you to check out here you can simply manage your contacts customers and accounts here you can again manage the lifetime value of your customers next to that we have a sales pipeline then next to sales pipeline we have a sales calendar that is built in we also have a client task checklist this allows you to manage all your business related task tasks this also connects to the Google task app next to that we have client calendar which is built in to sheify CRM then email templates these are email templates that you can customize and then bulk send email campaigns directly to your customers next to that we have a visual dashboard that allows you to manage the different analytics and performance of your business then we have settings purchases where you can manage all your purchases here you can manage all your inventory Services items then next to that we have transactions and this is where you can manage all your transactions then we also have tickets and issues again if you want to learn more about our sheify CRM allinone business toolkit built with Google Sheets and appscript I will add all the resources Down Below in the description however that is everything that I wanted to cover in this complete tutorial showing you how you can create anything with Google Sheets and Gemini AI if you have any questions make sure to pop them down below and with that said thank you so much for watching this video if you got value leave a like leave a comment and I'll see you in the next video take care everyone