hi,
i have a google sheets watch rows trigger.
i want to delete the content of the cell after the content is pulled.
how can i do it
Hi @trokiano ,
You can use the Clear a Row
or Clear a cell
module from the Google Sheets app.
Based on the output from your Watch
module, you can specify the right row where you want to clear the content.
Glenn - Callinetic
ok but can i tell google sheets to watch only the cell a1.
because when i delete the row the “watcher” jumps to cell a2.
If you want to monitor just one cell, you can use the Watch changes
module instead.
Therefore, you’ll need to install the Make add-on in your Google Sheets workspace. (https://www.make.com/en/help/app/google-sheets?_ga=2.191019562.1415841260.1672044530-422898980.1666116240#connectinginstant-triggers--perform-a-function-watch-changes-using-the-make-google-sheets-add-on)
Once installed, configure it to your needs
For example. If you want to monitor only cell A1, you can configure it like this.
Then, whenever the watcher is triggered in your scenario, you can invoke the Clear a Cell
module to clear your cell again.
When you monitor a wider range than only A1:A1, you can work with filters to specify for which cells you really want to start an action.
Glenn - Callinetic
the watcher is not finding the data.
i added the webhook
You changed the content of the cell?
Can you share a screenshot of the settings you set in your add-on? And if possible, the example of your sheet?
Glenn - Callinetic