+44 203 287 0899 info@solvaa.co.uk
A laptop on a desk being used by a woman with fruit in the background. Overlaid with text which says : Optimising Xero to delivery cost and time savings. Includes a small Solvaa logo in the corner.

We love to share our success in helping clients improve their business because it demonstrates how spending a little time on process improvement and automation can deliver massive results.

IQ Glass is a great example of this, a business that had put all the right systems in place but they weren’t talking to each other.  Duplication of data entry was time-consuming, caused inevitable human error, gaps in the process, and lack of visibility across departments.  Some simple Zapier automations had been configured but the business required more complex workflow automations to fully optimise the applications and integrate them.  With our help, they save on average 45 hours per week, the equivalent of a full-time member of staff, delivering a host of other benefits such as providing up to date information in various apps that is visible to everyone and calculating overtime accurately.

IQ Glass: background and project objectives


IQ Glass are the UK’s leading architectural and structural specialist glazing company who work with some of the world’s leading.  They supply pioneering glass technology and offer a complete range of bespoke services, including the latest trends.  They use employed and self-employed glass fitters who are overseen by a team of project managers and supported by warehouse staff.  A sales and management teams are based at head office alongside others who perform administration and finance support functions.

They use Salesforce to manage sales leads, opportunities and projects, ScheduleIt to manage the workforce and organise each installation, FastField Forms for fitters and other staff to capture site reports, event logs, and timesheets, and the Microsoft Office 365 suite for email communication and admin.  However, there was minimal integration in place between the systems so staff had to rekey information manually, which was time-consuming and prone to error. IQ Glass wanted to streamline their business processes by fully integrating the applications to save time, reduce costs, and eliminate human error.

Group Operations Manager Hugo Cox defined the project goals and overall business requirements and then worked alongside Kelly Goss of Solvaa to improve each individual process by strategising and building the workflows.  We used Zapier, a no-code automation tool, to optimise key business workflows using its pre-built integrations with the aforementioned apps and the functionality of Zapier built-in apps.  We have helped IQ Glass build several complex Zapier automations to streamline their business processes, and there are currently on average 40,000 tasks running every month.  

Infographic showing the systems which have been integrated to represent the work by Solvaa to improve business processes and automating manual tasks for a featured case study, One Year No Beer. At the centre is a Xero logo which is connected by coloured arrows to other software such as Quaderno, Silversiphon, Stripe, Paypal, Shopify, an OCR application and a Pleo prepaid expense card. Text explains how the data flows between the systems and the human interactions that are required to initiate them.

Automating Salesforce sales and operations workflows

When webforms were submitted, new sales lead information needed to be entered into Salesforce manually. In addition, when sales opportunities converted into new projects in Salesforce the workflows to create records in other systems weren’t automated and tasks were often forgotten.  There was no overall visibility of information. Data had to be manually updated in ScheduleIt, Microsoft Excel sheets, and FastField Forms, causing delays and risk of human error.

We replaced Microsoft Excel sheets with Google Sheets where possible to utilise the vast array of Zapier + Google sheets trigger and action events, allowing for better automation opportunities than with Microsoft Excel.

The following Zapier workflow automations were implemented:

  1. When new webforms were submitted we used Zapier to automate the creation of leads in Salesforce. We used look-up tables to map differences in field entries between webform dropdown options and Salesforce field API names.
  2. When a new project is created in Salesforce create a new resource in ScheduleIt, a new Google Sheets row, add a look-up to a list (using a .csv upload) in FastField Forms so that it can be used immediately, and update the project status in Salesforce.
  3. When a project status is changed in Salesforce update the resource in ScheduleIt.
  4. When a field is updated in Salesforce initiate the relevant updates in ScheduleIt, Google Sheets and Fastfield Forms to keep the data in line across all applications.

Keeping all data in-line across the applications was crucial and ensured better visibility of up to date information in all the systems.


Automating purchase order workflows

When projects required glass to be manufactured, a purchase order needed to be created in Salesforce and sent to the supplier.  The purchase order processes involved duplication of data entry in different systems, with human error occurring as a result.  This was time-consuming, not only the manual task of keying data but also for investigating discrepancies.

The following workflow automations were implemented:

  1. When a new order was received by email, it is now parsed automatically to extract the relevant data and create a purchase order in Salesforce.
  2. When a FastField Form is used to capture purchase information, it is automatically used to create a purchase order in Salesforce.
  3. When purchase order documentation is attached to an email, it is automatically added to the Salesforce purchase order record.

