UNBOXED: The power of GPTs in your favourite spreadsheet to save time
By accessing ChatGPT directly in your spreadsheets, you can quickly automate those tedious tasks, create tailored content at scale, and free up time to focus on what truly matters: delivering exceptional event experiences. Here are just some use cases.
Let's face it: spreadsheets are useful, but in event management or marketing, we don't always get information how we need it. Speaker bios, for example, come in all shapes and sizes or not at all. All of us have spent hours late into the evenings getting the information into the format we would like, whether that is speaker bios, a seating plan, or just a delegate list put into different formats.
By popular demand, we have built a more user-friendly version of the Chat GPT in Sheets that does not require you to copy and paste code. You can get it and the associated instructions either via this free course or in which you can copy the sheet, including the app script.
With GPTs we have Artificial Intelligence right in our spreadsheets. It may just help us win back some of those Zzzzzzzs.
In this episode of UNBOXED, I show you some potential use cases for Digitising Events; I am sure you can think of more as you explore having GPTs directly accessible from our favourite spreadsheet to automate event planning and reduce repetitive tasks with GPTs in Google Sheets or any spreadsheet saving you time by creating content at scale.
A Show and Tell of Using GPTs in SpreadSheets
How do you get GPTs to work in your spreadsheet?
Accessing the GPTs from Google Sheets, as in this demo, is pretty simple. As mentioned above, we have created a more polished and public version of the script we built internally, and you can get that for free.
If you prefer, there are numerous plugins out there. These guys seem to have done the most comprehensive job: https://gptforwork.com/, but if you are not afraid to copy and paste some code and you work with Google Sheets, you can watch this loom and use what we have done.
In essence, once you have it, you can access the power of Chat GPT by using formulas just as you would for summing things. So the formula =GPT(A2&C2) sends the content of A2, which can be prompt, and C2, which can contain some data like a spearer Bio, to Chat GPT and reruns the answer.
I review some potentially relevant use cases for Digitising Events in this UNBOXED video.
Use Case: More Relevant Speaker Bios
Preparing speaker bios can be tedious, mainly because you get them in all shapes and sizes. Often, valuable information is at the end of the bio, and this can be lost if systems use, say, just the first 100 characters and so on.
But with GPTs in Sheets, it can become a seamless activity. Utilise the "GPT" formula in Google Sheets to direct GPTs to create speaker bios based on tailored prompts. In essence, to your recipe.
You could put a prompt like "Use the following bio to create a compelling one that starts with the speaker's FIRST NAME ONLY of no more than 50 words and focuses on the experiences that show competency in your events niche. Use an informal style."
In one go, you can apply this to all 20, 60, or 100 speakers at your event, making the bios much more relevant to your target audience.
Use Case: Simplifying Event Data Categorisation
Categorisation based on text is one of the things GPTs are very good at, and this can be extremely valuable in the daily life of anyone involved in event production.
In the video, I use an example of using the speaker bio to categorise speakers into four categories, but the applications are endless.
You could use it to efficiently reformat lists, create descriptions, and augment exhibitor or speaker lists.
Use Case: Tailored Social Media and Other Content
As with the example above, we are all tired of generic social media messages created by some tools where we have little control over the content. You can now craft your own prompt and use the speaker bios in the same sheet to give you useful social posts based on your prompt.
These were just some examples. The real opportunity is that with access to CPTs, a lot of those unplanned admin requirements that require data to be changed or augmented can be dealt with quickly. These tasks are usually important but don't usually add too much value. Handing them off to GPTs frees up time to focus on participant engagement and acquisition for your events.
GPT Models at Your Disposal: GPT3.5, GPT-4 & GPT4o
In the script we created and used, you can choose between accessing different GPT modes OpenAI offers. As a rule, GPT 3 is excellent for categorisations and simple summarisation.
The more advanced GPT-4 model is much better at dealing with complex tasks.
There are slightly different costs, with older models being much cheaper, so when deploying at scale, choose your models well. To avoid surprises, you can set budget caps in Open AI, which may be good as you start working with GPTs in sheets.
The formulas
=GPT( 'uses gpt3
=GPT4( 'uses gpt4
=GPT4o('uses gpt4o
Show and Tell: Live Project Example
In this example, we needed to categorise some existing assets efficiently and quickly. This would have been one of those turgid jobs handed over to some poor intern. Instead, we got it done in 20 minutes.
Don't worry; the intern still got a look in, as we needed someone to spot-check the 300 results just to make sure and then load them up to the site. But most of their day was taken up with interesting stuff requiring proper brain power!! not this nonsense.
AI-centric Working with GPTs in your favourite spreadsheet saves time.
AI, whether it's GPTs or predictive models, are helpful tools we should activate to help us work smarter. Putting GPTs in sheets has helped us save hours, deliver better results, and enable content creation at scale.
The digitisation of events is about leveraging this fast-moving technology to free up our time to focus on creating memorable experiences for all participants.
Whether generating speaker bios, crafting social media content, or categorising event data, GPTs in Sheets equip you to approach event management with different agility and effectiveness.
Stay tuned for more episodes of UNBOXED, where we spotlight the latest in technology, driving the future of event digitisation.
Disclaimer: This overview is our view of how the use of GPTs & AT in spreadsheets can help Event Organizers to Digitising Events by leveraging their digital content as we see it. Any scripts we originated and shared are provided 'as is, ' and we recommend visiting the relevant websites to watch videos and request live demonstrations from a representative. And for the cynics among you, we do not take sponsorship from any tech providers; it allows us to be more impartial.