Creating Tables of Data in Seconds with ChatGPT
The GPT_TABLE function of GPT for Sheets makes it easy to create and fill tables with data automatically. In this video, we walk you through four use cases to make the most of the GPT_TABLE function.
Examples explained in this video:
Generate 5 sample people and their related information with a simple prompt
Extract from a long text players' names and their home country into a table
Add metadata about fruits characteristics in a table with predefined headers
Extract relevant data from property listings into a table with predefined headers
📖 Function in this video:
Syntax: =GPT_TABLE(prompt, [head], [inputs], [temperature], [max_tokens], [model]) - model by default: GPT-3.5-turbo
Copy/Paste example: =GPT_TABLE("top 10 most eaten fruits and their nutrition data")
Copy/Paste example with custom temperature, max_tokens and model parameters: =GPT_TABLE("top 10 most eaten fruits and their nutrition data", [headers],[inputs], 0.5, 600, GPT-3.5-turbo) ️
⌚️ TIMESTAMPS
00:00 Generate dummy data
03:39 Extract and classify data
06:03 Generate metadata
10:50 Extract and classify data #2
▶️ PLAYLIST: Discover all the functionalities of the GPT for Sheets and Docs add-on: • All about GPT for Sheets
📥 List of all available functions and template of examples to download : https://gptforwork.com/help/gpt-for-s...
❗️ Do not hesitate to comment below or fill out this form with your questions and feedback, we'll be happy to answer: https://support.gptforwork.com/hc/en-...
------------------------------------------------------------------------------------------
GPT for Work is an AI assistant for Microsoft Excel and Word, Google Sheets and Docs. You can use it for all sorts of tasks: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining... and even analyzing pictures!
GPT for Work brings the power of OpenAI's latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo and GPT-4 Vision into Microsoft Excel and Word, Google Sheets and Docs. It is like using ChatGPT directly in your spreadsheets and documents!
👉 Install for Microsoft: https://gptforwork.com/install-msft
👉 Install for Google: https://gptforwork.com/install-google
Our GPT functions are perfect for bulk operations in Excel and Sheets.
Our Word and Docs integrations are great for long form content.
💡 More resources and examples on our website: https://gptforwork.com/
🔔 Don't miss any new feature by subscribing to our channel: / @gpt4work
------------------------------------------------------------------------------------------
This channel is brought to you by TALARIAN: https://talarian.io/
Check out our other productivity tools for Google Workspace:
🚀 YAMM : https://yamm.com/
🔥 AWESOME TABLE : https://awesome-table.com/
🤖 FORM PUBLISHER : https://form-publisher.com/