Sync export bookings with google docs

[rayedgar]

It's great that your plugin is able to generate an export data url that i can read into google docs.

But how do i sync ? Everytime a link is generated the url is different.

What is the way to have an up to date readout of the export in google docs? So if something changes in the filtered booking and generated a link it would update in google docs.

[rayedgar]

I see i can reference an url by copy and pasting it into a cell and ref to importdata. But is there an automated workflow? An update button perhaps?

[yoancutillas]

Your screenshots are correct, your data are already synced :) If something changes in Booking Activities, the change will also appear on google sheets.

Booking Activities sends real time data, but Google Sheets refreshes every hours only (according to this docs), so you need to wait 1 hour to see the changes. There is no manual "Update" button.

The active filters at the moment when you generate the export link are saved. So if you export the "Booked" bookings only for example, and if one of your "Booked" booking becomes "Cancelled", then that booking will disappear from the synced Google Sheets. You don't need to generate new export links, unless you want to change the filters.

[rayedgar]

That is brilliant! And I should have read your instructions. Great work!!