#One cool automation you built?

35 messages · Page 1 of 1 (latest)

mild valley
#

What's the smartest automation you've built for yourself?

#

For me, it's a straightforward one that saves me (and my colleague) a lot of time:

  1. Triggers when an email is received in a shared Exchange email inbox
  2. AI checks if it can be answered automatically, e.g., if a person asks for help with a specific problem, they receive an email with a short message and a link to this community
  3. Power Automate with AI guides the remaining to the correct inbox
  4. If in doubt, send a Teams approval message to let the user decide what to do with the email (e.g., manual answer or forward).

But I built plenty, also for automating my LinkedIn work 😄

#

One cool automation you built?

buoyant coral
#

My company works alot with Amazon as a vendor.
We receive about 80 invoices from them each month for activities relating to marketing and agreed fees we pay them for services. As we are a listed company we have to have these audited and processed through our SAP system before the close of each month and the detail required is substantial.

I have a Power Automate Desktop program which recovers the invoices from inbox to a folder. they are then processed manually for any issues we see like over claims ect and then once approved they are processed by PAD through the submission process. What used to take a day takes less than an hour by PAD.

Once processed they go into a teams approval system before getting sent via a daily output which auto uploads them into SAP for clearing.

I made all that (Y)

#

Oh and in another one - this is even cooler i think.

Some of our sales reps have multiple invoices to process and the form filling is laborious for them as they don't have automation abilities and i'm not setting that up because its a pain in the d*** for people who can't do a vlookup let alone run something like this.

I created a http request trigger and an excel file which they can fill in and a macro which sends a HTTP post to the form with all the data.

mild valley
buoyant coral
# mild valley Good one. What happens if they misspell in the Excel sheet and either do not rea...

there is 3 columns which are guided using a list to provide the input (payment type, country code and channel)
the rest are free text.

There is validation which shows any empty columns in red through conditional formating and then when the macro runs it checks any required columns and if they are empty it fails, gives an on screen message and updates the status column with missing values and then goes onto the next line.

Once its in power automate it also processes the input again so if the customer number is not a known customer number for example it will fail and send them an email, or if the invoic enumber is generic (AAAAA) instead of an actual invoice number then again it wil fail and send an email.

cunning harness
#

I did ot yet. But I am planning this week to have an automation that will fill up car number plate information for our Apartment complex's parking system since our relatives are visiting us often 😄

#

Tired of manually typing that

rigid lance
#

I build few automation but not with RPA tool, i am n8n developer and I developed:

  • system to do timesheet review for of there employees

  • build system to post automatically on linkedin and x/twitter everyday based on client requirement

severe lodge
mild valley
shy elk
#

In the process of building so idk if it counts. But we use a lot of windows vms for automation estate. I am building a tool. That after running a job it deallocates and shutdowns the machine. And when a job needs it turns it back on with the correct resources. This will use runbooks and uipath orchestrator.

severe lodge
split siren
#

The company I work for has to send out invoices through a web portal that doesn’t have an API or any way to programmatically create the documents, and doesn’t easily support reporting on what has already been sent. Using PAD, I set up an automation that queries our SQL database for all invoices that have been posted in the last week, scrapes the portal for invoices that were sent during that time, grabs the header and line item info for each one that needs to be created, then loops through them and creates them in the portal using RPA. I build it early in my RPA journey and even after iterating quite a bit it’s still not the prettiest / most robust automation, but it’s saved our invoicing team tons of time and repetitive entry and I’m pretty proud of it.

winter dragon
#

Hello, for the context, I work in a logistics departement.

  • I created a sap bi report on specific items open orders that is sent everyday on a SharePoint folder
  • Then a power automate cloud flow reads the report, compare the item numbers in the report, will check in a SharePoint data base if there is a picture named for all the items, and if not, it will send an automatic mail to our warehouse so that they take a picture of the item.
  • Once they answer, the picture will be integrated directly in the SharePoint data base with another PA flow.
rocky void
#

