Better Sheets - a perfect use of AI
I think I found the perfect use of AI. in Google Sheets. Categorization. I made a video and included it in Master Spreadsheet Automation. You can get it today! From scratch, we utilize boilerplate code and leverage the OpenAI API to automate the process. The step-by-step tutorial covers how to obtain an API key, write a prompt, and see the AI in action as it accurately assigns categories. This should keep you more organized. Get Master Spreadsheet Automation at the best price available for the next 4 days. https://www.udemy.com/course/spreadsheet-automation-101/?couponCode=EAF178A7ED8F7F38CB8C -Andrew Your Resident Google Sheets Wizard P.S. Here's the final code: function ai(task) { var prompt = "Give us back only the category of the task given. Only give back either Work or Home. No other categories. for example: Task: Prepare breakfast Category:Home Task:Respond to emails Category:Work Task:Clean the living room Category:Home Task:Attend morning meeting Category:Work Task:" + task + " Cateogry:" var apikey = "enteryourapikeyhere" var role = "" var data = { "model": "gpt-4o", "messages": [{"role": "system", "content": role}, {"role": "user", "content": prompt }], "temperature": 1, "max_tokens": 500, "top_p": 1, "frequency_penalty": 0, "presence_penalty": 0 } var options = { 'method': 'POST', 'contentType': 'application/json', 'headers': { 'Authorization' : 'Bearer ' + apikey }, 'payload': JSON.stringify(data) } var answer = UrlFetchApp.fetch("https://api.openai.com/v1/chat/completions",options) var response = answer.getContentText() var json = JSON.parse(response) return json.choices[0].message.content } |
Older messages
Stuck?
Monday, July 8, 2024
Hi, I got a simple question. If you have not yet learned to automate your sheets, what's keeping you from coding in Google Sheets? That's the whole question. I really want to know. The reason
10% off Better Sheets for 48 Hours
Wednesday, June 12, 2024
For those who have not yet gotten a lifetime deal, here's a HUGE chance! AppSumo is offering 10% off of Better Sheets, but it's only for less than 48 hours. Go beyond Better Sheets. You'
Do you have a google sheet you wish looked better?
Monday, June 10, 2024
Hi, It's Andrew from Better Sheets here. Do you have a google sheet you want me to make look better? Happy to do free design work if I can record a YouTube Video showing my work on your sheet. Just
Happy Birthday!
Monday, June 3, 2024
It might not be your birthday, but it's mine. And as a celebration of life, it's bountifulness and it's blessed beauty, you get a free course! Get my course: Learn to Code in Google Sheets
Podcast app setup
Monday, June 3, 2024
Open this on your phone and click the button below: Add to podcast app
You Might Also Like
🤝 The Biz Buyer’s Guide to Risk (Without Going Insane)
Tuesday, October 29, 2024
Inside: 1 awesome event, 1 key lesson for biz buyers to know, and 1 great meme Main Street Minute Newsletter Header (4) (1) Biz Buyers, This is where we share some of the best tips, tools, and ideas
Ebook Many Devices: A Second Chance with My Grumpy Detective: A Next Door - Lovers Romance
Tuesday, October 29, 2024
Contemporary Romantic Suspense Welcome to ContentMo's Book of the Day "This book isn
A Brief History of Art Collecting
Tuesday, October 29, 2024
Your weekly 5-minute read with timeless ideas on art and creativity intersecting with business and life͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
The Batman of Baltimore
Tuesday, October 29, 2024
This actually isn't a Halloween story.
Don’t Wait for the Breakup
Tuesday, October 29, 2024
Write your exit options now. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
🧙♂️ 3 surprising truths about breaking free from the 9-5 grind
Tuesday, October 29, 2024
Why I gave this "creator thing" my best shot ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
For Authors: Audio Book Promos 🔊 Tweets & FB group posts • 60 Day orders save 15% +
Monday, October 28, 2024
Affordable Audio Book Promos Enable Images Audiobook Promos for Authors & Publishers CHOOSE
Connect GA4 to BigQuery for greater insight and analysis📈
Monday, October 28, 2024
Fred Pike walks you through a tutorial for how to set up a free BigQuery account and connect it to GA4. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ Learn How to Set Up a
An exclusive invitation: ⭐ Deal Analysis & Evaluation With Codie ⭐
Monday, October 28, 2024
Don't miss this! Happy Monday Crew! Who's up for a little Deal Analysis tomorrow night? It's all going down @6pm CT tomorrow night and I want YOU to be there! We're doing something we
🧙♂️ Do you need a "signature" talk?
Monday, October 28, 2024
Prepping for a podcast tour ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