How Coupler.io updates data in the destination?
Coupler.io supports two approaches to scheduled data updating in the destination:
Update data each run
To use this approach - enable the "Update data each run" setting during the importer's setup:
Once you define a schedule for the importer with this setting, Coupler.io will update your data in the destination sheet each time when the importer is executed. If you set up an importer to run hourly, Coupler.io runs every hour, pulls your data, and saves it to the destination. Also, Coupler.io will update the "Last run" and "Last imported" dates, so you can track when your data was actually updated:
Update data only if source data was changed
In Coupler.io terms " the source was changed" means:
- new data added
- old data updated
- data order is changed
- etc.
The logic behind this is that Coupler.io calculates the hash of your data and compares it during runs. So even space adding to some secondary field you don't care about is counted as data change.
To use this approach - disable the "Update data each run" setting during the importer's setup:
Once you define a schedule for the importer with this setting, Coupler.io will update your data in the destination sheet only if it changed in the data source since the last time our tool had imported it. If you set up an importer to run hourly, Coupler.io runs every hour, pulls your data, and checks whether something has been changed or not.
If there is any change in data Coupler.io updates data in your destination and therefore updates the "Last run" and "Last imported" date and time.
If your data updates only once per day (in your data source), Coupler.io will update it in your destination only once per day as well (even if you set up data refresh frequency to 1 hour). In this case, each time importer runs Coupler.io updates the last run date and time, but the last imported date remains the same.
FAQ
How data is updated when I run the importer manually?
When you run an importer manually, Coupler.io will rewrite data in your destination sheet because you asked it to do so (not because your data changed from the previous time Coupler.io had pulled it over to the destination).
How data is updated when the importer is triggered by webhook?
Once your importer is triggered by webhook - Coupler.io will update data in the destination without checking if the data is changed or no, so you can be sure that your automation flows are working with the newest data.