Scheduled updates not happening

Status: Closed · Asked by Lars on · 0 views

Lars — Question ·

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.

Pabblymember11 — Reply ·

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 — Reply ·

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.

Back to all forum threads · Log in to reply