Explore how to use AI for task categorization in Google Sheets, from setting up the environment to using a pre-made code template. Watch as we walk through the process, from generating an API key to fine-tuning the prompt for effective categorization of work and home tasks.Final code is available in the sheet below. And the original template code is available here:https://bettersheets.co/snippets/updated-open-ai-model-to-omni
Add a Custom MenuCreate Native-like FunctionsGet URL and Sheet ID's via Apps ScriptA Few things to know about Developing Google Sheet Add-ons
Create automatic notifications when a project is assigned, a project needs review. And move a project from one tab to another tab.
Going beyond PRIDE, to show you some undocumented google sheets hacks that you might call "Easter Eggs"
I'll show you how to get text from one spreadsheet file to another with Apps Script. Yes you can do this by Importrange() but you might want another way to do it.
Count the number of cells or rows in a merged cell. This is a quick little code you can add to your sheets with the onOpen code.
Automate the apps script we just created that moves blank rows from one sheet to the other sheet. Original tutorial to write the apps script
Apps Script function to move all blank rows if a certain column is not filled in. Learn how to automate this script →Here
There's something wrong with PROPER() the google sheets function. Let's fix it by customizing our own TitleCase() function inside of Apps Script.
Make a copy and rename to BACKUP plus the Date of the backup. Execute this automatically via Triggers in your Apps Script. Two are shown here. to back up a tab or back up a spreadsheet file.
Automatically copy a spreadsheet tab to a whole new spreadsheet file, get the url of that new sheet, and make sure the new file is values only. no formulas. A member asked this question and I'm happy to answer it, code it, and let you in on the answer in this short video.
Build a website from scratch using a little bit of Google Sheets as the backend. Using Carrd to build a html website from the data and display a random quote every time you refresh the page. All the code including the HTML embed is in the sheet below.
Copy text output and input into a google sheet from your OpenAI API calls. Great way to save AI text into a sheet or start to create your own AI writer, or even clone ChatGPT
Tips and tricks to make sure people don’t resell your sheet. Or if they do, catch them. - Brand the heck out of your Awesome Useful sheets- Add your business info everywhere (I mean everywhere!)- Consider selling more than the sheet (advice/consulting/onboarding/auto email series/videos)
Get this tool: Coupon Code Maker to make it insanely easy to launch and sell on marketplaces like AppSumo Marketplace.
Repliers are buyers. Regularly build an email list with freebies, and giveaways so that you can resell later. This email list is a secret that I think only the six figure sellers selling spreadsheets actually do well. There are two known examples of Etsy sellers making 6 figures. Both of them mention email lists in their interviews.