This topic was automatically generated from Slack. You can find the original thread here.
When I update a value in my Google Sheets spreadsheet, it takes at least 1 minute for it to arrive at pipedream. what is wrong?
I’m sorry to hear that you’re experiencing a delay in receiving updates from your Google Sheets spreadsheet. To better understand the issue, can you please provide more information about your workflow? Specifically, which trigger or action are you using to receive updates from Google Sheets? This will help me identify any potential issues and provide a solution.
i have a google sheets workflow. as trigger new “update instant”. then immediately comes an “update cell” in my workflow, where an always same word is entered. So it should take a maximum of 5 seconds
I understand that you’re using the “New Update Instant” trigger for your Google Sheets workflow, followed by an “Update Cell” action. Ideally, it should take a maximum of 5 seconds for the update to reflect in Pipedream. However, there might be some latency or rate-limiting factors affecting the speed of updates. To better understand and resolve the issue, please ensure that you’ve set up the trigger and action correctly in your workflow. If the issue persists, I recommend reaching out to Pipedream support at https://pipedream.com/support for further assistance.
should i rather use “new update shared drive”?
It seems like you’re asking about using a different trigger for your Google Sheets workflow. However, “New Update Shared Drive” is not a trigger available in Pipedream. The “New Update Instant” trigger you’re currently using should work for your use case. If you’re still experiencing delays, I recommend reaching out to Pipedream support at https://pipedream.com/support for further assistance.
how long does it usually take for a google sheets trigger to recognize when something has been updated?
The time it takes for a Google Sheets trigger to recognize an update can vary depending on factors like network latency and Google Sheets API rate limits. However, in most cases, the trigger should recognize updates within a few seconds. If you’re experiencing significant delays, please double-check your workflow setup and consider reaching out to Pipedream support at https://pipedream.com/support for further assistance.
i don’t get support because i don’t pay anything. what can i set so that the trigger checks for new updates all the time and doesn’t take 3 minutes.
I understand your concern about the delay in the Google Sheets trigger. While the “New Update Instant” trigger should ideally recognize updates within a few seconds, there might be some latency or rate-limiting factors affecting the speed of updates. One possible workaround is to use the “Scheduler” trigger instead of the “New Update Instant” trigger. You can set the scheduler to run at a specific interval (e.g., every 5 seconds) and then use the Google Sheets API to check for updates within your workflow. This way, you can control the frequency of checking for updates. Here’s an example of how you can set up a Scheduler trigger and use the Google Sheets API to check for updates: 1. Replace the “New Update Instant” trigger with a “Scheduler” trigger in your workflow. 2. Set the scheduler interval to your desired frequency (e.g., every 5 seconds). 3. Add a code step to make an API call to Google Sheets to check for updates. You can use the Google Sheets API documentation to find the appropriate endpoint and parameters: Google Sheets API | Google for Developers Remember to use the axios constructor from the @pipedream/platform package for making API requests, and use the this.google.$auth.oauth_access_token for authorization. Please note that this approach might consume more API quota and may be subject to rate limits imposed by Google Sheets API. Always check the API documentation for any limitations and adjust the scheduler interval accordingly.