How to Open Google Sheets Daily (or regular schedule)

[VFW 4893]

I have two Google Sheets: "A" and "B". Sheet "A" has the source data and Sheet "B" uses an "IMPORTRANGE" function to pull data from Sheet "A". Unfortunately, I need to open Sheet "B" daily for the new data to update.

Is there a way to use Pabbly to open Sheet "B" daily so the function can update the new data from Sheet "A"?

 

[Supreme]

Hey @VFW 4893

We strictly asked our users to not use any kind of formulas or any filter in their Google Sheets to trigger the workflow. Since it might affect the incoming data with the app script.

So, kindly pass the proper data in their Google Sheet to the trigger column manually or from 3rd party application.