Use AI functions in your tables
The hype around GPT-3 or ChatGPT can no longer be ignored. Exciting applications and tools for ChatGPT or GPT-3 are popping up everywhere. Although you cannot generate AI images with this script (yet) , you can use extensive AI commands in your usual Google spreadsheet.
How would it be if you could use artificial intelligence in your tables in Google Sheets? The good Lucas Perret recently published a guide on LinkedIn and here about exactly that. Here I want to show you how you can set it up too.
Don't feel like using scripts? These plugins will help you!
If you don't feel like building your own app scripts, you can simply use existing plugins to integrate GPT-3 directly into your Google Sheets.
GPT for Sheets
The possibilities of ChatGPT in your documents are cameroon phone number data almost endless. This add-on brings the AI power of GPT-3 to Google Sheets™ by providing two simple custom functions:
=GPT to get the result in a single cell
=GPT_LIST to get one list element per line
Using GPT3 in Google Sheets 1
Cargo
Write emails, follow-ups, Google Ads copy, and blog posts at scale with AI-powered templates.
Using GPT3 in Google Sheets 2
Setup - Create and customize app script
To build your own Google Sheets function that works with GPT-3, you first need to install the appropriate App Script. This is easy to do in just a few steps and without much previous experience. I'll show you how to do it step by step.
1. Create an Apps Script
First open a new Google Sheet (Tip: Sheets.new is one of Google's shortcuts)
Now click on Extensions and select Apps Script. This will open a window in which you can integrate and execute various scripts.
Using GPT3 in Google Sheets 3
2. Insert App Script
In the window you are in, you just need to paste the code below in full. To do this, replace any content that may already be there and name the script as you wish.