Graben · Berner Oberaargau
(01)  —  AUTOMATION AND CUSTOM SOFTWARE FOR SMES

Fewer repetitive tasks, fewer manual handoffs, less friction.

Lightnet automates recurring work with PowerShell, connects systems via API, and builds lean tools when standard software does not fit.

  • PowerShell & scripting
  • REST APIs & webhooks
  • Desktop & web tools
Our approach

Small maintainable solutions instead of large platforms

We build targeted tools: exactly what solves the bottleneck – nothing more. The result: tools you still understand two years later.

It starts with a conversation about the actual workflow: which data flows between which systems? Where do duplicate entries, copy-paste chains, or manual checks happen that could run automatically?

Then the right solution is built: a PowerShell script as a scheduled task, a background Windows service, an API integration between two systems, a WordPress plugin, or a small desktop app with a database.

  • Analysis of the real workflow, not just the UI
  • Smallest sensible solution, not maximum platform
  • Documentation and error handling built in
  • Handover that keeps the solution maintainable
Process automation with PowerShell and APIs
Scripting, APIs, and custom software for SMEs
POWERSHELL & AUTOMATION

Automate recurring Windows and AD tasks

PowerShell is the sharpest tool for anything around Active Directory, file systems, reporting, and scheduled workflows.

01 · AUTOMATISIERUNG

Active Directory

User provisioning from CSV, password resets, group memberships, Microsoft 365 licence assignment, automatic deactivation on exit. Onboarding in minutes instead of across several consoles.

02 · ORDNER

File operations

Bulk processing: rename, move, archive by age, unzip, convert, set NTFS permissions. Runs once scheduled, not manually every week.

03 · REPORTING

Reporting

Daily or weekly email reports: backup status, disk usage, failed logons, expiring passwords. Visible instead of invisible.

04 · ABLÄUFE

Scheduled jobs

Time-based routines via Task Scheduler: nightly archiving, weekly exports, monthly cleanups. With logging and failure notifications.

BACKGROUND SERVICES

When a scheduled task is not enough

For always-on logic we build small Windows services with a clear purpose – stable, observable, maintainable.

01 · SERVICE

Windows services

Custom .NET or PowerShell-based services for always-on logic: folder watching, inbound file processing, continuous sync between systems.

02 · MAIL

Email automation

Automated sending of status reports, warnings, and summaries. Incoming mail as a trigger for downstream steps, e.g. invoice filing in SharePoint.

03 · MIGRATION

Data import/export

Exchange between CSV, Excel, SQL Server, MySQL, APIs, and legacy systems. Clean error handling instead of silent failures.

APIS & INTEGRATIONS

Connect systems instead of maintaining duplicate data

REST APIs, webhooks, and classic import/export flows as a clean bridge between accounting, CRM, ERP, webshop, and internal tools.

01 · WEBHOOK

REST API integration

Connections to accounting (Bexio, Abacus), CRM (HubSpot, Pipedrive), ERP, webshop (WooCommerce, Shopify), and other systems with clean auth (OAuth, API keys).

02 · HYBRID

Data synchronisation

Customers, products, orders, invoices aligned between systems – one- or two-way, with a clearly defined master system.

03 · AUTOMATISIERUNG

Webhooks & events

Real-time reaction to events: a new order triggers a notification, a paid invoice updates the CRM, a stock movement triggers replenishment.

04 · REPORTING

API documentation

For later maintenance and extension: endpoints, parameters, expected responses, failure modes. So the next developer understands what is running.

Desktop applications

Windows applications for specific requirements

When the team needs a clear, recurring tool that no standard software covers well.

Typical examples: an internal inventory manager, a customer database with field mode, a job-reporting app for construction sites, or a configurator for product variants. Built as a lean Windows app that does its job – and nothing else.

Database backend per scope: SQLite (local), SQL Server, or MySQL. Multi-user capable, with clean permission logic, automatic update mechanism, and logging for diagnostics.

  • Inventory, customer DB, job reporting, configurators
  • Database: SQLite, SQL Server, or MySQL
  • Multi-user with permissions
  • Update mechanism and logging
WEB DEVELOPMENT

WordPress, dynamic forms, and customer portals

When the website needs to do more than display content – custom functionality instead of plugin sprawl.

01 · WEB

WordPress development

Custom plugins, custom post types, WooCommerce extensions, theme adjustments. A clean solution instead of 30 plugins that block each other.

02 · AUTOMATISIERUNG

Dynamic forms

Multi-step forms: configuration, ordering, application with file upload, contact forms with validation and automatic forwarding into CRM or SharePoint.

03 · SCHUTZ

Customer portals

Login-protected areas with roles: document downloads, order history, support tickets, and group-specific price lists per customer segment.

RELATED TOPICS

Individual development building blocks in detail

Custom software is not a monolith – the individual parts can be combined exactly where they fit.

01 · WEBHOOK

APIs & interfaces

REST, SOAP, CSV exchange and webhooks between ERP, CRM, shop and line-of-business software – cleanly documented.

02 · AUTOMATISIERUNG

Desktop applications

Windows tools in .NET/C# for specific workflows that standard software cannot cover cleanly.

03 · AUTOMATISIERUNG

Dynamic forms

Multi-step forms with validation, file upload and forwarding into CRM, SharePoint or by email.

04 · SERVICE

Windows background services

Services for automated imports, exports, scheduled processes and integrations – running quietly in the background.

05 · MIGRATION

Data import & export

Migration, synchronisation and interface jobs for Excel, CSV, XML, JSON, SQL and line-of-business systems.

06 · WEB

WordPress development

Custom plugins, custom post types and WooCommerce extensions – a clean solution instead of plugin sprawl.

FAQ

Frequently asked questions

When does process automation start paying off?

As soon as a task is recurring, has several steps, and is error-prone, automation pays back quickly. Rule of thumb: if the same clicks happen every week in the same order, that belongs in a script.

Do we need to introduce a whole new piece of software?

Usually not. Often a PowerShell script, a Power Automate flow, or an API integration between the systems you already have is enough. We only propose a custom tool when existing paths truly do not work.

Can existing systems like Bexio or Abacus be connected?

Yes, if a documented API or an import/export path exists. Bexio, Abacus, HubSpot, Pipedrive, WooCommerce, and Shopify all have REST APIs. We check up front which data is available and what is realistically automatable.

Who operates the solution later? Do we become dependent on Lightnet?

No. The code belongs to you, is documented, and uses standard technologies where possible (PowerShell, .NET, WordPress, SQL). You can continue operations in-house or with another provider if you want.

What happens when requirements change later?

That is exactly why we build small and maintainable. Extensions are planned as the next step – not anticipated as theoretical flexibility nobody ever uses. That keeps the solution understandable and the cost in check.

Is there support and maintenance after delivery?

Yes. Smaller adjustments, new requirements, or fixes happen either on time and material basis or under a maintenance agreement. The solution is not simply handed over and forgotten.

Contact

Do you have processes that waste time every single day?

We review where automation and integration will have the strongest effect without making your stack harder to maintain.