How to export only new records without using milions of credits

How To
1

Hello,

I need help optimizing my workflow for exporting Clockify entries to Google Sheets. I’ve set up the scenario to run once per day, just before midnight, but I’m encountering an issue.

image
image654×363 13.4 KB

I have a module that finds time entries from Clockify and adds rows to Google Sheets. While it works, the problem is that every time it runs, it exports all the entries instead of only the new ones that haven’t been exported yet.

I’ve tried several solutions, including:

  1. Adding a “Search Row” or “Get a Range of Values” module with Google Sheets to identify existing entries and filter them out. However, this approach consumes an excessive number of credits—potentially tens of thousands over time.
  2. Using a Data Store to check for the existence of records, but this method also ends up using too many credits.
    I’m looking for a more efficient way to achieve this without incurring high credit usage. Ideally, I want the workflow to export only the new entries added since the last run.

Does anyone have suggestions for how to set this up more efficiently?

Thank you in advance for your help!

Best Regards

2

Hello @Dejan_Kletecki , you should use the module( watch time entries), such once a new entry is updated it updates it in real time

3

Hello,

Thank you for your suggestion.

That’s definitely one option, and I appreciate your input. However, the challenge with this approach is that it processes entries instantly, which can be problematic if a mistake is made and an entry needs to be corrected later.

I’ll need to explore whether it’s possible to set up a second workflow specifically for handling updates or corrections when they occur.

Thanks again for your help!