Hi,
I am still a bit new to using Pipedream and was wondering about the following.
I would like to have a trigger for when a Google Sheet column is updated.
I know there are triggers for a new row or a sheet update, but I am looking for a way, that when there is an update in a column, then it is triggered.
I could use the sheet update, but it is triggered every time it is updated. But I just want one column.
Not a cell, because each cell in that column can be updated.
This column has two options.
Or it’s empty or there is a tick mark in it. I want to have the trigger only when the tick mark is placed in any cell in that column.
I hope someone can tell me if this is possible and if so, how do I do this?
Hopefully, my question is clear.
Thanks in advance for your help and time.
Great question. You can use the Google Sheets - New Updates (Instant) trigger to trigger the workflow on all changes in a given spreadsheet, then you can use a Filter to only process events that update a specific column or cell.
You can also request for specific new actions, triggers or enhancements to pre-existing actions and triggers on our public component board here: Sign in to GitHub · GitHub
All of our actions and triggers are also open source, you can modify and publish your own versions to your own account or contribute to the registry!
Hi @pierce,
How do Filters work and how can I set them to a column?
I had tried to create a new workflow, but I cannot see the option Filters
Here’s our documentation on using Filters, it includes a short video as well:
The Filter is an action not a trigger.
So my recommendation is to use the Google Sheets - New Updates trigger, then a Filter after that in a separate step.
@pierce, How would I do this if I want to check if a cell in a Google Sheets has text, then continue?
I have created a user sheet.
The workflow is triggered when a new row is added.
Then an email is sent.
In the email, I place the name field, but when the email is sent, there is no name.
When I check the Google Sheets, I can see the name in the correct field/cell.
I tried a delay of 1 minute, but there is still no name in the email.
I cannot figure out, what options/conditions I need to use, for the workflow to continue when the name field/cell has text in it.
When the name field/cell is empty, it needs to wait until there is some text in it.
I hope my question is clear.
Many thanks in advance for all your help and time.
I believe there is a “is empty” condition in the Filter action. So you can detect if a text is empty or not. If the text is empty then exit the workflow.
I checked it again, but I am not able to find the condition “if empty”
Maybe you can tell me where I could be able to find this.
