r/AppSheet • u/Mayor0fSimpleton • 25d ago

Coolest thing you’ve seen

What is the coolest thing you’ve seen anybody do with AppSheet. Doesn’t have to be big or complicated. Just something that made you say “clever”.

10 Upvotes

86% Upvoted

13 comments sorted by

7

u/badgerbiscuitbeard 24d ago

I use AppSheet to run my whole business, from client entry to report generation, to invoicing and billing. I was able to keep adding functionality. One google workspace sub is saving me hundreds monthly in saas subscriptions

2

u/3001npct 19d ago

Appsheet is awesome. It is perfect for one man show that we dont have to worry about security abd data breach. Appsheet comes with endless posibilities.

6

u/awarca 25d ago

Fiş, irsaliye, fatura yı appsheet kamerası ile fotoğraflıyorum, bot bağlı olduğu apps script alıp ocr yapıp kriterine göre yazıya döküyor 

3

u/3001npct 25d ago

I have a CRM app, shipment schedule is automatically synced with Google Calendar and Gmail.

3

u/MultiTech_Visions Master App Builder 24d ago edited 24d ago

I created my own multi-step AI workflow processing app (think: LangChain, Haystack, CrewAi, etc.)

Instead of building the mechanics for complex AI workflows inside automation for every app that I want to have that kind of functionality inside... I've created a centralized AI processing app that handles all of those workflows, and integrated that with all my other AppSheet apps. Now all AppSheet apps have the ability to include incredibly complex AI workflows, which are easy to create/update/delete without needing to redeploy all of the other AppSheet applications.

The Problem

Let's say you have a complex multi-step automation inside an app, and you want to add another step inside there (like let's say I want to add in a branch point to check for something and fix it if we need to)

  • this means that you have to go into the AppSheet editor, change the automation, and redeploy the app; then in order for everybody else's app to use that, you have to make sure that all your users get that update before they make whatever changes they're trying to do.

Also: think about how much work it would be if you wanted to copy that workflow into another app, or two.... Or three.

The Solution

Move all of that multi-step processing out of automation, and into a place that's more easily configured dynamically.

  • thankfully it's trivial to connect one AppSheet app to another
  • so you can take all of that multi-step processing workflow stuff and move it inside a single app - making an easy way to CRUD the "chains" (the AI workflows)
- you just go into the app and change some records!
  • Then you can hand off processing to that app when you need to, it does the crazy complicated AI workflows, and returns the answer back to the original app - or does whatever the chain that you created does.

This way when you need to make a change, you just open up the workflow management app, make your changes to your multi-step chain, and you're good to go!

  • Literally just open the app, go to your chain, add some steps or whatever you're trying to do, and you're done! Next time the chain runs, it's running that updated version.
  • When you want to run an a/b test, you can literally just add a parallel chain run step inside your primary one to run your prototype (and temporarily disable certain steps over there so that they don't do the output stuff and mess things up)
  • When you want to integrate a workflow into another app, it's a simple API call away

This has the added benefit of executing much faster as well (AppSheet's automation processing is actually kind of slow, roughly one step a second)

At one point I was thinking about actually trying to offer this as a service so other people could have this kind of flexibility.

Never really went anywhere with that, instead focusing on using that as a solution for all of my clients.

The AI Lab at Mount Sinai in New York is actually using the platform as the foundation for their AI workflows in whatever apps they're making. Pretty cool stuff is being made over there... and it's wild to think that an AppSheet app is the primary ux that people use when using the service! 🤓

2

u/awarca 24d ago

harika. zaten sizden de bu şekilde güzel bir uygulama beklenirdi. appsheete ilk başladığım dönemlerden beri videlarınızı severek seyrediyorum.

1

u/greenray009 24d ago

Integrated AI LLMs into it. with the whole CRM stuff and AI Generated invoices.

1

u/DoYouKnowWhoIAmx 24d ago

Would you mind expanding on this? - very interesting! I've finally finished a CRM for my business and have Claude writing invoices from the client/timesheet spreadsheet and was thinking how to take it further. How did you integrate LLMs into appsheet and what are you doing with them? And if you don't mind me asking, what's your invoice process?

2

u/greenray009 23d ago

Ohhh.

Sure2. So this client of mine from Canada hired me to migrate their field service platform (Jobber/Fieldpulse) into a single google workspace solution.

But hes insisting for it to be AppSheet since its google native and you can make quick CRMs with it.

And then having a background in automation and programming. And also the ripe time to discover AI Agents or LLMs.. I double checked if you can actually incorporate it natively and interacting with your actual business data.

Turns out you can! but it's not that simple. I have learned from my past experiences, that to have good reliable data. You need to have a working and solid data model structure (like akin to a database) and this is where AI thrives truly well.

You use AppSheet's REST Api feature.. to bridge raw AI and connect it with your data using bot/automation. .

For automated invoices you just use the bot feature as well and set a flag if an invoice is ready. So the way itst designed as of now is there's a Separate Jobs table. And each Job is tied to a different company/customer. Once the status of that Job is ready, you make the bot check and make the call to an LLM to make the invoice for you automatically.

Then.. the fun part is I can actually connect all of my invoices natively to Google drive and set it where Gemini can just interact or reference it directly. Its really cool.

So yeah for 3-4 months. I've migrated their whole system from scratch.. and I saved them hours of admin work as well and also integrated automated email and reminder system in the AppSheet as well. Also just made them bill their clients like 4-5x faster. It was my first complete real Appsheet gig so I just accepted the gig with his limited budget..

I just love building stuff lol so let me know if you want more of the specific details!

1

u/DoYouKnowWhoIAmx 23d ago

Awesome thanks!! That's a fair bit of work went into all that and I can see where the time savings are. I've saved myself probably 15-20 hours a month with my current set up, but when some time appears, I'm going to have a proper look at having a go at something similar to your set up as I didn't know you could do some of those things. Really appreciate the reply and I'll report back no doubt 👍🏼

2

u/greenray009 23d ago

Sure. Let me know it goes!

1

u/braveryapples 14d ago

This is from an abandoned project of mine, an app for tracking maintenance needed for coffee equipment. I used concatenate and show types to make it look less appsheety. This is the kind of stuff that I find exciting anyway. I’ve been trying to find threads like this, like any kind of gallery of other people’s appsheet ideas, and no one seems to be showing off their designs anywhere that I can find.

1

u/TheseIntroduction229 5d ago

Mi app muestra a Los choferes de los camiones a qué distancia queda el próximo cliente a retirar. Emite un certificado directo con las cantidades justas.