Hi Guneet,

We don't have a native option to fetch the total number of rows from a table and post it somewhere, but you can achieve this with a workaround.

You can add a Formula Column to your Table linked from the Google Sheet, and just write "1" in the Formula.

This will serve as a "row counter".

Now, you can activate to calculate the Total for this Formula Column and as you can see on my example table, it counts all the rows correctly.

In my example, this table has a total of 105 rows.

You can then copy the SUM calculation's shortcode of this Formula column and paste it anywhere on your Front-End on any Page.

This way, you can achieve your goal to fetch the total number of rows and present it anywhere on your Site.

Let me know if that works for your use-case.

Just note, the Formula Column  is not available in the Starter licence plan, so if you need it, you would need to purchase any of the higher level Plans, such as "Standard" or higher.

You can compare the features between all Plans from Lite(free), then Premium versions from the Starter all the way up to the Developer Level, in the Plugin back-end Dashboard, under "Lite vs Premium".

You can also see this on the pricing Page, but here in the Dashboard, we show more details about each specific feature, etc.

If you don't have any installation now on your WordPress, you can easily see this on our Demo Sandbox Website.

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions.