Hi,
I would like to start using the OCR feature but before signing up for the Enterprise Plus plan i have a question that someone might be able to answer.
I would like to use the OCR feature to extract text from product specifications and then compare this data to a database. If a match is found this will then be presented for the user. Is this something you can achieve in Appsheet with the OCR feature?
Kindly
Fredrik
OCR is still in preview mode in AppSheet and I believe it has not been perfected yet for all or extended use cases.
In the meantime, in last couple of years AI has moved ahead and please evaluate if Gemini AI is useful to you.
However Gemini AI usage in AppSheet automation requires an Enterprise plan. So I am unsure how you can test it before you come to conclusion that it is useful to you and you can go for Enterprise plan. Maybe some other colleagues have suggestions for you in this regard.
I had also shared a tip of using Gemini AI with Google Apps Script. I believe this tip will not need an Enterprise plan and core plane will do but I could not find a concrete statement in help documentation about plan eligibility for Google Apps Script So please contact support for any queries.
I see, thank you so much for your insight! So with gemini this should be possible? I might have to sign up for enterprise then just to try.
Kindly
Fredrik
I have just signed up to an Enterprise account for testing (it was not an task to sign up, as I needed to become our workplace Google workspace admin).
From my limited testing on the A.I features, I will say that at first I was disappointed. It is not Gemini as you expect, such as look at this table and tell me trends. It works on a row basis.
From the A.I extraction I have made two test apps. One reads from a structured PDF and pulls values from it to a row and different columns. It then gives a summary as the last step. It works OK, but I know when the Gmail integration improves I can do 90% of the work from this.
This morning I quickly (15 minutes) created an expense app for auto pulling information. From my very quick test of 5 picture receipts with 5 extracts it got 23/25 entries correct. I think this is good for the amount of time I spent creating it.
For your question, I don’t have definitive answer, but it should have no problem extracting the text into a table. You will then have to create a second bot to compare the data and if it matches take it from there.
I see, thank you so much for this information! Since the task is rather simple it seems like it shouldnt be any problem.
One last thing. How is Gemini integrated in the enterprise plan - is it free/included or will you have to pay for tokens or similar?
Kindly
Fredrik
For more use cases using Gemini, perhaps try using a bot with Call a Script to get an Appscript to send your query, Image or whatever else to Gemini API and let it return you a response to capture back into Appsheet. It takes a short while but can definitly get amazing responses I’m using well constructed prompts. You can also ask It to respond with appsheet compatible json to make another appscript enter it as rows into Appsheet based on responses.
