How to trigger a Zap for updates to a row in Google Big Query to populate data in a Google Doc?

Hi @TitanBen 

Once you select a Table, you will be able to select a “Unique Column” from the dropdown list.
The “Value” field expects the value to match against the column in the WHERE clause.

@TitanBen 

Select a value for Table from the dropdown list.

Select a value for Unique Column from the dropdown list. (e.g. AAA)

Input a value for Value column. (e.g. XXX)

Those settings becomes: WHERE AAA = XXX
 

Hi @TitanBen and @ChrisHuyghe! 👋

@TitanBen - were you able to get that Updated Row trigger set up following Troy’s suggestions? Let us know if you’re still stuck on this - happy to assist! 

@ChrisHuyghe - In the Unique Column you’d select the column that you’re going to be checking for updates in. As Troy mentioned earlier, you’d likely need to select the Table that the column exists in first, before the list of available columns will appear in the Column field’s dropdown menu.

If you’ve selected values for the required Project ID, Dataset and Table fields but there’s still no options listed for the column, then you could try selecting it using the Custom value option where you’d enter the ID for the column directly into the Column field - see our Add custom values to dropdown menu fields in Zaps guide for more details.

Then, in the Value field you’d enter in the value you’d want to check the selected column for. For example if you had a column called Status and you wanted the Zap to trigger for updates where the “Status” of a row is set to “Closed” you’d enter the word Closed into the Value field. Since the Value field is not a dropdown field it’s not possible to select from a list of existing values.

Hope that helps. If you run into any further trouble just let us know! 🙂

Sorry to hear that, @ChrisHuyghe. 

The ID wouldn’t change for each row so that wouldn’t be the right column to use. Although it’s named Unique Column it’s not actually looking for a column containing a unique value like an ID. It’s looking for a specific column to check for updates in. The Updated Row trigger will not be able to look for any updates made to a row, it’s very specific and will only trigger for specific changes i.e. where a specific column has been changed to have a specific value (static, not dynamic value). 

Is there another column you could select to have the Zap check for specific changes?

If there aren’t any suitable columns then perhaps you could add a new column called “Send to Zapier” (or whatever you prefer) and select that column in the Zap. Then you could set the value to be something like “Y” so that when making a change to a row could add the value Y in the “Send to Zapier” column and that would trigger the Zap. 

Looking forward to hearing from you!

Thanks for getting back to me, @ChrisHuyghe. 🙂

It definitely wasn’t given that name through any intent to deceive or give a false representation of what functionality the Updated Row trigger provides. It does technically trigger for an updated row, but unfortunately is currently limited to looking for certain changes to a specific column. I totally understand how it’s current functionality isn’t ideal.

I’d suggest reaching out to our Support team to put in a feature request for that trigger to be made more flexible, to allow it to trigger on updates in any column of the row not just one specific column. 

The approach you mentioned of creating a new row and deleting the old one every time you want to make an update should in theory allow you to use the New Row trigger instead of the Updated Row trigger. I can’t think of any other potential workarounds at this time, other than the one I previously mentioned, but if I do come across any further workarounds or ideas I’ll be sure to share them here.

Please do keep us posted on how you get on with that workaround. And please let me know if there’s anything else I can help in the meantime.