+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

Solvaa blog header image: Automate sales and marketing to make your holidays more jolly

Marketing and Sales Automations to Make Your Holidays More Jolly

Between Black Friday, Thanksgiving, and the holidays, November and December are busy times for businesses. Your busiest days may be yet to come, but if you want to get ahead, you need to start preparing as soon as possible. This post offers tips for automating and...
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...
Toy robot on an orange background with the text “What are the benefits of using Zapier” in black along with a Solvaa logo.

What Are The Benefits Of Using Zapier?

If you’re wondering how Zapier can benefit your business then think about what your ‘pain points’ are, because the chances are it can address many of them.  Most people do not sail through the day, working in the most streamlined, optimised manner possible.  I would...
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...
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...
Closeup of computer keyboard with blue ‘survey’ button between the A and D letters.

Our business survey reveals that business owners are keen to automate

We recently conducted a survey of business owners, employees and entrepreneurs to get a better understanding of their attitudes and plans regarding automation.  We were delighted to find that the vast majority of respondents are keen to automate parts of their...
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. ...
Illustration of a messy office with stacks of paperwork on the floor and a vintage robot working behind the desk

How did Robbie the Robot reap the benefits of automation?

  You probably keep hearing about the benefits of automation but wonder how they can help you and your business.  Whether you’re a one-person-band or a large organisation, automation can be a real game-changer, but it can feel like a big step when you’ve got a...
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...
A piece of corrugated card with the text Process Automation on it, alongside a black market pen and some wooden discs with letters printed on them. This is overlaid with text which says : Automate tasks using Zapier : 5 quick wins! Includes a small Solvaa logo in the corner.

Automate tasks using Zapier : 5 quick wins!

Running a business can be a rewarding experience, but there’s no doubt that there are certain processes that take up far too much time.  Manual tasks that seemingly only take a couple of minutes can soon add up and often require a follow-up action too. For example,...
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...
A man typing on the laptop with floating email icons

Client Success Story : How Summerley Recruitment automated their email chasers and saved hours of manual work every week

We love sharing customer automation success stories with you because it shows how other businesses are using Zapier, and how a sprinkle of Kelly’s wisdom can be a total game-changer. Summerley Recruitment is a busy recruitment agency which spends the winter months...

How to automate thanking your customers for paying their Xero invoices

Learning how to automate sending an email using Zapier when a Xero invoice is paid is a really simple but useful workflow that saves time and provides great customer service. Xero is a cloud-based accounting system which includes a host of features to reduce...
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...
Mobile phone with a ‘new message received’ message with a cursor hovering over a ‘show’ button and thumb poised to select it.

How to harness the power of automating text messages using SMS by Zapier

Automating text messages can be extremely useful in business, and using SMS by Zapier is really powerful, easy – and free! In this article we cover the following: Why is SMS such a powerful business tool? What is SMS by Zapier? What could I use SMS by Zapier for? What...
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...
Side view of a girl with a superhero cape, with Solvaa logo and text 'Become an automation superhero'.

Become an automation superhero with Zapier

Although Zapier is brilliant at connecting the apps you use every day, it also comes with over 20 inbuilt functions which will help you become an automation superhero in no time! These functions are a range of helper apps that we’ve listed on our free cheatsheet which...
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...
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...
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...
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