It would be amazing if we could use Google's upcoming Bard AI Chatbot in AppSheet. My idea is to build an app that takes a political statements, and asks AI Chatbot to rank it on a scale from 1 (Liberal) to 100 (Conservative). Then, a complete profile of a person's opinions could be created and give them an calculated score based on the AI's rating based on each statement.
The way that I can imagine this happening is a formula in the formula editor. For example...
BARD("Please rank the following statement on a scale from 1 to 100, where 1 is very liberal, and 100 is very conservative: "&[Political Statement])
The output is whatever BARD responds.
Thoughts?