Vbout to google sheets vo vbout again

[Andrefercunha]

Hello.

Need some help with this workflow.

What i need is to get infor from vbout to a google sheet, then google sheet apply some formulas in a diferent spot to that info, and send the info again to vbout.

But dont know why the trigger is not working on the second part (when the page with the formulas get data to send to vbout).

Someone can help please?

 

[Fagun Shah]

Have you check marked Send on Event aand Send on Schedule both in pabbly addon setup?

If no, then do that first.

Also when data is added to gsheet using third party API like you're adding it via Pabbly Connect, pabbly addon will send all new rows only once per hour to pabbly connect(trigger part of your 2nd workflow).

Check this article - https://www.pabbly.com/common-problems-with-google-sheets-integration-in-pabbly-connect/

 

[Andrefercunha]

got both marked yeah, but dunno why that doesnt trigger the event.

Maybe because last colloun already has data (via formulas)?

 

[Fagun Shah]

got both marked yeah, but dunno why that doesnt trigger the event.

Maybe because last colloun already has data (via formulas)?

Yes, that can also cause the issue.

In that case you have 2 options,

1. Do the calculation in Pabbly Connect - Number Formatter -> Spreadsheet Formulas

2. If you have at least one unique data per response then you can send that data to other workflow where it will find in the row in sheet and return all the formula results too from gsheet

Feel free to ping me on FB if you get stuck and want to do a zoom session - https://www.facebook.com/fagun.shah.7/

 

[Andrefercunha]

ok, Fagun Shah saved my day with the help with the zoom session.

Thanks a lot once again!