All About Basic

Here’s a simple automation workflow I recently built to track WooCommerce store activity and log structured data into Google Sheets — along with sending a notification to the admin.

When the order status is marked as Completed, the code will work. 

I have used the following blocks 

1) Webhook block — Receives structured data from the WooCommerce site

2) Split out — Separates product line items for better analysis

3) Send a Message —Sends a formatted notification to admin

4) Append row in a sheet – it will save those infos in google sheet 

The code I had to use in functions.php in WordPress theme 

So, another issue my client faced which i helped her to solve. Client was trying to install a plugins in her wordpress website but cloudflare was blocking it. Client was using paid / pro cloudflare.

I checked cloudflare dashboard and found under Security > Security Rules page, at the bottom there is Cloudflare Managed Ruleset which was showing active ( screenshot below)

So I have tried to create another small automation for Contact Form 7 where the submitted form data will be saved directly in a google sheet  and also will send a mail to admin. 

This approach can be a solution for DigitalOcean droplet where hosting does not allow or block send mail or email  functionality of PHP . 

Here I have used Webhook to receive data from contact form 7 in this format

I have tried to create a small automation using n8n where I have tried to save post comments of my WordPress blog posts directly into google sheet.  I have used n8n to implement this.

In the workflow, I have used webhook  which receive information when posts get any new comments and Append row in sheet helps to append that comment in a new row of google sheet.

If you want to create a Yoga based site with free wordpress theme you can check this post, i have shared the basic setup guid with some css modification

You can see Demo here.

Here is the OceanWP TheAme.

1. Here is the initial guide about the setup which you can do easily

So I tried to create a small automation where I get WordPress post comments directly in my WhatsApp messages whenever anyone comments on any of my WordPress blog posts.

I used a Webhook and an HTTP Request node. As I understood it, the Webhook is a listener/receiver that receives data. When a comment is made on my WordPress site, the comment is sent to the Webhook using this code:

add_action('wp_insert_comment', function($comment_id, $comment) {
    $data = [
        'author' => $comment->comment_author,
        'email' => $comment->comment_author_email,
        'content' => $comment->comment_content,
        'post' => get_the_title($comment->comment_post_ID),
        'date' => $comment->comment_date
    ];
    wp_remote_post('https://n8n.example.com/webhook/wp-comment', [
        'method'  => 'POST',
        'body'    => json_encode($data),
        'headers' => [
            'Content-Type' => 'application/json'
        ],
    ]);
}, 10, 2);

The Webhook receives it in JSON format like this:

My Client was using shopify store and she faced a frustrating issue. She was trying to send order directly to customers, but when customers was trying to fill in the details and tried to pay, the checkout page was showing some Validation issue because customer is directly using checkout page without giving some information which was necessary in Cart page/ Product page.

I was using  wordpress-ubuntu-s-1vcpu-1gb-blr1-01 ( WordPress on Ubuntu 1 vcpu, 1 gb ram)  using digitalocean droplet.

Though i am new of using DigitalOcean droplet, i am much familiar with Cpanel type hosting, where i managed files and databases by own. But in DigitalOcean wordpress droplet I didnt get such option. 

So, after doing Client’s work, i reset the whole wordpress  using Wp Reset Plugins https://wordpress.org/plugins/wp-reset/

If you are using Contact Form 7 in WordPress and want users to upload files securely, you can easily configure allowed file types and maximum upload size using the file tag.

For example, something like this:

Here is the code which you need to use in Contact Form 7