Discover what an Add-on is, what it could possibly do and what kind of problems an add-on can solve. There are much more in depth idea driven videos later in the course. For those who might want to know exactly what an add-on is, this video help you out!
In this course we'll go step by excruciating step how to take a simple apps script from a bound script to your spreadsheet and turn it into a published Google Sheets add-on available to the public on the Google Workspace Marketplace.
This is a review and improvement of Emmett Shear's Life to Date Sheet. Originally he tweeted about it and shared a sheet. I thought I could make it a bit better looking.
Two things I would teach every beginner to immediately improve your skillset in Google Sheets: 1. How to Combine Formulas2. How to Copy/Paste Apps Script Code to Your SheetLearn these two things in this quick video going over why I think these are important. And how unintuitive they are to beginners!→ Learn more about Formula Combinations→ Learn more Apps Script in Spreadsheet Automation 101
If you type the letters of PRIDE in the first 5 columns in the first row of your sheets they'll turn the color of the pride flag. If you want to create your own easter egg in sheets then follow along this step-by-step tutorial as I show you how.This might be better than Conditional Formatting! We're using the onEdit() simple trigger in Apps Script..
Wanted to share with members this course outline I am using for my own course making process. I outlined the course then added a bunch of cool little stats to help see my progress and keep me on a certain pace of video creation.
This is an attempt to create a waterfall effect in sheets. Where an AI response becomes the prompt in another ai API call.I show you one way not to do it, that fails with onEdit() but then I do show one particular way it could work. We wrestle with AI a bit in this video and the conclusion is not so sweet.Get the sheet below with the Apps Script and API code already written for you.
Walk through step-by-step going from a blank sheet to an AI powered prompt engineering cheat sheet of a spreadsheet.Watch the Upgrade to GPT-4 video to see the differences between GPT-3 and GPT-4 Apps Script
Create a ChatGPT prompt inside a sheet, edit that prompt with a single input 100 times over. In this case we're creating a twitter thread prompt and replacing the topic 100 times. so you can use 1 prompt to run 100 ai calls, and then we go furtherWe make it better.We add a checkbox and another prompt to take the output of the 1st prompt and run it again. And we can do that 100 times too. So each horizontal row can be it's own ChatGPT.You can get the ai Apps Script in this video's sheet or in the sheet connected to the GPT-4 upgrade: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4
Jodi asked: ab out Building a sales CRM spreadsheet that has 4-5 tabs at the bottom. Each sales person gets their own sheet and then I want a master spreadsheet that pulls each salespersons Information they enter (customer, job, status etc) into one place. I’m not sure how to get the master sheet to pull in from the other sheets as they enter the data so that the master sheet shows real-time what’s happening without making one row = a row from another sheet. I just want it to come in one row after the next as it happens. Other Videos Mentioned in this video:https://bettersheets.co/tutorials/add-a-timestamp-to-task-lists-without-now-formulahttps://bettersheets.co/tutorials/spreadsheet-automation-101-lesson-2-onedit-triggerSpreadsheet Automation 101: https://bettersheets.co/courses/spreadsheet-automation-101
Showing you how to use the new Spintax add-on to write 1,000 headlines from a spinned version of a headline.Get Spintax here: https://spintax.bettersheets.co/
How to figure out a percentage score when our reporting numbers are a formatted in a particular way. In this case we have a score and then a slash and then the total possible score in a single cell. We go through each option of solution and try to derive a solution that is both useful in the exact situation and possibly useful for other problems too.We find that the Query formula and other solutions are inflexible or time intensive. We want a solution that does actually solve the problem at hand, in a quick way, and also is easy to edit and flexible to solve other problems.
Create an epic writing tool to generate text from AI with a parade of prompts. A list of prompts you create and write that can be used over and over again. Or use this template to create your own workbook to sell a sheet of your own prompts.
Find out How to Optimize your Apps Script functions. Learn the trade offs between flexibility, edit-ability, and protection. Different cell references allow you to do more with your apps script.In the context of the video we're talking about an AI prompt and how I used different Cell References when writing different Apps Script functions. I'll show you why I chose those syntaxes and why you might choose different ones.This video is more about Apps Script than writing Prompts but can help you create better web apps inside of Google Sheet, utilizing the best of Apps Script and creating your own custom functions.
Create a chat interface inside of Google Sheets using GPT-4. Insert rows as prompts get written. This sheet will help us ultimately write better prompts. We can actually tell the difference between what we're doing to get good vs bad response from the prompts.
Introductng a new tool from Better Sheets. A free Google Sheets™️ Add-On to parse spin syntax content.Revolutionize Your Google Sheets writing with Spin Tax Content Spinner! Say Goodbye to Tedious Editing. Get All the Variations You Need. Spin randomly to get one variation Spin text for all variations Spin text for all variations including duplicates Spintax is written with pipes separating content you want to randomly select. {Hi|Hello|Hey} would either be Hi, or Hello, or Hey.
Create the Ultimate Headline Writer: Unleash the Power of Google Sheets and OpenAI's API / GPT-3.5-Turbor to Create Compelling Website Headlines. Write in different styles, using different parameters to make the ultimate headline writer for an agency or for your own business.
Unlock the Power of OpenAI: Create Ultimate GPT Prompts for Seamless Interaction! Discover the Formula Inside, Explore APIs, and Boost Productivity. Watch Now!
Discover the Ultimate Google Sheets Hack! Transform Text with Title Case Formula. Say Goodbye to 'Proper' and Hello to Easy Capitalization. Find Out How!