+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

More Youtube tutorials

We have other Youtube video tutorials which will help you work smarter, not harder.

Our other resources

We also have plenty of free resources:

And finally, our founder / chief problem solver / chief automator Kelly Goss’ new book, Automate It with Zapier, is out now and is the most comprehensive Zapier guide on the market. It will get you up and running and to the stage where you can build and debug advanced automations. Buy your own copy today directly from publisher Packt using this link.  Or here are links to Amazon (.co.uk) and Amazon (.com) if you prefer.

 

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

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...
Close-up of a businessman's hand placing the roof on a house made out of building blocks.

How can I use Zapier’s Sub-Zap feature to save time with automation?

One thing we love about Zapier is how it is constantly evolving and introducing new features, like the new Sub-Zap function. Sub-Zap by Zapier is one of the built-in tools which Zapier developed to supplement the functionality that your other business apps provide....
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...

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...
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...
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. ...
Flatlay with notebooks and pens, plant, glasses and text overlay which says ‘Supercharging Productivity With Automation Masterclass’

Free Masterclass: Supercharging Productivity With Automation

  Our Chief Problem Solver, Kelly, recently had the pleasure of speaking at the Practically Perfect virtual summit for assistants, talking all about the tools and technologies which can help VAs, executive and personal assistants to boost efficiency. If you’re a...
Closeup of a man's hand over a laptop keyboard with a blank blue screen and folder and document icons floating over the screen.

How to boost productivity using Zapier to automate Google Docs

Creating documents is something that most businesses do every day, and it can be a time-consuming, manual task which is prone to error when the text or data is input incorrectly. Copying data from one app to another is so inefficient and the time wasted could be...
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. ...
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...

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...
Pages from a calendar with heading of ‘Four Day Week’ and a fountain pen.

How to make a 4 day working week more productive

Many UK businesses are participating in a 6-month pilot programme for their employees to work a four-day week but get the same pay and benefits that they would if they were full-time. It might sound too good to be true but the expectation is that increasing...
Blog featured image for Solvaa blog post Using business automation software and excited to automate something new? Do these things first!

Using business automation software and excited to automate something new? Do these things first!

In the ever-evolving landscape of business processes, automation has become the cornerstone of efficiency and productivity. In this post, we'll delve into the art of enhancing your existing automation infrastructure by seamlessly integrating new automations into the...
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...
Businesswoman at an office desk with six arms to represent productivity. She holds papers, a phone, a landline phone and laptop in her many hands.

The best productivity tips in 2022 : tried and tested productivity hacks

As a small business owner, employee, freelancer or solopreneur, you know that productivity is key to your success. At Solvaa we are big on productivity and love to increase efficiency using automation wherever possible.  But with ever-changing technology 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...
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...
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...

How to automate your Pipedrive CRM sales processes

One of the biggest challenges for business owners is maintaining a streamlined sales process that is both reliable and easy to use. The modern sales process tends to rely on multiple tools and apps which, while making individual tasks easy to complete, leads to...
Automate ebook

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

Shares