Examine the systems already in use

Native capabilities versus external middleware

Many smaller enterprises retain unused functionality inside their active software subscriptions. For instance, organisations that use Microsoft 365 frequently possess access to Microsoft Power Automate, which can transfer files, notify teams, and update SharePoint lists without incurring extra licence fees. Similarly, established CRM platforms like Salesforce contain sophisticated internal process builders.

Introducing external cloud glue such as Zapier or custom scripts should only occur when native capabilities cannot bridge system gaps. When an external consultant immediately recommends purchasing additional SaaS licences before auditing existing application features, business owners should pause to evaluate whether added software complexity is truly warranted.

The reality of spreadsheet dependencies

Microsoft Excel remains the primary operational engine for small businesses across the United Kingdom. While spreadsheets offer unmatched flexibility for ad-hoc accounting, they represent fragile integration endpoints. Unlike formal relational databases like PostgreSQL, desktop spreadsheets lack row-level locking, schema constraints, and reliable change audit logs.

When consultants build automated flows on top of unmanaged shared spreadsheets, concurrent edits by staff can corrupt records or cause webhook triggers to fail silently. Prior to building automation pipelines, advisory work should focus on converting critical spreadsheet records into structured tables or relational database schemas.

Core system integration characteristics

Review how common workplace platforms behave when exposed to automated data transfers:

Microsoft Excel

Excellent for internal calculation and presentation; susceptible to formatting inconsistencies and concurrent write conflicts when used as an automation data source.

Salesforce

Robust API infrastructure with strict rate limits and permission profiles; requires thoughtful mapping of custom fields and validation rules.

PostgreSQL

Standard open-source relational database; provides strict typing, foreign key constraints, and transactional consistency suitable for backend workflow data.

Webhooks & REST APIs

Lightweight web messaging protocols; ideal for event-driven updates, but require error handling and retry queues when endpoints become temporarily unreachable.

Access permissions and operational security

External automation consultants frequently ask for broad administrative credentials to inspect systems rapidly. Granting universal administrative tokens to outside contractors introduces significant risk. Small businesses should maintain discrete service accounts with least-privilege permissions, ensuring that automated scripts can only read or write to designated tables.