Automating ScheduleIt event workflows


One of the most frequent tasks happens when ScheduleIt is updated with events, for example, to fit a product, make a site visit or update a job.  Before the processes were automated the data needed to be manually rekeyed in Salesforce to ensure the project record was kept up to date but this was time-consuming.  Every time a record was deleted in one system then it needed to be updated manually in the other.  An additional issue was that there was a mismatch between the project identifiers in the different systems, and also the timestamps were in different formats which made automatic data transfer complex.


The following Zapier workflow automations were implemented:

  1. When a site visit event in ScheduleIt is created, create a record in Salesforce and then loop back and update the ScheduleIt event.
  2. When an event in ScheduleIt is deleted, the site visit is automatically updated in Salesforce.


Automating FastField Forms lookup list workflows

There is a range of dropdown lists in FastField Forms, for example containing clients and projects, which need to be selected when filling in a form.  If these aren’t up to date then it’s impossible for fitters and project managers to pick the right one and therefore time is wasted while they wait to get it updated manually.  It is also a duplication of effort and prone to human error as the data needs to be entered in two places.

The following workflow automations were implemented:

  1. When a new supplier is added in Salesforce, add the details to a Google Sheet and update the FastField Forms list (using a .csv upload).
  2. When a new project is added in Salesforce, add the details to a Google Sheet and update the FastField Forms list (using a .csv upload).

Automating site event reporting workflows

Glass fitters routinely need to advise the administration team about issues such as damaged materials, including submission of photos taken on-site.  When they entered this data into FastField Forms it was not automatically fed into Salesforce where the customer and project records are stored.  It needed to be keyed manually which carried the risk of user error and also a time lag.

The management team had no visibility of progress, and events were not actioned as swiftly as they could be.  If fitters needed to include an image of a relating to an issue then it was a laborious process to attach the photo file to the relevant project in Salesforce.

New entries in form dropdown lists, such as a project references, needed to be added manually.  If there was a delay in this process then the fitters would not be able to choose the right customer when they were working on a job.

The following workflow automations were implemented:

  1. When a FastField Form for an event is submitted then the Salesforce record is updated.
  2. When various events are triggered in Salesforce, such as a project being added or updated, an email is sent to the relevant project lead or member of staff.
  3. When new projects are created in Salesforce, or an existing one is amended, the FastField Form lookup lists are updated automatically.
  4. When an inbound email is received, the image attachment is automatically saved in Salesforce.

Automating timesheet workflows


There was a significant manual effort involved in capturing the hours worked, calculating overtime and expenses for fitters, and also inevitable human error from rekeying data into different systems.  Data was submitted by email in a non-standard format, so it desperately needed to be organised and input into the timesheet systems automatically. The approval process was disjointed and often delayed.  Payments were at risk of being inaccurate and time-consuming to correct.

The following Zapier workflow automations were implemented:

  1. A Fastfield Form captures hours, overtime, and expenses, and this data is automatically fed into a Google Sheet.
  2. Calculations run automatically using Formatter by Zapier number formatting functions to give the correct overtime figures.
  3. Automatic reminder emails are sent to approve timesheets before deadlines are reached.
  4. Spreadsheet data is automatically updated when timesheets are approved.

Using Zapier built-in apps


We implemented several complex Zapier automations to keep the data in-line between Fastfield Forms, Salesforce, ScheduleIt, and Google Sheets. We also used Google Drive from storing file records and Microsoft Outlook for sending emails, as well as the following Zapier built-in apps:

Delay by Zapier to delay workflows to account for other automations running independently in a series of co-dependent workflows.

Email Parser by Zapier to extract data from emails before creating or updating records.

Email by Zapier to collect email attachments before adding them to records.

Filter by Zapier for basic conditional logic to ensure certain workflows ran based on specific conditions.

Formatter by Zapier to manipulate number, text, date/ time, line-item formats, look-up tables and spreadsheet-type formulas.

Paths by Zapier for more complex conditional logic to allow workflow to run specific pathways with action-based set conditions, for example when calculating timesheet combinations ensuring the correct type of work was recorded. 

Satisfied client


Our ongoing consultancy for IQ Glass has delivered measurable benefits in time and cost savings, as well as non-quantifiable gains that have delighted IQ Glass Group Operations Manager Hugo Cox and his team. Hugo reports time savings of 45 hours per week, “doing the work of a full-time employee who we don’t have to pay tax or NI for, doesn’t go sick, need holiday or occupy a desk!”

