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.
Fluent Forms
Note: I will skip the form creation and embedding process and jump straight to the settings.
To start off, locate the relevant form setting via wp admin > Fluent Form > All Forms > *relevant form name* > Settings > Email Notifications > Settings (blue cog) and then do the following:
Name → set a useful name
Send to → leave as default as this will be changed later on
Subject → set a useful subject
Email Body →
{inputs.email}
{embed_post.permalink}
Settings should look something like this:-
Google Sheets
Note: I will skip the Google Sheet creation process and jump straight to the setup