• 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.

Unable to see auto-collection of response from Google sheets

Pratyush

Member
Your Task History ID
1
I've created a form which seeks certain numbers as inputs. All the inputs are automatically recorded in a linked Google sheet. Based on those inputs, I want to calculate certain values which I need to ultimately see in a same/separate worksheet in Google sheets. Hence. I'm using query function to copy all the values received from the form and formulae in the following columns to calculate the dependent variables I wish to. Eventually, I want to see all the independent/dependent variables in Google Slides. However, I'm unable to see any automated response collection in Pabbly for dependent variables since they are neither collected from the form nor manually input. How can I resolve this issue?
 

ArshilAhmad

Moderator
Staff member
Hi @Pratyush,

For Google Sheets, we do not support formula-based triggers. The data must either be entered manually into the trigger column or through an API.

If any formula is added to the trigger column of the Google Sheet, then automation will not work.
 
Top