Scheduled updates not happening

[Lars]

Hi, re-raising this topic here. What I need to accomplish is simple enough: sync data from query result in Google Sheet to - in this case - Mailerlite. Since PC doesn't currently trigger on queries of formulas, I'm relying on scheduled syncs instead. Setup works fine, as does test send, but then nothing happens.

Details:

• Worksheet A contains manually updated values
• Sheet B retrieves these data using a query
• The PC webhook is set up in sheet B to monitor the column where data in A is updated
• Sheet B correctly displays updates from A

What might be stopping the scheduled syncs from happening despite correct setup?

Thanks,
Lars.

 

[Supreme]

Hey @Lars

Is the trigger column/sheets contain any query in it? Also, please elaborate on your concern about how you are processing the entries.

 

[Lars]

Hi, no, no queries in the sheet the values originate from. Not sure what you mean by concern - my problem is that updated values don't trigger syncs from the sheet B as intended. Any changes in a trigger column in a sheet should trigger syncs any time the scheduled hourly checks are performed, as I've understood from docs and also confirmed by Fagun.