Effortlessly Manage Your Invoice Tracker Google Sheets for Customer Service

Invoice tracker google sheets for Customer Service

hey guys Stuart here welcome back to another shety tutorial today's focus is to show you how you can generate free QR codes using Google Sheets maybe you want to create QR codes to online forms your website blog product pages or other online destinations you can do that with a QR code and using Google Sheets and the free image charts API you can do this in just a few clicks now if you like you can grab my free Google Sheets QR code generator which I'll link Down Below in the description deson however in this tutorial I'm going to show you how to do this yourself okay so to create a free QR code using Google Sheets simply open up Google Sheets or access the template that I added down below then simply click on a row all we need to do is add this formula up here again you'll find this in the description down below okay so I'm going to add this formula to this row again this is using the API image charts if you would like to see more information about this API I will add the documentation Down Below in the description essentially in the past you had access to a Google infographics API for generating QR codes however this is now being depreciated so the free alternative that I'm showing you now is using the API image chart which is highly reliable deployed in data centers all around the world and has subsecond response time again I'll add more documentation if you're interested Down Below in the description now all you need to do is replace this as you can see this is the website to my sheify CRM my all-in-one Google sheet CRM template I'm going to delete this so add the destination URL including https and then your online destination with do and then your url then simply hit enter and just like that the QR code has been generated then what we can do is make it larger by expanding these rows and columns and I'm happy with that hey guys just quickly before we get back to this video I just want to mention my sheety CRM an allinone business toolkit and CRM built with Google Sheets and designed for Google users you can simply manage leads customers tasks engage in email marketing manage your inventory tickets and more the great part is I've made this sheify CRM a onetime payment no subscriptions unlimited access and future updates if you're interested in learning more you can find the link to my sheify CRM Down Below in the description okay so with that covered let's go ahead and get back to this video and you can do the same with your other URLs to create your QR codes again all you need to do is add this code and then replace this text here with your own URL and that will generate your QR code then what you can do is simply copy and paste these QR codes into a different platform or you can navigate up to file then download and you can download these images as a PDF and simply click export and just like that you now know how to create QR codes for free using Google Sheets now you might need to give permission to the API in order to generate these QR codes so go ahead and do that and then you'll be able to generate these QR codes using this free image charts API connection and there we have it if you have any questions about this process make sure to pop them down below and with that said I'll see you in the next video take care guys