Trouble with category numbers, not text, displaying in Google Sheets from Brevo contact form.

@erikahauj 

Help articles to reference for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

Hi @Beauty Pro Lab, welcome to the Community! 👋

I’m not sure whether @erikahauj has already solved this, but it looks as those the ID number for the category is being sent to the Zap rather than the name of the category. For cases like that you can use a Formatter (Utilities > Lookup Table) action to create a lookup table that converts the category IDs into the corresponding category name. 

You can learn more about how to use lookup tables in Zaps here: Create lookup tables in Zaps

Hope that helps to get you pointed in the right direction. If you run into any issues or have any further questions at all do let us know! 

Apologies @Beauty Pro Lab, I didn’t realise you were on a Free plan.

Hmm, perhaps you could add an IFS function in the relevant field in your Google Sheets action to display the name of the value depending on what the number in the selected Brevo form field is? For example a formula like this should have the desired affect: =IFS({{categoryID}}=10, "Category Name 1", {{categoryID}}=11, "Category Name 2", {{categoryID}}=12, "Category Name 3")

Instead of {{categoryID}} you’d select the field from the Brevo trigger which would look something like this in practice:



And would result in the category being displayed as “Category Name 3” instead of “12”, in the spreadsheet. And would get around the issue of needing to add an additional action step.

You can learn more about Google Sheets IFS function formulas here: https://support.google.com/docs/answer/7014145?hl=en-GB

Hope that helps. Let me know if you get stuck at all in adding that formula, happy to assist further! 🙂