Automatically export Fluent Form submissions to Google Sheets

Farhan
5 min readAug 3, 2022

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:

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

--

--

Farhan

I am currently a financial analyst training to become a chartered accountant. In my spare time, I build and blog about WordPress and VBA solutions for people.