+44 203 287 0899 info@solvaa.co.uk
: A laptop and plants on a wooden desk with grey wall, with text overlay saying ‘save contact form submissions in a spreadsheet’.

If you use a form on your website for visitors to contact you then you will usually get their details emailed to you so that you can then respond.  Whilst this works adequately as a lead notification system, what would be more useful is to save contact form submissions in a spreadsheet, database, or CRM.  This avoids them getting lost in your email inbox and reduces the risk of human error if you need to transfer them manually to your lead management system (even if that ‘system’ is just a spreadsheet!).  It’s a simple way of streamlining your business which will save you time and improve productivity.

Whilst some webform apps can do all of this for you, many don’t have Zapier integrations or their Zapier hooks form part of a premium version of the plugin so you have to pay extra to save the form data automatically.

We have a great solution, a simple single-step zap that uses an email parser to record form submission entries and then store them in a spreadsheet.  Although our example uses Google Sheets, you can also use Microsoft Excel or Airtable.  You could also send your leads to a CRM such as Hubspot, Pipedrive, or Dubsado.

All you need to do is set up an inbox filter to send web form submissions to a Zapier email address and the automation will do the rest!  The zap extracts the form data according to the rules you have set up, and stores it in the relevant columns in your Google Sheet.

The great news is that this simple zap can be created using the free version of Zapier, so there’s nothing to stop you giving it a try!

 

Our video demonstrates how to use an email parser to save contact form submissions in a spreadsheet

Our new video shows how to save contact form submissions in a spreadsheet using Zapier’s email parser.

The steps to save web form submission entries are :

  • Create a trigger event using the Email Parser by Zapier
  • We show how an email parser account manages the template for mapping data from the email to the spreadsheet
  • Create a spreadsheet row in Google Sheets which is populated with the mapped, parsed data

As we explain in the video, the data in your email needs to be formatted consistently for the parser to be able to send it to the right columns in the spreadsheet.  If you have more than one form then you could either set up separate zaps for each one, or could add a filter step to process the data correctly for each one.

 

Find out more

If you’d love to learn more about Zapier, including a deep dive into the email parser, then we are launching a course soon!  You can join the course waitlist here to be kept in the loop.

 You can also get our free quick-reference cheatsheet to Zapier built-in functionality just below:

Watch the video and subscribe to our YouTube channel

Save some time and download the Zap template

If you liked the video and can use process in your business, go ahead and download the ready-made template below. Once you have the template, just open it up in your Zapier account and customise it to your needs.

Save time and grab our pre-built Zap template

 

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 Zapier to save you time, reduce costs and keep you agile as you grow.

Related Posts

Yellow and orange post-it notes on a white wall, containing details of business tasks to be undertaken, representing a productivity concept. Overlaid text with ‘4 Productivity Tools That Will Change The Way You Do Business’ in black on a light blue background.

4 Productivity Tools That Will Change The Way You Do Business

As a business owner, life can get overwhelming. Between working on client assignments, running your own company, and maintaining some kind of family or social life, it’s almost impossible to do it all without a solid foundation and proper organisation. Productivity...
Concept of a sales funnel featuring small silver balls feeding into a metal funnel with a neat row coming out the other side. A red sign is pointing at the funnel which reads 'Leads'.

How to avoid losing leads

  Winning new business isn’t easy, so it’s vital to learn how to avoid losing valuable leads.  Sometimes you’re so busy juggling your everyday tasks that you neglect your prospects and ultimately lose them to a competitor.  Automation can be a game-changer...
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...
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...
Side view of a girl with a superhero cape, with Solvaa logo and text 'Become an automation superhero'.

Become an automation superhero with our free cheatsheet

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...

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...
A draft stamp on its side with the word DRAFT with the orange Zapier logo.

New cool Zapier feature coming soon : Zap editor Drafts (in beta now!)

If you’ve ever had to tweak one of your Zaps then you’ve always had to turn it off first, which is always a worry as you may be missing vital automations which should be triggering while you work on it. So, when we received an email from Zapier inviting us to take...
Blackboard with rainbow coloured arrows pointing right, with word PRODUCTIVITY drawn with chalk

How to be more productive in 2021

Have you thought about what it could mean for your business if you were more productive?  It’s sometimes hard to measure productivity gains, but think about how you could use the time you save by being more efficient in your business. Recently, our chief problem...
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...
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...
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...
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...
Female dentist examining a patient with a mirror whilst a male dental assistant looks on and smiles.

Client Success Story : How Ascent Dental Group saved many hours of manpower by automating their dental practice

Ascent Dental Group is based in the Midlands, with 36 reception and patient-care staff plus 35 dentists across four practice locations.  They wanted to implement automations to increase productivity, reduce manual administrative tasks and improve communication with...
Closeup of a section of a light grey keyboard with a blue ‘Organise’ button. Solvaa logo in top right hand corner.

How to organise your zaps

If you’re a new Zapier user then learning how to organise your zaps will help you manage them efficiently from Day 1.  As an existing Zapier user, if your zaps aren’t organised then you may find that it gets harder and harder to find the zap you’re looking for....
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...
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...
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...
Wooden blocks spelling 'LEARN' on a wooden surface with plain blocks in the foreground and background.

Free checklist to help you justify an automation learning budget

If you’re keen to learn more about automation then it’s likely you’ll need to justify the budget with your boss.   You may be competing with many other requests for finance so it’s vital to ensure you have a good business case. So where do you start?   We have the...
Group of young employees in a meeting room giving each other a high five.

Business owners : 5 Reasons why you must empower your workforce with automation

As a business owner, you're always looking for ways to stay ahead of the competition.  You may have heard about the power of automation and how it can help your business grow.  But you may be wondering: is automation really worth it?  Here are five reasons why you...
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

Shares