Video course · 9 chapters · 15 min · certificate
How to use GPT for Sheets Plugin in Google Sheets
Use GPT for Sheets in Google Sheets: GPT_TABLE, setup and cheap pricing, getting data in (web apps, scrapers), GPT_CLASSIFY, GPT_SUMMARIZE, open prompting with GPT, AI automations and GPT_FILL pattern replication.
What you'll learn
- Enable GPT for Sheets
- Generate tables with GPT_TABLE
- Import data from web apps
- Classify and summarise with GPT functions
- Use open prompts
- Clean data with GPT_FILL
Chapters
9 chapters · 14:42-
1:58
01Setup Members
GPT_TABLE and setup
Sheets + ChatGPT.
-
1:12
02Pricing Members
Dirt-cheap pricing
Pay per use.
-
1:15
03Data Members
Functions and getting data in
Two ways.
-
1:10
04Import Members
Import from web apps
Pre-built automation.
-
1:30
05Classify Members
GPT_CLASSIFY
Label data.
-
1:58
06Summarise Members
GPT_SUMMARIZE and web scraper
Condense.
-
1:08
07Prompt Members
Open prompting with GPT
Any instruction.
-
1:29
08Automation Members
AI automations beyond Sheets
Bardeen AI.
-
3:02
09Fill Members
GPT_FILL pattern replication
Clean names.
Jobs this course suits
Our AI checked this course against 500 jobs; these get the most out of it. Each job links to its learning path.