Here is how to automatically send Fluent Form submissions to Google Sheets so you can easily manage and backup email capture leads for free using Zapier, a leading workflow automation tool.
Prerequisite
For this tutorial, I will be using the following:
- WordPress (with Oxygen Builder — but you can use any builder)
- Fluent Forms plugin
- Google Sheets
- Email Parser by Zapier
- Zapier
Scenario
For example, I have a blog subscription form below all of my posts so people can sign up to be notified when new posts come out. Every subscriber’s email address gets automatically pushed into Google Sheets on a new row which allows me to easily manage my email notification list. Likewise, if someone decides they do not want to be notified, I have a similar setup for removing email addresses.
In addition, as I am constantly changing my website, this method allows me to maintain a back up of email capture leads in case I delete the Fluent Forms plugin or something.
The steps
Just to keep things simple, the example for this post will be based on the above scenario — a simple email address submission form.