I did. I solved my problem through Zapier with two separate updates. One is an immediate trigger and the other is scheduled daily through the zapier scheduler.
The reason I have one scheduled is that Knack will not fire a Record Updated trigger in Zapier if that record is updated through a workflow. In my case, that would be a shed being updated as sold when a salesperson submits a sale with that shed connected to it.
So my basic setup is that I have connected a Google Sheet and anytime a shed is created or updated in Knack it triggers a Zapier workflow that either updates a current line in the Google Sheet if the shed already exists or adds a new line if it doesn’t exist. In that sheet I record the Knack record ID.
I have a second Zap that is triggered anytime a line in this sheet is updated or a new line is added.
Since I record the Knack record ID in my Bubble app, all this Zap does is grabs the Knack ID and sends it to an API endpoint in bubble. This endpoint takes the Knack ID and searches for an existing shed in bubble that includes this Knack ID. If it can’t find one, it creates a new shed.
Then I do a call directly to Knack for all the object data on that shed and update either the existing shed in Bubble or the one I just created.
That’s it for the immediate update.
As a secondary measure to make sure the inventory is synched properly each day, I have a Zap that does nothing but send send an empty request to another API endpoint in bubble to start the workflow at 2am every night.
This workflow does a search for sheds in my bubble app that aren’t sold and grabs the first one, sends a call to knack using the Knack ID and updates that shed in Bubble.
Then I simply call this workflow recursively until all the sheds have been updated.
Mostly everything is synched in real time but the nightly update is that final assurance that even if we missed something during the day we are starting fresh every morning.
Depending on your needs, that may not be exact enough but it serves our purposes well.