Metrics Reporting

[spinckney]

Hello.
I am new to Pabbly so please forgive me if this is a simple question.
If I have a google sheet that contains KPIs/Metrics in a standard 3 column table like the following:

Metric	Value	Notes
Number of Sessions this week	4
Number of Meetings this week	10
Revenue Earned this week	$500

is it possible for Pabbly to extract these values and send them to me in the body of an email?
Thanks.

 

[Fagun Shah]

Use Get Rows action of Google Sheet in Pabbly Connect workflow and then use Gmail to send the email with this values.

 

[spinckney]

Awesome. Will check it out.
Thanks Fagun.

 

[spinckney]

Hi Fagun, I've gotten GetRows() to work.
The result set i get back is a list of values in the screenshot below.
The next step after this is the SendMail via GMail step.

I've have the HTML for a Table, but what is the best way to capture the GetRows() data in a table?
Should I set a placeholder in each cell and replace each placeholder with a particular value?
Or is the an easier way to structure this dataset as a table?

Thanks.

 

[Fagun Shah]

If your number of rows and columns are fixed then you can go ahead and setup HTML table with placeholder with data you got from getrows action.