I am trying to get time entries from clockify to google sheet, But it does not work, Have added a clockify trigger, but Nothing happens,no executionsDono where I am wrong.
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
n8n version: 1.61.0Database (default: SQLite): Defaultn8n EXECUTIONS_PROCESS setting (default: own, main): Running n8n via (Docker, npm, n8n cloud, desktop app): DockerOperating system:
ria
December 10, 2024, 2:57pm
2
Hi @Vinod_Kanted
Thanks for sharing this.
n8n-io:master ← wsdevv:master
opened 07:20PM - 12 Sep 24 UTC
## Summary
Fixes some aspects of the "new time entry" clockify trigger, as we… ll as adding support for periodically fetching all entries for entry updating workaround.
**Problem**: This issue stems from a fundamental problem within the [Clockify API](https://docs.developer.clockify.me/#tag/Time-entry/operation/getTimeEntries), which does not allow access to most recent time entry submissions by date submitted (or finalized/created or stopped). Furthermore, Clockify only allows one to retrieve entries through start date (registered by the user) and end date (also inputted by the user) [plus a bit more irrelevant options]. The prior code seemed to have been treating the "start date" as submission/stop/finalization date (that's at least what it looks like, not sure if it was intentional), which caused problems such as discarding entries that have start dates prior to the latest checked date (so if it checked a minute ago, it would only fetch items from the current minute, then move onto the next minute).
**Solution**: Only set the "last checked"/"lastTimeChecked" variable when data is retrieved, then update the "lastTimeChecked" to the current time to skip already processed data. However, this doesn't update or account for modifications and/or additions after the "last checked" time is updated. This is why the new feature for polling all events is added, to support updating previous records, etc, though costly (meant to be used along with the fixed "new time entry" trigger, except at a slower interval).
**Purpose**: To put into place a system that gives a real time "feel" to clockify API updates while not requiring the use of webhooks and port forwarding. (this is useful for home servers)
Illustrations:
*note: I use task and time entry interchangeably here*
### Previous method
### New method
### Update/manual insert workaround
## Related Linear tickets, Github issues, and Community forum posts
<!--
Include links to **Linear ticket** or Github issue or Community forum post.
Important in order to close *automatically* and provide context to reviewers.
-->
[Community post](https://community.n8n.io/t/polling-not-working-or-am-i-doing-something-wrong/10576/2)
## Review / Merge checklist
- [x] PR title and summary are descriptive. ([conventions](../blob/master/.github/pull_request_title_conventions.md)) <!--
**Remember, the title automatically goes into the changelog.
Use `(no-changelog)` otherwise.**
-->
- [ ] [Docs updated](https://github.com/n8n-io/n8n-docs) or follow-up ticket created. (In progress)
- [ ] Tests included. (In progress)
- [ ] PR Labeled with `release/backport` (if the PR is an urgent fix that needs to be backported) N/A
The GitHub post is pointing to something else, I cannot get any data from Clockify to Google Sheets. ideally, we should be able to get some data. please correct me if I am wrong
system
March 20, 2025, 4:05am
4
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.