Have you heard about GPT-3, the latest AI tool from OpenAI?
It is a natural language processing (NLP) model developed by OpenAI that has been trained on a massive amount of text data.
In this article, we will explore how to use GPT-3 with Google Sheets to get the most out of your productivity. We will use https://elephas.app, which adds an intelligent AI layer to your Mac.
Some of the examples we will cover are,
Extracting enhanced data from a column
- Count occurrences of a specific word combination
- Generate a text template from a row
- Validate text
- Remove invalid duplicates
Here is a video if you want to see this in action,
Elephas uses GPT-3 behind the scene. I used a feature in Elephas called "Snippets" that lets you extend it to your own custom tasks.
I set up 5 different snippets. Here are they,
Extract
Instruction:
Following google sheet contains address.
I want to extract the state name in full form and append a new column.
Count
Instruction:
Following Google sheet contains name and descriptoin.
I want to know the times cat and dog appear together in any order in a single cell. The cell is fine to have other data, still count it.
Text template
Instruction:
Following 3 cells selected in google sheets with a full name (first name needs to be pulled out), description of their challenge (needs to be turned into their desired outcome) and date and time of the call (just time needs to be pulled out)
Output format:
Hi {NAME}, Kamban from Elephas here again. Looking forward to speaking with you today at {CALL TIME} about how you can {DESIRED OUTCOME}. Can you please reply with a Y so I know you're still able to make it?
Validate
Instruction:
Following contains rows from a google sheet. Update the valid column with “yes” if the email contains a ‘@‘ else use “no”
Remove duplicates
Instruction:
From the following Google Sheet cells, remove duplicate rows but with the empty Type column. I.e preserve the row which has a type column value.
Conclusion
These are only a few use cases; you can do a lot more interesting things, such as filling text for empty rows. Try the 7-day free trial at https://elephas.app.