Hugo went on to list further business gains:

  • Significant systems and process improvements with increased visibility in all applications.
  • Better accuracy and timely approval of timesheet payments.
  • Data is accurate and there are no human entry errors.
  • Reduces likelihood of missed deadlines.
  • Scalable and repeatable.
  • Low maintenance.

He says “Kelly has been excellent at understanding the problems and quirks of the organisation, and identifying solutions or workarounds to achieve the aim. She also has a knack for understanding the key/actual requirements from a garbled verbal description from me of what I think I want! She gets the balance right between doing what is asked, and offering alternative routes to solving the problem. She is also open and honest about what is not achievable rather than saying ‘yes, no problem’ to everything. Similarly, she doesn’t try to sell you solutions to problems that don’t exist to gain extra revenue.  In summary, Kelly is very knowledgeable, helpful and a great asset to have contributing to your business.”

Read more about how our certified experts use Zapier workflow automations to simplify processes and increase efficiency.

Solvaa is a process and automation consultancy specialising in improving sales, operations and financial administration workflows. We help you to simplify and streamline existing processes, integrate your business tools to make data transfer more efficient and automate manual tasks to increase productivity. We are Zapier Certified Experts, Pipedrive Certified Experts and Xero Certified Advisors. 

Contact us today to discuss how Solvaa can help you simplify, improve and automate all aspects of your business with to save you time, reduce costs and keep you agile as you grow.

Related Posts

Mockup of a computer screen in an office with the Zapier homepage displayed on the monitor.

How to get started with Zapier

  If you’ve never used Zapier before then getting started can seem daunting.  Although the Zapier website has many examples of automations you can build, the most important thing to do before you even consider automation is to review your processes. If you’re...
Turquoise letters of the alphabet flying around randomly.

How to unlock the power of Zapier’s text formatter

If you haven’t used Zapier’s inbuilt text formatting function then you may be surprised by just how powerful it is.  Many zaps process character data in one form or another, and if the data isn’t ‘clean’ then it won’t look neat when it’s output onto invoices, used in...
Blue square with the text “How to automate a 7 day sales cadence of activities in Pipedrive” on a teal background with brass paperclips, a mug of black coffee, plant and a Solvaa logo.

How To Automate A 7 Day Sales Cadence Of Activities In Pipedrive

Creating a structured sales cadence is vital when prospecting for new business.  If you don’t follow up leads, or adopt a haphazard approach then they are less likely to convert into sales.  A sales cadence is a series of activities where you contact a person or...
A digital whiteboard depiction of a process, represented by virtual sticky notes showing a series of steps with Pipedrive logos above each one.

How to document processes and procedures

Learning how to document processes and procedures has a number of benefits.  It will save you time as you won’t need to think about what to do when carrying out regular business functions.  Your work will become more consistent as you will always be following the same...
View from below of five people joining hands as a concept of empowering employees with automation training and mindset.

How to empower employees with an automation mindset

2022 promises to be the year when businesses which adopt an automation mindset will thrive, not only from a more streamlined workflow but also from the resulting increase in profits.  Furthermore, employers don’t need to hire a huge team of developers to build...
Two toy metal robots talking to each other with a yellow background and blue overlay with white text which says ‘The Benefits of Business Process Automation’.

The Benefits of Business Process Automation

The benefits of business process automation mean that you can work smarter, not harder, which is our mantra and something that is easily achieved using the tools we discuss below.   What is business process automation?   Business process automation, or BPA,...
Infographic showing the outline of people in rainbow colours and rainbow-coloured cogs on a white background with black text saying ‘7 reasons to invest in your employees learning automation’.

7 Reasons To Invest In Your Employees Learning Automation

In today’s increasingly competitive market, businesses should be looking at ways to keep employees engaged as well as maximise profit.  One way of achieving both these goals is by investing in your employees learning automation.  Not only does it upskill your staff...
Solvaa blog header image: AI-tomation: How Zapier is using AI to make automation easy. Part 2 - Using AI to create Zaps and Zap actions

AI-tomation: how Zapier is using AI to make automation easy

Part 2 of our series of blogs on using AI in Zapier will delve into using AI to create Zaps and Zap actions. If you missed Part 1, which gives an overview of all the places that you can find AI in Zapier, check it out here: Part 1 - An overview of AI in Zapier In this...
Small wooden people are lined up to look like members of a membership, next to a sign which says MEMBERSHIP.

How to use Zapier like a boss to run your online membership on autopilot

