This is awesome! Thank you for building such a great tool! I’m not as active in this community as I’d like to be but this is becoming such a valued part of my business and strategy.
Ya-hooo, fiery! It works, without a single line of code! It’s strange that rows from the table that have already been deleted are displayed for a long time (in the Zapier editor), updates do not help, but this is nothing! The ability to launch processes when rows appear in the Glide table is in itself very valuable, especially since we didn’t have to write any scripts. Hurray, let’s continue in the same spirit!
So there’s no Lookup/Search rows action? I’m not seeing how to edit (or delete) rows. Normally in Google sheets I would look up the row ID with a search step, then use that row ID in a later update step. How do I tell Zapier which row to edit?
Yeah, that’s the question - how to get that Row ID. It’s not going to exist in any of the other apps I would use in a Zap, so I would need to search a different column with a value from a previous step.
Here’s what I’m currently doing with Google Sheets and Zapier. In our service business we use Quotient for quoting, Glide for managing jobs once they have been accepted, Quickbooks for invoicing and Zapier to connect them. I use both Google Sheets and Glide Tables as data sources in the same Glide apps. The most important Sheets are Jobs and Items (Job details).
Quotient allows quote writers to edit quotes, even after they have been accepted, then re-accept. When a quote is accepted, Zapier checks the Jobs sheet if the job is already there and either adds or edits accordingly, searching by Quote number. Same for Items, except that both edits and additions happen for each item. Items from a previous acceptance are marked inactive and new items are added.
Storing the Row IDs somewhere that Zapier can access them (Google Sheet) would defeat my goal of using only Glide Tables in Zapier. Although I suppose that additional Google Sheet wouldn’t have to be a data source for Glide. It just seems even more convoluted than what I already have!
One approach I’m considering is to have the Job ID be the Quote number combined with the timestamp of acceptance, instead of just the Quote number. Then Glide could determine that any jobs or items that aren’t the most current version of the quote can be ignored.
It’s correct that you don’t have to connect the helper Google Sheet to Glide, and you can add only two columns: the rowID, and whatever value you need to do the lookup on the Zapier side.
However, that means you have to keep two separate tables connected with all flows in the app, so when something happens on the Glide side, you must make adjustments as needed on the related row in Google Sheets. I don’t like that a lot for updates count.
You would need a way to get a list of rowIDs that match your condition, and run an iteration on that, I guess.
So, if you need to do that not with an action inside the app, you would have to get an API call first to query the related rows, and then iteratively delete those.