• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Lookup and calculations with Google Sheets

NelsonE

Member
Hi,
I have an app that can send the following values to a webhook every time a user updates his weight:
- Initial Weight
- Actual Weight

What I want to do is to email the user to congratulate him, motivate him, according to the weight he lost between the last time he updated the weight and the actual one.

My idea is to use Google Sheets to receive 3 entries for every user: Email address, Date and Actual weight. This action is easy.

My difficulty is to use Pabbly to find the last record for that user inside Google Sheets and then send an email based on the weight he lost.

The second part of sending the email based on the weight I imagine I can do it with a Router inside Pabbly, once I get the weight the user lost. But I didn't even get to that part. I don't know how I can look up inside Google Sheet to get the last value for the user and then calculate the difference against the actual value.

Can anyone help me on this?

Thanks
 

Fagun Shah

Well-known member
You can use Lookup Row action of Google Sheet. Which will give you the last saved weight of the user.

Then you can use that weight and current weigh submitted by client in pabbly number formtter - Math Operation, Subtract to calculate the difference and send email based on that.(positive or negative values)

Let me know if you want to do this on a zoom call, PM me on FB messenger.
 
Top