If you're running an online membership, then you know there are a lot of moving parts.  From managing content to processing payments, it can be a lot to keep track of. But what if there was a way to put some of those repeat tasks on autopilot? That's where Zapier...
Concept of date time with a photo of a hand overlaid with a hand drawn calendar and clock in white.

How to express dates in Zapier

Once you start to unleash the power of Zapier you will more than likely need to schedule a step to run at some point in the future.  For example, you might want to set up a cadence of sales emails to follow up leads.   You may want to automatically create project...
Wooden blocks with black letters spelling MYTHS on a blue background with heading Business Automation above.

Busting Business Automation Myths : We Reveal The Truth

You’ve heard the hype surrounding business automation, but are these claims true? As a small business owner, you're always looking for ways to save time and streamline your operations. It's no secret that automation can be a powerful tool in achieving this goal. In...
Grey background with overlaid text which says ‘How to improve business productivity with automation’ with a polaroid-style photo of Kelly Goss and icons below for Spotify, LinkedIn and YouTube.

How to improve business productivity with automation

People often talk about improving business productivity with automation but don’t explain exactly how to do it.  Our founder and Zapier Certified Expert, Kelly Goss, recently appeared as a guest on the Habitz podcast to suggest ways that business owners and members of...
An image showing spring cleaning for your technology stack.

Spring clean your tech stack: how to review your apps to save money and boost efficiency

As the flowers bloom and the birds chirp, it's time for that annual ritual: spring cleaning. While you're tidying up your physical space, don't forget about your digital domain. Yes, we're talking about your tech stack. The term 'tech stack' refers to the suite of...
Blue background with electrical components arranged to look like robots with text overlay ‘Zapier Automation Project Showcase’.

Zapier Project Showcase

  We work with such a diverse range of clients, many of whom had never heard of Zapier before they connected with us.  We understand that you may be unsure what kinds of apps can be connected using Zapier so thought we’d share a showcase of some of our key...
A bookshop with an arm reaching out to choose a business book from the shelf.

Our 6 favourite business productivity books for overwhelmed business owners

If you're feeling overwhelmed by the day-to-day running of your business, you're not alone. Productivity can be a huge struggle for business owners, especially when you're trying to do it all yourself. That's why we've put together a list of our favourite business...
Featured image for blog post: AI-tomation: How Zapier is using AI to make automation easy. Part 4: No code? No problem. Build an AI chatbot using Zapier.

AI-tomation Part 4: No code? No problem. Build an AI chatbot using Zapier.

Zapier's chatbots feature has graduated from its first version into beta, so if you've been thinking about creating your own AI chatbot, now's a great time to take the plunge! In this article, we'll cover how to create your chatbot and everything else that you need to...
A laptop on a desk being used by a woman with fruit in the background. Overlaid with text which says : Optimising Xero to delivery cost and time savings. Includes a small Solvaa logo in the corner.

Client success story : How OYNB saves over £2800/month by optimising Xero

At Solvaa we love helping our clients streamline their business, saving them time and money in the process. A perfect example of this was our work with One Year No Beer where we helped slash 63% off their bookkeeping time, a massive 32 hours per week – nearly the...
Header image for the Solvaa blog post AI-tomation: how Zapier is AI to make automation easy. Part 3 - AI apps to turbocharge your Zaps

AI-tomation: how Zapier is using AI to make automation easy

Welcome to the third instalment of our series on leveraging artificial intelligence (AI) with Zapier. In this edition, we explore different ways Zapier supports AI, like OpenAI and ChatGPT. This blog post shows how 'generative AI' and automation can increase...
Decorative feature image for Solvaa blog post " Boost Your LinkedIn Sales: Streamline your sales process with Surfe and Pipedrive"

Boost Your LinkedIn Sales: Streamline your sales process with Surfe and Pipedrive

LinkedIn sales thrive on effective communication and relationship management. LinkedIn serves as a powerful tool for sales pros to engage with leads and nurture valuable connections, however, it's challenging to get your LinkedIn leads into your CRM in an automated...
Rear view of successful businessman relaxing in his office with his hands behind his head.

The benefits of automation in business

Everyone is talking about automation in business but many people aren’t sure what it actually means and what the benefits are.  It sounds really complicated and time-consuming, and (even worse) expensive!  Who would actually bother finding out?  We want to bust those...
Automate ebook

Get our free ebook

Learn about how business process automation with Zapier can help you to run your business on autopilot. The ebook is packed with real-life examples, use cases, and success stories. Whatever kind of business you have, you can use automation to help you work smarter, not harder.

Thanks! Your ebook is on the way.

Pin It on Pinterest