Building an automation for supply chain that parses freeform text to structured text using AI Foundry (or Microsoft Foundry, can’t tell what MS rebranded it 😂). Combining it with pydantic for fixed json output and more validation logic in my code. Valid work orders are posted in ERP system and non valid ones are flagged.

rose axle
#

This is a workflow i built recently using make.com.
It's all about a workflow i built for my client who is a principal for extra coachig lesson.
The workfflow starts with a webhook to an onboarding form built on Gohighlevel and then create a new lead in Airtable which serve as the database, then with the information in the database, created a new group chat individual student where the parent, student, tutor and prncipal (my client). and also the tutor to be added to the group will the selected automatically and randomly through a logic conditioning to meet certain conditions.

I built alot more scenarios for my client, but i will stop at this for today.
Y'all should have a good day!

Webhook_to_Airtable_to_Classcard_Api_to_Whatsapp_Group_Complete_Onboarding___Make_2.png
rare venture
#

Really nice

#

I mainly work on n8n. It's really useful and easy to learn.

naive flint
#

My son and I built a tool for monitoring RPA workflows. So instead of having to check that a job started on time, or finished on time the worklows ping back to our service and the service will let us know if one of the workflows missed its expected heartbeat. So far we've used it with UiPath, next will use it to monitor n8n flows.

naive flint
# mild valley For me, it's a straightforward one that saves me (and my colleague) a lot of tim...

Nice! I'm working on something similar next. Handles emails and determines intent and updates an internal tracking tool. Monitors customer and partner responses and if it doesn't fit nicely in one of our intents that we know how to handle we escalate for human support.

I too will be doing some LI out reach to people in the RPA community (sorry in advance ???) But I wouldn't do it if I didn't think our other product couldn't help you 🙂

spring maple
# mild valley What's the smartest automation you've built for yourself?

I have so many cool flows both on the cloud and on desktop but one that gives me a buzz everytime I initiate it is this. I screen shot a transfer from on customer to another as a gatekeeper of asset transfers and then I save it into a folder (keeping the current date and time stamp. the flow activates and does several thing. It sends an email to the Sample team and then moves it ot another folder on OneDrive. This then does the same trigger to another flow which sends a different email and has links to this second folder. It also then sends an email to a manager to keep track of asset movements. This saves me time and increases communication across different teams in one foul swoop

viscid quiver
hallow laurel
#

I also built a couple of automations using Power Automate that were pretty decent:

  1. Help Desk Ticket System
  2. User Onboarding Flow
  3. Scheduled Flow to grab Azure DevOps tasks and add to Project Operations
  4. Phish Email Analyzer
vast plinth
mortal lance
#

I built my own process mining solution so I can find automation ideas with data

mild valley
naive flint
# vast plinth Have you used it with Power Automate Desktop?

Not as yet, I haven't used PAD recently.
Do you want to give it a try ??
I've tried to make this as simple as possible without having to get SECOPS involved... Your workflow only needs to make an API call out and you have 100% control of the data always, and there is no need to send any data to our system.

pliant bay
#

I built a self-managed automation using n8n that integrates lead sources, AI-based classification, CRM pipelines, and calendar scheduling. It includes conditional logic, retries, and alerts, so it’s resilient and production-ready.
The key value wasn’t just automation, but reliability.
I added error handling, retries, and notifications so I always know if something breaks. It saves me several hours each week and ensures nothing slips through the cracks.

mint fern
#

I built an automation that scrapes targeted websites, normalizes messy data, handles errors and retries, and then exports clean datasets. I can adapt it easily for different sites or data needs, which saves a lot of time.

mental barn
#

I built a solution in Power Automate Cloud last night to handle event registrations. Participants register in a Microsoft Form, which triggers an approval/rejection for me on Teams, and then sends a personal acceptance or rejection email to the participants. Finally, it reports everything back to me in an Excel sheet. I could not be prouder 😃🤓. I was looking into using an event software like Eventbrite for this, but a particular colleague you guys might know challenged and supported me to build it myself.

mild valley