This topic was automatically generated from Slack. You can find the original thread here.
For a google sheet new row instant trigger what is the logic that governs if a row is deleted and added back? How does it handle a scenario like this?
I understand you’re asking about how a Google Sheets new row trigger handles a scenario where a row is deleted and then added back. To provide a specific answer, I would need more information about the trigger you’re using. If you’re using a Pipedream Google Sheets trigger, please let me know the name of the trigger or provide more details about the scenario you’re trying to handle. This will help me give you a more accurate answer.
I am using new row added (instant) trigger - when a row is added and deleted and then readded, does the novel row still trigger the workflow?
The “New Row Added (Instant)” trigger in Pipedream listens for new rows added to a Google Sheet. If a row is added, deleted, and then re-added, the trigger will consider the re-added row as a new row and trigger the workflow accordingly. Keep in mind that the trigger is based on new rows added, so it will not detect the deletion of a row, only the addition of a new one.
So for example, the second row in a sheet can only trigger the workflow once?
Yes, that’s correct. When using the “New Row Added (Instant)” trigger, it will only trigger the workflow once when a new row is added. If the second row is deleted and then re-added, it will be considered as a new row and trigger the workflow again. However, the trigger won’t detect the deletion of a row, only the addition of a new one.
Got it - so is there a workaround to create a trigger that watches for new content in a row, or at the very least can I reset the trigger? I’m assuming I should just delete and recreate it if I can only reset
There isn’t a built-in trigger specifically for watching new content in an existing row. However, you can create a custom solution using a scheduled trigger that periodically checks for changes in the Google Sheet. Here’s a high-level approach: 1. Use a scheduled trigger to run the workflow at your desired interval (e.g., every minute, hourly, etc.). 2. In the workflow, use the Google Sheets API to read the data from the sheet. 3. Compare the current data with the previous data stored in a Pipedream key-value store or an external database. 4. If there are changes, perform the desired actions and update the stored data. To reset a trigger, you can disable and re-enable it in the workflow settings. If you want to create a new trigger, you can delete the existing one and add a new one in the workflow. Keep in mind that this custom solution may have limitations and may not be as efficient as an instant trigger.