Do you often wonder about the easiest way to add WordPress post to Google Sheets as row?

How to Add WordPress Post to Google Sheets as Row

If so, then here in this blog we will discuss the easiest way to do that using automation software named Pabbly Connect.

Basically, Pabbly Connect is an integration and automation tool that helps connected unlimited premium applications. The best part about the tool, it doesn’t require any kind of coding skill.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect offers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect  

But before jumping on to the integration process, let’s know about the services and the need for integration. WordPress is a web publishing software you can use to create a beautiful website or blog. It just may be the easiest and most flexible blogging and website content management system (CMS) for beginners.

On the other hand, Google Sheets allows users to edit, organize, and analyze different types of information. It allows collaborations, and multiple users can edit and format files in real-time, and any changes made to the spreadsheet can be tracked by a revision history.

By connecting WordPress and Google Sheets via Pabbly Connect, one can easily auto-populate the published post into Google Sheets without any manual work. All you have to do is set a workflow then Pabbly Connect will take care of the rest.

We have also an enclosed video. have a look at it.

Further, we have also attached a template for this integration to get you started more quickly. Also, for more apps and integrations, you can simply visit Marketplace.

Clone Template - WordPress and Google Sheets

Here in this blog, we will connect WordPress and Google Sheets.

So, let’s get started.

Step 1: Sign up to Pabbly Connect

Sign Up

Begin the process to add WordPress post to Google Sheets as row by clicking on the “Sign Up Free” icon on the Pabbly Connect dashboard. Afterward, either fill-up the details manually or sign up using Gmail credentials.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Furthermore, after logging into the account, click on the “Access Now” button as shown in the above image.

Step 3: Workflow for WordPress to Google Sheets Integration

(a) Start with a New Workflow

Create New Workflow

Start the process of creating a workflow for integration by clicking on the “Create Workflow” button.

(b) Name the Workflow

Name the Workflow

Moreover, add the name of workflow which in our case is “WordPress to Google Sheets”. Although, you can always name the workflow according to your necessities.

Step 4: Setting Trigger for WordPress to Google Sheets Integration

Following, after creating a workflow, you have to choose the integration app to add WordPress post to Google Sheets as row. Pabbly Connect allows you to build innumerable workflows within minutes, click here to sign up for unlimited integrations for free.

(a) Select Application you Want to Integrate

Select WordPress

The following step is to select “WordPress” from the dropdown, then choose the “New Post Published/Updated” option to add WordPress posts to Google Sheets as a row.

(b) Copy the Webhook URL

Copy the Webhook URL

The following step is to copy the Webhook URL.

Step 5: Connecting WordPress to Pabbly Connect

Next, to integrate WordPress with Pabbly Connect, you have to paste the copied Webhook URL into the account. For that, you must log in to your WordPress account.

(a) Head to WordPress Plugins Option

Head to WordPress Plugins Option

After logging into your WordPress account, go to the dashboard and click on “Plugins”.

(b) Search for WP Webhooks

Search for WP Webhooks

Immediately look for WP Webhooks in the plugins section.

(c) Click on WP Webhooks Settings

Click on WP Webhooks Settings

Now, click on the “Settings” to move further.

(d) Click on Send Data Option

Click on Send Data Option

As soon as you click on the settings option. Then a window will open there click on”Setting” again and then, click on the “Send Data” option.

(e) Choose Send Data on Post Update

Choose Send Data on Post Update

As soon as you click on the “Send Data” option, it will show two options. Select the “Send Data on Post Update” option.

(f) Add Webhook URL

Add Webhook URL

Simply scroll down, add the webhook name and URL and then click on the “Add” button.

Step 6: Publish a Post in WordPress

Now, in order to check this WordPress and Google Sheets integration, we will capture the data from WordPress, and for that, we will create a dummy post in WordPress.

(a) Capture Webhook Response

Capture Webhook Response

After adding the webhook URL to your WordPress account, now we will click on the “Capture Webhook Response” button to capture the data from WordPress.

(b) Add New Post

Add New Post

Simply add the title of the post and attach the category as well which in our case is “Automation & Integration”.

(c)  Publish Post

Publish Post

After doing all the changes, hit the “Publish” button.

Step 7: Test the Response in Pabbly Connect Dashboard

Test the Response in Pabbly Connect Dashboard

After hitting the “Publish” button, the info will appear on the Pabbly Connect dashboard. Then, click on the “Save” button.

Step 8: Setting Actions for WordPress to Google Sheets Integration

To make this WordPress- Google Sheets integration work, you have to choose two actions for your trigger. The first action is to set the filters and the next is to add post details in Google Sheets.

(a) Select Application you Want to Integrate

Select Filter

Next, we will add the “Filter” to set the conditions for WordPress posts. Select on the “+” icon and then select “Filter”.

(b) Map the Fields

Map the Fields

Now, map “Post status” Equal to “Publish” and category Equal to “Automation Software”.

(c) Save & Send Test Request

Save & Send Test Request

Simply click on the “Save & Send Test Request” button.

(d) Save the API Response

Save the API Response

As you can see we got the API response. Click the “Save” button.

(e) Select Application you Want to Integrate

Select Google Sheets

Further, click on the “+” icon then select “Google Sheets” and in the choose method option, select ” Add New Row”.

(f) Click the Connect Button

Connected with Google Sheets

After making all the necessary changes, click on the “Connected with Google Sheets” button. Further, it will open the authorization window, for which you have to log in to your Google account.

(g) Map Field Data

Map Field Data

All the sheets in your account will appear on the dropdown. Simply select the sheet, which in our case is “Cognito Forms Entries”. Now, all you have to do is add the necessary field from the drop-down such as for the name, select the name option, and for the email field select the email.

(h) Save and Send Test Request

Save and Send Test Request

Subsequently, after filling in all the details, save the setting and then “Send Test Request” to test the WordPress and Google Sheets integration.

Step 9: Check Response in Google Sheets

Check Response in Google Sheets

Lastly, when you check the Google Sheets, the entered details gets auto-populated in a sheet.

Conclusion –

Hopefully, now we have cleared all the uncertainty about the automation process. Here, in this post, we learned how to save WordPress post to Google Sheets as row in real-time. All you have to do is follow all the steps listed above and you can connect WordPress to Google Sheets quickly. One can easily avoid repetitive work with the help of automation. And in those situations, software like Pabbly Connect is true salvation that allows unlimited premium applications.

So, wait no longer. Go and get your access by signing up for a free account.

You May Also Like to Read –