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 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.
Update data only if the source data has 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 adding space 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 has changed in the data source since the last time our tool imported it. If you set up an importer to run hourly, Coupler.io runs every hour, pulls your data, and checks whether something has changed or not.
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).
FAQ
How is data 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 is data updated when the importer is triggered by a webhook?
Once your importer is triggered by a webhook - Coupler.io will update data in the destination without checking if the data has changed or not, so you can be sure that your automation flows are working with the newest data.