Whether you’re offering a service, selling a product, or running an event, collecting feedback from your customers is an important part of any business. But this process can be as resource-intensive as it is important, from designing a survey to analyzing responses.
With Spreadsheet.com’s OpenAI integration – as well as other features like Form Views and Row Grouping – you can take some of the manual work out of this process by asking OpenAI to summarize and classify responses for you.
Read on to learn more about using these powerful features in your own workbooks.
Spreadsheet.com Form Views let you turn worksheet columns into questions in an online form that can be shared with anyone. Forms can be shared with a sharing link accessible on any mobile or desktop browser. When responses are submitted through a Form View, they’re automatically added as new rows in your worksheet.
In our workbook, we’re using a Form View to collect feedback about our product. Forms can be used for all sorts of things, like receiving RSVPs for an event, collecting orders, taking attendance, gathering newsletter sign-ups, or even creating online quizzes.
Spreadsheet.com forms can be customized with a company logo and contain additional information not found in your primary worksheet, like description text.
Try using an Automation to distribute your feedback form to a list of customers or newsletter members.
Once the feedback starts coming in via your Form View, you may end up with dozens or hundreds of responses and thousands of words to read through. With a simple OPENAI_COMPLETE formula, you can ask OpenAI to read through every response and distill the information into simple bullet points or a short summary.
Try adjusting your OpenAI query until you get the results you’re looking for. Instead of asking for a bullet point summary, ask for a summary in “1-2 sentences” or a summary “less than 100 characters”. Simplify information even further by asking OpenAI to return a list of keywords from a response instead of a whole summary.
Test your formula on a few rows before dragging it down through an entire column. Be patient as it may take a while for OpenAI to analyze an entire column of responses. If a cell returns a #TIMEOUT! error, try re-running the formula.
Take a look at our guide “5 Tips & Tricks for Using OpenAI in Spreadsheet.com” for more information about using the OPENAI_COMPLETE function.
In addition to summarizing feedback responses, OpenAI can classify responses for you as well. Automatically classifying responses can help further reduce the time it takes for you to read through and sort a slate of responses.
In the example above, we’re using OPENAI_COMPLETE to formulate a request asking OpenAI to classify responses as “Positive”, “Negative”, or “Neutral”. Like all functions, the OPENAI_COMPLETE function can be used in columns with unique Data Types like Select, as we’ve done here.
In our example, we’re giving OpenAI three specific terms by which to classify responses. You can also ask OpenAI a more open-ended question and have it determine its own classification terms.
Now that your feedback has been summarized and classified, it’s time to drill down further into the information. Spreadsheet.com supports more than a dozen types of charts commonly found in traditional spreadsheets, which can help you better visualize your data.
Try placing charts in the table header region for maximum visibility.
Using Spreadsheet.com’s data organization features like sorting, filtering, and row grouping can help you better understand your data. And with support for multiple Views based on the same worksheet, you can create different groups of responses for different members of your team.
In the example above, we have a View grouped by “Ease of Use” responses for our Engineering team, and another grouped by “Likelihood of Upgrading” meant for our Sales team.
Filters can also be applied to individual Views. In the example below, we’re using filtering to create a View that only shows responses from users on the Free plan. We have similar Views showing responses from Premium and Enterprise users.
Notice how the charts in the table header region adjust to reflect the data in the current View.
Ready to use Spreadsheet.com to help collect feedback from your customers? Get started for free today. Check out our Template Gallery to get a head start on your workbooks, or begin creating your own from scratch.
For more information on the features seen in this guide, visit our Help Center.