+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

Virtual assistant concept featuring a young woman with background of illustrated icons including 'like', 'share' and other digital marketing themes.

How To Use Zapier As A Virtual Assistant

So many people are choosing to be Virtual Assistants these days, as it is a flexible freelance role that is packed with variety.  There are many different types of VA, for example, Social Media VAs, Marketing VAs, Technical VAs, and eCommerce and Finance VAs. ...
Illustration of online course concepts including book, pencil, cloud and microphone, with photo of hands holding a smart phone with finger poised on the screen. Light blue background with Solvaa logo in bottom corner.

Why online course providers should learn Zapier

As an online course provider, you wear many hats, juggling the tech, finance, customer service and marketing functions, to name but a few.  Unless you are well established and have a team, then it can be overwhelming being responsible for so many tasks yourself. ...
Concept of business meeting showing an overhead shot of hands from a group of business people looking at a colourful report and pointing their pens over it.

How business owners can benefit from no-code workflow automation in 2022

Everyone is talking about the no-code revolution and “no-code” is one of 2022’s most common business buzzwords.  But what exactly is “no-code” and how can no-code automations help business owners?   What does no-code workflow automation mean? A no-code solution...
Computer keyboard with a large blue Help button with the letters lit up and shining upwards.

How to get help with Zapier

If you’re just starting out and need some help with getting the best out of Zapier, or you’re simply stuck and don’t know where to turn, then we have some useful resources for you. Zapier’s Zap Editor has a help icon at the top (the blue question mark button) which...
Flatlay showing a computer keyboard, notepad and pen with text overlay “Calculate lead to customer conversion times”.

How To Calculate Lead To Customer Conversion Time

When you’re running a business it’s important to stay on top of your figures, and you should measure key performance indicators to review performance and plan for the future.  One of these metrics is the lead time from when a prospect is created to when they become a...
Flatlay of a macbook, glasses, coffee and plant on a dark desk with overlaid text saying 'Trello checklist for social media engagement'.

How to automate creation of a Trello checklist for handling Twitter engagements

Keeping on top of your social media accounts can be extremely time-consuming.  It takes so much longer than you think to create content and post it, and you can then waste hours on engagement. If you regularly nip in to check for comments then you can easily fall into...
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...
Cover of the book ‘Automate it With Zapier’ with byline ‘Boost your business productivity using effective workflow automation techniques’ by author Kelly Goss.

Automate It with Zapier Book

Writing a Zapier book was a natural step for our founder, Kelly Goss as she is so passionate about helping business owners increase productivity in their companies.  As a Certified Zapier Expert, Kelly is the perfect person to impart everything she’s learned using...
Image showing a flatlay laptop with bulldog clips on a white background with overlaid text in a blue section which says “Add contacts to your email marketing tool from your CRM”.

How To Automatically Add Contacts To Active Campaign From Pipedrive

It’s never been more important to keep in touch with customers, and if you’ve ever wondered how to automatically add contacts to Active Campaign from Pipedrive then we have a really simple solution. As many CRMs don’t have built-in email marketing modules there are a...
Desk flatlay with yellow coffee cup, yellow notebook on a white background with white text on a blue shape saying “Create and send a sales proposal from your CRM”.

Create And Send A Bespoke Sales Proposal PDF From Your CRM

When you need to create and send a bespoke sales proposal PDF from your CRM, you can either shell out for software that will do it for you, do it completely manually or let Zapier do it for you. Automating this task is really simple and will save time, money, and...
Concept of time with a clock face showing the time at 11:54 and the days in a calendar..

How to use Schedule by Zapier like a pro to run workflows regularly

The brilliant thing about Zapier is that as well as triggering automations when events happen in your apps, you can also make things happen when YOU choose, thanks to Schedule by Zapier. Imagine if you wanted to receive a list of your sales every evening, or get a...
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...
Wooden desk with a laptop, phone and stationery with blue square featuring the text “How to send a daily digest of all paid Xero invoices using Slack”

How to send a Slack message with a daily digest of paid Xero invoices

Using Zapier to send a Slack message with a daily digest of paid Xero invoices can provide useful data which is sent to your team automatically.  Knowing when invoices have been paid is business-critical information, but it can be time-consuming to check your...

The Advantage Of Automation

Our Chief Problem Solver, Kelly Goss recently joined Shelley and Jo on the Virtually Amazing podcast to talk about the advantage of automation and how it can help businesses.  They also discussed how automation skills can be used by VAs to broaden their service...
Red toy robot writing on a blackboard with chalk, with text A Simple Guide To Zapier on the blackboard.

A Simple Guide To Zapier

If you’re wondering what all the fuss about automation is then here’s our simple guide to Zapier. We will explain how it can save you hours of time that you can spend growing your business, being creative, or simply reading that book that you haven’t got around to...
Mocked up book cover with a background of shades of teal in a geometric pattern, a retro robot image and a title "Automate!" with a subtitle of "The essential guide to business productivity", written by Kelly Goss with a Solvaa logo.

Download our free automation ebook

Do you feel overwhelmed and busy ALL THE TIME?   Do you wish you could afford another pair of hands to do the boring, mundane tasks that suck up your time? I have the answer! I’m Kelly Goss, founder of Solvaa, business process automation specialists. It’s no...
Vintage blue toy robot isolated on a white background with black text “Will Zapier work for my business?” and Solvaa logo.

Will Zapier work for my business?

We get asked a lot whether Zapier will work for a particular business, because maybe some of the use cases we talk about don’t necessarily translate exactly to a particular sector.  Maybe you have a service-based business but have seen more product-based business case...
Businessman holding a mobile device with automation concept and text which says ‘Marketing Automation’.

How to use Zapier to automate your marketing processes and win more business

Are you tired of doing the same tasks over and over again every day? Do you wish there was a way to automate some of your marketing processes? Well, there is! With Zapier, you can connect different applications to create automated workflows. This can save you time and...
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...
Businessman in a meeting holding a tablet which shows pie charts and bar graphs from a Powerpoint presentation.

What operations processes can be automated?

Your operation is the engine room of your business and automating the processes there can free up valuable time to spend winning more business or serving your customers better. If you’re wondering what operations processes can be automated then we have plenty of...
Get our free 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